how to create a JDBC Driver

[Former Member]

hi... pls tell me how to create a JDBC driver that will enable me to connect SAP Netweaver to oracle database through JDBC.. pls give the sample code with syntax....

thank you

[Former Member · Accepted solution]

Hi

See this thread for connecting SQL Server

For Oracle

try

{DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@Oracle_server_ip:Oracle port:SID of the Database","user_name","password");

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("your query");

}catch(Exception e){

}

see this thread

Kind Regards

Mukesh