RE: dbtool and postgres

You'll need to create the tables manually using the SQL
scripts. In 0.7.6, these are shipped under $OPENJMS_HOME/config/db.
Due to an oversight, I haven't included them in 0.7.7 yet.

-Tim

> -----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: Tuesday, 31 May 2005 11:05 PM
> To: [email protected]
> Subject: [openjms-user] dbtool and postgres
> 
> 
> Hello
> 
> I have sucessfully compiled the 0.7.7-dev version, but there 
> is a bit problem during database creation (with Postgres 8.x)
> 
> D:\openjms\bin>dbtool -recreate -config ..\config\openjms.xml 
> Using OPENJMS_HOME: ..
> Using JAVA_HOME:    c:\jdk1.5
> Using CLASSPATH:    ../lib/postgresql-8.0.309.jdbc2.jar
> ;..\lib\openjms-tools-0.
> 7.7-dev.jar
> 14:46:22.656 ERROR [main] - 
> org.exolab.jms.persistence.PersistenceException:
> Database 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:282)
> 
> Regards
> Laszlo Schaffer
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create apps 
> using Yahoo! Search APIs Find out how you can build Yahoo! 
> directly into your own Applications - visit 
> http://developer.yahoo.net/?fr=fad-ysdn-ostg-q22005
> _______________________________________________
> openjms-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openjms-user
> 



-------------------------------------------------------
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005