connecting to the j2ee engine internal database server(oracle)

[Former Member]

Hi

i am creating a datasource in visual administrator for accessing/to create tables in j2ee engine internal database like oracle.

after filling all the information, then iam trying to execute database schema squery called select * from tab in visual administrator. but gives the following error

-

---

java.rmi.RemoteException: com.sap.engine.services.dbpool.exceptions.BaseRemoteException: SQL statement(s) cannot be executed over DataSource "ExxonLogViewerDS". If you are using an Open SQL DataSource, you must register your tables using JDDI before you request them. Reason: com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL [id = Unknown]

please anybody help me out on this issue.

sudha..

[former_member698570]

Hi,

I guess you have to register a JNDI Resource and then perform a lookup on this resource when using the Datasource.

See the following docs:

http://help.sap.com/saphelp_nw70/helpdata/EN/08/8f633e0084e946e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/EN/15/83343ecc7f892ee10000000a114084/content.htm

http://help.sap.com/saphelp_nw70/helpdata/EN/a0/8e633e0084e946e10000000a114084/content.htm

Hope this helps

Cheers

[Former Member]

I m not sure this may help. But try this

http://help.sap.com/saphelp_nw04/helpdata/en/5c/2f2c4142aef623e10000000a155106/content.htm