Filemaker JDBC Mathematica5.2
- To: mathgroup at smc.vnet.net
- Subject: [mg67029] Filemaker JDBC Mathematica5.2
- From: "Alfredo Polo" <alfredo_polo_md at hotmail.com>
- Date: Wed, 7 Jun 2006 05:10:04 -0400 (EDT)
- Sender: owner-wri-mathgroup at wolfram.com
Hello, I have been fighting during tha last week against the following problem without success. Can anybody help me? I have a Filemaker 8 database and I want to access (retrieve) it from Mathematica, make some calculations (radiobiological modelling, fuzzy modelling) and put the results back in Filemaker... 1. Filemaker 8 natively supports ODBC/JDBC, so I created a dummy database using Filemaker8 (just a few fields and entries, just one table) called it "PruebaMathematica" and activated "Filemaker Pro -> Sharing -> ODBC/JDBC". I left the database open. 2. In a separate installing package (from the original CDRom) I got the client drivers (DataDirect Sequelink for JDBC 5.4 Installer). I run the installer and I now have "Library/Java/Extensions/driver/lib/sljc.jar" It is supposed to me that this is the client driver I need to access data in Filemaker. 3. I registered the driver using the terminal (java -Dsql.drivers=com.ddtek.jdbc.sequelink.SequeLinkDriver) 4. Then I moved to mathematica, following the online documentation I opened Xcode and create a file named "_Filemaker_Prueba.m" with the following code: JDBCDriver[ "Name"->"filemaker", "Driver"->"com.ddtek.jdbc.sequelink.SequeLinkDriver", "Protocol"->"jdbc:sequelink://", "Version"->1.0 ] and put in Mathematica5.2/AddOns/Applications/DatabaseLink/DatabaseResources That is supposed to be the client driver for mathematica In Mathematica I can run this code In[1]:=Needs ["DatabaseLink`"] JDBCDriverNames[] Out[2]:= {filemaker, hsqldb, jtds_sqlserver, jtds_sybase, mysql, odbc} That means that the file is recognized having good format 5. I created another piece of code for the SQL connection. It is called "PruebaMathematica_3.m" and resides in Mathematica5.2/AddOns/Applications/DatabaseLink/DatabaseResources SQLConnection[ JDBC["filemaker", "jdbc:sequelink://localhost:2399;databaseName=PruebaMathematica;DBUser="admin";DBPassword="admin""], "Name" -> "PruebaMathematica_3", "Description" -> "Prueba de conexion a traves de JDBC", "Username" -> "", "Password" -> "", "RelativePath" -> False, "Version" -> 1. ] 6. Back to Mathematica I tried to open "PruebaMathematica_3" without success. I ran in parallel the following ("demo" is the demo conecction that comes with Mathematica): In[141]:=conn1 = OpenSQLConnection["demo"] conn2 = OpenSQLConnection["PruebaMathematica_3"] SQLConnections[] Out[142]:=SQLConnection[demo, 20, Open, <>] Out[143]:=OpenSQLConnection[JDBC[filemaker, ; jdbc:sequelink://localhost:2399; databaseName=PruebaMathematica;DBUser= Alfredo iMac17], Description -> \ Prueba de conexion a traves de JDBC, Location -> \ /Applications/Mathematica_5.2/Mathematica \ 5.2.app/AddOns/Applications/DatabaseLink/ DatabaseResources/PruebaMathematica_3.m, Name -> PruebaMathematica_3, \ Password -> , RelativePath -> False, Timeout -> None, Username -> Alfredo iMac17, Version -> 1.] Out[144]:={SQLConnection[demo, 20, Open, <>]} // \\ // So I can get no data because I cannot set up a connection for Filemaker. Do anybody see where the problem could be?? My system: iMac17 G4 with Tiger. Java SDK 1.4 and 1.5. Mathematica 5.2 and FM8 Thanks Alfredo Polo MD Brachytherapy Unit. Catalan Institute of Oncology Barcelona. Spain