Topic
1 reply Latest Post - ‏2013-04-16T08:22:23Z by mones
SystemAdmin
SystemAdmin
532 Posts
ACCEPTED ANSWER

Pinned topic FileMaker JDBC provider and datasource

‏2013-01-10T15:56:36Z |
Hi all,

I'm trying to access a FileMaker instance. Connection using vendor test application and from a minimal java program which uses the driver class succeeds, so FM server is not the problem.

I've created a user-defined JDBC provider using the fmjdbc.jar provided by the vendor, and setting the implementation class to com.filemaker.jdbc2.optional.PoolingDataSource. The class path is hardcoded and doesn't depend on variables.

Now I'm trying to create a datasource using this provider. Data store helper class name is set to default value ( com.ibm.websphere.rsadapter.GenericDataStoreHelper ), and specific properties ( username, password, serverName and databaseName ) are set in the datasource custom properties.

Of course, it doesn't work :) Testing the connection shows this error message:

The test connection operation failed for data source ficheroGeneral on server WebSphere_Portal at
node <nodename> with the following exception: java.sql.SQLException: java.lang.IllegalAccessError.
View JVM logs for further details.


Reading the logs doesn't shed much light on, but for completeness, here is the relevant part of the exception:

[1/10/13 15:47:38:025 CET] 0000003b MBeanHelper E Could not invoke an operation on object: WebSphere:name=DataSourceCfgHelper,process=WebSphere_Portal,platform=dynamicproxy,node=<nodename>,version=7.0.0.11,type=DataSourceCfgHelper,mbeanIdentifier=DataSourceCfgHelper,cell=portalin,spec=1.0 because of an mbean exception: java.sql.SQLException: java.lang.IllegalAccessError
[1/10/13 16:25:20:259 CET] 0000003c webapp I com.ibm.ws.webcontainer.webapp.WebApp log SRVE0292I: Servlet Message - [isclite#isclite.war]:.action: DataSourceDetailForm was null.Creating new form bean and storing in session
[1/10/13 16:30:06:478 CET] 00000044 DSConfigurati W DSRA0174W: Warning: GenericDataStoreHelper is being used.
[1/10/13 16:30:06:497 CET] 00000044 DataSourceCon E DSRA8040I: Failed to connect to the DataSource. Encountered "": java.lang.IllegalAccessError
at com.filemaker.jdbc2.optional.PoolingDataSource.<init>(Unknown Source)
at java.lang.J9VMInternals.newInstanceImpl(Native Method)
at java.lang.Class.newInstance(Class.java:1325)
at com.ibm.ws.rsadapter.DSConfigurationHelper.createDataSource(DSConfigurationHelper.java:1408)
at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:3432)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:549)
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:477)
...


So, has anybody succesfully configured a FileMaker provider/datasource within WAS 7.0? how? :)
Thanks in advance,
  • mones
    mones
    1 Post
    ACCEPTED ANSWER

    Re: FileMaker JDBC provider and datasource

    ‏2013-04-16T08:22:23Z  in response to SystemAdmin

    Funny this question is now attributed to other user instead of me... I guess every migration has problems ;-)