RE: openjms0.7.7 / postgres problem

From http://openjms.sourceforge.net/config/jdbc.html

"The dbtool application may not support all available JDBC 
drivers, due to buggy JDBC implementations. In this case, the 
tables must be manually created. The OpenJMS distribution ships 
with SQL scripts for most popular databases. 
These scripts are located in the $OPENJMS_HOME/db/sql 
directory and are named in the form of create_db.sql 
(e.g create_oracle.sql, create_mysql.sql)"

In your case, you probably need: $OPENJMS_HOME/db/sql/create_postgresql.sql
 

> -----Original Message-----
> From: openjms-user-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 
> [mailto:openjms-user-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] On Behalf 
> Of Laszlo Schaffer personal
> Sent: Wednesday, 13 July 2005 7:12 PM
> To: [email protected]
> Subject: [openjms-user] openjms0.7.7 / postgres problem
> 
> Hello,
> I have tried to create the openjms.db with postgres but I 
> have got the following result 
> 
> r;..\lib\openjms-tools-0.7.7-alpha-1.jar
> 11:09:23.234 ERROR [main] - 
> org.exolab.jms.persistence.PersistenceException:
> Dat
> abase does not support type=varchar(20)
> org.exolab.jms.persistence.PersistenceException: Database 
> does not support type=
> varchar(20)
>         at
> org.exolab.jms.tools.db.SchemaBrowser.getType(SchemaBrowser.java:188)
> 
>         at 
> org.exolab.jms.tools.db.RDBMSTool.getSQLType(RDBMSTool.java:277)
>         at 
> org.exolab.jms.tools.db.RDBMSTool.create(RDBMSTool.java:164)
>         at 
> org.exolab.jms.tools.db.RDBMSTool.create(RDBMSTool.java:110)
>         at org.exolab.jms.tools.db.DBTool.create(DBTool.java:142)
>         at org.exolab.jms.tools.db.DBTool.main(DBTool.java:256)
> 
> 
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the 'Do More With Dual!' 
> webinar happening July 14 at 8am PDT/11am EDT. We invite you 
> to explore the latest in dual core and dual graphics 
> technology at this free one hour event hosted by HP, AMD, and 
> NVIDIA.  To register visit http://www.hp.com/go/dualwebinar 
> _______________________________________________
> openjms-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openjms-user
> 



-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
core and dual graphics technology at this free one hour event hosted by HP, 
AMD, and NVIDIA.  To register visit http://www.hp.com/go/dualwebinar