2 Replies Latest reply on Sep 16, 2006 2:12 PM by Anne Forumer

    Simple EJB3.0 App deploys with HypersonicSQL but no Postgres

    Anne Forumer Newbie

      To learn, I have a very simple app with only one Session Bean and one Entity Bean, User and I am deploying it iin JBoss-4.0.4.CR2. It deploys fine when I use DefaultDS in persistence.xml. Table User is created fine too. But it is --NOT-- working when I point persistence.xml to PostgresqlDS, another datasource used in our application. It fails when trying to create the table, User! I'd appreciate any help to get this working. I am including persistence.xml, postgresql-ds.xml and console output...

      BTW, I don't know why hibernate.hbm2ddl.auto = create-drop, as part of persistence.xml is not showing when I preview this post!

      postgresql-ds.xml:

      <?xml version="1.0" encoding="utf-8" ?>


      <local-tx-datasource>
      <jndi-name>PostgresqlDS</jndi-name>
      <connection-url>jdbc:postgresql://localhost:5432/begss
      </connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
      <user-name>postgres</user-name>
      password

      <type-mapping>PostgreSQL 8.1</type-mapping>

      </local-tx-datasource>


      ---

      persistence.xml:



      <persistence-unit name="myejb30">
      <jta-data-source>java:/PostgresqlDS</jta-data-source>



      </persistence-unit>



      ---

      Console output:

      08:42:04,044 INFO [Ejb3Configuration] Processing PersistenceUnitInfo [
      name: myejb30
      ...]
      08:42:04,044 INFO [Ejb3Configuration] found EJB3 Entity bean: test.User
      08:42:04,044 INFO [AnnotationBinder] Binding entity from annotated class: test.User
      08:42:04,044 INFO [EntityBinder] Bind entity test.User on table user
      08:42:04,054 INFO [ConnectionProviderFactory] Initializing connection provider: org.hiber
      nate.ejb.connection.InjectedDataSourceConnectionProvider
      08:42:04,054 INFO [InjectedDataSourceConnectionProvider] Using provided datasource
      08:42:04,054 INFO [SettingsFactory] RDBMS: PostgreSQL, version: 8.1.3
      08:42:04,054 INFO [SettingsFactory] JDBC driver: PostgreSQL Native Driver, version: Postg
      reSQL 8.1 JDBC3 with SSL (build 404)
      08:42:04,054 INFO [Dialect] Using dialect: org.hibernate.dialect.PostgreSQLDialect
      08:42:04,054 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
      08:42:04,054 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      08:42:04,054 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup

      08:42:04,054 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
      08:42:04,054 INFO [SettingsFactory] Automatic session close at end of transaction: disabl
      ed
      08:42:04,054 INFO [SettingsFactory] JDBC batch size: 15
      08:42:04,054 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
      08:42:04,054 INFO [SettingsFactory] Scrollable result sets: enabled
      08:42:04,054 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
      08:42:04,064 INFO [SettingsFactory] Connection release mode: auto
      08:42:04,064 INFO [SettingsFactory] Default batch fetch size: 1
      08:42:04,064 INFO [SettingsFactory] Generate SQL with comments: disabled
      08:42:04,064 INFO [SettingsFactory] Order SQL updates by primary key: disabled
      08:42:04,064 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTrans
      latorFactory
      08:42:04,064 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
      08:42:04,064 INFO [SettingsFactory] Query language substitutions: {}
      08:42:04,064 INFO [SettingsFactory] Second-level cache: enabled
      08:42:04,064 INFO [SettingsFactory] Query cache: disabled
      08:42:04,064 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCachePro
      vider
      08:42:04,064 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
      08:42:04,064 INFO [SettingsFactory] Structured second-level cache entries: disabled
      08:42:04,064 INFO [SettingsFactory] Statistics: disabled
      08:42:04,064 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disable
      d
      08:42:04,064 INFO [SettingsFactory] Default entity-mode: pojo
      08:42:04,064 INFO [SessionFactoryImpl] building session factory
      08:42:04,074 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
      08:42:04,074 INFO [SchemaExport] Running hbm2ddl schema export
      08:42:04,074 INFO [SchemaExport] exporting generated schema to database
      08:42:04,084 ERROR [SchemaExport] Unsuccessful: create table user (id int4 not null, password varchar(255), username varchar(255), primary key (id))
      08:42:04,084 ERROR [SchemaExport] ERROR: syntax error at or near "user"
      08:42:04,104 INFO [SchemaExport] schema export complete
      08:42:04,104 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.init
      ial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
      08:42:04,104 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=test.ear,jar=beans.jar,name=UserSessionBean,service=EJB3 with dependencies:
      08:42:04,104 INFO [JmxKernelAbstraction] persistence.units:ear=test.ear,jar=beans.jar,unitName=myejb30
      08:42:04,234 INFO [EJBContainer] STARTED EJB: test.UserSessionBean ejbName: UserSessionBean
      08:42:04,254 INFO [EJB3Deployer] Deployed: file:/C:/jboss-4.0.4.CR2/server/all/tmp/deploy/tmp2592test.ear-contents/beans.jar
      08:42:04,264 INFO [TomcatDeployer] deploy, ctxPath=/MyEJB30, warUrl=.../tmp/deploy/tmp2592test.ear-contents/web-exp.war/
      08:42:04,334 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-4.0.4.CR2/server/all/deploy/test.ear
      08:42:04,334 ERROR [URLDeploymentScanner] Incomplete Deployment listing: