[jboss-user] [JBoss Tools] New message: "Re: getting up and running with Eclipse Galileo + JBoss Tool for seam project"

Chris Eska do-not-reply at jboss.com
Thu Jan 28 10:47:55 EST 2010

User development,

A new message was posted in the thread "getting up and running with Eclipse Galileo + JBoss Tool for seam project":


Author  : Chris Eska
Profile : http://community.jboss.org/people/chec69

> 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
> http://stackoverflow.com/questions/1061091/persistence-xml-and-osgi-equinox
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

More information about the jboss-user mailing list