Hi there,
I'm hoping someone can help me track down my Posgresql datasource problems:
The error is occuring trying to create the table for my CMP EJB automatically,
and it seems to be indicating that the postgres data object catalog is unavailable.
Here's the stack trace:
[LeaseoutDS] Pool LeaseoutDS [1/3/3] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@c436b[LeaseoutDS] Pool
LeaseoutDS [0/3/3] returned object
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@c436b to the pool.
[LeaseoutDS] Resource 'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@1989b5'
enlisted for 'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@c436b'.
[LeaseoutDS] Pool LeaseoutDS [1/3/3] gave out pooled object:
org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@c436b[JAWS]
java.sql.SQLException: ERROR: Unable to locate type name 'object' in catalog
[JAWS]
[JAWS] at org.postgresql.Connection.ExecSQL(Connection.java)
[JAWS] at org.postgresql.jdbc1.Statement.execute(Statement.java)
[JAWS] at org.postgresql.jdbc1.Statement.executeUpdate(Statement.java)
[JAWS] at org.postgresql.jdbc1.PreparedStatement.executeUpdate(PreparedStatement.java)
[JAWS] at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStatementAndHandleResult(JDBCUpdateCommand.java:49)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:122)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:97)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:105)
[JAWS] at org.jboss.ejb.EntityContainer.init(EntityContainer.java:198)
[JAWS] at org.jboss.ejb.Application.init(Application.java:183)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:337)
[JAWS] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:275)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[JAWS] at org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:435)
[JAWS] at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:178)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[JAWS] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:358)
[JAWS] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:221)
[JAWS] at org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:332)
[JAWS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[JAWS] at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[JAWS] at java.lang.reflect.Method.invoke(Native Method)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[JAWS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[JAWS] at org.jboss.Main.<init>(Main.java:203)
[JAWS] at org.jboss.Main$1.run(Main.java:107)
[JAWS] at org.jboss.Main.main(Main.java:103)
[JAWS] Could not create table FORUMMESSAGE: ERROR: Unable to locate type name
'object' in catalog
I've tried this with both postgresql 6.5.3 and postgresql 7.1release 4 with the same
result.
The version of the postgresql jdbc driver is 7.0.2-3, if that helps.
I'm running this all under Debian linux, "testing" version.
The jboss version is : JBoss-2.2.1_Tomcat-3.2.1
Note that a similar error occurs whilst trying to unload the ear, as a result of
trying to delete
the associated table.
Here are the relevant sections in jboss.jcml:
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.postgresql.Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=LeaseoutDS">
<attribute name="PoolName">LeaseoutDS</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:postgresql://eagle/lotest</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">russ</attribute>
<attribute name="Password">russ</attribute>
<attribute name="MaxSize">3</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">true</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">3</attribute>
</mbean>
And, here are my jaws.xml overrides:
<jaws>
<datasource>java:/LeaseoutDS</datasource>
<type-mapping>PostgreSQL</type-mapping>
<debug>true</debug>
<default-entity>
<create-table>true</create-table>
<remove-table>true</remove-table>
<tuned-updates>false</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<select-for-update>false</select-for-update>
</default-entity>
<enterprise-beans>
<entity>
<ejb-name>ForumMessage</ejb-name>
<table-name>FORUMMESSAGE</table-name>
<cmp-field>
<field-name>id</field-name>
<column-name>ID</column-name>
</cmp-field>
<cmp-field>
<field-name>subjectId</field-name>
<column-name>SUBJECT_ID</column-name>
</cmp-field>
<cmp-field>
<field-name>subjectType</field-name>
<column-name>SUBJECT_TYPE</column-name>
</cmp-field>
<cmp-field>
<field-name>messageSubject</field-name>
<column-name>MSUBJECT</column-name>
</cmp-field>
<cmp-field>
<field-name>messageBody</field-name>
<column-name>mBody</column-name>
</cmp-field>
<cmp-field>
<field-name>messageDate</field-name>
<column-name>mDate</column-name>
</cmp-field>
<finder>
<name>findBySubjectIdAndType</name>
<query>SUBJECT_ID = {0} and SUBJECT_TYPE = {1}</query>
<order>ID</order>
</finder>
</entity>
</enterprise-beans>
</jaws>
I'm guessing that this is more a postgresql problem as I think it works when I use the
default datastore...
Anyways, any help at this point would be useful...
--
Russell Chan
Stable Network Technologies Inc.
PO Box 86079
Oakville, Ontario, Canada
L6H 5V6
Email: [EMAIL PROTECTED]
Mobile: 416 822 5200
Fax: 416 867 7170
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
