SQL Server conecction with jdbc eclipse
I have the following code to connect to my database in SQL Server:
public static void main (String args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://DESKTOP-G8057U8\SQLEXPRESS:1433;databaseName=Vaporizadores;integratedSecurity=true;";
DBConection=DriverManager.getConnection(url);
DBStatement = DBConection.createStatement();
System.out.println("Conexion exitosa");
}catch(ClassNotFoundException | SQLException e) {
System.out.println("Conexion fallida");
}
}
when I run it I get "Conexion fallida", meaning that an exception was catched. I've tried different urls but I still can't connect to my DB. I know very little about jdbc and sql server, so it may be a stupid error.
java
sql-server eclipse jdbc asked Nov 11 at 19:03
Agus Martinez
11
|
show 3 more comments
I have the following code to connect to my database in SQL Server:
public static void main (String args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://DESKTOP-G8057U8\SQLEXPRESS:1433;databaseName=Vaporizadores;integratedSecurity=true;";
DBConection=DriverManager.getConnection(url);
DBStatement = DBConection.createStatement();
System.out.println("Conexion exitosa");
}catch(ClassNotFoundException | SQLException e) {
System.out.println("Conexion fallida");
}
}
when I run it I get "Conexion fallida", meaning that an exception was catched. I've tried different urls but I still can't connect to my DB. I know very little about jdbc and sql server, so it may be a stupid error.
java
sql-server eclipse jdbc asked Nov 11 at 19:03
Agus Martinez
11
1
do a, catch(ClassNotFoundException | SQLException e) { System.out.println(e); } and give the result...
– dilanSachi
Nov 11 at 19:07
Don't specify both port (1433) and instance name (SQLEXPRESS). They are mutually exclusive. Remove the port number.
– Andreas
Nov 11 at 19:07
2
@dilanSachi Better yet:catch(ClassNotFoundException | SQLException e) { e.printStackTrace(System.out); }
– Andreas
Nov 11 at 19:08
integratedSecurity=truerequires the.dllfile in the PATH. Is it there?
– Andreas
Nov 11 at 19:09
@Andreas thanx for the tip
– dilanSachi
Nov 11 at 19:09
|
show 3 more comments
I have the following code to connect to my database in SQL Server:
public static void main (String args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://DESKTOP-G8057U8\SQLEXPRESS:1433;databaseName=Vaporizadores;integratedSecurity=true;";
DBConection=DriverManager.getConnection(url);
DBStatement = DBConection.createStatement();
System.out.println("Conexion exitosa");
}catch(ClassNotFoundException | SQLException e) {
System.out.println("Conexion fallida");
}
}
when I run it I get "Conexion fallida", meaning that an exception was catched. I've tried different urls but I still can't connect to my DB. I know very little about jdbc and sql server, so it may be a stupid error.
java
sql-server eclipse jdbc asked Nov 11 at 19:03
Agus Martinez
11
I have the following code to connect to my database in SQL Server:
public static void main (String args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://DESKTOP-G8057U8\SQLEXPRESS:1433;databaseName=Vaporizadores;integratedSecurity=true;";
DBConection=DriverManager.getConnection(url);
DBStatement = DBConection.createStatement();
System.out.println("Conexion exitosa");
}catch(ClassNotFoundException | SQLException e) {
System.out.println("Conexion fallida");
}
}
when I run it I get "Conexion fallida", meaning that an exception was catched. I've tried different urls but I still can't connect to my DB. I know very little about jdbc and sql server, so it may be a stupid error.
java
sql-server eclipse jdbc java
sql-server eclipse jdbc asked Nov 11 at 19:03
Agus Martinez
11
asked Nov 11 at 19:03
Agus Martinez
11
edited Nov 11 at 19:45
asked Nov 11 at 19:03
Agus Martinez
11
asked Nov 11 at 19:03
Agus Martinez
11
asked Nov 11 at 19:03
Agus Martinez
11
11
1
do a, catch(ClassNotFoundException | SQLException e) { System.out.println(e); } and give the result...
– dilanSachi
Nov 11 at 19:07
Don't specify both port (1433) and instance name (SQLEXPRESS). They are mutually exclusive. Remove the port number.
– Andreas
Nov 11 at 19:07
2
@dilanSachi Better yet:catch(ClassNotFoundException | SQLException e) { e.printStackTrace(System.out); }
– Andreas
Nov 11 at 19:08
integratedSecurity=truerequires the.dllfile in the PATH. Is it there?
– Andreas
Nov 11 at 19:09
@Andreas thanx for the tip
– dilanSachi
Nov 11 at 19:09
|
show 3 more comments
1
do a, catch(ClassNotFoundException | SQLException e) { System.out.println(e); } and give the result...
– dilanSachi
Nov 11 at 19:07
Don't specify both port (1433) and instance name (SQLEXPRESS). They are mutually exclusive. Remove the port number.
– Andreas
Nov 11 at 19:07
2
@dilanSachi Better yet:catch(ClassNotFoundException | SQLException e) { e.printStackTrace(System.out); }
– Andreas
Nov 11 at 19:08
integratedSecurity=truerequires the.dllfile in the PATH. Is it there?
– Andreas
Nov 11 at 19:09
@Andreas thanx for the tip
– dilanSachi
Nov 11 at 19:09
1
1
do a, catch(ClassNotFoundException | SQLException e) { System.out.println(e); } and give the result...
– dilanSachi
Nov 11 at 19:07
do a, catch(ClassNotFoundException | SQLException e) { System.out.println(e); } and give the result...
– dilanSachi
Nov 11 at 19:07
Don't specify both port (1433) and instance name (SQLEXPRESS). They are mutually exclusive. Remove the port number.
– Andreas
Nov 11 at 19:07
Don't specify both port (1433) and instance name (SQLEXPRESS). They are mutually exclusive. Remove the port number.
– Andreas
Nov 11 at 19:07
2
2
@dilanSachi Better yet:
catch(ClassNotFoundException | SQLException e) { e.printStackTrace(System.out); }– Andreas
Nov 11 at 19:08
@dilanSachi Better yet:
catch(ClassNotFoundException | SQLException e) { e.printStackTrace(System.out); }– Andreas
Nov 11 at 19:08
integratedSecurity=true requires the .dll file in the PATH. Is it there?– Andreas
Nov 11 at 19:09
integratedSecurity=true requires the .dll file in the PATH. Is it there?– Andreas
Nov 11 at 19:09
@Andreas thanx for the tip
– dilanSachi
Nov 11 at 19:09
@Andreas thanx for the tip
– dilanSachi
Nov 11 at 19:09
|
show 3 more comments
1 Answer
1
active
oldest
votes
It worked like this:
String url = "jdbc:sqlserver://DESKTOP-G8057U8;databaseName=Vaporizadores;integratedSecurity=true;";
and i added the sqljdbc_auth.dll to Java bin folder
answered Nov 11 at 19:44
Agus Martinez
11
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53252161%2fsql-server-conecction-with-jdbc-eclipse%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It worked like this:
String url = "jdbc:sqlserver://DESKTOP-G8057U8;databaseName=Vaporizadores;integratedSecurity=true;";
and i added the sqljdbc_auth.dll to Java bin folder
answered Nov 11 at 19:44
Agus Martinez
11
add a comment |
It worked like this:
String url = "jdbc:sqlserver://DESKTOP-G8057U8;databaseName=Vaporizadores;integratedSecurity=true;";
and i added the sqljdbc_auth.dll to Java bin folder
answered Nov 11 at 19:44
Agus Martinez
11
add a comment |
It worked like this:
String url = "jdbc:sqlserver://DESKTOP-G8057U8;databaseName=Vaporizadores;integratedSecurity=true;";
and i added the sqljdbc_auth.dll to Java bin folder
answered Nov 11 at 19:44
Agus Martinez
11
It worked like this:
String url = "jdbc:sqlserver://DESKTOP-G8057U8;databaseName=Vaporizadores;integratedSecurity=true;";
and i added the sqljdbc_auth.dll to Java bin folder
answered Nov 11 at 19:44
Agus Martinez
11
answered Nov 11 at 19:44
Agus Martinez
11
answered Nov 11 at 19:44
Agus Martinez
11
answered Nov 11 at 19:44
Agus Martinez
11
11
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53252161%2fsql-server-conecction-with-jdbc-eclipse%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
do a, catch(ClassNotFoundException | SQLException e) { System.out.println(e); } and give the result...
– dilanSachi
Nov 11 at 19:07
Don't specify both port (1433) and instance name (SQLEXPRESS). They are mutually exclusive. Remove the port number.
– Andreas
Nov 11 at 19:07
2
@dilanSachi Better yet:
catch(ClassNotFoundException | SQLException e) { e.printStackTrace(System.out); }– Andreas
Nov 11 at 19:08
integratedSecurity=truerequires the.dllfile in the PATH. Is it there?– Andreas
Nov 11 at 19:09
@Andreas thanx for the tip
– dilanSachi
Nov 11 at 19:09