Hi All, We have a application which communications via java to a .DBF file (using Java and Codebase for Linux). We are working on moving the database over to MS-SQL server (relational). What is the preferred method of communicating with a MS-SQL database using Java (JDBC, etc)? Can someone point me in the right direction? -Bill
Bill Parker wrote:
Hi All,
We have a application which communications via java to a .DBF file (using Java and Codebase for Linux). We are working on moving the database over to MS-SQL server (relational). What is the preferred method of communicating with a MS-SQL database using Java (JDBC, etc)? Can someone point me in the right direction?
JDBC yes. I don't know if there are any free JDBC drivers for SQLServer though. Last time I needed to look (around early 1998), the only one available was from BEA and cost *thousands*. However, it did work perfectly. MS of course didn't provide one because they hate Java and want to lock you into ODBC and therefore Windows on the server. This is the choice you make. If there isn't now an affordable JDBC driver for SQLServer, I suggest using another RDBMS as I believe SQLServer is alone among proprietary and free database systems in not including a JDBC implementation. :-) Don't be tempted by the JDBC-ODBC bridge, it doesn't work very well. Oracle if you want to spend money, PostgreSQL if you don't. DB2 also worth a look. Also none of these will lock you to a Windows database server for the forseeable future (which trust me is a bad idea). -- Rachel
MS now provides a JDBC drive for SQLServer. I have not used it but it was released some months back. Robert On Saturday, October 12, 2002, at 04:10 AM, Rachel Greenham wrote:
Bill Parker wrote:
Hi All,
We have a application which communications via java to a .DBF file (using Java and Codebase for Linux). We are working on moving the database over to MS-SQL server (relational). What is the preferred method of communicating with a MS-SQL database using Java (JDBC, etc)? Can someone point me in the right direction?
JDBC yes. I don't know if there are any free JDBC drivers for SQLServer though. Last time I needed to look (around early 1998), the only one available was from BEA and cost *thousands*. However, it did work perfectly. MS of course didn't provide one because they hate Java and want to lock you into ODBC and therefore Windows on the server. This is the choice you make. If there isn't now an affordable JDBC driver for SQLServer, I suggest using another RDBMS as I believe SQLServer is alone among proprietary and free database systems in not including a JDBC implementation. :-) Don't be tempted by the JDBC-ODBC bridge, it doesn't work very well.
Oracle if you want to spend money, PostgreSQL if you don't. DB2 also worth a look. Also none of these will lock you to a Windows database server for the forseeable future (which trust me is a bad idea).
-- Rachel
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
We have a application which communications via java to a .DBF file (using Java and Codebase for Linux). We are working on moving the database over to MS-SQL server (relational). What is the preferred method of communicating with a MS-SQL database using Java (JDBC, etc)? Can someone point me in the right direction?
Hi, you might try http://www.microsoft.com/sql/ . Somewhere on that page is a link to a JDBC driver. They have a win version and a unix version, and it seems to be free. But of course, we are talking about MS, so you should read any "fine print" you find. Good luck. --mioriticus "Think of it as evolution in action."
Bogdan Ionita wrote:
We have a application which communications via java to a .DBF file
(using Java
and Codebase for Linux). We are working on moving the database over
to MS-SQL
server (relational). What is the preferred method of communicating
with a
MS-SQL database using Java (JDBC, etc)? Can someone point me in the right
direction?
Hi,
you might try http://www.microsoft.com/sql/ . Somewhere on that page is a link to a JDBC driver. They have a win version and a unix version, and it seems to be free. But of course, we are talking about MS, so you should read any "fine print" you find.
Shouldn't need to be two versions, just a jar file, unless they've been silly and included native methods, which will mess with your ability to choose what platform to run your Java code on. However, looking at what they say, it's a Type 4 (pure Java) driver all right, so that's good, and the unix / windows versions are just packaging; The Windows one is in a setup.exe and the unix one is in a tarfile. Damn, one good reason not to use SQLServer shot down in flames You'll have to use one of the others :-> I'm actually quite surprised they did this, and in a good way too. :-) -- Rachel
Hi, You will have to use JDBC, but here is the rub: --> Currently due to Microsoft's Licensing, etc. etc., there are NO JDBC 4 Drivers for free... ...all of them cost a fortune. --> There are other JDBC drivers for MS-SQL that are for free, but they do not provide you with full support and functionality that the level 4 JDBC drivers do. So you can either pay a firtune for the JDBC drivers and then still spend enromous amounts on CALs for your MS-SQL server, or look at other DBs (e.g MySQL, PostgressSQL, Interbase, or even Oracle), it all depends on exactly what you are going to be using the DB for. Hope this helps, and please note that this is what I found when I last searched for JDBC drivers for MS-SQL, so I may be wrong... ...;) Regards Q On Sat, 2002-10-12 at 05:09, Bill Parker wrote:
Hi All,
We have a application which communications via java to a .DBF file (using Java and Codebase for Linux). We are working on moving the database over to MS-SQL server (relational). What is the preferred method of communicating with a MS-SQL database using Java (JDBC, etc)? Can someone point me in the right direction?
-Bill
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
participants (5)
-
Bill Parker -
Bogdan Ionita -
Quinton Delpeche -
Rachel Greenham -
Robert Fenney