To be more specific: When using Hibernate+Derby then in your
persistence.xml there's a line like this:
<property name="hibernate.connection.url"
value="jdbc:derby://localhost:1527/MySampleDb;create=true"/>
If you are using PostgreSQL the line would look like this:
<property name="hibernate.connection.url"
value="jdbc:postgresql://localhost:5432/MySampleDb"/>
If you add ";create=true" just as in the example above, it breaks the
code and you get this as a result:
org.postgresql.util.PSQLException: FATAL: database
"MySampleDb;create=true" does not exist
at
org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:471)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at
org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
at
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
[...]
Isn't this automatical table creation possible with PostgreSQL at all?
Thanks, again!
Bata
On 05/02/2012 12:15 PM, Bata Degen wrote:
> Hi list,
>
> what is your choice of trust when it comes to Java persistence libraries?
>
> NetBeans gives me these out of the box:
> EclipseLink (JPA 2.0)
> Hibernate (JPA 1.0)
> TopLink Essentials (JPA 1.0)
>
> Is any of them known to work very well together with PostgreSQL? Or what
> else can you recommend?
>
> I am looking for a solution to do this (the direction is important, it's
> not the other way around):
> XML-Schema --[via Hyperjaxb3]--> annotated Java classes --[via JPA]-->
> PostgreSQL
>
> I've already managed to do the first two steps but would appreciate your
> advice on the last step. I've done loads of tutorials. This one
> http://bit.ly/b7vCkF for example employs Hibernate and the cool thing is
> that you can let the relations be created for you automatically. But it
> uses Apache Derby as the database backend. This is not what I want. I
> want to use PostgreSQL. But when exchanging Derby for PostgreSQL
> relations won't be created automatically anymore.
>
> Has anyone done such magic things successfully with PostgreSQL and if
> so, which persistence library where you using?
>
> Thank you guys for your feedback!
>
> Regards,
> Bata
>
