Hi there! I'm trying to connect to our filemaker database using jdbc. i've written a small piece of java code to connect, however i can't get the class.forName to work. i have the file fmpjdbc.jar . where do i put this and how do i use it?

Suppose your program is called Main.java that have the class.forName in it. You can do the following:

javac Main.java

(or javac -classpath fmpjdbc12.jar; Main.java)

to run it (important that you have the classpath part when you run it):

java -classpath fmpjdbc12.jar; Main

I'm assuming here that you have the jar file in the same directory as the Main.java file.

However, I think you should throw the fmpjdbc12.jar file into your "lib" directory inside the jdk directory. From there set your CLASSPATH environment variable to include the path to the jar file and then you don't have to keep writing it out like I did above.

Also, I had trouble using the newest version of JDK to run a program using the JDBC driver for FMP. I think it was intended to be used with JDK 1.1.8. So, if you have problems in the future keep this in mind.