Solved

StaleConnectionException, RollBackException, RetryableException when using JNDI

Posted on 2009-05-19
7
477 Views
Last Modified: 2013-12-19
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
Comment
Question by:ramadevimandala
  • 4
  • 3
7 Comments
 
LVL 12

Expert Comment

by:Gibu George
Comment Utility
Hello ramadevimandala,

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

Regards,

gibu_george
0
 
LVL 12

Accepted Solution

by:
Gibu George earned 500 total points
Comment Utility
Also the error -516 is related to the prepared statement
0
 

Author Comment

by:ramadevimandala
Comment Utility
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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 12

Expert Comment

by:Gibu George
Comment Utility
Post the statement please
0
 

Author Comment

by:ramadevimandala
Comment Utility
processStmt=conn.prepareStatement("SELECT xxeis.eis_rs_utility.y(?) FROM dual");
                  processStmt.setString(1,encrypProcessId);
                  processRS=processStmt.executeQuery();
0
 
LVL 12

Expert Comment

by:Gibu George
Comment Utility
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
 

Author Comment

by:ramadevimandala
Comment Utility
Thank you for your help,

My issue is resolved after setting the connection pllo value to 0.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to take different types of Oracle backups using RMAN.
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now