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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] > 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) > > [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > -- > ______________________________________________ > Dan Johnsson | Säkerhetsarkitekt > [EMAIL PROTECTED] | 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]