FM and Java

[xtrim]

Does anybody has an example of JAVA working with JDBC and FMP?

[dwanehollands]

sure thing man

first load the the driver

d = (Driver)Class.forName("com.ddtek.jdbc.sequelink.SequeLinkDriver").newInstance();

you can either do it that way of set the system property and use the driver manager to load the driver

System.setProperty("jdbc.drivers","com.ddtek.jdbc.sequelink.SequeLinkDriver");

en = DriverManager.getDrivers();

while (en.hasMoreElements()) {

d = (Driver)en.nextElement();

sb.append(d.getClass().getName());

}

k, once u have the driver get the connection

Connection con = DriverManager.getConnection("jdbc:sequelink://127.0.0.1:2399","Username","Password");

witht the above url im hosting the database on the same machine as my java app

and the port number is 2339

and now that u have the conection u can execute sql statements

a few things that might help u.....

make sure the driver (jar file i forget its name) is in the class path or u will get a class loading exception ....

Make sure the filemaker database is running when you try and connect ....i know i know... but it got me a couple of times

and that should be it

ohh and make sure that JDBC shareing is turned on

kool

well have fun