StaleConnectionException, RollBackException, RetryableException when using JNDI

Posted on 2009-05-19
Last Modified: 2013-12-19
The above exceptions are coming when I try to execute ps.executeQuery

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

SQLCODES are -107,-516, -517 in DB2. I am using JNDI.
Question by:ramadevimandala
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 12

Expert Comment

by:Gibu George
ID: 24420189
Hello ramadevimandala,

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


LVL 12

Accepted Solution

Gibu George earned 500 total points
ID: 24420194
Also the error -516 is related to the prepared statement

Author Comment

ID: 24420256
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 12

Expert Comment

by:Gibu George
ID: 24420283
Post the statement please

Author Comment

ID: 24420335
processStmt=conn.prepareStatement("SELECT xxeis.eis_rs_utility.y(?) FROM dual");
LVL 12

Expert Comment

by:Gibu George
ID: 24420377
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

Author Comment

ID: 24421091
Thank you for your help,

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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
java imports not found 4 48
Checking for column width 8 39
SQL query for highest sequence 4 62
PL/SQL: ORA-00979: not a GROUP BY expression 3 53
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

756 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