Changing SQL driver in BIRT runtime 2.5.1

I would like to change the SQL driver in the runtime to use the Level4 JTDS driver. How can I register this jar file with the runtime BIRT??

Find more posts tagged with

Comments

mwilliams

Hi dduggan123,

What have you done so far? If you've placed the driver to connect to your SQL database in the drivers file under the runtime, you should just have to use that driver when setting up your JDBC dataSource.

dduggan123

Michael:
Thanks for the response! I don't seem to have a drivers directory under my runtime.
birt-runtime-2_5_1
about_files
ReportEngine
configuration
lib
plugins
samples
workspace

Is it as easy as creatig a directory called drivers??

THANKS!!

dduggan123

I tried just adding the directory and changed my data source to use the new driver and I get the following:
Apr 16, 2010 10:59:50 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager loadExtraDriver
SEVERE: DriverClassLoader failed to load class: net.sourceforge.jtds.jdbc.Driver
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver

Any ideas??

Thanks for your help!

mwilliams

dduggan123,

Are you using the web viewer from the runtime? Or are you actually just using the runtime to create your reports?

If runtime:

runtime -> report engine -> plugins -> org.eclipse.birt.report.data.oda.jdbc_version -> drivers

If viewer:

viewer -> WEB-INF -> Platform -> Plugins -> org.eclipse.birt.report.data.oda.jdbc_version -> drivers