Re: Anybody here have any experience running Rollbase on a V6 box?(cross-posted)

Hi James,

From this,

java.sql.SQLException: Transaction state not valid.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:360)
at com.ibm.as400.access.AS400JDBCConnection.setReadOnly(AS400JDBCConnection.java:2885)

I'd check to see if journaling is on. That's how the AS/400 handles commitment control and transactions. If you created a collection or schema, that's done for you automatically, but otherwise, as I'm sure you're aware, you have to crank up journaling yourself. The AS/400 actually defaults to JDBC_TRANSACTION_NONE, but it's one of the few systems to do so and allow most things to work.

Now, I suppose it could also fail if there were exclusive locks, but from what you sent, no journaling would be my first guess. If you've got it done on your box, check what's different in their set up. Here's a reasonable description of transactions:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzaha%2Ftransiso.htm

HTH,


Joe Sam

Joe Sam Shirah - www.conceptgo.com (904) 302-6870
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: www.ibm.com/developerworks/java
Just the JDBC FAQs: www.jguru.com/faq/JDBC
Going International? www.jguru.com/faq/I18N
Que Java400? www.jguru.com/faq/Java400




-----Original Message----- From: James Lampert
Sent: Tuesday, July 10, 2012 12:42 PM
To: Midrange Systems Technical Discussion ; Java Programming on and around the iSeries / AS400
Subject: Anybody here have any experience running Rollbase on a V6 box?(cross-posted)

We now appear to be over the hurdle of setting up the RB_DBO
library/schema (thanks again, Rob and Luis), but our offsite people are
now getting this, when they go to the next step (and I'm typing this by
hand, from a screen shot; you'd think a fellow programmer would know
better!):

==>> Installing local Rollbase instance
RB_1: UPDATE RB_ID SET NEXT_ID=?
Creating Master Zone: system records
Creating Master Zone: installing app1_rb.xml

===>> Installing application: Rollbase [v.1]
Created object definition USER
Created object definition $GROUP
Created object definition $SETTINGS
Created object definition $ORG_FUNC
Created object definition COMMLOG
Created object definition $ORG_LOCN
Created object definition $ORG_DEPT
Created object definition tudo
Created object definition meeting
Finishing application: Rollbase...
java.sql.SQLException: Transaction state not valid.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:360)
at com.ibm.as400.access.AS400JDBCConnection.setReadOnly(AS400JDBCConnection.java:2885)
at com.rb.util.db.a414.setReadOnly(a414.java:272)
at com.rb.util.db.a413.getConnection(a413.java:94)
at com.rb.util.db.a415.getConnection(a415.java:46)
at com.rb.util.db.a415.getConnection(a415.java:35)
at p12.a221.x24(a221.java:335)
at com.rb.core.data.a71.getReports(a71.java:843)
at p12.a221.getReports(a221.java:363)
at p12.a221.getByOriginalId(a221.java:112)
at p0.a39.createReport(a39.java:1128)
at p0.a39.createObjectDefParts2(a39.java:461)
at p0.a39.install(a39.java:242)
at p25.a343.checkInstallation(a343.java:96)
at com.rb.master.logics.servlet.Starter.init(Starter.java:65)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1306)

Anybody have any insight?

--
JHHL