using the local db in the netweaver developers workplace

[Former Member]

hi guys,

is it possible to use the local db of my developers workplace?

I am planning to create jsp-pages in the netweaver developers studio (nds) and want create some db-table for my application (create and update statements). how can I access the local db in the nds? do I need a special jar-file like in jdbc to handle the communication with the db?

In a later step I want to migrate this application into the local sap portal.

thanks

thorsten

[Former Member · Accepted solution]

Yes you need jar files to connect to database from jsp in NWDS.

Connection con;

Statement stmt;

public DataBaseDAO()

{

try{

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

Class.forName("oracle.jdbc.driver.OracleDriver");

String s ="jdbc:oracle:thin:@ip address:database sid";

con=DriverManager.getConnection(s,"usrname","password");

stmt = con.createStatement();

}catch(Exception e){}

}

Please send me your email id .i can send u the jar files

Reward points if helpful

Bala

[Former Member · Accepted solution]

hi Bala,

the delivered local db in the developers workplace should be a max-db and not an oracle-db.

so your coding can´t work...I have formerly worked with the odbc.jar for the oracle-db but now I think I need a special one for the max-db.

and where can I get the access informations about my local max-db like "database sid" and "user" and "pw" ???

Thanks for your answer and merry x-mas

[Former Member · Accepted solution]

hi thorsten,

the access information about your local max-db is shown in the sapmmc.

the preferred way to access databases is by using jdbc datasources

--> http://help.sap.com/saphelp_nw70/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/content.htm

and the following link to get familiar with driver class and connection string:

--> http://help.sap.com/saphelp_nw04s/helpdata/en/43/313c13198d0d26e10000000a1553f7/content.htm

or:

hth, regards and merry x-mas to you, too

regards, jens

[Former Member]

thank you jens for your perfect answer