Connect MS SQL database from Java in ubuntu environment

Question

I am using ubuntu 12.04 and wanted to connect to the MS SQL server database which is hosted in the same network. I was able to connect this using Squirrel , yet unable to connect from a java program. These are the tools I and .jars I am using . Intellij Idea is the tool jar are jtds-1.3.1.jar and sqljdbc4.jar Java version 1.7

I am hoping to develop a web application in the Ubuntu Environment , yet my database will be in Ms Sql windows table. Is this feasible ? Please intruct me step by step , and sample code to connect ms sql database which s hosted ina wondows environment

Rashen

Show your code. How did you create the JDBC connection, what error did you get? — RealSkeptic
– RealSkeptic, Commented Nov 4, 2014 at 9:55
"I was able to connect this using Squirrel, yet unable to connect from a Java program" - SQuirrel is a Java program. So your problem (which you didn't specify) is in your program code, not in the connection itself. — user330315
– user330315, Commented Nov 4, 2014 at 10:28

J-16 SDiZ · Accepted Answer · 2014-11-04 10:20:58Z

1

Both microsoft's driver and jTDS works on linux.

Their web site have example jdbc urls.

answered Nov 4, 2014 at 10:20

J-16 SDiZ

27k4 gold badges67 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rashendra - Rashen Over a year ago

Did work, actually the user which was created only had the Windows Authentication, yet created a user with SQLAuthentication and this did work.

MirecXP · Accepted Answer · 2014-11-04 10:30:49Z

1

Don't care about the OS. Have you tried the recommended way to connect using the MS SQL JDBC Driver?

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

String dbHostName = "windowsHostName";
String dbName = "myDb";
String dbUserName = "myUserName";
String dbPassword = "topSecret";

String connectionUrl = "jdbc:sqlserver://" + dbHostName + ":1433;" +
   "databaseName=" + dbName + ";user=" + dbUserName + ";password=" + dbPasword + ";";
Connection con = DriverManager.getConnection(connectionUrl);

answered Nov 4, 2014 at 10:30

MirecXP

4437 silver badges18 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:25:20Z

0

It does not change anything that your DB is hosted on Linux / Windows, as long as you can access it through your network.

There is a post where you can see how to connect to your DB from Java using jTDS: Connect to SQL Server 2012 using jTDs

If it does not solve your problem, can you give us your exact error message?

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Nov 4, 2014 at 10:23

chouk

2895 silver badges14 bronze badges

2 Comments

user330315 Over a year ago

The database is not hosted on Linux. The client is.

chouk Over a year ago

As I've just said, it does NOT change anything that your DB is not in Linux.

Collectives™ on Stack Overflow

Connect MS SQL database from Java in ubuntu environment

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related