1 Reply Latest reply on Jan 6, 2011 10:49 AM by philmodjunk

    FM11 JDBC Exception

    J.Hildemann

      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)