It also appears that the OpenDBConnector needs to be updated too. The previous version of the driver class required a connection string which was prefixed with jdbc:microsoft:sqlserver, however the new driver requires jdbc:sqlserver. The OpenDBConnector actor automatically appends this prefix when trying to connect to a SQL server database, however it still uses the old connection string which currently makes it impossible to connect to a SQL Server database.
________________________________ Hi Peter, I have updated the actor to use the driver class com.microsoft.sqlserver.jdbc.SQLServerDriver. However, the MS SQL Server JDBC jars included in Kepler appear to be from "MS SQL Server 2000 Driver for JDBC", which does not support Java 1.5. I have removed these jars since Kepler requires Java 1.5. The license for "MS SQL Server 2005 JDBC Driver 1.2" (which does support Java 1.5) does not permit redistribution. You will need to download the jars and place them in $KEPLER/lib/jar/. The Kepler loader will automatically add them to the classpath. If you are using Eclipse, you might need to add them to the .classpath file. Let me know if you have questions, --dan Peter.Fitch at csiro.au<http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users> wrote: > Hi Kepler users, > > I have found a problem with using the open database connector actor with MS > SQL Server. When you set the database format to MS SQL Server you get an > exception class not found com.microsoft.jdbc.sqlserver.SQLServerDriver. > > Unfortunately the class is correct for Java 1.4 but not for 1.5 which is the > current recommended version. In Java 1.5 the driver class is > com.microsoft.sqlserver.jdbc.SQLServerDriver. > > Anyone else found this? > > Cheers > Peter > > > > _______________________________________________ > Kepler-users mailing list > Kepler-users at > ecoinformatics.org<http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-users> > http://mercury.nceas.ucsb.edu/ecoinformatics/mailman/listinfo/kepler-users > Cheers Jamie To be, or what?- Sylvester Stallone [cid:725274307 at 01062009-1FC1] Jamie Vleeshouwer Software Developer CSIRO Land and Water Long Pocket Laboratories 120 Meiers Road, Indooroopilly QLD 4068, Australia Ph: +61-7-3214 2785 Fax: +61-7-3214 2855 Mobile: 0437 531 125 Web: www.clw.csiro.au -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mercury.nceas.ucsb.edu/kepler/pipermail/kepler-users/attachments/20090601/7343c06b/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: attc8d0f.gif Type: image/gif Size: 2094 bytes Desc: attc8d0f.gif URL: <http://mercury.nceas.ucsb.edu/kepler/pipermail/kepler-users/attachments/20090601/7343c06b/attachment.gif>
