[JBoss-user] [J2EE Design Patterns] - Re: Using PostgreSQL 8.0 in place of HypersonicSQL

2006-02-21 Thread dave_cawthorn
Whiter, I had the same problem and found that it was due to and invalid entry in my default datasource. I changed it to type-mappingPostgreSQL 7.2/type-mapping. There are probably correct mappings for postgres 8 that will work but this one solved the problem. View the original post :

[JBoss-user] [J2EE Design Patterns] - Re: Using PostgreSQL 8.0 in place of HypersonicSQL

2006-02-19 Thread whiter
Even though this solves the problem for JMS, this does not solve it for the ejb-deployer, which is installed by default and relies on the default hypersonic db as well. I'm running PostgreSQL 8.0.3, jBoss AS 4.0.3SP1, JAVA 1.4.1_06, PostgreSQL JDBC driver 8.2dev-501 JDBC 3. Operating system

[JBoss-user] [J2EE Design Patterns] - Re: Using PostgreSQL 8.0 in place of HypersonicSQL

2005-12-01 Thread pabalose
What about a schema? Does this use the public schema in your jms database? Where and how would you define a custom PostgreSQL schema? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3910099#3910099 Reply to the post :

[JBoss-user] [J2EE Design Patterns] - Re: Using PostgreSQL 8.0 in place of HypersonicSQL

2005-11-30 Thread pabalose
Thanks for answering my post. I was wondering if your answer is a complete replacement to HypersonicSQL? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=3909948#3909948 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3909948

[JBoss-user] [J2EE Design Patterns] - Re: Using PostgreSQL 8.0 in place of HypersonicSQL

2005-11-16 Thread oglueck
I am successfully using PostgreSQL with JBoss 4.0.3 + EJB3 (all) for JMS and the persistence layer. You need to do the following: * Start PgSQL and create a new DB called jms * remove the sample destinations: deploy-hasingleton/jms/jbossmq-destinations-service.xml * remove the HSQL JMS