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

List:       tomcat-user
Subject:    Re: Database pool problem
From:       Dan Johnsson <dan.johnsson () omegapoint ! se>
Date:       2003-12-05 23:46:51
[Download RAW message or body]

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

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