Connecting to sqlserver from Java

[pink123]

I am using Java 1.6.0_27 ,SQL server 2005,Weblogic 10.3.5.
I am using weblogic.jdbc.sqlserver.SQLServerDriver as the driver class
and jdbc:bea:sqlserver://hostname:1433 jdbcProperties
where jdbcProperties={db=Test, user=test, password=test, ProgramName
=WebLogic JDBC Driver}

Properties jdbcProperties = new Properties();
jdbcProperties.put("user", user);
jdbcProperties.put("password", password);
jdbcProperties.put("db", DB);
jdbcProperties.put("ProgramName", "WebLogic JDBC Driver");
Driver jdbcDriver = (weblogic.jdbc.sqlserver.SQLServerDriver )Class.forName(DRIVER).newInstance();
Connection sqlCon = jdbcDriver.connect(PROTOCOL + "//" + server + ":1433", jdbcProperties);

sqlConn is returned as null.I am not able to connect to the database
Is there some issue with the driver?This code worked fine with Java 1.5_06 and Weblogic 9.1.
I just did an upgrade to Weblogic 10.3.5 and Java 1.6.0_27.
Please help

[meyerstravisl]

Convert

Driver jdbcDriver = (weblogic.jdbc.sqlserver.SQLServerDriver )Class.forName(DRIVER).newInstance();

to

Driver jdbcDriver = ("weblogic.jdbc.sqlserver.SQLServerDriver");
Class.forName(jdbcDriver).newInstance();

I'm not sure if that's causing your problems because if you don't have a String DRIVER variable it shouldn't compile to begin with.
It might help if you copy past your code along with the stacktrace of your error

[clydedoris]

Try printing the content of jdbcDriver and see what it contains tos see which variable and when in the program it becomes null.

If it were a connectivity problem, there should be an exception error. If you have an exception handler, try printing out any error caught.

[Tolls]

Oh for god's sake...reporting.