OraFAQ Forum: Programming Interfaces

Home » Open Source » Programming Interfaces » jdbc thin client

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

jdbc thin client [message #436502]

Wed, 23 December 2009 19:42

florida
Messages: 82
Registered: April 2006

Member

I am connecting to Oracle 9i using JDBC in my JSP/Servlets web pages. I am closing all my connections in Finally blocks. Everything works great during the day with JDBC and Oracle.
But after a Web crawler runs through our web server at 3 AM the next morning a v$session check shows several lines of JDBC Thin Client inactive status. Any way to find exactly what sql statement or program that could be causing the JDBC Thin Client to show up?

Report message to a moderator

Re: jdbc thin client [message #436541 is a reply to message #436502]

Thu, 24 December 2009 01:51

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If the status is inactive then no SQL is currently running.
You might get the last SQL statement with joining v$session and v$sql or v$sqltext on sql_address, sql_hash_value.
As it is a THIN jdbc client you cannot know which program it was unless this one set it in connection properties.

Regards
Michel

Report message to a moderator

Re: jdbc thin client [message #436639 is a reply to message #436541]

Thu, 24 December 2009 18:53

florida
Messages: 82
Registered: April 2006

Member

Thanks, your post really helped me alot. I got the sql statements from joining v$session and v$sqltext.

Report message to a moderator

Previous Topic:	Excel to Ora tool
Next Topic:	php with Oracle BFILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 21:05:32 CST 2024