3 Replies Latest reply on Jan 2, 2006 5:19 PM by buholzer

    ejb3 with maxdb 7.6

    buholzer

      Did anyone try to use maxdb with ejb3 as persistence store on jboss 4.0.3 SP1?

      I added a new DS for the maxdb:

      <local-tx-datasource>
      <jndi-name>alohaDS</jndi-name>
      <connection-url>jdbc:sapdb://127.0.0.1/MAXDB1</connection-url>
      <driver-class>com.sap.dbtech.jdbc.DriverSapDB</driver-class>
      <user-name>asdf</user-name>
      asdf

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->

      <type-mapping>SapDB</type-mapping>

      </local-tx-datasource>


      and changed for a first try/hack the ejb3.deployer\META-INF\persistence.properties to point to the new DS.

      This all seems to work, but when I deploy my entities i get Errors during the Schema Export:

      09:36:26,099 INFO [SettingsFactory] RDBMS: SAP DB, version: KERNEL 7.6.00 BUILD 009-123-105-149
      09:36:26,099 INFO [SettingsFactory] JDBC driver: SAP DB, version: package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0 Build 011-000-003-936
      09:36:26,177 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect
      09:36:26,193 INFO [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
      09:36:26,208 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
      09:36:26,224 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
      09:36:26,224 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
      09:36:26,224 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
      09:36:26,224 INFO [SettingsFactory] JDBC batch size: 15
      09:36:26,224 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
      09:36:26,224 INFO [SettingsFactory] Scrollable result sets: enabled
      09:36:26,224 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
      09:36:26,224 INFO [SettingsFactory] Connection release mode: after_statement
      09:36:26,240 INFO [SettingsFactory] Default batch fetch size: 1
      09:36:26,240 INFO [SettingsFactory] Generate SQL with comments: disabled
      09:36:26,240 INFO [SettingsFactory] Order SQL updates by primary key: disabled
      09:36:26,240 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      09:36:26,255 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
      09:36:26,255 INFO [SettingsFactory] Query language substitutions: {}
      09:36:26,255 INFO [SettingsFactory] Second-level cache: enabled
      09:36:26,255 INFO [SettingsFactory] Query cache: disabled
      09:36:26,255 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider
      09:36:26,255 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
      09:36:26,255 INFO [SettingsFactory] Structured second-level cache entries: disabled
      09:36:26,286 INFO [SettingsFactory] Statistics: disabled
      09:36:26,286 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: enabled
      09:36:26,286 INFO [SettingsFactory] Default entity-mode: POJO
      09:36:26,740 INFO [SessionFactoryImpl] building session factory
      09:36:28,786 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
      09:36:28,818 INFO [Configuration] processing extends queue
      09:36:28,818 INFO [Configuration] processing collection mappings
      09:36:28,818 INFO [Configuration] processing association property references
      09:36:28,818 INFO [Configuration] processing foreign key constraints
      09:36:28,833 INFO [Configuration] processing extends queue
      09:36:28,833 INFO [Configuration] processing collection mappings
      09:36:28,833 INFO [Configuration] processing association property references
      09:36:28,833 INFO [Configuration] processing foreign key constraints
      09:36:28,833 INFO [SchemaExport] Running hbm2ddl schema export
      09:36:28,833 INFO [SchemaExport] exporting generated schema to database
      09:36:28,880 ERROR [SchemaExport] Unsuccessful: create table bp_address (address_id bigint generated by default as identity (start with 1), location varchar(255), primary key (address_id))
      09:36:28,880 ERROR [SchemaExport] [-5016] (at 44): Missing delimiter: )


      any ideas are more than welcome!
      mirko

        • 1. Re: ejb3 with maxdb 7.6
          buholzer

          Got it -
          Need to set the dialect property right:

          server\default\deploy\ejb3.deployer\META-INF\persistence.properties
          hibernate.dialect=org.hibernate.dialect.SAPDBDialect

          mirko

          • 2. Re: ejb3 with maxdb 7.6
            epbernard

            you should define the DS and dialect in a META-INF/persistence.xml file inside your persistence archive, not in persistence.properties

            • 3. Re: ejb3 with maxdb 7.6
              buholzer

              I was using the persistence.properties file only as quick and dirty hack.

              Now I was able to successfully deploy with a persistence.xml

              <entity-manager>
               <name>aloha</name>
               <jta-data-source>java:/maxdbDS</jta-data-source>
               <properties>
               <property name="hibernate.dialect"
               value="org.hibernate.dialect.SAPDBDialect "/>
               <property name="hibernate.hbm2ddl.auto"
               value="create-drop"/>
               </properties>
              </entity-manager>