Dissable batch updates, there is no batch updates in server protocol, driver just emulates this feature and it will not increase performance on postgresql at this time.
> I think it is a bug in the Postgres implementation of JDBC batch updates. > > Gerry Duprey wrote: > > > Howdy, > > > > I'm new to hibernate and have run into a problem almost immediatly in > > my test > > program while trying to save a new object/record. I've tried this with > > Hibernate 2.0.3 and 2.1b3. This is on PostreSQL7. > > > > After creating a hibernatable object instance, I attempt to save it > > and close > > the transaction. When I do, I get an exception like this: > > > > 16:29:31,379 DEBUG BatcherImpl:24 - Adding to batch > > 16:29:31,381 DEBUG BatcherImpl:46 - Executing batch size: 1 > > 16:29:31,423 ERROR BatcherImpl:62 - Exception executing batch: > > java.lang.ArrayIndexOutOfBoundsException: 1 > > at org.postgresql.core.QueryExecutor.sendQuery(QueryExecutor.java:143) > > at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:65) > > at > > org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection .java:451) > > > > at > > org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j ava:281) > > > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j ava:48) > > > > at > > org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State ment.java:179) > > > > at > > org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State ment.java:165) > > > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statem ent.java:80) > > > > at > > net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:50 ) > > > > at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:116) > > at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2281) > > > > There is more and I can provide it if necessary. The code for > > xreating and committing the > > new record looks like: > > > > Session theSession = theContext.getSession(); > > Transaction theTransaction = theSession.beginTransaction(); > > > > UserProfile baseUser = (UserProfile) > > theSession.load(UserProfile.class, > > new Integer(1)); > > UserRole baseRole = (UserRole) theSession.load(UserRole.class, new > > Integer(1)); > > DAOChangeNote changeNote = (DAOChangeNote) > > DAOCommonFactory.getFactory().createChangeNote(baseUser); > > > > UserProfile theUser = (UserProfile) > > DAOCommonFactory.getFactory().createUserProfile(); > > > > theUser.setName(userName); > > //theUser.setFullName(new Name()); > > theUser.setRole(baseRole); > > theUser.setChangeNote(changeNote); > > > > theSession.save(theUser); > > theSession.flush(); > > theSession.commitTransaction(); > > > > The error occurs when I do the theSession.flush(). I'm pretty sure the > > mappings are OK because I am able to load up other records of this > > same table > > (the baseUser theSession.load() call) and it seems to work. > > > > I realize there are probably hundreds of different places where this > > could be > > going wrong. If someone could suggest a few likely things to check, > > I'd appreciate it. > > > > Thanks much! > > > > Gerry > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
