Postgresql CMP problem ... Maybe?

[lateef]

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

[marcwea]

Hello,

I think (well I had the same problem with JBoss3 and postgresql 7.2) you have to change the standardjbosscmp-jdbc.xml file in conf directory to set the DataSource mapping to PostgreSQL 7.2 (or PostgreSQL)

change
<datasource-mapping>Hypersonic SQL</datasource-mapping>

to
<datasource-mapping>PostgreSQL 7.2</datasource-mapping>
and then Jboss knows how to mapp an object to a postgresql type.

I hope it helps.

Marc

[lateef]

Marc,
Thank YOU!!!
One more question about this.
Is there documentation somewhere that I have missed? I have subscribed to the $ documentations and I looked on the Volunteer but I probably missed it.

Lateef

[marcwea]

Lateef,

It's good to be able to help. Basically, I am doing like you, looking at documents, even the Jboss2 docs can help you understand jboss3. You need also a lot of spare time, looking at all the different service.xml files and understand what they are doing. Good luck Lateef!

Marc