Jasperserver and Sybase SQLAnywhere JDBC

[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.