• 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

Is it hard to use SQL Server with Java?

 
Ranch Hand
Posts: 201
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic