Database operation with web dynpro java

[Former Member]

Hi,

Our portal installed on MaxDB database.We need to develop web dynpro java application has some database opeartions (insert,update, delete, select) on MaxDB database.

1- Is there a blog or sample how can it be done over MaxDB?

2- Is there exploring tool for MaxDB to create tables?

Thanks.

[Former Member · Accepted solution]

Hi,

To access MAXdb you have to use JDBC connectivity.

Here is the blog written by Karthikeyan Rammohan which describes JDBC Connectivity with Webdynpro and Max DB

[BLOG|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7979%3Fpage%3Dlast%26x-showcontent%3Doff%26x-maxdepth%3D0] [original link is broken] [original link is broken] [original link is broken];

Regards,

srikanth

[junwu]

hi,

point 1, it is just pure java programing

you can go with this:

ResultSet result = null;

try

{

InitialContext initialcontext = new InitialContext();

DataSource datasource = (DataSource)initialcontext.lookup("jdbc/<DataSourceName>");

Connection connection = datasource.getConnection();

Statement statement = connection.createStatement();

result = statement.executeQuery( <Query>);

connection.close();

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

2. maxdb has standard client you can use to manage the database

Best regards,

john