Hi Innes,
Are you getting the error in Debug from Mashup Studio?
If so, the issue is that debugging uses the "embedded server". You also need to add the JAR file for your driver into Eclipse and also change some configuration (specifically the MANIFEST for one of the Mashup Studio plug-ins). Easier way to find the specific instructions is to open Help in Eclipse and search for Configuring Datasource Drivers. Or go to the Presto Library at http://www.jackbe.com/prestodocs/v2.7.0/prestolibrary/index.html and search for the same topic.
Sara, technical writer/jackbe
Hi Sara,
Yip ... that's exactly where I was getting the error. I've checked the help in Eclipse and configured the Mashup Studio. It works perfectly now. I should have realised that was the problem ... after all Steve covered that in the training last week. I guess I can't quite get my head around why you need to specify the classpaths, etc when using the Mashup Studio debug, when the mashups and services run perfectly well off the server.
Thanks for putting me right.
Cheers, Innes
Hi mashers,
Can someone please confirm the correct location for the jar file for a defined jdbc driver.
I'm using the jTDS JDBC driver to access a SQL database, and the driver works fine with the database published as a database service (i.e. DAO) but when I try to access it via the Presto Studio through <datasource> and <sql> I get the following error:
Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver
I can use the Service Inspector to pull data back from published DB service so I know that works correctly and I've also confirmed independently that the driver works by using Squirrel SQL Client.
Thanks everyone.
Cheers, Innes