JDBC class path and JDBC URL

[pradeepvv82]

Hi all,

I am using JDBC driver sqljdbc4.jar in Filemaker 9 and connecting to SQL Server database using 360 Works Plug-in.

I want to know if the following are correct:

jdbcLoadDriver( "[color:yellow][color:brown]com.microsoft.sqlserver.jdbc.SQLServerDriver" ; "file:///Users/admin/Desktop/JDBC/sqljdbc4.jar" )

jdbcOpenDatabase( "jdbc:sqlserver://16x.xx.xx.xxx:1433;databasename=training;user=zzz_yyyy;password=xxxxxxx" )

Is the class path mentioned above is correct or the one below:

[color:yellow][color:brown]com.microsoft.jdbc.sqlserver.SQLServerDriver

[Valentin]

This should be specified in Microsoft documentation.

[edgecity]

I am troubled by this reply by someone from 360 Works, "This should be specified in Microsoft documentation."

360Works provides a demo file with no jar for the Microsoft driver within the container field, yet it supplies the class path, "com.microsoft.sqlserver.jdbc.SQLServerDriver"

As is obvious in the question by pradeepvv82, Microsoft's website provides the class path, "com.microsoft.jdbc.sqlserver.SQLServerDriver", different from the class path provided by 360Works.

The demo file provides the following url for the Microsoft driver, "http://msdn.microsoft.com/data/ref/jdbc/". It may have been active at one time, but it isn't now.

I just purchased the 360Works JDBC plugin, and am unable to get it work work for me, especially with the minimal documentation and the poorly designed Demo file.

All of the other 360Works Plugins and Demo files which I have tried are useful, simple to use and helpful to FileMaker developers. I cannot say that about the Demo file for the JDBC plugin.

What bothers me more, is that a simple question by a user is answered with a simplistic reply.

[Valentin]

You're right the information is old, current information is here http://msdn.microsoft.com/en-us/library/ms378672.aspx

[tcosta]

Hi guys,

I'm actually now trying to do the same .

to load the Driver I use : jdbcLoadDriver( "com.microsoft.sqlserver.jdbc.SQLServerDriver" ; _properties::jdbcDriver ) - the driver is in a Container in the DB itself so you don't need to put it in every laptop. And it works.. I get the message ... "1" , which means connected.

But when I try to Open a Connection like this:

jdbcOpenDatabase("jdbc:sqlserver://10.**.**.****:1433; databaseName=Test" ; "user" ; "password" ; True )

I get the error : java.lang.UnsupportedOperationException: Java Runtime Enviroment (JRE) 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for IDBC 4.0

And Actually I'm loading the driver sqljdbc4.jar :/ so It's kinda wierd... should I update the JRE on my MAC ?

[tcosta]

Solved Guys !!

Using a new driver that actually works !! the jTDS JDBC Driver .

You can load the DB like this: jdbcLoadDriver( "net.sourceforge.jtds.jdbc.Driver" ; _properties::jdbcDriver) - as I said , the driver is in a container but instead of _properties::jdbcDriver , you can use the normal file location above.

then to Open a connection use: jdbcOpenDatabase("jdbc:jtds:sqlserver://10**.**.*****:1433/Test" ; "user" ; "password" ; True )

And that is it ! I manage to retreive my data from an SQL Server to Filemaker Database.

Here to Download the Driver ... I'm using the latest version