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.
2 Answers
-
Best Answer
Former MemberPosted on Aug 13, 2009 at 05:45 AMHi,
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
Add a comment
-
Posted on Aug 13, 2009 at 03:21 AM
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
Add a comment
Add a comment