javax.naming.NameNotFoundException: Name java:comp is not bound in this Context

[jbferrer2012]

Hi Isomorphic,

I was trying to create a jdni Data Source, the purpose is to move all the db connection settings outside the application and configure it on tomcat.

DS was not able to connect.

Error: javax.naming.NameNotFoundException: Name java:comp is not bound in this Context


##############
Tomcat - server.xml
##############

<Resource name="jdbc/jndiTest"
                 auth="Container"
                 type="javax.sql.DataSource"
                 driverClassName="oracle.jdbc.driver.OracleDriver"
                 url="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:mySid"
                 username="oracuser"
                 password="oracuser"
                 initialSize="5"                 
                 maxActive="50" />

###################
server.properties
###################

sql.OraDB.driver.name: java:/comp/env/jdbc/jndiTest
sql.OraDB.database.type: oracle
sql.OraDB.interface.type: jndi

regards,
/john

[Isomorphic]

This means your JNDI name is wrong. Most likely Tomcat does not want you to use the java: prefix or java:comp/env since its implicit.

If you still can't fix it, remember you need to post the complete server log for the failing request, not just the exception.

[jbferrer2012]

Hi,

I was able to fix the issue by moving my configuration in sever.xml inside the <Host></Host> tag and included <Context docBase="AppName" path="/AppName" reloadable="true">

<Context docBase="AppName" path="/AppName" reloadable="true">
<Resource name="jdbc/jndiTest"
                 auth="Container"
                 type="javax.sql.DataSource"
                 driverClassName="oracle.jdbc.OracleDriver"
                 url="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:mySid"
                 username="oracuser"
                 password="oracuser"
                 initialSize="5"
                 maxActive="50" />
</Context>