Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC and SQL Server 2000 Part II Question

 
Nelson Nadal
Ranch Hand
Posts: 170
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was asked a question like this...
"Is it possible that I have a web application (jsp/servlets using JDBC) running on Solaris and then the database is in different machine and it is MSSQL Server running on Windows NT? "
I dont know what to say... All I know is it is possible Web application on a machine and Oracle on diff. machine but w/same PLATFORM (Solaris).
Also Web application on a machine and MSSQL/Win Oracle on diff. machine but w/same PLATFORM (Windows NT)
...but w/diff platform Im not sure.

Is it really possible, a web application(on Solaris) accessing a MSSQL database(on different machine and diff. PLATFORM such as Windows)?
Thanks.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sure it's possible. The question is really about whether someone has developed a JDBC driver for the particular database. In the case of MSSQL, open-source drivers don't exist if, I remember correctly, so you need to get a commercial driver. I have only worked with Oracle/DB2/Sybase/MySQL/PostgreSQL myself so I am not that aware of the situation with MSSQL drivers but this is what I've been hearing for the past couple of years.
The fact that the database is running on a different platform doesn't really matter as the processes running on the two are using TCP/IP anyway, which is standard, and the actual database application protocol is implemented by the driver vendor.
[ June 19, 2003: Message edited by: Lasse Koskela ]
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQL Server open source drivers do exist. My experiences with this driver weren't very good but that was more than a year ago. As far as free closed-source drivers are concerned, I understand Microsoft has recently(-ish) made a JDBC driver available. My understanding is that it will work for the latest version of SQL Server only, and is not the fastest or most feature-rich on the market; however I have no personal experience with it so check it out for yourself.
- Peter
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nice to know, Peter.
Too bad that the development must be quite frustrating... Quoted from the FreeTDS site: FreeTDS was and is developed by observation and experimentation, which is to say, by trial and error.
 
Nelson Nadal
Ranch Hand
Posts: 170
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Lasse Koskela and Peter den Haan for replying, I appreciate you, have a good day!!!
 
Arpit Aggarwal
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I dont think it will cause any problem . If you are closing connection in finally block
 
Pushkar Choudhary
Rancher
Posts: 425
Android Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arpit,
Welcome to Javaranch!

We do appreciate your answers on the questions posted here. However, this is a 7 years old thread and I'm quite sure the OP is no longer seeking an answer for it. Please do look how old the thread is before posting. In other words, please Dont Wake The Zombies.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic