-How to use JDBC to connect the SQLServer and Oracle.

[Former Member]

Hi,

I create a table in the WIP DB, I want to modify this table when use "PRE-START" activity in POD.

SAPME version: 5.2.3.4 SDK:2.0 DB:SQL2005 and Oracle 10.2g

SourceCode like below:

public void execute(StartHookDTO dto) throws Exception {

initServices();

try{

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

Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=SAPMEWIP", "sa" ,"sap12345");

conn.close();

}catch(Exception e){

e.printStackTrace();

}

}

Besides, I already setup the JDBC ClassPath in ConfigTool, but it gets somes error when executing.

the error code like below:

java.sql.SQLException: No suitable driver

Please give me some support or a example, thank you so much!

Br,

Alex

[tim_drury]

You probably want to use the WIP Datasource defined in JNDI.