|
... a no-no?
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
yeah right, next you're going to be talking about a double positive
Real programmers use butterflies
|
|
|
|
|
But does it come at the start or the end of the sentence?
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
Positively Yes
I'm not sure how many cookies it makes to be happy, but so far it's not 27.
JaxCoder.com
|
|
|
|
|
And is that a good Covid test result, or not?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
And do you considera positive Covid test positive? For you, or for someone else?
|
|
|
|
|
yep it's hard you can use "Ain't" and double negative will work
|
|
|
|
|
"Ain't nobody never loved me as I love myself."
(That's the opening sentence of a novel that I don't remember the author or title of. All I remember is that opening sentence.)
|
|
|
|
|
"cept my mother and she's dead."
|
|
|
|
|
Jack Kerouac: Pic
(and the quote not exact... Ain't never nobody loved me like I love myself )
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
There are definite instances where double-negatives are repulsive.
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Two wrongs don't make a right, but three lefts do.
|
|
|
|
|
Just thought I might rant a bit.
Simply trying to use MS example and driver to use Java to connect to sql server.
The only error I can ever get is: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://
I don't believe it is finding the proper jar file.
I noticed that when I build via javac that even if I provide a bad path to the jar or whatever, the "compiler" happily rolls on. Oy! No way to even tell if javac is incorporating the jar.
I've downloaded the jar from : Download Microsoft JDBC Driver for SQL Server - SQL Server | Microsoft Docs[^]
I've tried older versions also. I'm running java 1.8 so I'm using the JDBC built for 1.8.
Just wasting time and I can't tell why it is giving me the same bad error no matter what I try. So annoying! Waste of time!
Java is so unsupported by anyone.
I'm sure I'm doing something wrong.
EDIT
I noticed that it gave me two errors:
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
I searched for source and found it at:
DriverManager Java Source Code[^] -- don't know exactly which version that is and it doesn't have line numbers.
THen I saw this....
if(url == null) {
throw new SQLException("The url cannot be null", "08001");
}
I set the connection string (url) to null and got that error.
Now down below I see the other STUPID and NON-DETAILED error message:
println("getConnection: no suitable driver found for "+ url);
throw new SQLException("No suitable driver found for "+ url, "08001");
modified 29-Jun-20 17:45pm.
|
|
|
|
|
raddevus wrote: use Java to I found your problem!
raddevus wrote: Java is so unsupported by anyone. How's that even possible?
It's only been the most used language, according to TIOBE and the like, for about 25 years straight
|
|
|
|
|
Sander Rossel wrote: How's that even possible?
The Internet is so clogged up with 25 years of Java documentation you can't find anything out here. It's all hopes and dreams of past generations, but nothing that actually works.
|
|
|
|
|
First time I've heard someone bitch about something being over supported.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
The Internet version of "57 channels and nothing on"
|
|
|
|
|
Mycroft Holmes wrote: First time I've heard someone bitch about something being over supported.
I have an extreme talent for bitching and can do so about good or bad.
|
|
|
|
|
Assuming the JAR is already added in your classpath, try adding Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); before the call to DriverManager.getConnection . I think that's still the full name of the SQL Server driver at least. Those are the two things that commonly cause this error.
EDIT:
Also if you're curious why javac doesn't seem to care, from what I understand it's because the SQLServerDriver class is never referenced in your code and therefore unnecessary for javac. DriverManager doesn't explicitly load driver classes, it just fetches them which is why you need to explicitly load the class via Class.forName .
modified 29-Jun-20 20:33pm.
|
|
|
|
|
Really great info. Thanks very much. It helps me confirm that I should have everything right.
Here's the deal:
My CLASSPATH is set to the directory where I'm building and the location of the mssql-jdbc-8.2.2.jre8.jar (downloaded from MS site).
I can compile a program that has only the following in it:
try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}
catch(Exception e1){System.out.println(e1);}
When I run it, I see the following exception:
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver.class
I thought I had the class name incorrect or something so I looked inside the jar (named aboe) and found the class.
Maybe this jar is dependent upon another and that one isn't in the classpath or something??
I'm stumped!!
Thanks again for the info.
|
|
|
|
|
I have the following example working. Hopefully it helps point you in the right direction.
Folder structure:
jdbctest
- classes
- lib
- mssql-jdbc-8.2.2.jre8.jar
- src
- JDBCTest.java
Files:
JDBCTest.java
import java.sql.Driver;
import java.sql.DriverManager;
public class JDBCTest {
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Driver sqlServerDriver = DriverManager.getDriver("jdbc:sqlserver://localhost");
System.out.println(
sqlServerDriver.toString()
+ ":" + sqlServerDriver.getMajorVersion()
+ "." + sqlServerDriver.getMinorVersion()
);
}
catch (Exception ex)
{
System.out.println(ex.getMessage());
}
}
}
Commands (run from project directory):
javac -d classes src/JDBCTest.java
java -classpath classes:lib/* test.JDBCTest
It should print out "SQLServerDriver:1:8.2".
|
|
|
|
|
Wow! That is a really great detailed example. Thanks so much.
I'm going to try it right now. I'll set it up exactly like yours and we will see what happens.
Thanks again. I will let you know.
|
|
|
|
|
I set up everything exactly the same as you showed, but I did have to alter a couple of things to get it working...
When I ran java -classpath classes:lib/* test.JDBCTest from the project directory, I got an error that said:
Error: Could not find or load main class test.JDBCTest
If I run it successfully from the classes directory, it throws an exception that outputs:
com.microsoft.sqlserver.jdbc.SQLServerDriver
I believe the test.JDBCTest is not correct on the last line in your example, but I'm not sure. Seems like that would have it in a pkg named test, right?
I'm hacking around but still don't quite have it. Thanks
|
|
|
|
|
Wow!! I finally figured it out because I screwed around with -classpath so much!!.
I'm on Windows so the separator has to be ; not a :
Once I did that your instructions worked with the following java command:
java -classpath classes;lib/* JDBCTest
Notice I removed the test. (pkg name) and I changed the : to a ;
While trying to get it working, I changed the output to have separate lines :
SQLServerDriver:1
8
2
Thanks so much, you got me there. Phew...
|
|
|
|
|