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

[Chris Eska]

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
> 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