• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic