7 Replies Latest reply on Nov 22, 2010 8:24 PM by gvalenc

    Problem auto creating table

    gvalenc

      I'm getting these errors while deploying a bean that has a persistence unit (edited names of classes, fields):

      15:00:33,636 INFO  [SchemaExport] Running hbm2ddl schema export
      15:00:33,636 INFO  [SchemaExport] exporting generated schema to database
      15:00:33,636 ERROR [SchemaExport] Unsuccessful: create table SUBSCRIPTION_TABLE (DTYPE varchar(31) not null, SUBSCRIPTION_ID varchar generated by default as identity (start with 1), REPO_ID varchar(255), SUBSCRIBER_LOCAT
      OR longvarbinary, ITEM_URN varchar(255), ITEMCLASS_NAME varchar(255), primary key (SUBSCRIPTION_ID))
      15:00:33,651 ERROR [SchemaExport] Wrong data type: SUBSCRIPTION_ID in statement [create table SUBSCRIPTION_TABLE (DTYPE varchar(31) not null, SUBSCRIPTION_ID varchar generated by default as identity (start with 1)]
      15:00:33,651 INFO  [SchemaExport] schema export complete

       

      15:00:33,417 INFO  [PersistenceUnitDeployment] Starting persistence unit persistence.unit:unitName=MyApp.ear/myapp_director.jar#MyApp

      15:00:33,417 INFO  [Ejb3Configuration] Processing PersistenceUnitInfo [

      name: MyApp

      ...]

      15:00:33,417 WARN  [Ejb3Configuration] Persistence provider caller does not implement the EJB3 spec correctly. PersistenceUnitInfo.getNewTempClassLoader() is null.

      15:00:33,448 WARN  [EJB3OverridenAnnotationReader] Property xyz1._1234URN not found in class but described in <mapping-file/> (possible typo error)

      15:00:33,448 WARN  [EJB3OverridenAnnotationReader] Property xyz2._id not found in class but described in <mapping-file/> (possible typo error)

      15:00:33,448 WARN  [EJB3OverridenAnnotationReader] Property xyz2._****Locator not found in class but described in <mapping-file/> (possible typo error)

      15:00:33,448 WARN  [EJB3OverridenAnnotationReader] Property xyz2._ABCDID not found in class but described in <mapping-file/> (possible typo error)

      15:00:33,448 WARN  [EJB3OverridenAnnotationReader] Property xyz3._5678Name not found in class but described in <mapping-file/> (possible typo error)

      15:00:33,448 INFO  [AnnotationBinder] Binding entity from annotated class: xyz2

      15:00:33,448 INFO  [EntityBinder] Bind entity xyz2 on table ****_TABLE

      15:00:33,464 INFO  [AnnotationBinder] Binding entity from annotated class: xyz1

      15:00:33,464 INFO  [AnnotationBinder] Binding entity from annotated class: xyz3

      15:00:33,495 INFO  [HibernateSearchEventListenerRegister] Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.

      15:00:33,495 INFO  [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider

      15:00:33,495 INFO  [InjectedDataSourceConnectionProvider] Using provided datasource

      15:00:33,495 INFO  [SettingsFactory] RDBMS: HSQL Database Engine, version: 1.8.0

      15:00:33,495 INFO  [SettingsFactory] JDBC driver: HSQL Database Engine Driver, version: 1.8.0

      15:00:33,495 INFO  [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect

      15:00:33,495 INFO  [TransactionFactoryFactory] Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory

      15:00:33,495 INFO  [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup

      15:00:33,495 INFO  [TransactionManagerLookupFactory] instantiated TransactionManagerLookup

      15:00:33,495 INFO  [SettingsFactory] Automatic flush during beforeCompletion(): disabled

      15:00:33,495 INFO  [SettingsFactory] Automatic session close at end of transaction: disabled

      15:00:33,495 INFO  [SettingsFactory] JDBC batch size: 15

      15:00:33,495 INFO  [SettingsFactory] JDBC batch updates for versioned data: disabled

      15:00:33,495 INFO  [SettingsFactory] Scrollable result sets: enabled

      15:00:33,495 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): disabled

      15:00:33,495 INFO  [SettingsFactory] Connection release mode: auto

      15:00:33,495 INFO  [SettingsFactory] Default batch fetch size: 1

      15:00:33,495 INFO  [SettingsFactory] Generate SQL with comments: disabled

      15:00:33,495 INFO  [SettingsFactory] Order SQL updates by primary key: disabled

      15:00:33,495 INFO  [SettingsFactory] Order SQL inserts for batching: disabled

      15:00:33,495 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory

      15:00:33,495 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory

      15:00:33,495 INFO  [SettingsFactory] Query language substitutions: {}

      15:00:33,495 INFO  [SettingsFactory] JPA-QL strict compliance: enabled

      15:00:33,495 INFO  [SettingsFactory] Second-level cache: enabled

      15:00:33,495 INFO  [SettingsFactory] Query cache: disabled

      15:00:33,495 INFO  [SettingsFactory] Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge

      15:00:33,495 INFO  [RegionFactoryCacheProviderBridge] Cache provider: org.hibernate.cache.HashtableCacheProvider

      15:00:33,495 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled

      15:00:33,495 INFO  [SettingsFactory] Cache region prefix: persistence.unit:unitName=MyApp.ear/myapp_director.jar#MyApp

      15:00:33,495 INFO  [SettingsFactory] Structured second-level cache entries: disabled

      15:00:33,495 INFO  [SettingsFactory] Statistics: disabled

      15:00:33,495 INFO  [SettingsFactory] Deleted entity synthetic identifier rollback: disabled

      15:00:33,495 INFO  [SettingsFactory] Default entity-mode: pojo

      15:00:33,495 INFO  [SettingsFactory] Named query checking : enabled

      15:00:33,511 INFO  [SessionFactoryImpl] building session factory

      15:00:33,526 INFO  [SessionFactoryObjectFactory] Factory name: persistence.unit:unitName=MyApp.ear/myapp_director.jar#MyApp

      15:00:33,526 INFO  [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}

      15:00:33,620 INFO  [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.unit:unitName=MyApp.ear/myapp_director.jar#MyApp

      15:00:33,620 WARN  [SessionFactoryObjectFactory] InitialContext did not implement EventContext

      15:00:33,636 INFO  [SchemaExport] Running hbm2ddl schema export

      15:00:33,636 INFO  [SchemaExport] exporting generated schema to database

      15:00:33,636 ERROR [SchemaExport] Unsuccessful: create table ****_TABLE (DTYPE varchar(31) not null, ****_ID varchar generated by default as identity (start with 1), ABCD_ID varchar(255), ****_LOCATOR longvarbinary, 1234_URN varchar(255), 5678_NAME varchar(255), primary key (****_ID))

      15:00:33,651 ERROR [SchemaExport] Wrong data type: ****_ID in statement [create table ****_TABLE (DTYPE varchar(31) not null, ****_ID varchar generated by default as identity (start with 1)]

      15:00:33,651 INFO  [SchemaExport] schema export complete

       

      This is my orm.xml:

       

      {code:xml}

      <?xml version="1.0" encoding="UTF-8"?>

      <entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance

         xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_1_0.xsd" 

         version="1.0">

       

      <entity class="xyz2" access="FIELD">

      <table name="****_TABLE"/>

      <inheritance strategy="SINGLE_TABLE"/>

      <attributes>

      <id name="_id">

                  <column name="****_ID" nullable="false" column-definition="varchar"/>

      <generated-value strategy="AUTO"/>

      </id>

      <basic name="_****Locator">

                  <column name="****_LOCATOR"/>

      <lob/>

      </basic>

      <basic name="_ABCDID">

      <column name="ABCD_ID"/>

      </basic>

      </attributes>

      </entity>

      <entity class="xyz1" access="FIELD">

            <attributes>

      <basic name="_1234URN">

      <column name="1234_URN"/>

      </basic>

            </attributes>

      </entity>

      <entity class="xyz3" access="FIELD">

            <attributes>

      <basic name="_5678Name">

      <column name="5678_NAME"/>

      </basic>

            </attributes>

      </entity>

      </entity-mappings>

      {code}

       

      This is my persistence.xml:

       

      {code:xml}

      <?xml version="1.0" encoding="UTF-8"?>

      <persistence xmlns="http://java.sun.com/xml/ns/persistence"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"

         version="1.0">

       

         <persistence-unit name="MyApp">

            <jta-data-source>java:/MyAppDataSource</jta-data-source>

            <class>xyz2</class>

            <class>xyz1</class>

            <class>xyz3</class>

            <class>xyz4</class>

            <exclude-unlisted-classes/>

            <properties>

               <property name="hibernate.hbm2ddl.auto" value="create-drop" />

            </properties>

         </persistence-unit>

      </persistence>

      {code}

       

      I haven't found anything that says we can't use varchar for the primary key. Is there something else I'm missing?

       

      This is on 5.1.0 GA and I'm not using any JPA annotations, only XML.

        • 1. Re: Problem auto creating table
          wdfink

          I'm using the annotations for Entities, so im unsure about you problem.

          But, do you test the create SQL direct?

          And it will help to post what DB you use, I suppose HSQLDB (because of tags)

          BTW this db should not used in production.

          • 2. Re: Problem auto creating table
            gvalenc

            I haven't tested the create command directly. Not sure how to do this. I am using the HSQLDB that comes with JBoss for testing purposes. This is my first time with JPA so just wanted to verify the mappings and such. I won't be using it for production.

             

            Can you point me to some docs somewhere to test the DB directly? In any case, the error msg seems to indicate a problem with the data type. Any thoughts on this?

            • 3. Re: Problem auto creating table
              wdfink

              Direct access to HSQLDB is possible with SQUIRREL  http://squirrel-sql.sourceforge.net/

              (but only if JBoss is down in case of HSQLDB).

               

              Maybe you might try a different database ...

              • 4. Re: Problem auto creating table
                gvalenc

                I am now trying Derby 10.3 but I get a different error (same JPA XML):

                 

                11:27:18,515 INFO  [SchemaExport] exporting generated schema to database
                11:27:18,515 ERROR [SchemaExport] Unsuccessful: create table SUBSCRIPTION_TABLE (DTYPE varchar(31) not null, SUBSCRIPTION_ID varchar not null, REPO_ID varchar(255), SUBSCRIBER_LOCATOR blob(255), ITEM_URN varchar(255), IT
                EMCLASS_NAME varchar(255), primary key (SUBSCRIPTION_ID))
                11:27:18,515 ERROR [SchemaExport] Syntax error: Encountered "not" at line 1, column 86.
                11:27:18,531 INFO  [SchemaExport] schema export complete
                11:27:18,531 WARN  [JDBCExceptionReporter] SQL Warning: 10000, SQLState: 01J01

                11:27:18,515 INFO  [SchemaExport] exporting generated schema to database

                11:27:18,515 ERROR [SchemaExport] Unsuccessful: create table ****_TABLE (DTYPE varchar(31) not null, ****_ID varchar not null, ABCD_ID varchar(255),****_LOCATOR blob(255), 1234_URN varchar(255), 5678_NAME varchar(255), primary key (****_ID))

                11:27:18,515 ERROR [SchemaExport] Syntax error: Encountered "not" at line 1, column 86.

                11:27:18,531 INFO  [SchemaExport] schema export complete

                11:27:18,531 WARN  [JDBCExceptionReporter] SQL Warning: 10000, SQLState: 01J01

                 

                I added this to JBOSS_HOME/server/default/deploy/hsqldb-ds.xml

                 

                {code:xml}

                <local-tx-datasource>

                 

                      <!-- The jndi name of the DataSource, it is prefixed with java:/ -->

                      <!-- Datasources are not available outside the virtual machine -->

                      <jndi-name>MyAppDataSource</jndi-name>

                 

                      <!-- for in-process persistent db, saved when jboss stops. The

                      org.jboss.jdbc.DerbyDatabase mbean is necessary for properly db shutdown -->

                      <connection-url>jdbc:derby:${jboss.server.data.dir}${/}derby${/}MyApp;create=true</connection-url>

                 

                      <!-- The driver class -->

                      <driver-class>org.apache.derby.jdbc.EmbeddedDriver</driver-class>

                 

                      <!-- The login and password -->

                      <user-name>sa</user-name>

                      <password></password>

                 

                      <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->

                      <min-pool-size>5</min-pool-size>

                 

                      <!-- The maximum connections in a pool/sub-pool -->

                      <max-pool-size>20</max-pool-size>

                 

                      <!-- The time before an unused connection is destroyed -->

                      <idle-timeout-minutes>5</idle-timeout-minutes>

                 

                      <!-- Whether to check all statements are closed when the connection is returned to the pool,

                           this is a debugging feature that should be turned off in production -->

                      <track-statements></track-statements>

                 

                      <!-- This mbean can be used when using in process persistent derby -->

                      <depends>jboss:service=Derby</depends>

                   </local-tx-datasource>

                 

                   <mbean code="org.jboss.jdbc.DerbyDatabase" name="jboss:service=Derby">

                      <attribute name="Database">MyApp</attribute>

                   </mbean>

                {code}

                 

                I took this from this wiki: http://community.jboss.org/wiki/SetUpADerbyDatasource

                • 5. Re: Problem auto creating table
                  gvalenc

                  For some reason, this SQL works when I execute it directly (via Eclipse DTP):

                   

                  {code}

                  create table SUBSCRIPTION_TABLE (
                     SUBSCRIPTION_ID varchar(255) primary key not null,
                     SUBSCRIBER_LOCATOR blob(1M),
                     REPO_ID varchar(255),
                     ITEM_URN varchar(255),
                     ITEMCLASS_NAME varchar(255)
                  );

                  create table ****_TABLE (

                     ****_ID varchar(255) primary key not null,

                     ****_LOCATOR blob(1M),

                     ABCD_ID varchar(255),

                     1234_URN varchar(255),

                     5678_NAME varchar(255)

                  );

                  {code}

                   

                  So it seems that Hibernate doesn't generate an SQL statement that Derby likes. In any case, I get this problem now as deployment begins:

                   

                  14:41:21,968 INFO  [SchemaValidator] Running schema validator

                  14:41:21,968 INFO  [SchemaValidator] fetching database metadata

                  14:41:22,843 INFO  [TableMetadata] table found: .SA.****_TABLE

                  14:41:22,843 INFO  [TableMetadata] columns: [****_locator, abcd_id, 1234_urn, ****_id, 5678_name]

                  14:41:22,843 ERROR [AbstractKernelController] Error installing to Start: name=persistence.unit:unitName=MyApp.ear/myapp_director.jar#MyApp state=Create

                  javax.persistence.PersistenceException: [PersistenceUnit: MyApp] Unable to build EntityManagerFactory

                  at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)

                  at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:132)

                  at org.jboss.jpa.deployment.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:301)

                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                  at java.lang.reflect.Method.invoke(Method.java:618)

                  at org.jboss.reflect.plugins.introspection.ReflectionUtils.invoke(ReflectionUtils.java:59)

                  at org.jboss.reflect.plugins.introspection.ReflectMethodInfoImpl.invoke(ReflectMethodInfoImpl.java:150)

                  at org.jboss.joinpoint.plugins.BasicMethodJoinPoint.dispatch(BasicMethodJoinPoint.java:66)

                  at org.jboss.kernel.plugins.dependency.KernelControllerContextAction$JoinpointDispatchWrapper.execute(KernelControllerContextAction.java:241)

                  at org.jboss.kernel.plugins.dependency.ExecutionWrapper.execute(ExecutionWrapper.java:47)

                  at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchExecutionWrapper(KernelControllerContextAction.java:109)

                  at org.jboss.kernel.plugins.dependency.KernelControllerContextAction.dispatchJoinPoint(KernelControllerContextAction.java:70)

                  at org.jboss.kernel.plugins.dependency.LifecycleAction.installActionInternal(LifecycleAction.java:221)

                  at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54)

                  at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42)

                  at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)

                  at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)

                  at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)

                  at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

                  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

                  at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

                  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

                  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

                  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:774)

                  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:540)

                  at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:121)

                  at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataDeployer.deploy(BeanMetaDataDeployer.java:51)

                  at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)

                  at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)

                  at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)

                  at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)

                  at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)

                  at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)

                  at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1210)

                  at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)

                  at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

                  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

                  at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

                  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

                  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

                  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

                  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

                  at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)

                  at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)

                  at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)

                  at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)

                  at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)

                  at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)

                  at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

                  at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

                  at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

                  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

                  at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

                  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

                  at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

                  at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)

                  at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)

                  at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)

                  at org.jboss.Main.boot(Main.java:221)

                  at org.jboss.Main$1.run(Main.java:556)

                  at java.lang.Thread.run(Thread.java:811)

                  Caused by:

                  org.hibernate.HibernateException: Missing column: DTYPE in .SA.****_TABLE

                  at org.hibernate.mapping.Table.validateColumns(Table.java:277)

                  at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1116)

                  at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)

                  at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:349)

                  at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)

                  at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)

                  at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)

                  ... 62 more

                  14:41:22,921 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

                   

                  DTYPE was used as in the SQL statement generated by Hibernate, but it results in an error. Can anyone see why that statement does not work?

                  • 6. Re: Problem auto creating table
                    gvalenc

                    I updated my persistence.xml to use hibernate.hbm2ddl.auto=true, and it seems to work, but I see something about a missing table. Should I be concerned?

                     

                    15:05:04,031 INFO  [SchemaUpdate] Running hbm2ddl schema update
                    15:05:04,031 INFO  [SchemaUpdate] fetching database metadata
                    15:05:04,031 INFO  [SchemaUpdate] updating schema
                    15:05:04,281 INFO  [TableMetadata] table found: .SA.SUBSCRIPTION_TABLE
                    15:05:04,281 INFO  [TableMetadata] columns: [subscriber_locator, repo_id, item_urn, subscription_id, itemclass_name]
                    15:05:04,281 INFO  [TableMetadata] foreign keys: []
                    15:05:04,281 INFO  [TableMetadata] indexes: [sql101122141632780]
                    15:05:04,281 INFO  [DatabaseMetadata] table not found: hibernate_unique_key
                    15:05:05,390 INFO  [SchemaUpdate] schema update complete

                    15:05:04,031 INFO  [SchemaUpdate] Running hbm2ddl schema update

                    15:05:04,031 INFO  [SchemaUpdate] fetching database metadata

                    15:05:04,031 INFO  [SchemaUpdate] updating schema

                    15:05:04,281 INFO  [TableMetadata] table found: .SA.****_TABLE

                    15:05:04,281 INFO  [TableMetadata] columns: [****_locator, abcd_id, 1234_urn, ****_id, 5678_name]

                    15:05:04,281 INFO  [TableMetadata] foreign keys: []

                    15:05:04,281 INFO  [TableMetadata] indexes: [sql101122141632780]

                    15:05:04,281 INFO  [DatabaseMetadata] table not found: hibernate_unique_key

                    15:05:05,390 INFO  [SchemaUpdate] schema update complete

                    • 7. Re: Problem auto creating table
                      gvalenc

                      Guess it creates the unique key table. Found this after restarting JBoss:

                       

                      17:20:52,125 INFO  [SchemaUpdate] updating schema
                      17:20:52,734 INFO  [TableMetadata] table found: .SA.SUBSCRIPTION_TABLE
                      17:20:52,734 INFO  [TableMetadata] columns: [subscriber_locator, repo_id, dtype, item_urn, subscription_id, itemclass_name]
                      17:20:52,734 INFO  [TableMetadata] foreign keys: []
                      17:20:52,734 INFO  [TableMetadata] indexes: [sql101122141632780]
                      17:20:52,750 INFO  [TableMetadata] table found: .SA.HIBERNATE_UNIQUE_KEY
                      17:20:52,750 INFO  [TableMetadata] columns: [next_hi]
                      17:20:52,750 INFO  [TableMetadata] foreign keys: []
                      17:20:52,750 INFO  [TableMetadata] indexes: []
                      17:20:52,750 INFO  [SchemaUpdate] schema update complete

                      17:20:52,734 INFO  [TableMetadata] foreign keys: []

                      17:20:52,734 INFO  [TableMetadata] indexes: [sql101122141632780]

                      17:20:52,750 INFO  [TableMetadata] table found: .SA.HIBERNATE_UNIQUE_KEY

                      17:20:52,750 INFO  [TableMetadata] columns: [next_hi]

                      17:20:52,750 INFO  [TableMetadata] foreign keys: []

                      17:20:52,750 INFO  [TableMetadata] indexes: []

                      17:20:52,750 INFO  [SchemaUpdate] schema update complete