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.
