Home » Developer & Programmer » JDeveloper, Java & XML » JDBC Architecture
JDBC Architecture [message #268969] Thu, 20 September 2007 04:40 Go to next message
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 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

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

Cheers
Soumen
Re: JDBC Architecture [message #269172 is a reply to message #269134] Thu, 20 September 2007 23:01 Go to previous messageGo to next message
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

Re: JDBC Architecture [message #269175 is a reply to message #268969] Thu, 20 September 2007 23:20 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?
Re: JDBC Architecture [message #269177 is a reply to message #269175] Thu, 20 September 2007 23:24 Go to previous messageGo to next message
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.........
Re: JDBC Architecture [message #269178 is a reply to message #268969] Thu, 20 September 2007 23:29 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: JDBC Architecture [message #269692 is a reply to message #269178] Mon, 24 September 2007 02:19 Go to previous messageGo to next message
gurumurthy4
Messages: 17
Registered: August 2007
Junior Member
Any reference for finding JDBC Message data information please?
Re: JDBC Architecture [message #269957 is a reply to message #269692] Tue, 25 September 2007 04:28 Go to previous message
dimis283
Messages: 38
Registered: July 2007
Location: greece
Member
You want to find the last value of the "auto increment" primary field?
Read this
Mabe you want to see how to create a jdbc driver
Dimis
Previous Topic: Issue with timestamp precision
Next Topic: Need Help - java.sql.SQLException: Io exception: Got minus one from Read Call
Goto Forum:
  


Current Time: Fri Dec 09 07:46:50 CST 2016

Total time taken to generate the page: 0.07625 seconds