etiennevt

Hi, I'm trying to connect JasperServer to my SQLAnywhere V12 DB using the SQLA JDBC drivers and I'm having some problems. I've used Google and tried all sorts of things without any luck. I've also discussed this with Sybase on their Google group without too much luck and was hoping that someone here may already have experience with getting SQLA to work with JasperServer. My Environment: Ubuntu 9.04 PATH=/opt/sqlanywhere12/sun/jre160_x86/bin:/opt/sqlanywhere12/bin32:/ usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games LD_LIBRARY_PATH=/opt/sqlanywhere12/lib32:/opt/sqlanywhere12/sun/ jre160_x86/lib/i386/client:/opt/sqlanywhere12/sun/jre160_x86/lib/i386/ server:/opt/sqlanywhere12/sun/jre160_x86/lib/i386:/opt/sqlanywhere12/ sun/jre160_x86/lib/i386/native_threads In my Jasperserver I created a new datasource and I've tried both the V3 & V4 JDBC drivers, i.e. sajdbc4.jar & sajdbc.jar using the following: V3: Driver: sybase.jdbc.sqlanywhere.IDriver URL: jdbc:sqlanywhere:server=jobbeatasa;host=ubuntu-rails3.local:2638 In my tomcat6 log file I have the following: java.lang.ClassNotFoundException: sybase.jdbc.sqlanywhere.IDriver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.ja va: 1645) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.ja va: 1491) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) ... V4: Driver: sybase.jdbc4.sqlanywhere.IDriver URL: jdbc:sqlanywhere:server=jobbeatasa;host=ubuntu-rails3.local:2638 This time I get an exception message in JasperServer: type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.UnsatisfiedLinkError: no dbjdbc12 in java.library.path org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServ let.java: 924) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServl et.java: 807) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSe rvlet.java: 571) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.ja va: 511) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) ... I think Jasperserver is unable to find the SQLA JDBC stuff, I've tried copying the jar files to the tomcat/lib directory as well as the jasperserver/drivers directory without any luck. I've got no idea what to try next so any help greatly appreciated. Thanks, Etienne.