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)
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
