Link Details

Link 790667 thumbnail
User 1010917 avatar

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.
  • 7
  • 0
  • 698
  • 323

Comments

Add your comment
User 1010917 avatar

Mahmoud A. El-Sayed replied ago:

0 votes Vote down Vote up Reply

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

User 1010917 avatar

Mahmoud A. El-Sayed replied ago:

0 votes Vote down Vote up Reply

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

User 1019689 avatar

martin.lucas replied ago:

0 votes Vote down Vote up Reply

I always use this approach also

User 1010917 avatar

Mahmoud A. El-Sayed replied ago:

0 votes Vote down Vote up Reply

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

User 1019689 avatar

martin.lucas replied ago:

0 votes Vote down Vote up Reply

Fantastic post

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (7)



Voters Against This Link (0)



    Java Performance Optimization
    Written by: Pierre-Hugues Charbonneau
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. Java EE7
    5. HTML5 Mobile
    1. Node.js
    2. Debugging JavaScript
    3. OO JS
    4. JSON
    5. Ajax