This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Which version of SQL to install? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which version of SQL to install?" Watch "Which version of SQL to install?" New topic
Author

Which version of SQL to install?

Vighnesh Mu
Greenhorn

Joined: Jan 06, 2011
Posts: 29

Hi,

I want to develop a java based web application in my system and planning to use MS SQL 2008 as back end(to be installed on the same system). But I am not sure which edition of MS SQL to use, can anybody tell me do I need to install "developer edition" or "express edition" or "standard edition" or other?
I tried installing "developer edition" and it got installed too, but I am unable to connect to DB because of some access related errors. I used "SQL Authentication" but didn't know the server name, user ID and password and also the port number needed to connect, somebody please help me on this. What will be the url for DB to connect through java if the database is installed on the same machine?

Thanks in advance.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

All should work - the licencing of some editions prevent them being used for production, but to develop against any is fine.


I used "SQL Authentication" but didn't know the server name, user ID and password and also the port number needed to connect, somebody please help me on this. What will be the url for DB to connect through java if the database is installed on the same machine?


Your driver documentation will cover this - without knowing which driver you are using, I can't say.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Vighnesh Mu
Greenhorn

Joined: Jan 06, 2011
Posts: 29

Paul Sturrock wrote:All should work - the licencing of some editions prevent them being used for production, but to develop against any is fine.


Thanks for the information paul, so can I go with any edition for my application?

Paul Sturrock wrote:Your driver documentation will cover this - without knowing which driver you are using, I can't say.


I didn't get this part, where can I get driver documentation? I am using MS SQL 2008 version.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

For developing yes, for production, no.



I didn't get this part, where can I get driver documentation? I am using MS SQL 2008 version.

I'm going to guess you mean the Microsoft supplied JDBC driver? In which case MSDN will have the online instructions, but I think you also get the help files installed when you install it (this suggests you do anyway).
Vighnesh Mu
Greenhorn

Joined: Jan 06, 2011
Posts: 29

Paul Sturrock wrote:For developing yes, for production, no.


For production which is the edition I need to use?

Paul Sturrock wrote:
I'm going to guess you mean the Microsoft supplied JDBC driver? In which case MSDN will have the online instructions, but I think you also get the help files installed when you install it (this suggests you do anyway).


I am planning to use "jtds" driver in java to connect to database using JDBC ,as per my requirement. But it needs url(containing DB location,port and driver), username and password to connect to the the database installed in my system. I am unable to find them. can you please suggest me where can I get these from SQL installation?

Thanks.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Standard or Enterprise I think. Check with Microsoft.

jTDS have an extensive FAQ section that document all the stuff you need to know. See their web site.
Vighnesh Mu
Greenhorn

Joined: Jan 06, 2011
Posts: 29

Thanks a lot Paul.
 
Consider Paul's rocket mass heater.
 
subject: Which version of SQL to install?