You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Chaikin, Yaakov Y (US SSA)" <ya...@baesystems.com> on 2003/12/05 17:07:54 UTC
Database pool problem
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
Re: Database pool problem
Posted by Brent Verner <br...@rcfile.org>.
[2003-12-05 11:07] Chaikin, Yaakov Y (US SSA) said:
| 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.
| My server.xml file has this <context>:
|
| <!--*** BEGIN AFECWEB Context ***-->
| <Context className="org.apache.catalina.core.StandardContext"
| <ResourceParams name="jdbc/afecWEBDB">
| <parameter>
| <name>user</name>
^^^^^^^^^^^^^^^^^
That should be <name>username</name>
hth.
Brent
--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Database pool problem
Posted by Dan Johnsson <da...@omegapoint.se>.
I understand that you do not have a choice, but please not that the
JDBC-ODBC bridge is *not for production* [according to Sun], it is
*solely* for development and evaluation.
The bridge contains identified bugs that will not be addressed [i e
support is EOLed]. So, you are using this at your own risk.
Check out the bug parade of the bridge; you might have encountered a
well-known, documented bug. It that case, there might be a published
work-around.
Otherwise: I am sorry to say that you are out in the wilderness alone.
Dan Johnsson, System Architect and Security Consultant
Chaikin, Yaakov Y (US SSA) wrote:
> 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
--
______________________________________________
Dan Johnsson | Säkerhetsarkitekt
dan.johnsson@omegapoint.se | www.omegapoint.se
tel 0709-15 88 43 | fax 08-517 008 29
Omegapoint AB - din säkra punkt i tillvaron
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org