for DB2 case when I am doing
Code:
setAutoCommit(false);
When i tried to find the reason it was suggested that to get that working. You need to put the journaling on on DB2 file on which you want this feature to work....
giffy
Last Activity: Oct 3 '08, 10:13 PM
Joined: Aug 27 '08
Location:
-
Thanks Sanjay. And sorry for delayed addendum
for DB2 case when I am doing
nothing changes. And things seem to be working the same way as with the default setting of autoCommit mode on transaction level.
When i tried to find the reason it was suggested that to get that working. You need to put the journaling on on DB2 file on which you want this feature to work.... -
why dun you try on your own.
Use a parameter in your stored procedure.
And while passing it make it two parameters.
The first will be spaces 32K in leght. generate it using a loop.
and add to the end Second parameter that is of your need with some value may be 'TEST'
Then debug the application after calling it using java by making callable prepated statements. And see whether you...Leave a comment:
-
Here is what I have used
And the code for execStrSQL isCode:String callQuery = "call " + pgmLibraryName + "/procName('" + inpParam + "')"; ResultSet rs = new BidderUtility().execStrSQL(callQuery);
...Code:public ResultSet execStrSQL(String s) throws SQLException { ResultSet resultset = null; java.sql.CallableStatement callablestatementLeave a comment:
-
using setAutoCommit(false) in DB2 and MSSQL
I need to use commit and rollback feature in DB2. With executeBatch() feature.
I am facing the problems
a) journalling features are contradicting with it
what does that mean? And how to get rid of that.
b) I am not sure what is the databse version. How to see the version of database and the compatibility as far as executeBatch() support is concerned
c) Do we need it mandatorily... -
how to set SelectMethod=cursor; for SQL 2000
Hi Everyone,
I am trying to use thebefore doing the updates. So that in case of error I can useCode:setAutoCommit(false)
But while trying to do so I am getting this error.Code:rolloverTransaction().
I am using a datasource to connect to the database. And using connection...Code:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
-
Thanks Guys. split() method with two arguments did the trick
here is the code
and the output is as desired with all the sapces being returned and not ignored...Code:String origAVNListStr = "~`L~`L~`L~`~`~`L~`"; String[] strArr = origAVNListStr.split("~`", -1); for(int i=0;i<strArr.length;i++) { System.out.println(i+1 +"the next token - " + strArr[i]); }Leave a comment:
-
Thanks for the prompt reply.
It is a dynamic array situation. The code was just to test what is going wrong.
In addition -
1. I dun know the array size before hand
2. Also the data can be many blanks at the end
3. these are data fields that I need to handle as that only
to be specific
Code:String theData = "";
Leave a comment:
-
String.split() not giving proper results
HOW to get the spaces out of a delimited string ??
here is a usage scenario where split() seems not to work
and the output isCode:String origAVNListStr = "~`L~`L~`L~`~`~`L~`"; String[] strArr = origAVNListStr.split("~`"); for(int i=0;i<strArr.length;i++) { System.out.println(i+1 +"the next token - " + strArr[i]); }
...Code:1the next
-
HOW to get the spaces out of a delimited string ??
here is a usage scenario where split() seems not to work
...Code:String origAVNListStr = "~`L~`L~`L~`~`~`L~`"; String[] strArr = origAVNListStr.split("~`"); for(int i=0;i<strArr.length;i++) { System.out.println(i+1 +"the next token - " + strArr[i]);Leave a comment:
No activity results to display
Leave a comment: