• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • 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 GeorgeCTOCommented:
Hello ramadevimandala,

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

Regards,

gibu_george
0
 
Gibu GeorgeCTOCommented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Gibu GeorgeCTOCommented:
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 GeorgeCTOCommented:
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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