By mah6326955
via mahmoudoracle.blogspot.com
Published: May 11 2012 / 09:25
We can use Java code directly in PLSQL to manipulate database (insert data , update , do transaction .... etc) , and also we can write java code to manipulate database through JDBC connection.
When you have two solutions to do the same task, you should wait and choose the best solution.
So in my post today I will illustrate the difference between embedded java in PLSQL and Java run through JDBC connection.
Comments
Mahmoud A. El-Sayed replied ago:
You can indicate from where you connect to database from System.getProperty("oracle.jserver.version")
if it has null value then you connected through JDBC connection otherwise you connected from database using Oracle JVM
I posted before post about Java system Properties
http://mahmoudoracle.blogspot.com/2012/04/print-java-system-properties-in-plsql.html
Mahmoud A. El-Sayed replied ago:
I always create PLSQL functions, procedures and packages in database and call it from Java. But what I intend to illustrate is that running everything in database is faster than others
martin.lucas replied ago:
I always use this approach also
Mahmoud A. El-Sayed replied ago:
I intend to illustrate that running everything in database is faster than others because no network load and no loop back
Every People know that running PLSQL from database faster than others, and in my post I want to prove that it is faster in JVM also
martin.lucas replied ago:
Fantastic post
Voters For This Link (7)
Voters Against This Link (0)