Hibernate 2.1.6
With DB2 on iServer V5R1
hibernate properties file at end of post
I
AM having a problem with AS400 and hope dirk can shed some light.
In spite of many alternative attempts, I can not insert records into a
table. Below is error message:
[java] Hibernate: insert into TRMIDOH ( ... ) values (...)
[java] 12:39:57,671 WARN JDBCExceptionReporter:38 - SQL Error: -7008, SQLState: 55019
[java] 12:39:57,671 ERROR JDBCExceptionReporter:46 - [SQL7008] TRMIDOH in TESTTRUST not valid for operation.
From other forums, I have learned this is related to 1) journaling
and/or 2) auto commit. See below Is this to believed?
My dba insists jourmalling is on for table in question and
Hibernate in Action tells me auto commit is set to FALSE for
all connections by default.
Does anyone (dirk?) have any ideas? Am I in need of any
special properties on url? Is there an explicit way to set
auto commit false? (numerous googles have given no answer)
A couple other notes: The insert in question WORKS from
a sql interpreter when connected as same user.
AND
I can read records.
TIA
Rob
hibernate.properties
hibernate.dialect=net.sf.hibernate.dialect.DB2400Dialect
hibernate.connection.driver_class=com.ibm.as400.access.AS400JDBCDriver
hibernate.connection.isolation=4
hibernate.connection.url=jdbc:as400://192.168.1.3/testtrust
hibernate.connection.username=<...>
hibernate.connection.password=<...>
The AS400 Expert says:
Quote:
Subject: Re: Error 7008 Please help.
Reply | Reply to Author | Forward | Print | Individual Message | Show original | Report Abuse
Your Insert/Update request is running under commitment control which
requires journalling/logging of the target table on the AS/400. So
you need to start journalling the table on the AS/400 or disable
commitment control for this request.
--
Kent Milligan, DB2/400 Solutions Team
AS/400 Partners In Development
k...@us.ibm.com