[jboss-user] [JBoss Tools] New message: "Re: getting up and running with Eclipse Galileo + JBoss Tool for seam project"
User development,
A new message was posted in the thread "getting up and running with Eclipse Galileo +
JBoss Tool for seam project":
http://community.jboss.org/message/522794#522794
Author : Chris Eska
Profile : http://community.jboss.org/people/chec69
Message:
--------------------------------------------------------------
snjeza wrote:
The "information_schema.system_sequences" table/view doesn't exist in
PostgreSQL.
Check if your hibernate dialect is org.hibernate.dialect.PostgreSQLDialect (review your
persistence.xml).
Another problem could be caused by using the SEQUENCE generator in which case you need to
create your SEQUENCE table.
Hey Thanks for sending me on the right path, just had to
do a little more research and learned a bit more of how everything its connected on the
back
Indeed it was the org.hibernate.dialect.PostgreSQLDialect I was using the default, but
even modifying, the property I was getting the exception
after reading a bit more i decided to mod the whole persistence.xml file and looked for
some examples at google and founded this
i know
its not for jboss seam but it does contain info of how the persistence.xml should be
here is the result:
( ! this is with in the persistence.xml file)
<properties>
<property name="hibernate.hbm2ddl.auto" value="create-drop"
/> <!-- drop/create tables @startup, drop tables @shutdown -->
<!-- Database Connection Settings -->
<property name="hibernate.connection.driver_class"
value="org.postgresql.Driver" />
<property name="hibernate.dialect"
value="org.hibernate.dialect.PostgreSQLDialect" />
<property name="hibernate.show_sql"
value="true"/>
<property name="hibernate.format_sql"
value="true"/>
<property name="jboss.entity.manager.factory.jndi.name"
value="java:/-name of your proyect-EntityManagerFactory"/>
<property name="hibernate.connection.username"
value="AnyUserName" />
<property name="hibernate.connection.password"
value="YourPassWord" />
<property name="hibernate.connection.url"
value="jdbc:postgresql://-your psql server address -/-name of database-" />
</properties>
Thanks to all
ill report any other inconvenience
--------------------------------------------------------------
To reply to this message visit the message page:
http://community.jboss.org/message/522794#522794