INFORMIX DB AS DATA SOURCE

By: Ronald Pölking - rpolking
INFORMIX DB AS DATA SOURCE
2006-05-18 10:50
HI,

I HAVE NO EXPERIENCE WITH JAVA, TOMCAT AND APACHE.

I'M TRYING TO USE JASPERSERVER WITH INFORMIX DB,
BUT I'M NOT SUCCEEDED YET.

I COPIED JDBC DRIVER FOLDER TO <tomcatdir>\common\lib
C:\Arquivos de programas\jasperserver-0.9.2\apache-tomcat\common\lib\com\informix\jdbc\IfxDriver.class

AND I MODIFIED
<js-install-dir>/apache-tomcat/webapps/jasperserver/META-INF/context.xml
(VALUES:
<Resource name="jdbc/reportingDS" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="user" password="password" driverClassName="com.informix.jdbc.IfxDriver"
url="jdbc:informix-sqli://<ip>:<port>/logix:informixserver=ol_baseteste"/>))

AND
<js-install-dir>/apache-tomcat/webapps/jasperserver/WEB-INF/web.xml
(VALUES:
<resource-ref>
<description>Report data source</description>
<res-ref-name>jdbc/reportingDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>)

WHEN I TRY TO ACCESS I RECEIVE THE ANSWER THAT CAN´T CONNECT WITH THE SERVER.

DID I FORGET TO CONFIGURE ANYTHING?

IF I DON´T USE THESE VALUES I CAN ACCESS THE SERVER, BUT I CAN´T VIEW THE
REPORT BECAUSE OF THE DRIVER.

THE iREPORT IS WORKING FINE WITH THE DRIVER.

THANKS,
RONALD POLKING.



By: Ronald Pölking - rpolking
RE: INFORMIX DB AS DATA SOURCE
2006-05-19 04:42
Hi,
Was my fault, I forgot to start JasperServer.
Now I can connect with the server, but when I try to view de report I recieve this message:
Error Message:
org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@970110 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1c6f1f4, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: java.lang.ClassNotFoundException: com.informix.jdbc.IfxDriver

Thanks.
Ronald.



By: Sherman Wood - sgwood
RE: INFORMIX DB AS DATA SOURCE
2006-05-19 06:07

If you have your driver JAR in <Tomcat>/common/lib, you should not have this problem.


Sherman
JasperSoft


By: Ronald Pölking - rpolking
RE: INFORMIX DB AS DATA SOURCE
2006-05-19 07:14
Hi Sherman,

I was using the driver opened (with the complete folder .../com/informix/jdbc...
Now I copy .JAR to tomcat folder and work fine.

Thank you very much for the help.
Ronald.