Problem setting up Oracle connection pool

[John Eric Hamacher]

Tomcat 6.0.18
ojdbc5dms.jar (11.1.0.7).
JDK 1.5

Hello:

I get the following exception:

java.sql.SQLException: User credentials doesn't match the existing ones
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:77)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:132)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:200)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:264)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:497)
	at oracle.jdbc.pool.OracleImplicitConnectionCache.validateUser(OracleImplicitConnectionCache.java:353)
	at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:440)
	at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:544)
	at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:248)
	at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:201)
	at survey.db.SurveyConnection.getConnection(SurveyConnection.java:70)

at:

            Context context = new InitialContext();
            DataSource pds = null;
            pds = (DataSource)context.lookup(name);            
            Connection conn = pds.getConnection();   //Exception occurs here 

I've been working on this for days. I have tried many different <Resource> configurations in server.xml. Here is my current server.xml (I've changed the values of some attributes for privacy):

<Server port="8005" shutdown="SHUTDOWN">

  <Listener className="org.apache.catalina.core.AprLifecycleListener" SSLEngine="on" />
  <Listener className="org.apache.catalina.core.JasperListener" />
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" />
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />

  <GlobalNamingResources>

    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
              description="User database that can be updated and saved"
              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname="conf/tomcat-users.xml" />

     <Resource name="jdbc/GFDataSource" auth="Container" scope="Shareable" 
            	type="oracle.jdbc.pool.OracleDataSource"
			factory="oracle.jdbc.pool.OracleDataSourceFactory" 
			connectionCacheName="XXX"
			connectionCachingEnabled="true" 
			connectionCacheProperties="{MaxStatementsLimit=10, MinLimit=0, InitialLimit=0, ValidateConnection=true, ConnectionWaitTimeout=10, MaxLimit=4}
		    	maxActive="30"
		    	maxIdle="2"	 
		    	maxWait="1000"
		    	username="username"
		    	password="password"
		    	driverClassName="oracle.jdbc.driver.OracleDriver"
		    	url="jdbc:oracle:thin:@someserver:1111:SID"/>
      <ResourceLink name="jdbc/GFDataSource" global="jdbc/GFDataSource" type="javax.sql.DataSource"/>



  </GlobalNamingResources>

  <Service name="Catalina">
   
    <Connector port="8080" protocol="HTTP/1.1" 
               connectionTimeout="20000" 
               redirectPort="8443" />

    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />

    <Engine name="Catalina" defaultHost="localhost">

      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
             resourceName="UserDatabase"/>

      <Host name="localhost"  appBase="webapps"
            unpackWARs="true" autoDeploy="true"
            xmlValidation="false" xmlNamespaceAware="false">

       <Context docBase="gallupFaith" reloadable="true" path="/gallupFaith">
       </Context>

      </Host>
    </Engine>
  </Service>
</Server>

The database connection information is correct.

Can anybody shed light on this?

Thanks

Eric

[Misha Ver]

Eric, could you try this code

Connection conn = null;
Context context = new InitialContext();  
DataSource pds = null;  
pds = (DataSource)context.lookup(name);              
conn = pds.getConnection();

[John Eric Hamacher]

Thanks.

Tried the code with no luck. I can get it to work if I use getConnection("username", "password") but putting the credentials in the code isn't an option. I can find very little in Google about this exception.