199 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
WebSphere Application Server - Scripting Security
Wed, Jul 26th 2017 16
WebSphere Liberty Profile - Variables
Wed, Jul 26th 2017 11
Moving an IBM BPM 8.5.7 environment, dealing with the Service Integration Bus (SIBus ) tables
Wed, Jul 26th 2017 11
Hmm, Box Sync not playing nice - "Unable to Connect to Box"
Wed, Jul 26th 2017 9
IBM BPM and the Process Federation Server - A Voyage of Discovery #3
Tue, Jul 25th 2017 11
IBM BPM and the Process Federation Server - A Voyage of Discovery #2
Tue, Jul 25th 2017 10
IBM BPM and the Process Federation Server - A Voyage of Discovery #1
Tue, Jul 25th 2017 10
Top 10
java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002
Mon, Jul 24th 2017 74
Further adventures with Oracle database - ORA-01078 and LRM-00109
Mon, Jul 24th 2017 59
Transport Layer Security (TLS) 1.2 and SoapUI
Fri, Jun 12th 2015 47
Hmmm, macOS Sierra and XQuartz and X11
Thu, Oct 27th 2016 37
IBM HTTP Server / IBM WebSphere Plugin - Using Transport Layer (TLS) 1.2
Tue, Nov 10th 2015 36
Executing external Python/Jython scripts from within WebSphere Application Server's wsadmin tool
Thu, Feb 27th 2014 33
java.lang.UnsupportedClassVersionError: JVMCFRE003 bad major version; class=com/davehay/EmployeeServlet, offset=6
Sat, Nov 8th 2014 31
WebSphere Application Server - Transaction Logs - getting it wrong
Sun, Jul 16th 2017 26
WAS - How to clear the WebSphere class caches
Mon, Feb 10th 2014 25
"SECJ0371W: Validation of the LTPA token failed because the token expired with the following info..." - much more useful with WAS 8.5
Wed, Feb 12th 2014 25


java.sql.SQLException: Could not commit with auto-commit set on
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

I saw this earlier: -

[14/07/17 20:00:02:593 BST]     FFDC Exception:java.sql.SQLException SourceId:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit ProbeId:587 Reporter:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@964a1c09
java.sql.SQLException: Could not commit with auto-commit set on

in the FFDC logs for an IBM BPM 8.57 JVM: -

view /opt/ibm/WebSphereProfiles/AppSrv01/logs/ffdc/AppClusterMember1_72d880eb_17.07.14_20.00.02.5935101433318572951378.txt 

I am using Oracle 12c ( specifically 12.2.0.1.0  )

and am using the version of the Oracle JDBC drivers that ship with WAS 8.5.5.11: -

ls -altrc /opt/ibm/WebSphere/AppServer/jdbcdrivers/Oracle/

total 6632
-rw-r--r-- 1 wasadmin wasadmins 3389454 Jul 10 19:59 ojdbc6.jar
drwxr-xr-x 5 wasadmin wasadmins      45 Jul 10 19:59 ..
drwxr-xr-x 2 wasadmin wasadmins      40 Jul 10 19:59 .
-rw-r--r-- 1 wasadmin wasadmins 3397734 Jul 10 19:59 ojdbc7.jar


specifically: -

/opt/ibm/WebSphere/AppServer/java_1.7.1_64/jre/bin/java -jar /opt/ibm/WebSphere/AppServer/jdbcdrivers/Oracle/ojdbc6.jar -getversion

Oracle 12.1.0.1.0 JDBC 4.0 compiled with JDK6 on Thu_Apr_04_15:06:58_PDT_2013
#Default Connection Properties Resource
#Fri Jul 14 20:11:21 BST 2017


Source: Checking the Oracle JDBC Driver Version on a Weblogic Server

Thankfully, this IBM developerWorks Answers ( dwAnswers ) page: -


provides an answer: -

This kind of exceptions occur when the Oracle JDBC Driver (ojdbc6.jar) version 12 or above will be used. Version 12 and above of the driver is more strictly than earlier driver versions. You can solve the problem, by setting the jvm-argument:

•  -Doracle.jdbc.autoCommitSpecCompliant=false
on all affected servers.

as does this IBM Technote: -


Once I added the JVM property, and restarted the AppCluster, all was well.

For the record, this is what I now have in server.xml in the context of JVM arguments: -

    <jvmEntries xmi:id="JavaVirtualMachine_1499716654178" verboseModeClass="false" verboseModeGarbageCollection="true" verboseModeJNI="false" initialHeapSize="1536" maximumHeapSize="2560" runHProf="false" hprofArguments="" debugMode="false" debugArgs="-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=7777" genericJvmArguments="${IBMSCMX} ${IBMGCPOLICY_GENCON} ${IBMJITPMC} -Xmns256m -Xmnx768m -Xgc:preferredHeapBase=0x100000000 -Xdisableexplicitgc -Xss2048k -Dsun.net.http.allowRestrictedHeaders=true -Declipse.bundle.setTCCL=false  -Doracle.jdbc.autoCommitSpecCompliant=false" executableJarFileName="" disableJIT="false">

and, via the GUI: -





---------------------
http://portal2portal.blogspot.com/2017/07/javasqlsqlexception-could-not-commit.html
Jul 14, 2017
21 hits



Recent Blog Posts
16
WebSphere Application Server - Scripting Security
Wed, Jul 26th 2017 1:45p   Dave Hay
I'm creating a set of scripts to automate a number of common tasks, including setting up Web SSO: - /mnt/Scripts/enableSSO.jy AdminTask.configureSingleSignon(['-enable', 'true', '-requiresSSL', 'true', '-domainName', 'uk.ibm.com']) # Save and Sync AdminConfig.save() AdminNodeManagement.syncActiveNodes() /mnt/Scripts/exportLTPAkeys.jyAdminTask.exportLTPAKeys('[-ltpaKeyFile file:/mnt/Misc/bpm855.uk.ibm.com.ltpa -password passw0rd ]') /mnt/Scripts/importLTPAkeys.jy AdminTask.config
11
WebSphere Liberty Profile - Variables
Wed, Jul 26th 2017 12:58p   Dave Hay
As per my previous posts, I'm setting up an IBM BPM Process Federation Server (PFS), which runs on WebSphere Liberty Profile (WLP).I'm now going back through the setup from scratch, to see (a) what I learned and (b) whether I can repeat my success :-)Looking at the WLP configuration file - server.xml - I'd noticed reference to a pair of variables: -… …and was trying to work out what, if anything, the difference is, given that they actually point to a the same darn file.This helped:
11
Moving an IBM BPM 8.5.7 environment, dealing with the Service Integration Bus (SIBus ) tables
Wed, Jul 26th 2017 10:32a   Dave Hay
I'm working through this process: -Migrating IBM BPM to the same version on new hardwarespecifically testing the process of "lifting and shifting" an IBM BPM Deployment Environment from one VM to another.This is, in part, to help a client move a running environment from Red Hat Enterprise Linux v5 to v7.So I've got a working environment on a VM, and I've exported the BPM Deployment Environment thus: -/opt/ibm/WebSphere/AppServer/bin/BPMConfig.sh -export -de De1 -profile Dmgr01 -outputDir /t
9
Hmm, Box Sync not playing nice - "Unable to Connect to Box"
Wed, Jul 26th 2017 6:34a   Dave Hay
So I started seeing this: -Unable to Connect to BoxBox Sync is unable to connect to Box.Verify that you are connected to the Internet and restart Box Sync.If you continue to see this message, contact your administrator to verify if it is a network issue.If it is not a network issue, visit the Box Support website to submit a ticket.yesterday, on my Mac.No matter how many times I tried stopping/starting the Box Sync app, it flatly refused to connect.This whilst I was working away on Box via my bro
11
IBM BPM and the Process Federation Server - A Voyage of Discovery #3
Tue, Jul 25th 2017 4:07p   Dave Hay
So, following these two posts: -IBM BPM and the Process Federation Server - A Voyage of Discovery #1IBM BPM and the Process Federation Server - A Voyage of Discovery #2once I'd got PFS set up and (mostly) working, I did some testing.However, I kept seeing errors such as this: -when I logged into the BPM 8.5.7 Process Portal ( if you remember, this is the new go-to Portal for everything, including the 8.5.5 instances ) via this URL: -https://bpm857.uk.ibm.com:8443/ProcessPortalTalking to some of
10
IBM BPM and the Process Federation Server - A Voyage of Discovery #2
Tue, Jul 25th 2017 3:55p   Dave Hay
So, following on from my earlier post: -IBM BPM and the Process Federation Server - A Voyage of Discovery #1it took me a while to realise that PFS is NOT a UI in its own right; it merely aggregates processes from other BPMs into one single Process Portal.However, YOU need to provide that Process Portal :-)So, in my limited test rig here, I have four VMs: -BPM 8.5.5 This is my source environment, from which I am migrating, which has running instances which I need to drain down over timeBPM 8.5.7
10
IBM BPM and the Process Federation Server - A Voyage of Discovery #1
Tue, Jul 25th 2017 3:40p   Dave Hay
So I've spent the past week getting to grips with Process Federation Server (PFS), and I think I'm pretty close now. In essence, PFS is a capability that's been around for a few years, and allows a business to provide an aggregation layer across multiple different Process Server environments.Whilst this is often pertinent in the context of a migration or upgrade, perhaps where an older version of BPM is being maintained, to allow existing process instances to drain down, whilst new work is be
11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
Tue, Jul 25th 2017 2:39p   Dave Hay
I missed this on Friday: -8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12Fix list for IBM WebSphere Application Server V8.5Time to get downloading ….
74
java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002
Mon, Jul 24th 2017 3:56p   Dave Hay
I saw this: -The test connection operation failed for data source BPM Business Process Choreographer data source on server nodeagent at node Node1 with the following exception: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection DSRA0010E: SQL State = 08006, Error Code = 17,002. View JVM logs for further details.whilst testing JDBC data sources configured to connect to a newly-minted Oracle 12c database.I checked the Oracle box to ensure that the listener was
59
Further adventures with Oracle database - ORA-01078 and LRM-00109
Mon, Jul 24th 2017 2:58p   Dave Hay
Having installed Oracle 12c ( 12.2.0.1.0 ) today, I was somewhat concerned when I tried to start my database: -sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Mon Jul 24 14:04:56 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to an idle instance.SQL> startup ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/initorcl.ora'SQL> quitDisconnectedI checked the offen




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition