sqljdbc4.jar file in global container field

[pradeepvv82]

Hi All,

I am trying to connect to MS SQL server from FM-9 using 360 works plug-in. I am using MS sqljdbc4.jar in a global container field.

I tested the connection from my mac and it got connected, but when I put it on server the driver does not get loaded from all the clients.

I am thinking it is related to behavior of globals on the server.

I followed the following to procedure:

1) Un-served the FM files.

2) Copied to my mac.

3) Created the global field and inserted the sqljdbc4.jar file.

4) Copied back on to the server and served the files.

Is there any thing that I am missing ??

thanks,

venkat vallala

[Smef]

Global fields start as blank/empty when you load a file and any data put in them only exists during your current user's session. When you close a file all of the data in global fields is cleared out. If you want to store a jar in a container field for multiple users to access across different sessions you will need to make sure that you are using a regular container field and not not using a global field.

Edited November 18, 2010 by Guest

[pradeepvv82]

Hi,

As you said, I created a separate Table with only one record that hods the JAR file. But with that I am only able to connect from one client. I am getting error in load driver step when I try to connect from other clients.

I used the jdbclasterror which has the following text in it:

java.lang.UnsupportedClassVersionError: Bad version number in.class file

The following is the 360 plugin log file dump:

Dec 1, 2010 3:34:26 PM com.prosc.fmkit.PluginBridge doFunction

INFO: === doFunction jdbcLastError called on thread: AWT-AppKit===

Dec 1, 2010 3:34:54 PM com.prosc.fmkit.PluginBridge doFunction

INFO: === doFunction jdbcOpenDatabase called on thread: AWT-AppKit===

Dec 1, 2010 3:34:54 PM com.prosc.fmplugin.JdbcPluginModel openDatabase

WARNING: Error while inspecting database metadata com.microsoft.jdbc.base.BaseDatabaseMetaData@3ca754

java.lang.AbstractMethodError: com.microsoft.jdbc.base.BaseDatabaseMetaData.supportsGetGeneratedKeys()Z

at com.prosc.fmplugin.JdbcPluginModel.openDatabase(JdbcPluginModel.java:292)

at com.prosc.fmplugin.JDBCPlugin.jdbcOpenDatabase(JDBCPlugin.java:330)

at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:592)

at com.prosc.fmkit.StaticFunction.invoke(StaticFunction.java:229)

at com.prosc.fmkit.Plugin.invokeFunction(Plugin.java:316)

at com.prosc.fmkit.RegisterablePlugin.invokeFunction(RegisterablePlugin.java:61)

at com.prosc.fmkit.Plugin.invokeFunctionNoErrors(Plugin.java:300)

at com.prosc.fmkit.PluginBridge$3.run(PluginBridge.java:914)

at com.prosc.fmkit.PluginBridge.runTask(PluginBridge.java:1028)

at com.prosc.fmkit.PluginBridge.doFunction(PluginBridge.java:925)

Could you pls tell me what that error means ??

Thanks,

venkat vallala

[Valentin]

The error means that the version of Java Runtime you're using can not use the compiled class, likely b/c the class was compiled with a newer version. One option is to update your Java, another is to see if there is a different JDBC driver available.

[pradeepvv82]

Yeah, I googled that error message and found that the compiled version for JAR files is newer than the Java Run time environment on one my macs.

I was testing on two clients, one has OSX (ver 10.6) and other OSX (ver 10.5). I was getting the error on 10.5 but 10.6 was going fine. I updated the older to 10.6 and it went through fine.

Thanks for your reply.

-venkat vallala