Welcome to the Java Programming Forums
The professional, friendly Java community. 21,500 members and growing!
The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.
>> REGISTER NOW TO START POSTING
Members have full access to the forums. Advertisements are removed for registered users.
LinkBack URL
About LinkBacks
JAVA SQL Connection
I'm getting this error "com.microsoft.sqlserver.jdbc.SQLSer verDriver"
I'm trying to create an applet that can be sent to many machines on a LAN network, how can I resolve this?
Do I need to do something to each machine?
Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
Related threads:
Re: JAVA SQL Connection
do you have the driver set on the class path?
Re: JAVA SQL Connection
What you posted is not an error, not a complete one anyway. Post the entire error text, copied from exactly as it appears at your end.
Re: JAVA SQL Connection
Originally Posted by jocdrew21
What's that?
Re: JAVA SQL Connection
Looks like you are using SQL and not mySQL right.
Microsoft JDBC Driver for SQL Server
Once you download the driver, open it and find the jar file. Right click the file you are using and select "Build Path", then "Add External Archives", select the jar file that you just found and thats it.
GregBrannon (September 20th, 2014)
Re: JAVA SQL Connection
Does that get installed on each machine I use my applet on or does it get installed within my applet
Re: JAVA SQL Connection
anyone?
Re: JAVA SQL Connection
Can you put the missing classes in your jar file?
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
Is this a file that can be included in my jar file?
Is it another .exe file? does it need admin rights to run?
Re: JAVA SQL Connection
That would be a java class file.Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
I'm trying to connect to a database
and that it my output?Connection con = DriverManager.getConnection(connectionUrl);
System.out.println("Connected.");
} catch(Exception e){
System.out.println("Error " + e.getMessage());
}
what is wrong?
Re: JAVA SQL Connection
To see what is wrong, call the printStackTrace() method in the catch block. It will give a fuller error message.
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 372)
at java.net.URLClassLoader$1.run(URLClassLoader.java: 361)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:360)
at java.lang.ClassLoader.loadClass(ClassLoader.java:4 24)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 57)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:259)
at learn.DB.dbConnect(MainGUI.java:137)
at learn.MainGUI.main(MainGUI.java:112)
Re: JAVA SQL Connection
Make sure the class (or the jar containing it): com.microsoft.sqlserver.jdbc.SQLServerDriver is on the classpathjava.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
Ok very very new to this
How do I do that
Re: JAVA SQL Connection
The java command has an option: -cp that can be used to put a class or jar with classes on the classpath.
For example (on windows) this adds the current dir (.) and the jsoup.jar to the classpath:
D:\Java\jdk1.7.0.7\bin\java.exe -cp .;jsoup.jar TheClassFileHere
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
and when im using netbeans?
Re: JAVA SQL Connection
sorry, I don't know anything about netbeans.
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
Can anyone please help?
I'm not sure what i'm doing here..
Re: JAVA SQL Connection
Please explain what you are trying to do in more detail. What isn't working?
If this is a question about how to use your IDE, I'll move the thread to the IDE section.
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
I'm trying to connect to a SQL Server and am getting this error
I don't know what is wrongjava.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 372)
at java.net.URLClassLoader$1.run(URLClassLoader.java: 361)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:360)
at java.lang.ClassLoader.loadClass(ClassLoader.java:4 24)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 57)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:259)
at learn.DB.dbConnect(MainGUI.java:137)
at learn.MainGUI.main(MainGUI.java:112)
Re: JAVA SQL Connection
The java machine can not find the definition for the com.microsoft.sqlserver.jdbc.SQLServerDriver class. It's definition needs to be on the classpath.what is wrong
This has been discussed before.
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
how do i do that?
Re: JAVA SQL Connection
That post was the same as post#15. So we are now going in circles.how do i do that?
My response is what was said in post#16
If this is a netbeans setup problem, I'll move this thread to the Netbeans section.
If you don't understand my answer, don't ignore it, ask a question.
Re: JAVA SQL Connection
I guess this is my question, how do I that in netbeans?
Post 16 is not clear to me what i need to do
Reply With Quote