JDBC version not supported error

[achuthan mukundarajan]

i installed JDBC sql server driver 4.0 and configured it for netbeans 6.9 and i got an error saying this version is not supported for jdk 1.6. I went for jdbc 3.0 and i got the same error which is


java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

I just used the sqljdbc4.jar file in the libraries folder and still got the same error.

Help!

[Wendy Gibbons]

Where did you get the jar from, as it sounds to me like it is a very old jar that was written for a jdk version 1.5 or below.

[achuthan mukundarajan]

I have tried jdbc for sql server version 4.0

I havent found a method that works for this.

[achuthan mukundarajan]

I fixed it but i get a new error

SQLException caught: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

I am using sql server 2008 under windows authentication and my connection string is :

jdbc:sqlserver://localhost:1433;databaseName=sampledb;integratedSecurity=true

[achuthan mukundarajan]

Fixed the port thing Now i have a NullpointerException while insertion:

The code is given below:

String connectionURL="jdbc:sqlserver://localhost:1433;databaseName=sampledb;integratedSecurity=true";
        Connection connection=null;
        ResultSet rs;
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String name=request.getParameter("txtname");
        int age=Integer.parseInt(request.getParameter("txtage"));
        try
        {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection conn = DriverManager.getConnection(connectionURL,"","");
            String query="INSERT into details VALUES(?,?)";
            PreparedStatement pst=connection.prepareCall(query);
            pst.setString(1, name);
            pst.setInt(2, age);

             }
        catch(ClassNotFoundException e){
  out.println("Couldn't load database driver: "
  + e.getMessage());
  }
        catch(SQLException e){
  out.println("SQLException caught: " 
  + e.getMessage());
  }
  catch (Exception e){
  out.println(e);
  }
        finally {
  // Always close the database connection.
  try {
  if (connection != null) connection.close();
  }
  catch (SQLException ignored){
  out.println(ignored);
  }
  }

[Paul Clapham]

Then your first step is to find out what line of code threw the exception. Check the stack trace, it tells you exactly that.