[prev in list] [next in list] [prev in thread] [next in thread] 

List:       tomcat-user
Subject:    Database pool problem
From:       "Chaikin, Yaakov Y (US SSA)" <yaakov.y.chaikin () baesystems ! com>
Date:       2003-12-05 16:07:54
[Download RAW message or body]

Hi,

I am having the following problem and how someone can point out to me
what I am doing wrong.

I am trying to configure Tomcat to have a database connection pool for
my database, but when I try to access the database through a jsp, it
gives me "wrong password" for the database... BUT it IS the right
password.

I am using MS Access as the database (not much choice right now) and
have set up a System DNS.

The weird part is that I am using the same values for a Realm I defined
and I know that it DOES create a connection to the database and
authentication works.
The <Realm> that I have is this:
<Realm 
	className="org.apache.catalina.realm.JDBCRealm"
	connectionName="default" 
	connectionPassword="afecrelease2003"
	connectionURL="jdbc:odbc:afec" debug="0"
	driverName="sun.jdbc.odbc.JdbcOdbcDriver" 
	roleNameCol="UserRole"
	userCredCol="UserPassword" 
	userNameCol="UserName"
	userRoleTable="TestUsers" 
	userTable="TestUsers" 
	validate="true"/> 


My server.xml file has this <context>:

<!--*** BEGIN AFECWEB Context ***-->
<Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper"
cookies="true" 
crossContext="true" 
debug="0"
displayName="AFECWEB" 
docBase="c:/corej2ee/stage/wls/afecWebApp/afecWEB.war"
mapperClass="org.apache.catalina.core.StandardContextMapper"
path="/afecWEB"
privileged="false" 
reloadable="true"
swallowOutput="false" 
useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
	<Logger className="org.apache.catalina.logger.FileLogger"
	debug="0" directory="logs"
	prefix="localhost_afecWEB_log." 
	suffix=".txt"
	timestamp="true" 
	verbosity="99"/>
	<Resource 
	name="jdbc/afecWEBDB" 
	auth="Container"
	description="AFEC database; stores info about documents, login"
	type="javax.sql.DataSource" 
	scope="Shareable" />
	<ResourceParams name="jdbc/afecWEBDB">
		<parameter>
			<name>factory</name>
	
value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
		</parameter>
		<parameter>
			<name>maxActive</name>
			<value>1</value>
		</parameter>
		<parameter>
			<name>maxIdle</name>
			<value>1</value>
		</parameter>
		<parameter>
			<name>maxWait</name>
			<value>10000</value>
		</parameter>
		<parameter>
			<name>driverClassName</name>
			<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
		</parameter>
		<parameter>
			<name>url</name>
			<value>jdbc:odbc:afec</value>
		</parameter>
		<parameter>
			<name>user</name>
			<value>default</value>
		</parameter>
		<parameter>
			<name>password</name>
			<value>afecrelease2003</value>
		</parameter>
		<parameter>
			<name>connectionName</name>
			<value>default</value>
		</parameter>
		<parameter>
			<name>connectionPassword</name>
			<value>afecrelease2003</value>
		</parameter>
		<parameter>
			<name>connectionURL</name>
			<value>jdbc:odbc:afec</value>
		</parameter>
		<parameter>
			<name>driverName</name>
			<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
		</parameter>
	</ResourceParams>
</Context>
<!--*** END AFECWEB Context ***-->

Any help would be greatly appreciated.

Thanks.

Yaakov Chaikin
Software Engineer
BAE SYSTEMS
301-838-6899 (phone)
301-838-6802 (fax)
yaakov.y.chaikin@baesystems.com



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]