Setting up the JDBC driver

[crpatter]

I was hoping someone out there can help me out...

I'm trying to set up a connection to a FM database through JDBC. I have installed the JDBC driver according the user docs, ie, into my bin folder that contains java.exe. I'm using java jdk 1.5 in the Eclipse enviroment...

However, when I run a simple app to test the connection, I receive an exception stating...

"java.lang.ClassNotFoundException: com.ddtek.jdbc.sequelink.SequeLinkDriver"

It seems to me that the app can not see the driver, or that the driver is not compatible with JDK 1.5?

Has anyone encountered these issues before?

Below is the code I'm using to try to connect to the database...

/*

* Created on Jul 12, 2005

*

* TODO To change the template for this generated file go to

* Window - Preferences - Java - Code Style - Code Templates

*/

package databaseConnection;

import java.sql.*;

/**

* @author crpatter

*

* TODO To change the template for this generated type comment go to

* Window - Preferences - Java - Code Style - Code Templates

*/

public class JdbcTest {

public static void main(String[] args) {

try {

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

}catch (Exception e){

System.out.println(e);

}

//establish a connection to FileMaker

Connection con;

try{

DriverManager.getConnection("jdbc:sequelink://localhost;2399;databaseName=Contacts");

}catch(Exception e){

System.out.println(e);

}

}

}

[crpatter]

OK, I figured out my problem myself. I hadn't imported the jar file for the driver into my project. However, now I'm receiving a "connection refused" error.

Do I need to specify a user name and password? the only account is the admin which doesn't have a password.

Do I need to specify the path of the database?

Thanks for any help you can provide.

[ave!]

1. The character between 'localhost' and '2399' should be ':'.

2. Use 'serverdatasource' instead of 'databaseName'.

So, the connection string would be looked like below.

jdbc:sequelink://localhost:2399;serverdatasource=Contacts

(Presuming 'Contacts.fp7' is the file name you want to connect to.)

See chapter 3 of the developer's guide for more details.

Hope this helps.

--

New data source plugins and documents are released recently.

http://www.filemaker.com/odbc/

[crpatter]

Thanks for the help. I went to fm's website and downloaded the most recent version of the manual, definately significant changes from the one on the disks...

I was able to connect using the following url...

"jdbc:sequelink://localhost:2399;serverDataSource=Contacts;user=craig;password=craig"

I also didn't realize that the database had to be open, silly newbie mistake.

Anyway hopefully other people can benefit from my mistakes.