Hi,
When I try to deploy my application, jboss successfully creates the one
table, but then logs that the remaining tables already exist. When
configured to use hsql, the tables are created successfully. Does anyone
recognize this behavior or see my mistake?
Thanks,
fawce
------------- Details ----------------
--------------------------------------
Jboss version: jboss-head build
Postgres version: 7.2.1
JDK: 1.4.1
Jdbc driver: JDBC3 for jdk1.4.1
I am trying to use the example postgres-service.xml deployment
descriptor to connect to a postgres instance. I am using the latest
(downloaded today) jdbc3 driver, and it is in my
jboss/server/<server-name>/lib directory.
I am generating all my cmp2.0 code using xdoclet, and have been running
successfully against hsql. I am giving xdoclet
----------------- Console Output ----------------------
-------------------------------------------------------
5:38:10,437 INFO [EntityInstancePool] Starting
5:38:10,437 INFO [EntityInstancePool] Started
5:38:10,625 INFO [TopicInfoEntity] Created table 'topic_info'
successfully.
5:38:10,656 INFO [IndexInfoEntity] Table 'index_info' already exists
5:38:10,671 INFO [EntityTypeEntity] Table 'entity_type' already exists
5:38:10,703 INFO [ContentEntity] Table 'content' already exists
5:38:10,718 INFO [TestEntity] Table 'testentity' already exists
5:38:10,750 INFO [RelationshipEntity] Table 'relationship' already
exists
5:38:10,796 INFO [EntityEntity] Table 'entity' already exists
5:38:10,812 INFO [EntityEntity] Table 'entityentity_contentli_1ektlq5'
already exists
5:38:10,843 INFO [EntityAliasEntity] Table 'entity_alias' already
exists
5:38:10,859 INFO [IndustryInfoEntity] Table 'industry_info' already
exists
5:38:10,875 INFO [GenericRelationshipInfoEntity] Table
'generic_relationship_type_info' already exists
5:38:10,890 INFO [RelationshipTypeEntity] Table 'relationship_type'
already exists
5:38:10,921 INFO [CorporateInfoEntity] Table 'corporate_info' already
exists
----------------- Ant build.xml snippet ---------------
-------------------------------------------------------
<property name="xdoclet.typemapping" value="PostgreSQL" />
<property name="xdoclet.datasource" value="java:/PostgresDS" />
<property name="xdoclet.create-table" value="True" />
<property name="xdoclet.remove-table" value="True" />
......
<jboss xmlencoding="UTF-8" version="3.0"
typemapping="${xdoclet.typemapping}" datasource="${xdoclet.datasource}"
validatexml="false" destdir="${bin}/META-INF" />
-------------- EJB example snippet ---------------------
--------------------------------------------------------
*
* @ejb.bean name="TopicInfoEntity"
* type="CMP"
* cmp-version="${xdoclet.cmp-version}"
* primkey-field="${xdoclet.primkey-field}"
* jndi-name="ts/entity/TopicInfoEntity"
*
local-jndi-name="ts/entity/TopicInfoEntityLocal"
* @ejb.pk class="${xdoclet.primkey-class}"
* @ejb.persistence table-name="topic_info"
* @ejb.util generate="${xdoclet.util-generate}"
*
* @ejb.value-object
* name="TopicInfo"
* match="*"
*
*
* @jboss.create-table "${xdoclet.create-table}"
* @jboss.remove-table "${xdoclet.remove-table}"
------------- Postgres-service.xml snippet --------------
---------------------------------------------------------
<attribute name="JndiName">PostgresDS</attribute>
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=LocalTxDS,name=PostgresDS">
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:postgresql://10.22.74.191:5432/basindev</co
nfig-property>
<config-property name="DriverClass"
type="java.lang.String">org.postgresql.Driver</config-property>
<!--set these only if you want only default logins, not
through JAAS -->
<config-property name="UserName"
type="java.lang.String">jfawcett</config-property>
<config-property name="Password"
type="java.lang.String">jfawcett</config-property>
</properties>
</attribute>
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
