Re: Problem with DataSource

2009-01-30 Thread Martin Uhlir
Jacek Laskowski wrote: On Sat, Jan 24, 2009 at 2:02 AM, Martin Uhlir stoupa91de...@seznam.cz wrote: Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: relation country does not exist {prepstmnt 16963612 INSERT INTO Country (id, name) VALUES (?, ?) [params=(long) 5,

Re: Problem with DataSource

2009-01-30 Thread Martin Uhlir
Hi David, as I wrote in my previous email, I tried to install MySQL instead of PostreSQL and suddenly everything works fine. When using the MySQL I can see in the log the statements for creating tables, but trying to connect to PostgreSQL it didn't come to the point of creating tables at all.

Re: Problem with DataSource

2009-01-28 Thread Kevin Sutter
Hi Martin, I am not aware of any problems with SynchronizeMappings not working with PostgreSQL. If you turn on trace for OpenJPA, you should see the actual interaction with the database for creating the tables. Here's an example for turning on just the SQL trace, which should be sufficient for

Re: Problem with DataSource

2009-01-28 Thread Jacek Laskowski
On Sat, Jan 24, 2009 at 2:02 AM, Martin Uhlir stoupa91de...@seznam.cz wrote: Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: relation country does not exist {prepstmnt 16963612 INSERT INTO Country (id, name) VALUES (?, ?) [params=(long) 5, (String) aaa]} [code=0,

Problem with DataSource

2009-01-23 Thread Martin Uhlir
Hi all, I added new DataSources in my openejb.xml file: Resource id=MyDB type=DataSource JdbcDriver org.postgresql.Driver JdbcUrl jdbc:postgresql://localhost/TestDB UserName xxx Password yyy JtaManaged true /Resource Resource id=MyDBun type=DataSource JdbcDriver org.postgresql.Driver