direct jdbc database access

[Former Member]

Hi all,

I have to access the SAP-Standard-Database directly without EntityBeans in order to improve the performance of my application (J2EE).

For that purpose i want to use the SAPSR3DB db data source, so no database connection data have to be configured in my application.

Has anyone an idea how to connect the database with this datasource or an alias?

Thanks

[Former Member]

Florian,

You need to define new Data Source / Alias (according to your scenario). You may refer these links in the same sequence to understand the steps involved in making your scenario work.

[Application Resources Management|http://help.sap.com/saphelp_nwce10/helpdata/en/44/e3c34b4c836c2fe10000000a114a6b/content.htm] (especially Managing JDBC Drivers, Managing JDBC DataSources, Managing JDBC DataSource Aliases)

Once you deployed your driver and created the JDBC datasource, create an alias for the datasource and start using it in your application as a specified [here|http://help.sap.com/saphelp_nwce10/helpdata/en/45/c82cd460a42e96e10000000a155369/content.htm]

Bala

[Former Member]

Thanks for the reply,

but the given links does not help me really.

I use Enterprise Java Beans under SAP NW-AS 7.0 The application accesses the database with EntityBeans. But for one query i need direct access to the database.

In Visual Admin the default datasource SAPSR3DB is configured (with some aliases, which are used by the entity beans). And i want to use the connection data definded in this datasource.

Is there no possibility to do this in the java sourcecode?

I have found a posibility over jndi-Context.lookup. So the problem is solved

Edited by: Florian Fuchs on Sep 29, 2008 3:02 PM