tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan_Pie...@seagram.com (Jonathan Pierce)
Subject Fwd:JDBC Realm Questions Tomcat 3.2.2
Date Wed, 04 Jul 2001 22:31:41 GMT
Someone please respond to these questions so I know whether JDBC Realms are a
supported feature of Tomcat3.2.2. I posted the question a few days ago and have
gotten no responses. 

Has anyone been successful in referencing a jdbc datasource configured in the
server.xml of Tomcat 3.2.2? If so, how?

Jonathan

____________________Forward Header_____________________
Subject:    JDBC Realm Questions Tomcat 3.2.2
Author: tomcat-dev@jakarta.apache.org
Date:       7/3/2001 8:21 PM

This may be a stupid question but I've found hundreds of messages from confused
users on the subject of JDBC Realms and Tomcat and no good explanation or
example. There is a documentation file JDBCRealm.howto but it doesn't describe
how to instantiate the datasource with a code example or what additional
property files need to be included to configure jndi properties.

Like lots of other people, I'm trying to use the release Tomcat 3.2.2, configure
multiple jdbc datasources in the server.xml file, and reference it in my
servlet. I am only interested in using a shared database ID to connect to the
database for all users of my servlet. The database connect info needs to be in
Tomcat conf files since the passwords need to be reconfigured at deployment time
outside my war file.

1. Is this behavior supported by Tomcat 3.2.2? How do I configure multiple
database datasources and instantiate them in my code?

2. Assuming I setup the datasources like below, what properties do I use to
assign a name to the datasource so I can reference it?

<RequestInterceptor 
    className="org.apache.tomcat.request.JDBCRealm" 
    debug="99" 
    driverName="oracle.jdbc.driver.OracleDriver"
    connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL"
    connectionName="scott"
    connectionPassword="tiger"
/>

<RequestInterceptor 
    className="org.apache.tomcat.request.JDBCRealm" 
    debug="99" 
    driverName="oracle.jdbc.driver.OracleDriver"
    connectionURL="jdbc:oracle:thin:@ntserver2:1521:ORCL"
    connectionName="scott"
    connectionPassword="tiger"
/>


3. What do I need to add to a config file in order to access the initial context
so I can retrieve the datasource?

import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.*;
import javax.sql.*;

String          theDataSourceName = "???";
String          theNamingProviderURL = "???";
String          theInitialContextNamingFactory = "???";
Properties theProperties = new Properties (); 
theProperties.put("java.naming.provider.url", theNamingProviderURL);
theProperties.put("java.naming.factory.initial",theInitialContextNamingFactory);

Context theInitialContext = new InitialContext(theProperties);
DataSource theDataSource = (DataSource) theInitialContext.lookup
(theDatasourceName);

Mime
View raw message