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

    ejb3 with maxdb 7.6

    Mirko Buholzer Newbie

      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