Q: Using Hibernate with the jdbc:odbc bridge
I've been able to run this instance of Hibernate outside of the AS, but as soon as I try and deploy it inside I receive the following
22:11:49,935 INFO [STDOUT] 22:11:49,935 INFO [ServiceBean] Exposing service with name {http://webservice.myob.identityconcepts.com.au}authenticate
22:11:51,732 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
22:11:52,403 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
22:11:52,747 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
22:11:52,794 INFO [JkMain] Jk running ID=0 time=0/203 config=null
22:11:52,810 INFO [Server] JBoss (MX MicroKernel) [4.0.4.GA (build: CVSTag=JBoss_4_0_4_GA date=200605151000)] Started in 2m:50s:313ms
22:14:32,560 INFO [STDOUT] 22:14:32,560 INFO [Environment] Hibernate 3.2.1
22:14:32,607 INFO [STDOUT] 22:14:32,607 INFO [Environment] hibernate.properties not found
22:14:32,607 INFO [STDOUT] 22:14:32,607 INFO [Environment] Bytecode provider name : cglib
22:14:32,622 INFO [STDOUT] 22:14:32,622 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
22:14:32,841 INFO [STDOUT] 22:14:32,841 INFO [Configuration] configuring from resource: /WEB-INF/classes/hibernate.cfg.xml
22:14:32,841 INFO [STDOUT] 22:14:32,841 INFO [Configuration] Configuration resource: /WEB-INF/classes/hibernate.cfg.xml
22:14:33,028 INFO [STDOUT] 22:14:33,028 INFO [Configuration] Reading mappings from resource : au/com/identityconcepts/myob/sync/hibernate/Customers.
xml
22:14:33,247 INFO [STDOUT] 22:14:33,247 INFO [HbmBinder] Mapping class: au.com.identityconcepts.myob.sync.hibernate.Customers -> Customers
22:14:33,372 INFO [STDOUT] 22:14:33,372 INFO [Configuration] Reading mappings from resource : au/com/identityconcepts/myob/sync/hibernate/Address.xm
l
22:14:33,388 INFO [STDOUT] 22:14:33,388 INFO [HbmBinder] Mapping class: au.com.identityconcepts.myob.sync.hibernate.Address -> Address
22:14:33,419 INFO [STDOUT] 22:14:33,419 INFO [Configuration] Reading mappings from resource : au/com/identityconcepts/myob/sync/hibernate/Employees.
xml
22:14:33,435 INFO [STDOUT] 22:14:33,435 INFO [HbmBinder] Mapping class: au.com.identityconcepts.myob.sync.hibernate.Employees -> Employees
22:14:33,466 INFO [STDOUT] 22:14:33,466 INFO [Configuration] Reading mappings from resource : au/com/identityconcepts/myob/sync/hibernate/PersonalCa
rds.xml
22:14:33,482 INFO [STDOUT] 22:14:33,482 INFO [HbmBinder] Mapping class: au.com.identityconcepts.myob.sync.hibernate.PersonalCards -> PersonalCards
22:14:33,513 INFO [STDOUT] 22:14:33,513 INFO [Configuration] Reading mappings from resource : au/com/identityconcepts/myob/sync/hibernate/Suppliers.
xml
22:14:33,544 INFO [STDOUT] 22:14:33,544 INFO [HbmBinder] Mapping class: au.com.identityconcepts.myob.sync.hibernate.Suppliers -> Suppliers
22:14:33,575 INFO [STDOUT] 22:14:33,575 INFO [Configuration] Configured SessionFactory: null
22:14:33,794 INFO [STDOUT] 22:14:33,794 INFO [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
22:14:33,810 INFO [STDOUT] 22:14:33,810 INFO [DriverManagerConnectionProvider] Hibernate connection pool size: 1
22:14:33,810 INFO [STDOUT] 22:14:33,810 INFO [DriverManagerConnectionProvider] autocommit mode: false
22:14:33,841 INFO [STDOUT] 22:14:33,841 INFO [DriverManagerConnectionProvider] using driver: sun.jdbc.odbc.JdbcOdbcDriver at URL: jdbc:odbc:Driver={
MYOB_ODBC};TYPE=MYOB;UID=Administrator;PWD=password;KEY=C:\myob15\615541809127.key;DATABASE=C:\myob15\Acme.myo;HOST_EXE_PATH=C:\myob15\Myob.exe;ACCESS
_TYPE=READ_WRITE;Identify_By=Card_Name;SUPPRESS_WARNING=TRUE;
22:14:33,872 INFO [STDOUT] 22:14:33,872 INFO [DriverManagerConnectionProvider] connection properties: {user=, password=, autocommit=false}
CLI : [TID: B84]:[Sat Mar 03 22:14:36 2007] rdacstmt.c:99: *** rda_cliAllocStmt: connection is not opened
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x2a2694e5, pid=240, tid=2948
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_07-b03 mixed mode)
# Problematic frame:
# C [odbcmyob.dll+0x3794e5]
#
# An error report file with more information is saved as hs_err_pid240.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
CLI : [TID: B84]:[Sat Mar 03 22:14:36 2007] rdachenv.c:342: rda_cliFreeEnv() 1 connection handles still exist under this environment handle
[error occurred during error reporting, step 270, id 0xc0000005]
Any thoughts on how to address this?
Thanks in advance.
Adam
