2 Replies Latest reply on May 5, 2008 7:19 AM by Jeroen Wenting

    Q: Using Hibernate with the jdbc:odbc bridge

    Adam Bradley Newbie

      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