11:41 a.m.
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:
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3972111#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...