OraFAQ Forum: JDeveloper, Java & XML

Home » Developer & Programmer » JDeveloper, Java & XML » JDBC Architecture

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

JDBC Architecture [message #268969]

Thu, 20 September 2007 04:40

gurumurthy4
Messages: 17
Registered: August 2007

Junior Member

I want to know how communication is done between application-jdbc driver-DBMS while executing sql statements..... I also heared that sql_id will also be returned from the DBMS to the driver and stored in client identification management table... Is it so? If so, How can we get that? Or else What is the identification that is being used to match the individual query?

[Updated on: Thu, 20 September 2007 04:42]

Report message to a moderator

Re: JDBC Architecture [message #269134 is a reply to message #268969]

Thu, 20 September 2007 15:56

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

I think you didn't read this Java Dataase Connectivity(JDBC)

Cheers
Soumen

Report message to a moderator

Re: JDBC Architecture [message #269172 is a reply to message #269134]

Thu, 20 September 2007 23:01

gurumurthy4
Messages: 17
Registered: August 2007

Junior Member

I am looking for some internals.... I think you are speaking about Basic JDBC information........ May be have a look again

Report message to a moderator

Re: JDBC Architecture [message #269175 is a reply to message #268969]

Thu, 20 September 2007 23:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Last time I checked the database does not know or care about what "flavor" (JDBC thick, JDBC thin, OBDC, OCI, etc.) of client is at the other end of the connection.

What business problem are you really trying solve?

Report message to a moderator

Re: JDBC Architecture [message #269177 is a reply to message #269175]

Thu, 20 September 2007 23:24

gurumurthy4
Messages: 17
Registered: August 2007

Junior Member

i just want to know if is SQL_ID is sent along with the reply from the DBMS......I studied from a patent that JDBC driver maintains a table storing these information in it.... I want to know more about them.........

Report message to a moderator

Re: JDBC Architecture [message #269178 is a reply to message #268969]

Thu, 20 September 2007 23:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I studied from a patent that JDBC driver
JDBC is RDBMS independent interface.
You should packet sniff the exchanged data to learn the complete protocol.

Report message to a moderator