Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is it hard to use SQL Server with Java?

 
Jay Dilla
Ranch Hand
Posts: 201
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have used Oracle 9i and JDBC before and I know SQL well enough to run queries. I told a company that I know SQL Server figuring it can't be THAT much different then Oracle. But after doing research I found out Oracle supports Java much better. So I'm wondering if simply knowing SQL will be enough for the job. Are there any good sites with SQL server - Java examples?
can I use JDBC methods with SQL Server?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

But after doing research I found out Oracle supports Java much better.

True, Oracle support's Java, whereas SQL Server does not. However this only matters if you are considering writing stored procedures in Java. If all you want is standard JDBC access to a SQL Server instance, you'll hardly notice the difference between Oracle and SQL Server.
 
Jay Dilla
Ranch Hand
Posts: 201
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Paul Sturrock:

True, Oracle support's Java, whereas SQL Server does not. However this only matters if you are considering writing stored procedures in Java. If all you want is standard JDBC access to a SQL Server instance, you'll hardly notice the difference between Oracle and SQL Server.


So I can use the same DataSource, Result, Connection objects with SQL server?
What are the major differences in regards to stored procedures.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

So I can use the same DataSource, Result, Connection objects with SQL server?

Yes - since these are all interfaces. The implementations are provided by the Driver you choose (Microsoft supply one which is fine, but I'd recommend jTDS).

What are the major differences in regards to stored procedures.

The big difference is in Oracle you can use PL/SQL or Java to implement your stored procedures. In SQL Server it is Transact-SQL you use. If you are familiar with PL/SQL, T-SQL is fairly easy to pick up.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic