Home > Archive > SQL Anywhere database > July 2005 > Viewing PreparedStatements









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Viewing PreparedStatements
Preston

2005-07-21, 11:24 am

I have a java app that's multi-threaded and is rather hard to step through.
Some where I'm preparing a statement and not releasing it. After a while ASA
throws a "Resource governor for 'prepared statements' exceeded" error.

Is there some place I can look and see all the prepared statements? It would
sure make tracking this down easier.


Chris Keating \(iAnywhere Solutions\)

2005-07-21, 1:23 pm

A request level log will show statements being prepared and dropped. You can
use it to determine which statements are not paired with the DROP.

"Preston" <nospam@nospam.com> wrote in message
news:42dfd308$1@foru
ms-2-dub...
>I have a java app that's multi-threaded and is rather hard to step through.
>Some where I'm preparing a statement and not releasing it. After a while
>ASA throws a "Resource governor for 'prepared statements' exceeded" error.
>
> Is there some place I can look and see all the prepared statements? It
> would sure make tracking this down easier.
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com