Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2006
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2006

[Date Index] [Thread Index] [Author Index]

Search the Archive

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



  • Prev by Date: Two questions (1) Sollve and (2) Precision
  • Next by Date: Re: Table through zero...strange
  • Previous by thread: Re: Re: Two questions (1) Sollve and (2) Precision
  • Next by thread: NDSolve:StoppingTest in Algebraic Differential Equations