how to work with oracle as backend

[Former Member]

Hi Forum

I would like to get some material which can guide me how to use oracle as backend with netweaver.

Thanks & Regards

Jaspreet Kaur

[Former Member]

Hi! Jas,

you need to create a WebDynpro Project and appl.using NWDS.

Then write following code to get connected to Oracle:--

MessageManager msgMgr = (MessageManager)wdThis.wdGetAPI().getComponent().getMessageManager();

String serverName = "172.43.87.65";

String portNumber = "1526";

String sid = "vision";

String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;

String userName = "scott";

String password = "tiger";

Connection connection = null;

try {

// Load the JDBC driver

String driverName = "oracle.jdbc.driver.OracleDriver";

Class.forName(driverName);

connection = DriverManager.getConnection(url, userName, password);

Statement stmt =connection.createStatement();

ResultSet resultSet = stmt.executeQuery("select * from employee");

if(resultSet.next()) {

msgMgr.reportWarning(resultSet.getString(1));

msgMgr.reportWarning(resultSet.getString(2));

}

} catch(Exception exc) {

exc.printStackTrace();

}

You need to put classes12.jar in classpath as well.

regards,

Mithileshwar

[Former Member]

hi,

check on service market place

http://service.sap.com/instguides

regards

ajai

[Former Member]

hi ajai

I need help in coding part not installation. Actually in abap we import rfcs n i guess in case of oracle i need to make a java class n import it so i needed guidance in that.

Thanks & Regards

Jaspreet Kaur