3 Replies Latest reply on Jul 15, 2002 3:35 PM by Marc Sturm

    Postgresql CMP problem ... Maybe?

    Lateef Jackson Newbie

      The good:

      15:38:46,803 INFO [MainDeployer] Undeploying file:/usr/local/jboss/server/default/deploy/default-service.xml
      15:38:46,805 INFO [LocalTxConnectionManager] Stopping
      15:38:46,806 INFO [LocalTxConnectionManager] shutting down pool: org.jboss.resource.connectionmanager.LocalTxConnectionManager@7616ad
      15:38:46,808 INFO [LocalTxConnectionManager] Stopped
      15:38:46,809 INFO [JBossManagedConnectionPool] Stopping
      15:38:46,809 INFO [JBossManagedConnectionPool] Stopped
      15:38:46,812 INFO [LocalTxConnectionManager] Destroying
      15:38:46,815 INFO [JCAManagedConnectionFactory] JCAManagedConnectionFactory.preDeregister(): JCAManagedConnectionFactory
      15:38:46,818 INFO [JCAConnectionFactory] JCAConnectionFactory.preDeregister(): JCAConnectionFactory
      15:38:46,820 INFO [LocalTxConnectionManager] Destroyed
      15:38:46,821 INFO [JBossManagedConnectionPool] Destroying
      15:38:46,821 INFO [JBossManagedConnectionPool] Destroyed
      15:38:46,828 INFO [MainDeployer] Cleaned Deployment file:/usr/local/jboss/server/default/deploy/default-service.xml
      15:38:46,836 INFO [MainDeployer] Undeployed file:/usr/local/jboss/server/default/deploy/default-service.xml
      15:38:46,901 INFO [MainDeployer] Starting deployment of package: file:/usr/local/jboss/server/default/deploy/default-service.xml
      15:38:47,577 WARN [ServiceController] jboss.jca:service=LocalTxDS,name=PostgresDS does not implement any Service methods
      15:38:47,579 INFO [JBossManagedConnectionPool] Creating
      15:38:47,579 INFO [JBossManagedConnectionPool] Created
      15:38:47,591 INFO [LocalTxConnectionManager] Creating
      15:38:47,607 INFO [LocalTxConnectionManager] Created
      15:38:47,614 INFO [JBossManagedConnectionPool] Starting
      15:38:47,615 INFO [JBossManagedConnectionPool] Started
      15:38:47,615 INFO [LocalTxConnectionManager] Starting
      15:38:48,334 INFO [DefaultDS] Bound connection factory for resource adapter 'JBoss LocalTransaction JDBC Wrapper' to JNDI name 'java:/DefaultDS'
      15:38:48,335 INFO [LocalTxConnectionManager] Started
      15:38:48,335 INFO [MainDeployer] Successfully completed deployment of package: file:/usr/local/jboss/server/default/deploy/default-service.xml


      15:40:09,467 INFO [MainDeployer] Undeploying file:/usr/local/jboss/server/default/deploy/util.jar
      15:40:09,487 INFO [EjbModule] Stopping
      15:40:09,492 INFO [EjbModule] Stopped
      15:40:09,493 INFO [EjbModule] Destroying
      15:40:09,536 INFO [EjbModule] Remove JSR-77 EJB Module: jboss.management.single:J2EEApplication= ,J2EEServer=Single,j2eeType=EJBModule,name=util.jar
      15:40:09,537 INFO [EjbModule] Destroyed
      15:40:09,576 INFO [MainDeployer] Cleaned Deployment file:/usr/local/jboss/server/default/deploy/util.jar
      15:40:09,576 INFO [MainDeployer] Undeployed file:/usr/local/jboss/server/default/deploy/util.jar
      15:40:09,577 INFO [MainDeployer] Starting deployment of package: file:/usr/local/jboss/server/default/deploy/util.jar
      15:40:11,386 INFO [EjbModule] Creating
      15:40:11,510 INFO [EjbModule] Deploying Sequence
      15:40:11,615 INFO [EjbModule] Deploying SessionSequence
      15:40:19,888 INFO [EjbModule] Created
      15:40:19,890 INFO [EjbModule] Starting
      15:40:22,423 INFO [Sequence] Table 'sequence' already exists
      15:40:22,426 INFO [EjbModule] Started
      15:40:22,427 INFO [MainDeployer] Successfully completed deployment of package: file:/usr/local/jboss/server/default/deploy/util.jar


      The bad:

      15:45:24,385 INFO [MainDeployer] Cleaned Deployment file:/usr/local/jboss/server/default/deploy/social.jar
      15:45:24,385 INFO [MainDeployer] Undeployed file:/usr/local/jboss/server/default/deploy/social.jar
      15:45:24,386 INFO [MainDeployer] Starting deployment of package: file:/usr/local/jboss/server/default/deploy/social.jar
      15:45:24,924 INFO [EjbModule] Creating
      15:45:25,030 INFO [EjbModule] Deploying Region
      15:45:25,112 INFO [EjbModule] Deploying Contact
      15:45:25,962 INFO [EjbModule] Created
      15:45:25,964 INFO [EjbModule] Starting
      15:45:28,806 INFO [Region] Created table 'region' successfully.
      15:45:30,158 ERROR [EjbModule] Starting failed
      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (java.sql.SQLException: ERROR: Unable to locate type name 'object' in catalog
      )
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:190)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:383)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:793)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)


      The ugly: (sorry couldn't help myself)

      The first two Beans Sequence, SessionSequence deploy fine in the database. The Region and Contact beans seem not to deploy. And I am not sure what Entity ERROR: Unable to locate type name 'object' in catalog means.

      Many thanks to any help.
      Lateef