Hi, Thank you very much, this helped me resolve my issue. Our problems are the same in that they emanate from the use of the DatabaseMetaData.getTables() function inside the CMP engine.
Postgresql has a non-standard way of organizing it's catalog information, that apparently does not map well to the JDBC metadata classes, and as a result is not fully implemented in the postgresql's group jdbc driver. Other postgres users have encountered similar problems and another opensource jdbc driver exists, which does a very good job of dealing with the MetaData classes -- http://jxdbcon.sourceforge.net/ Unfortunately, jxdbcon is still alpha, so I am trying to work out a way of using the jxdbcon driver for table creation during development, and then use postgresql's driver in production when our tables are well defined. Thanks, fawce -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Marek Lange Sent: Wednesday, January 29, 2003 5:19 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Funny postgresql behavior John Fawcett schrieb: > Hi, > > When I try to deploy my application, jboss successfully creates the > one table, but then logs that the remaining tables already exist. When > configured to use hsql, the tables are created successfully. Does > anyone recognize this behavior or see my mistake? See this thread from today, I had a similar problem with Oracle: http://www.jboss.org/forums/thread.jsp?forum=46&thread=27657 -marek ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
