Can I use postgresql instead of mysql  

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