aspose file tools*
The moose likes JDBC and the fly likes Accessing java code in an Oracle DB from outside WITHOUT using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Accessing java code in an Oracle DB from outside WITHOUT using JDBC" Watch "Accessing java code in an Oracle DB from outside WITHOUT using JDBC" New topic
Author

Accessing java code in an Oracle DB from outside WITHOUT using JDBC

Jean Falaise
Greenhorn

Joined: Oct 02, 2001
Posts: 3
Hello,
We've got an Oracle application with hundreds of PL/SQL APIs accessing tables, some of them are wrapped in java APIs classes which transform their results and provide java objects to java calling code which is in the database. Now we need to access these java APIs from JSP taglib located on the webserver machine. Is there any way to access these java classes in the DB from outside WIHOUT wrapping them by PL/SQL proc et using JDBC ??? (these java APIs are already wrapping PL/SQL procs). If there is any way to do that, do you know where i could find some documentation/exemples about how to do it and what are the restrictions.

Thanks in advance for any help, regards, JC
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

since jdbc is the standard for java to communicate with the database, java will not be able to talk to the database without it. If you are looking for alternative ways other than java to access the database, I guess you could call native code to access the database, then return the results from the native code back to the java program.
But then I have to ask you why? Why can't(won't) you use jdbc to access your database features? are you concerned about something like performance/security/limitations? If you are having problems or concerns with jdbc, post that problem and maybe we can help you get where you want to be using jdbc and java before you have to create a work around(which will be write your own jdbc code or use native code)
any other ideas?
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Accessing java code in an Oracle DB from outside WITHOUT using JDBC