• 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

what is the major diference using java with oracle than using MS-SQL?

 
Ranch Hand
Posts: 184
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
what is the major diference using java with oracle than using MS-SQL?
Any advantages over any??
was asked this question in an interview?
 
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Oracle is promoting java----THATS THE MAIN DIFF
well if u r developing web based applications on oracle then java is the best option. I have started using JDeveloper which comes with 9i Developer suite.
Oracle DB has a JavaPool (refer to Database Architechture ), i have never heard of it with MS-SQL

regards,
[ January 18, 2003: Message edited by: girish rateshwar ]
 
Ranch Hand
Posts: 180
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Senthil, in Oracle you can write your stored procedures in Java language, while with SQL Server you have to use T-SQL. As rightly said by Rateshwar, a separate memory area Java Pool can be maintained in Oracle for handling Java operations.
However, you have to declare the prototype kind of thing of your procedure that you have written in Java , in Oracle. Once the procedure is associated with the schema. It's there! and use CallableStatement class to scrub it.
enjoy Java, enjoy Oracle
 
reply
    Bookmark Topic Watch Topic
  • New Topic