Oracle Database Discussions

Hi All,

While connecting the sql server database using oracle procedure it 's raising the below error.

My java version in oracle is JDK1.5 version

SELECT  dbms_java.get_ojvm_property(PROPSTRING=>'java.version') FROM dual

1.5.0_10

Code :

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED TESTCONNECTION as import java.io.PrintWriter;

import java.io.StringWriter;

import java.sql.*;

import java.util.ArrayList;

public class TestConnection {

    public static int connect(String conString) throws Exception {

        System.out.println(conString);

        String[] connections = conString.split("\\#");

        usr = connections[0];

        pwd = connections[1];

        url = connections[2];

        jdbcdriver = connections[3];

        db_app = connections[4];

        app_id = connections[5];

        run_id = Integer.parseInt(connections[6]);

        int re = -5;

        try {

            System.out.println(url);

           // Class.forName(jdbcdriver);

           Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

           // conn = DriverManager.getConnection(url, usr, pwd);

           conn = DriverManager.getConnection("jdbc:sqlserver://191.164.1.14:1433;DATABASE=Test;integratedSecurity=true", "TEST", "TEST");

            re = 0;

        }

        catch (Exception e) {

            re = -1;

        }

        return re;

    }

};

/

Errorr:

java.lang.ClassNotFoundException: com/microsoft/sqlserver/jdbc/SQLServerDriver

  at java.lang.Class.forName0(Native Method)

  at java.lang.Class.forName(Class.java)

  at TestConnection.connect(TESTCONNECTION:53)

Could you please help on this one?

Thanks