on 08-12-2009 7:28 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.