Hi all.
Well, I'm not having much success with JDBC data source over JNDI. What happens
is that the object that should be javax.sql.DataSource is returned "null" from
the lookup.
What steps can I take to identify the source of (not only) my problem?
SERVER.XML
----------
<Context docBase="addr_admin" path="/addr_admin" debug="0">
<Resource name="jdbc/AddressBookDB" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/AddressBookDB">
<Parameter>
<Name>driverClassName</Name>
<Value>org.postgresql.Driver</Value>
</Parameter>
<Parameter>
<Name>driverName</Name>
<Value>jdbc:postgresql://test.domain.com/test</Value>
</Parameter>
<Parameter>
<Name>user</Name>
<Value>my_user</Value>
</Parameter>
<Parameter>
<Name>password</Name>
<Value>my_pass</Value>
</Parameter>
</ResourceParams>
</Context>
WEB.XML
-------
<resource-ref>
<res-ref-name>jdbc/AddressBookDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
TEST.JSP
--------
public void init() throws ServletException {
Context initCtx, envCtx;
super.init();
try {
initCtx = new InitialContext();
if( (envCtx = (Context)initCtx.lookup( "java:comp/env" )) == null ) {
throw new UnavailableException( "No java:comp/env context" );
}
if( (ds = (DataSource)envCtx.lookup( "jdbc/AddressBookDB" )) == null ) {
throw new UnavailableException( "No environment resource: JDBC" );
}
} catch( javax.naming.NamingException ne ) {
throw new UnavailableException( "Naming service failure" );
}
}
The servlet goes to "unavailable" and the error in logs is that JDBC line. So,
the "java:comp/env" is accessable, but not the "jdbc/AddressBookDB". What could
possibly be the reason for this? How can test JNDI setup?
Nix.
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
