8 Replies Latest reply on Jan 21, 2011 3:34 AM by lily liang

    database table cannot be created but no error

    lily liang Newbie

      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}