Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

StaleConnectionException, RollBackException, RetryableException when using JNDI

The above exceptions are coming when I try to execute ps.executeQuery

Conn = ds.getConnection();
Ps = conn.prepareStatement();
Ps.executeQuery();

SQLCODES are -107,-516, -517 in DB2. I am using JNDI.
0
ramadevimandala
Asked:
ramadevimandala
  • 4
  • 3
1 Solution
 
Gibu GeorgeChief Technology OfficerCommented:
Hello ramadevimandala,

I don't see any staement passed as a parameter to the conn.prepareStatement()

Regards,

gibu_george
0
 
Gibu GeorgeChief Technology OfficerCommented:
Also the error -516 is related to the prepared statement
0
 
ramadevimandalaAuthor Commented:
hi im passing the string to conn.prepareStatement() which is s statement.
i tried to get the staleexception in catch and didi the rollback but still its not working
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Gibu GeorgeChief Technology OfficerCommented:
Post the statement please
0
 
ramadevimandalaAuthor Commented:
processStmt=conn.prepareStatement("SELECT xxeis.eis_rs_utility.y(?) FROM dual");
                  processStmt.setString(1,encrypProcessId);
                  processRS=processStmt.executeQuery();
0
 
Gibu GeorgeChief Technology OfficerCommented:
the 107 error is caused when the parameter passed is too long.  check howmuch is the size of the parameter you are passing and how much xxeis.eis_rs_utility.y() can accept
0
 
ramadevimandalaAuthor Commented:
Thank you for your help,

My issue is resolved after setting the connection pllo value to 0.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now