macOS java jdbc connection to sql server

Hi

Don't you have to call newInstance() on the class?

eg

Class.forName( "com.mysql.jdbc.Driver" ).newInstance() ;

Well that's what I do at any rate.


b e n

lazydog said:

Hi

Don't you have to call newInstance() on the class?

eg

Class.forName( "com.mysql.jdbc.Driver" ).newInstance() ;

Well that's what I do at any rate.


b e n

Click to expand...

You don't have to call newInstance(). I use JDBC a lot at work connecting to Sybase enterprise database servers. We don't call newInstance(). When you ask for a connection the JDBC libraries automatically create an instance for you if needed. You simply have to ensure that the class has been loaded into the current JVM session. Which is what Class.forName does.

As for why it does not work: did you read and consider the error? It's not apparently a code problem. It is telling you that it did not receive a response from the server specified. Can you ping that IP address?

robbieduncan said:

You don't have to call newInstance(). I use JDBC a lot at work connecting to Sybase enterprise database servers. We don't call newInstance(). When you ask for a connection the JDBC libraries automatically create an instance for you if needed. You simply have to ensure that the class has been loaded into the current JVM session. Which is what Class.forName does.

Click to expand...

Thanks for the info… much appreciated!

b e n

ashokformac said:

no i am not able to connect using ping....

Click to expand...

Well if you can't ping it (this is not connecting, simply sending a packet and seeing if the address replies) then you cannot see that machine at a network level. Either the address does not exist or there are firewalls between you and it that are preventing you from talking to it. Is it a Uni server and you are outside the Uni network perhaps?