Can I use postgresql instead of mysql Â

[ktrinad]

By: ceyusa - ceyusa

Can I use postgresql instead of mysql Â

2006-05-10 16:52

Hi all,Â

Â

I've tryed to use jasperserver with postgresql, using the war packages without any luck. The error message in jasperserver.log is:Â

Â

12:23:57,788 ERROR JDBCExceptionReporter,http-8080-Processor24:72 - Cannot loadÂ

JDBC driver class 'com.mysql.jdbc.Driver'Â

12:23:57,789 ERROR [default],http-8080-Processor24:260 - Servlet.service() paraÂ

servlet default lanz? excepci?nÂ

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connectionÂ

Â

Even though change the jdbc driver in context.xml and hibernate.properties.Â

Â

So, currently is possibly use another DBMS for jasperserver?Â

Â

Thanks for all folks!

 

 

 

 

By: T Kavanagh - tkavanagh

RE: Can I use postgresql instead of mysql Â

2006-05-10 21:51

Sherman just made a checkin to support postgres (and the framework for supporting any future DB). However, there are some differences between mysql and postgres when using hibernate - so these differences are being ironed out. Â

Â

I expect postgres support to be in the next release - end of May. Unfortunately, we haven't converted over to getting the dev source tree on sourceforge yet - we only have the last release snapshot (0.9.2).

 

 

 

By: Sherman Wood - sgwood

RE: Can I use postgresql instead of mysql Â

2006-05-11 04:52

Â

Was this message related to using Postgres as the repository? If so, then Tony's anser is correct.Â

Â

You can define a data source for a report that uses a Postgres data source. Include the Postgres driver into Tomcat and define the data source to use the Postgres driver. JNDI and JDBC data sources can be defined.Â

Â

Â

Â

ShermanÂ

JasperSoft