-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 10 posts ] 
  Previous topic | Next topic 
Author Message
mraible
 Post subject: Hibernate works fine with DB2 8.1, but not 7.2
PostPosted: Tue Jan 20, 2004 4:41 pm 
Beginner
Beginner

Joined: Sun Oct 05, 2003 9:07 am
Posts: 47
I have an application that I recently ported from MySQL to DB2 - and it was extremely easy thanks to Hibernate. I got everything working using JDK 1.4 and DB2 8.1. At my client, they're using DB2 7.2 in production - so this is the target platform. I've been trying for a couple of days to get everything to work, but I get Hibernate related errors in my web layer (Struts Actions) on a few of my tests. Specifically, when saving a user's information. My basic question is:

Does anyone know of any major differences between DB2 7.2 and 8.1?

It seems strange to me that it works on one and not the other. Of course, the DB2 7.2 database sits on a different server, and I believe it uses JDK 1.3, but I wouldn't think that'd matter. I am using the .net. driver instead of the .app. driver (since I couldn't get the .app.) one to work.

If no one knows of any major differences, I can post my errors.

Thanks,

Matt
Top
 Profile  
 
michael
 Post subject:
PostPosted: Tue Jan 20, 2004 6:02 pm 
Hibernate Team
Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany
Post the errors.
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Wed Jan 21, 2004 9:22 am 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
Be specific on the DB2 env (AS400, MVS, W2k...)

_________________
Emmanuel

Top
 Profile  
 
mraible
 Post subject: DB2 env
PostPosted: Wed Jan 21, 2004 9:30 am 
Beginner
Beginner

Joined: Sun Oct 05, 2003 9:07 am
Posts: 47
DB2 8.1: Windows XP Desktop, JDK 1.4.2
DE2 7.1: Windows 2000 Server, whatever JDK gets installed with DB2

I'll report back with the errors when I get into the office today.
Top
 Profile  
 
mraible
 Post subject: Errors when running the tests on DB2 7.2
PostPosted: Wed Jan 21, 2004 9:34 pm 
Beginner
Beginner

Joined: Sun Oct 05, 2003 9:07 am
Posts: 47
I did a fresh install of db2 8.1 today, fixed a couple of bugs and got all tests running lickedly split (no errors) on that. The box that 8.1 sits on is very similar to the 7.2 box, save for RAM and CPU power.

However, I do still get an error on 7.2, but not 8.1 - it's the same code, so I don't know what's wrong - maybe the JDBC driver or something.

Code:
SaveContact:
[runservertests] Rhino classes (js.jar) not found - Javascript disabled
     [java] [apptracker] DEBUG [TP-Processor3] LoginServlet.execute(215) | Encrypting password for user 'administrator'
     [java] [apptracker] DEBUG [TP-Processor3] LoginServlet.execute(226) | Authenticating user 'administrator'
     [java] [apptracker] DEBUG [TP-Processor3] GZIPFilter.isGZIPSupported(76) | httpunit detected, disabling filter...
     [java] [apptracker] DEBUG [TP-Processor3] GZIPFilter.isGZIPSupported(76) | httpunit detected, disabling filter...
     [java] [apptracker] DEBUG [TP-Processor3] ContactAction.edit(135) | Entering 'edit' method
     [java] [apptracker] DEBUG [TP-Processor3] GZIPFilter.isGZIPSupported(76) | httpunit detected, disabling filter...
     [java] [apptracker] DEBUG [TP-Processor3] ContactAction.save(158) | Entering 'save' method
     [java] [apptracker] DEBUG [TP-Processor3] ContactDAOHibernate.saveContact(104) | contact's id: 1
     [java] [apptracker] ERROR [TP-Processor3] JDBCExceptionReporter.logExceptions(46) | [IBM][JDBC Driver] CLI0601E  Invalid statement handle or statement is closed. SQLSTATE=S1000
     [java] [apptracker] ERROR [TP-Processor3] JDBCExceptionReporter.logExceptions(46) | [IBM][JDBC Driver] CLI0601E  Invalid statement handle or statement is closed. SQLSTATE=S1000
     [java] [apptracker] ERROR [TP-Processor3] JDBCExceptionReporter.logExceptions(46) | [IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010
     [java] [apptracker] ERROR [TP-Processor3] JDBCException.<init>(38) | could not update: [us.co.adams.apptracker.persistence.Contact#1]
     [java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010
     [java]     at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:230)
     [java]     at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:394)
     [java]     at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:372)
     [java]     at COM.ibm.db2.jdbc.net.DB2PreparedStatement.loadParameters(DB2PreparedStatement.java:475)
     [java]     at COM.ibm.db2.jdbc.net.DB2PreparedStatement.execute2(DB2PreparedStatement.java:674)
     [java]     at COM.ibm.db2.jdbc.net.DB2PreparedStatement.executeUpdate(DB2PreparedStatement.java:592)
     [java]     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
     [java]     at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
     [java]     at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:672)
     [java]     at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:625)
     [java]     at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52)
     [java]     at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2308)
     [java]     at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2262)
     [java]     at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2187)
     [java]     at us.co.adams.apptracker.persistence.BaseDAOHibernate.saveObject(BaseDAOHibernate.java:100)
     [java]     at us.co.adams.apptracker.persistence.ContactDAOHibernate.saveContact(ContactDAOHibernate.java:107)
     [java]     at us.co.adams.apptracker.webapp.service.ContactManagerImpl.saveContact(ContactManagerImpl.java:112)
     [java]     at us.co.adams.apptracker.webapp.action.ContactAction.save(ContactAction.java:169)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at java.lang.reflect.Method.invoke(Method.java:324)
     [java]     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
     [java]     at us.co.adams.apptracker.webapp.action.BaseAction.execute(BaseAction.java:169)
     [java]     at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
     [java]     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
     [java]     at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
     [java]     at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at us.co.adams.apptracker.webapp.filter.ActionFilter.doFilter(ActionFilter.java:184)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:95)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at us.co.adams.apptracker.webapp.filter.GZIPFilter.doFilter(GZIPFilter.java:57)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
     [java]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
     [java]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
     [java]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
     [java]     at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
     [java]     at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
     [java]     at java.lang.Thread.run(Thread.java:554)
     [java] [apptracker] ERROR [TP-Processor3] SessionImpl.execute(2269) | Could not synchronize database state with session
     [java] net.sf.hibernate.JDBCException: could not update: [us.co.adams.apptracker.persistence.Contact#1]
     [java]     at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:690)
     [java]     at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:625)
     [java]     at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52)
     [java]     at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2308)
     [java]     at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2262)
     [java]     at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2187)
     [java]     at us.co.adams.apptracker.persistence.BaseDAOHibernate.saveObject(BaseDAOHibernate.java:100)
     [java]     at us.co.adams.apptracker.persistence.ContactDAOHibernate.saveContact(ContactDAOHibernate.java:107)
     [java]     at us.co.adams.apptracker.webapp.service.ContactManagerImpl.saveContact(ContactManagerImpl.java:112)
     [java]     at us.co.adams.apptracker.webapp.action.ContactAction.save(ContactAction.java:169)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [java]     at java.lang.reflect.Method.invoke(Method.java:324)
     [java]     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
     [java]     at us.co.adams.apptracker.webapp.action.BaseAction.execute(BaseAction.java:169)
     [java]     at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
     [java]     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
     [java]     at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
     [java]     at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
     [java]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at us.co.adams.apptracker.webapp.filter.ActionFilter.doFilter(ActionFilter.java:184)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:95)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at us.co.adams.apptracker.webapp.filter.GZIPFilter.doFilter(GZIPFilter.java:57)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
     [java]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
     [java]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
     [java]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
     [java]     at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
     [java]     at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
     [java]     at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
     [java]     at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
     [java]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
     [java]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
     [java]     at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
     [java]     at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
     [java]     at java.lang.Thread.run(Thread.java:554)
     [java] Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E  Function sequence error. SQLSTATE=HY010
     [java]     at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:230)
     [java]     at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:394)
     [java]     at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:372)
     [java]     at COM.ibm.db2.jdbc.net.DB2PreparedStatement.loadParameters(DB2PreparedStatement.java:475)
     [java]     at COM.ibm.db2.jdbc.net.DB2PreparedStatement.execute2(DB2PreparedStatement.java:674)
     [java]     at COM.ibm.db2.jdbc.net.DB2PreparedStatement.executeUpdate(DB2PreparedStatement.java:592)
     [java]     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)
     [java]     at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
     [java]     at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:672)
     [java]     ... 61 more


Here's the sequence of calls after ContactAction.save()

ContactAction.java
------------
Code:
        ContactManager mgr =
                new ContactManagerImpl(ActionFilter.getConnection());
        contactForm = (ContactForm) mgr.saveContact(contactForm);


ContactManagerImpl.java
--------------
Code:
public Object saveContact(Object obj)
            throws Exception {
        if (contact == null) {
            contact = new Contact();
        }

        contactForm = (ContactForm) obj;

        // copy form properties to contact
        try {
            BeanUtils.copyProperties(contact, contactForm);
        } catch (IllegalArgumentException i) {
            log.error("Exception occured copying properties", i);
            throw new ConversionException();
        }

        if (contact.getContactTypeId() == null) {
            contact.setContactTypeId(new Long(0));
        }

        // all contacts that are "saved" remain active as there
        // is no way to de-activate them from the UI (except to delete them)
        contact.setActive(Boolean.TRUE);

        dao.saveContact(contact);

        return getContact(String.valueOf(contact.getId()));
    }


ContactDAOHibernate.java
-------
Code:
    public Contact saveContact(Contact contact) throws DAOException {
        if (log.isDebugEnabled()) {
            log.debug("contact's id: " + contact.getId());
        }

        saveObject(ses, contact);

        return contact;
    }


BaseDAOHibernate.java
---------
Code:
    protected void saveObject(Session ses, Object obj)
    throws DAOException {
        try {
            ses.saveOrUpdate(obj);
            ses.flush();
        } catch (Exception e) {
            try {
                ses.connection().rollback();
            } catch (Exception ex) {
                e.printStackTrace();
            }

            ;
            throw new DAOException(e);
        }
    }


BTW, this code runs fine on MySQL as well.
Top
 Profile  
 
michael
 Post subject:
PostPosted: Thu Jan 22, 2004 4:07 am 
Hibernate Team
Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany
Try disabling prepared statement pooling. And enable Hibernate SQL logging and try to execute the SQL manually against the DB and see if it works.
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Thu Jan 22, 2004 4:36 am 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
Isn't there a DB2 8 JDBC driver ?

_________________
Emmanuel

Top
 Profile  
 
mraible
 Post subject:
PostPosted: Thu Jan 22, 2004 9:22 am 
Beginner
Beginner

Joined: Sun Oct 05, 2003 9:07 am
Posts: 47
emmanuel wrote:
Isn't there a DB2 8 JDBC driver ?


Yes, there are different JDBC Drivers depending on which database version you're using. You *must* use the db2java.zip (rename to .jar) from the target server you're pointing at. I've found that using the 8.1 driver on 7.2 kills the JDBC Listener server (Applet Service).

I think if I found a 3rd-party JDBC Driver for DB2, it might eliminate my issues. I'll try disabling the preparedstatement pooling.
Top
 Profile  
 
mraible
 Post subject: disabled prepared statement caching, batches
PostPosted: Thu Jan 22, 2004 1:45 pm 
Beginner
Beginner

Joined: Sun Oct 05, 2003 9:07 am
Posts: 47
According to http://www.hibernate.org/120.html, I need to disable batch statements for DB2, so I tried adding the following properties to my hibernate.cfg.xml, but no luck - I get the same error.

Are these settings right? How do I verify they're actually working? I also tried them w/o the "hibernate." prefix.

Code:
        <property name="hibernate.statement_cache.size">0</property>
        <property name="hibernate.jdbc.batch_size">0</property>
        <property name="hibernate.jdbc.use_scrollable_resultsets">0</property>
Top
 Profile  
 
mraible
 Post subject: Fixpack 11 Fixed the problem
PostPosted: Sun Jan 25, 2004 10:39 pm 
Beginner
Beginner

Joined: Sun Oct 05, 2003 9:07 am
Posts: 47
I updated to DB2's FixPack 11 (for version 7.2) and it fixed all my issues. My DB2 database is running on a Windows 2000 server.

You can get this fixpack at:

http://www-3.ibm.com/cgi-bin/db2www/dat ... d2w/report
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 10 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.