• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
senthil sen
Ranch Hand
Posts: 184
  • Mark post as helpful
  • send pies
  • 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?
 
girish rateshwar
Ranch Hand
Posts: 99
  • Mark post as helpful
  • send pies
  • 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 ]
 
Sumit Amar
Ranch Hand
Posts: 180
  • Mark post as helpful
  • send pies
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic