AnsweredAssumed Answered

FM11 JDBC Exception

Question asked by J.Hildemann on Jan 6, 2011
Latest reply on Jan 6, 2011 by philmodjunk

Summary

FM11 JDBC Exception

Product

FileMaker Server

Version

11v2

Operating system version

Mac OSX 10.6.5

Description of the issue

After a undefined number of hours, the FileMaker ODBC/JDBC interface is not responding any more.

java.lang.NullPointerException
     at com.filemaker.jdbc.FMSQLException.(Unknown Source)

If i try to open a new JDBC connection after this Exception i get another Exception:

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Connection refused. Check that the host address and port are correct and that xDBC sharing is enabled on the host.

After i deaktivate and then reactivate the ODBC/JDBC interface in the FileMaker Admin Console, the Java application is working for the next 8 to 16 hours.

Steps to reproduce the problem

Open a JDBC connection and make a SQL querry every 5 minutes. After a couple of hours the FileMaker ODBC/JDBC interface will crash. (>8hrs)

Exact text of any error message(s) that appear

java.lang.NullPointerException
     at com.filemaker.jdbc.FMSQLException.(Unknown Source)
     at com.filemaker.jdbc.FM_API.getAllResults(Unknown Source)
     at com.filemaker.jdbc.FM_API.execute(Unknown Source)
     at com.filemaker.jdbc.FM_API.execute(Unknown Source)
     at com.filemaker.jdbc1.CommonJ1Statement.execute(Unknown Source)
     at com.filemaker.jdbc2.CommonJ2Statement.execute(Unknown Source)
     at com.filemaker.jdbc1.CommonJ1Statement.executeUpdate(Unknown Source)
     at com.filemaker.jdbc1.CommonJ1Statement.executeUpdate(Unknown Source)
     at entry.myThread.run(myThread.java:70)
     at java.lang.Thread.run(Thread.java:680)

--------------------------------------------------------

com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Connection refused. Check that the host address and port are correct and that xDBC sharing is enabled on the host.
     at com.filemaker.jdbc1.CommonJ1Connection.openConnection(Unknown Source)
     at com.filemaker.jdbc.Driver.connect(Unknown Source)
     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     at java.sql.DriverManager.getConnection(DriverManager.java:185)
     at Helper.FileMakerJDBCHelper.getDbConnection(FileMakerJDBCHelper.java:24)
     at Helper.FileMakerJDBCHelper.getDbConnection(FileMakerJDBCHelper.java:47)
     at doit.mainclass.main(mainclass.java:52)

Outcomes