aspose file tools*
The moose likes Oracle/OAS and the fly likes what is the major diference using java with oracle than using MS-SQL? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "what is the major diference using java with oracle than using MS-SQL?" Watch "what is the major diference using java with oracle than using MS-SQL?" New topic
Author

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

senthil sen
Ranch Hand

Joined: Oct 10, 2002
Posts: 184
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

Joined: Mar 04, 2001
Posts: 99
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 ]

Girish
Sumit Amar
Ranch Hand

Joined: Jun 08, 2002
Posts: 180
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


SCJP, SCWCD, OCA, OCP-DBA 9i, <a href="http://brainbench.com/transcript.jsp?pid=2232802" target="_blank" rel="nofollow">BCIP</a>, MCP, MCAD, MCSD.NET, MCDBA, MCTS (SQL 05), MCITP (DBD, DBA)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: what is the major diference using java with oracle than using MS-SQL?