Java and oracle Session through JDBC driver

there Is java application which is connected oracle database with jdbc driver. Between oracle db and java application is tomcat.

Java has a own session when it executes some query to oracle db , and oracle has the own. I need to correspond java session to oracles session, so oracle session knows java's session or they have the same identity.

Enyone Know, how it to do or some example or ducumentation?

Thank's!

[448 byte] By [tamria] at [2007-11-27 9:47:06]
# 1

hello,

i am not giving you a response to your question i am sorry.. but i in turn wanted to ask you a question ...:) do you know how to connect to oracle from a jsp page. I am using Eclipse IDE and Tomcat. I have all the necessary java code like Connection.jsp and I want to use thin driver. I also know the code for using Think Driver. All I want to know is where to put what. Like I will have to put some jar files associated with the thin driver in some folder in tomcat and eclipse folder. and maybe in my project folder. Can you help me by telling where to place what.

Help will be appreciated.

Thank you

Sudipthaa at 2007-7-12 23:58:48 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

I'm not really clear on what you're asking to do. What do you mean "Java has a own session" - do you mean the user's HTTP session on a servlet or JSP or something? And what session does Oracle have? Oracle doesn't really have sessions, unless you mean like a transaction. If that's what you mean, a transaction shouldn't last across page views, so no reason to associate it with a user's web session. Is that what you meant? And what do you mean to "correspond" the sessions?

Jemiah

fishninja007a at 2007-7-12 23:58:48 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
Sudiptha go the in your project priperties, select "java build path " and then on libraryes tab. here you may put jar files( oracles jdbc driver -ojdbc14.jar file or something you need).Message was edited by: tamri
tamria at 2007-7-12 23:58:48 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 4
hey tamri,Thanks a looooot for your response. It works now. :)Thanks again.
Sudipthaa at 2007-7-12 23:58:48 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...