[prev in list] [next in list] [prev in thread] [next in thread]
List: tomcat-user
Subject: RE: Database pool problem
From: "George Sexton" <gsexton () mhsoftware ! com>
Date: 2003-12-08 12:19:18
[Download RAW message or body]
Why not go the extra mile and get a database that supports cutting edge
features like views?
PostgreSQL
-----Original Message-----
From: Edson Alves Pereira [mailto:eapereira@panamericano.com.br]
Sent: Monday, December 08, 2003 6:06 AM
To: 'Tomcat Users List'
Subject: RE: Database pool problem
Of course he has a choice, download MySQL in development machine
and
he will make his tests. This i´d choose.
> ----------
> De: Dan Johnsson[SMTP:dan.johnsson@omegapoint.se]
> Responder: Tomcat Users List
> Enviada: sexta-feira, 5 de dezembro de 2003 20:46
> Para: Tomcat Users List
> Assunto: Re: Database pool problem
>
> 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
>
---------------------------------------------------------------------
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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic