I know the issue has been risen a couple of times here, but I was not able to find the solution for me. I cannot retrieve my datasource for my server component. I am a not to sure about some configuration details:
<b>1. Visual Admistrator - JDBC Connector configuration</b>
How does the application name affect the lookup operation of the DS in JNDI. Or is it simply a name to group datasources?
<b>2. Configuration of the DataSource</b>
I have a DS with the name direct_jdbc and an alias myApp/jdbc/datasources/direct_jdbc. I can see the datasource in the JNDI Registry at multiply nodes.
Why are the "notx" and "client" nodes containing DS references? Which one do I need to lookup?
I have defined the following <db-properties> in my persistent.xml files:
<db-properties> <data-source-name> myApp/jdbc/datasources/direct_jdbc </data-source-name> </db-properties>
My client lookup is as follows:
InitialContext ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("jdbc/myApp/jdbc/datasources/direct_jdbc"); Connection con = ds.getConnection();
The lookup results in the following Exception
com.sap.engine.services.jndi.persistent.exceptions.NameNotFoundException: Object not found in lookup of myApp/jdbc/datasources/direct_jdbc.
I really don't see why this is not working. The datasource is defined and the JNDI-path looks ok to me. Why does the lookup fail?
Any answers are highly appreciated.