ejb3 with maxdb 7.6
buholzer Jan 2, 2006 4:09 AMDid 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