Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Jean Falaise
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic