INFORMIX DB AS DATA SOURCE

[ktrinad]

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>commonlib

C:Arquivos de programasjasperserver-0.9.2apache-tomcatcommonlibcominformixjdbcIfxDriver.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.