[jboss-user] [Datasource Configuration] - database table cannot be created but no error

[lily liang]

lily liang [http://community.jboss.org/people/lilyliang] created the discussion

"database table cannot be created but no error"

To view the discussion, visit: http://community.jboss.org/message/582009#582009

--------------------------------------------------------------
I use mySQL as jboss datasource, I have 5 entity class that need be created as database table after my application is deployed. But when I start up jboss, everything seems well but no table is created in database. Can someone help? the log as below:

[ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
[ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlDS' to JNDI name 'java:MySqlDS'
[TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
[EARDeployer] Init J2EE application: file:/C:/jboss-4.2.3.GA/server/default/deploy/contentmanager-ear-0.1.ear
[JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.entity.PersistenceUnitDeployment
[JmxKernelAbstraction] installing MBean: persistence.units:ear=contentmanager-ear-0.1.ear,jar=contentmanager-ejb-0.1.jar,unitName=ContentManagerDm with dependencies:
[JmxKernelAbstraction]       jboss.jca:name=MySqlDS,service=DataSourceBinding
[PersistenceUnitDeployment] Starting persistence unit persistence.units:ear=contentmanager-ear-0.1.ear,jar=contentmanager-ejb-0.1.jar,unitName=ContentManagerDm
[Version] Hibernate EntityManager 3.2.1.GA
[Version] Hibernate Annotations 3.2.1.GA
[Environment] Hibernate 3.2.4.sp1
[Environment] hibernate.properties not found
[Environment] Bytecode provider name : javassist
[Environment] using JDK 1.4 java.sql.Timestamp handling
[Ejb3Configuration] found EJB3 Entity bean: com.contentmanager.db.CategoryEntity
[Ejb3Configuration] found EJB3 Entity bean: com.contentmanager.db.ChannelEntity
[Ejb3Configuration] found EJB3 Entity bean: com.contentmanager.db.MovieEntity
[Ejb3Configuration] found EJB3 Entity bean: com.contentmanager.db.PackageEntity
[Ejb3Configuration] found EJB3 Entity bean: com.contentmanager.db.PhyChannelEntity
[Ejb3Configuration] found EJB3 Entity bean: com.contentmanager.db.ProgramEntity
[Ejb3Configuration] found EJB3 Entity bean: com.contentmanager.db.ScheduleEntity
[Configuration] Reading mappings from resource : META-INF/orm.xml
[Ejb3Configuration] [PersistenceUnit: ContentManagerDm] no META-INF/orm.xml found
[ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
[InjectedDataSourceConnectionProvider] Using provided datasource
[SettingsFactory] RDBMS: MySQL, version: 5.1.54-community
[SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.14 ( Revision: ${bzr.revision-id} )
[Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
[TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
[TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
[TransactionManagerLookupFactory] instantiated TransactionManagerLookup
[SettingsFactory] Automatic flush during beforeCompletion(): disabled
[SettingsFactory] Automatic session close at end of transaction: disabled
[SettingsFactory] JDBC batch size: 15
[SettingsFactory] JDBC batch updates for versioned data: disabled
[SettingsFactory] Scrollable result sets: enabled
[SettingsFactory] JDBC3 getGeneratedKeys(): enabled
[SettingsFactory] Connection release mode: auto
[SettingsFactory] Maximum outer join fetch depth: 2
[SettingsFactory] Default batch fetch size: 1
[SettingsFactory] Generate SQL with comments: disabled
[SettingsFactory] Order SQL updates by primary key: disabled
[SettingsFactory] Order SQL inserts for batching: disabled
[SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
[SettingsFactory] Query language substitutions: {}
[SettingsFactory] JPA-QL strict compliance: enabled
[SettingsFactory] Second-level cache: enabled
[SettingsFactory] Query cache: enabled
[SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider
[SettingsFactory] Optimize cache for minimal puts: disabled
[SettingsFactory] Cache region prefix: contentmanager-ear-0_1_ear,contentmanager-ejb-0_1_jar,ContentManagerDm
[SettingsFactory] Structured second-level cache entries: enabled
[SettingsFactory] Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
[SettingsFactory] Statistics: disabled
[SettingsFactory] Deleted entity synthetic identifier rollback: disabled
[SettingsFactory] Default entity-mode: pojo
[SettingsFactory] Named query checking : enabled
[SessionFactoryImpl] building session factory
[SessionFactoryObjectFactory] Factory name: persistence.units:ear=contentmanager-ear-0.1.ear,jar=contentmanager-ejb-0.1.jar,unitName=ContentManagerDm
[NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
[SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.units:ear=contentmanager-ear-0.1.ear,jar=contentmanager-ejb-0.1.jar,unitName=ContentManagerDm
[SessionFactoryObjectFactory] InitialContext did not implement EventContext
[SchemaUpdate] Running hbm2ddl schema update
[SchemaUpdate] fetching database metadata
[SchemaUpdate] updating schema
[SchemaUpdate] schema update complete
[NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/582009#582009]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110120/9fa56755/attachment-0001.html