I would like to request help with Filemaker's JDBC, Tomcat and the J2EE server.

I have figured out how to connect a servlet running in Tomcat 4.0 to a Filemaker database using Filemaker's JDBC drivers:

//

Class.forName("com.fmi.jdbc.JdbcDriver");

fmpConnection = DriverManager.getConnection("jdbc:fmpro:http://127.0.0.1:80");

//

Now I'm trying to use the drivers in a web application (CMP, session facade - much along the lines of Sun's Duke's Bank app) in the free J2EE server downloadable from Sun. When I try to 'Generate Default SQL' in the 'deployment settings' for the CMP that uses the driver (via JNDI), an error dialogue box displays "java.sql.SQL.Exception: Feature Not Supported". No default sql is generated.

This web app works all right with MySQL.

I was wondering if someone out there could offer some advice on how to interpret the error message, or if anyone has had luck using Filemaker's drivers with the J2EE server.

Thank you.

What version of FMP and JDBC Driver for FMP are you using? From my experience, the FMP JDBC driver that comes with FMP Developer 5.0 only worked properly along with Tomcat when I used JDK 1.1.8. Also, I had to use Tomcat 3.2.4, because I had to use the older version of JDK. When I used the newest version of Java and Tomcat it didn't work. So, that might be your problem.