0 Replies Latest reply on Feb 23, 2006 2:58 PM by Vivek Srivastav

    Tables not being created in MSDE data engine

    Vivek Srivastav Newbie

      When I deploy my application I get the following message. However when I check the database I don't see the tables in the database.

      The first time I tried to deploy the application there were a few tables created, but after that on subsequent deployment I am not getting any tables created in database.

      I am using MSDE as database. Appreciate any insight into the problem.

      14:31:59,625 INFO [EARDeployer] Init J2EE application: file:/F:/java/jboss/jboss-4.0.4RC1/server/de
      fault/deploy/corview.ear
      14:32:01,703 INFO [Ejb3AnnotationHandler] found EJB3: ejbName=SecurityManagerBean, class=org.vss.ej
      b3.sb.SecurityManagerBean, type=STATELESS
      14:32:01,796 INFO [Ejb3Deployment] EJB3 deployment time took: 484
      14:32:01,906 FATAL [PersistenceXmlLoader] ccor JTA
      14:32:01,921 INFO [Ejb3Deployment] EJB3 deployment time took: 93
      14:32:02,078 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:service=EJB3,ear=corview.ear,
      jar=corview.ejb3,name=SecurityManagerBean with dependencies:
      14:32:02,078 INFO [JmxKernelAbstraction] persistence.units:ear=corview.ear.ear,unitName=ccor
      14:32:02,093 INFO [EJB3Deployer] Deployed: file:/F:/java/jboss/jboss-4.0.4RC1/server/default/tmp/de
      ploy/tmp1134corview.ear-contents/corview.ejb3
      14:32:02,093 INFO [JmxKernelAbstraction] installing MBean: persistence.units:ear=corview.ear.ear,un
      itName=ccor with dependencies:
      14:32:02,093 INFO [JmxKernelAbstraction] jboss.jca:name=corviewDS,service=ManagedConnectionFactory
      
      14:32:02,250 INFO [Environment] Hibernate 3.1.2
      14:32:02,265 INFO [Environment] hibernate.properties not found
      14:32:02,281 INFO [Environment] using CGLIB reflection optimizer
      14:32:02,281 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
      14:32:02,578 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.Audit
      14:32:02,593 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.ConnectionPort
      14:32:02,593 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.ElementType
      14:32:02,593 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.Module
      14:32:02,593 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.ModuleType
      14:32:02,609 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.NetworkElement
      14:32:02,609 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.Role
      14:32:02,609 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.Service
      14:32:02,609 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.Trap
      14:32:02,609 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.TrapsDetail
      14:32:02,609 INFO [Ejb3Configuration] found EJB3 @Embeddable: org.vss.ejb3.eb.TrapsDetailPK
      14:32:02,625 INFO [Ejb3Configuration] found EJB3 Entity bean: org.vss.ejb3.eb.User
      14:32:02,812 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.ElementTy
      pe
      14:32:02,968 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.ElementType on table ElementType
      14:32:03,140 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.ModuleTyp
      e
      14:32:03,140 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.ModuleType on table ModuleType
      14:32:03,281 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.NetworkEl
      ement
      14:32:03,281 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.NetworkElement on table NetworkElement
      
      14:32:03,281 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.Module
      14:32:03,281 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.Module on table Module
      14:32:03,312 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.Connectio
      nPort
      14:32:03,312 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.ConnectionPort on table ConnectionPort
      
      14:32:03,343 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.Service
      14:32:03,343 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.Service on table Service
      14:32:03,359 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.Trap
      14:32:03,359 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.Trap on table Trap
      14:32:03,359 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.TrapsDeta
      il
      14:32:03,359 WARN [AnnotationBinder] Root entity should not hold an PrimaryKeyJoinColum(s), will be
       ignored
      14:32:03,359 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.TrapsDetail on table TrapsDetail
      14:32:03,390 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.Role
      14:32:03,406 INFO [QueryBinder] Binding Named query: getRole => select Object(r) from Role r where roleID = :roleID
      14:32:03,406 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.Role on table Roles
      14:32:03,406 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.User
      14:32:03,406 INFO [QueryBinder] Binding Named query: loginQuery => select Object(u) from User u where loginID = :loginID
      14:32:03,406 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.User on table Users
      14:32:03,421 INFO [AnnotationBinder] Binding entity from annotated class: org.vss.ejb3.eb.Audit
      14:32:03,421 INFO [EntityBinder] Bind entity org.vss.ejb3.eb.Audit on table Audit
      14:32:03,671 INFO [CollectionBinder] Mapping collection: org.vss.ejb3.eb.ModuleType.modules_of_type
       -> Module
      14:32:03,671 INFO [CollectionBinder] Mapping collection: org.vss.ejb3.eb.NetworkElement.modules -> Module
      14:32:03,671 INFO [CollectionBinder] Mapping collection: org.vss.ejb3.eb.NetworkElement.audit -> Audit
      14:32:03,671 INFO [CollectionBinder] Mapping collection: org.vss.ejb3.eb.Module.ports -> ConnectionPort
      14:32:04,328 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.c
      onnection.InjectedDataSourceConnectionProvider
      14:32:04,343 INFO [InjectedDataSourceConnectionProvider] Using provided datasource
      14:32:04,906 INFO [SettingsFactory] RDBMS: Microsoft SQL Server, version: Microsoft SQL Server 200
      0 - 8.00.760 (Intel X86)
       Dec 17 2002 14:22:05
       Copyright (c) 1988-2003 Microsoft Corporation
       Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
      
      14:32:04,906 INFO [SettingsFactory] JDBC driver: SQLServer, version: 2.2.0022
      14:32:04,984 INFO [Dialect] Using dialect: org.hibernate.dialect.SQLServerDialect
      14:32:05,015 INFO [TransactionFactoryFactory] Using default transaction strategy (direct JDBC trans
      actions)
      14:32:05,015 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hib
      ernate.transaction.JBossTransactionManagerLookup
      14:32:05,031 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      14:32:05,031 INFO [SettingsFactory] Automatic flush during beforeCompletion(): enabled
      14:32:05,031 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
      14:32:05,031 INFO [SettingsFactory] Scrollable result sets: enabled
      14:32:05,031 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
      14:32:05,031 INFO [SettingsFactory] Connection release mode: after_statement
      14:32:05,031 INFO [SettingsFactory] Default batch fetch size: 1
      14:32:05,031 INFO [SettingsFactory] Generate SQL with comments: disabled
      14:32:05,031 INFO [SettingsFactory] Order SQL updates by primary key: disabled
      14:32:05,046 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFacto
      ry
      14:32:05,046 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
      14:32:05,046 INFO [SettingsFactory] Query language substitutions: {}
      14:32:05,046 INFO [SettingsFactory] Second-level cache: enabled
      14:32:05,046 INFO [SettingsFactory] Query cache: disabled
      14:32:05,046 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider
      14:32:05,062 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
      14:32:05,062 INFO [SettingsFactory] Structured second-level cache entries: disabled
      14:32:05,078 INFO [SettingsFactory] Statistics: disabled
      14:32:05,078 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
      14:32:05,078 INFO [SettingsFactory] Default entity-mode: pojo
      14:32:05,515 INFO [SessionFactoryImpl] building session factory
      14:32:06,625 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configure
      d
      14:32:06,625 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jn
      p.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
      
      14:32:08,265 INFO [EJB3Deployer] Deployed: file:/F:/java/jboss/jboss-4.0.4RC1/server/default/tmp/de
      ploy/tmp1134corview.ear-contents/corview.par
      14:32:08,296 INFO [TomcatDeployer] deploy, ctxPath=/corview, warUrl=.../tmp/deploy/tmp1134corview.e
      ar-contents/corview-exp.war/
      14:32:08,781 INFO [SecurityContextFilter] The Login module is set to: corview-client
      14:32:08,781 INFO [LoggedInFilter] Context Root of the application is: /corview
      14:32:09,968 INFO [TilesPlugin] Tiles definition factory loaded for module ''.
      14:32:09,968 INFO [ValidatorPlugIn] Loading validation rules file from '/WEB-INF/validator-rules.xm
      l'
      14:32:09,984 INFO [ValidatorPlugIn] Loading validation rules file from '/WEB-INF/validation.xml'
      14:32:10,921 INFO [JBossCacheManager] init(): replicationGranularity_ is 0 and invaldateSessionPoli
      cy is 2
      14:32:10,953 ERROR [JBossCacheService] jboss.cache:service=TomcatClusteringCache service to Tomcat c
      lustering not found
      14:32:10,953 ERROR [JBossCacheManager] JBossCacheService to Tomcat clustering not found
      14:32:10,953 ERROR [TomcatDeployer] Failed to setup clustering, clustering disabled
      14:32:11,046 INFO [EARDeployer] Started J2EE application: file:/F:/java/jboss/jboss-4.0.4RC1/server
      /default/deploy/corview.ear
      
      
      
      

      My META-INF/persistence.xml file looks like this:

      <persistence>
       <persistence-unit name="ccor">
       <jta-data-source>java:/corviewDS</jta-data-source>
       <class>org.vss.ejb3.eb.ElementType</class>
       <class>org.vss.ejb3.eb.ModuleType</class>
       <class>org.vss.ejb3.eb.NetworkElement</class>
       <class>org.vss.ejb3.eb.Module</class>
       <class>org.vss.ejb3.eb.ConnectionPort</class>
       <class>org.vss.ejb3.eb.PORT_TYPE</class>
       <class>org.vss.ejb3.eb.Service</class>
      
       <class>org.vss.ejb3.eb.Trap</class>
       <class>org.vss.ejb3.eb.TrapsDetail</class>
      
       <class>org.vss.ejb3.eb.Role</class>
       <class>org.vss.ejb3.eb.User</class>
      
       <class>org.vss.ejb3.eb.Audit</class>
       </persistence-unit>
      </persistence>
      


      When I deploy the application using the default datasource (hypersonic) I can see all the tables created in there.