"whether sql statement compilation and execution steps are in JVM OR DATABASE" in JDBC programs
2 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Thursday, March 31, 2005 02:53 AM

suppose i have the following program
ex:
1:Statement stmt = con.createstatement();
2:resultset rs = stmt.executequery("select * from emp");

in the above program,
q1:whether the sql statement parsing,compilation and execution steps are done in jvm or database "SQL ENGINE"
q2:is there any sql engine is plugged in to jvm

Re: "whether sql statement compilation and execution steps are in JVM OR DATABASE" in JDBC programs

Posted By:   Anonymous  
Posted On:   Thursday, March 31, 2005 11:24 PM

It depends on the driver TYPE we are using.

Most of the times it is done in the database side only.

but when we are using type-2 and type-4 drivers it will

be converting them to the native formats in the clientside

itself (that too only parsing to some extent).compilation

and execution will be in the database i.e, SQL Engine.



regarding u'r second query

there won't be any sql engine plugged into the jvm

the driver itself do all the pre requisites.The driver

in the client side acts as the representative for DB.

Re: "whether sql statement compilation and execution steps are in JVM OR DATABASE" in JDBC programs

Posted By:   Christopher_Koenigsberg  
Posted On:   Thursday, March 31, 2005 09:30 PM

Depends. If you are executing your JDBC calls from a Java Stored Procedure, which has been deployed inside an Oracle database's own JVM, you will be using the "internal" JDBC driver, which is tied very closely to the SQL engine.
About | Sitemap | Contact