You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Jacob Kjome <ho...@visi.com> on 2002/09/17 01:27:47 UTC
Re: UnsupportedOperationException when connecting from
datasource
"user" should be "username".
Also, why are you calling ds.getConnection("", "")? Shouldn't it just be
ds.getConnection();
Jake
At 05:49 PM 9/16/2002 -0500, you wrote:
>Server: Tomcat 4.1.10
>DBMS: PostgreSQL 7.2.1-5
>JDBC-Driver: Driver for JDBC 2.0
>Java: JDK 1.4.0_02
>
>Hi, I can't get a connection from the datasource when running my
>servlet. I get an UnsupportedOperationException:
>
>java.lang.UnsupportedOperationException
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:125)
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:329)
> at cevex.servlet.QueryServlet.doGet(QueryServlet.java:121)
> (this is my servlet)
> ...
>
>the code breaks at
>
> conn = ds.getConnection("", "");
>
>I am using the default DataSource that comes with tomcat. Does anyone have
>an idea for what's going on???
>
>Following are my server.xml and web.xml files.
>
>thank you
>
>Jose
>
>
>Server.xml: just the CONTEXT part, everything else is unchanged
>since tomcat installation
>-----------------------------------------------------------------
>
>
> <!-- CEVEX Context -->
> <Context
>path="/cevex" docBase="/usr/local/www/cevex" reloadable="true">
> <Resource
>name="jdbc/cevexDB" auth="Container" type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/cevexDB">
> <parameter> <name>factory</name>
>
><value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
>
> <parameter> <name>maxActive</name> <value>100</value>
></parameter>
>
> <parameter> <name>maxIdle</name> <value>30</value> </parameter>
>
> <parameter> <name>maxWait</name> <value>10000</value>
></parameter>
>
> <parameter> <name>user</name> <value>postgres</value>
></parameter>
> <parameter> <name>password</name> <value></value> </parameter>
>
> <parameter> <name>driverClassName</name>
> <value>org.postgresql.Driver</value> </parameter>
>
> <parameter>
> <name>url</name>
> <value>jdbc:postgresql://localhost/cevex</value>
> </parameter>
> </ResourceParams>
> </Context>
>
>
>web.xml
>----------------------
>
>
><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web
>Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
>
><web-app>
> <servlet>
> <servlet-name>QueryServlet</servlet-name>
> <servlet-class>cevex.servlet.QueryServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>InscribeServlet</servlet-name>
> <servlet-class>cevex.servlet.InscribeServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>LoginServlet</servlet-name>
> <servlet-class>cevex.servlet.LoginServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>LogoutServlet</servlet-name>
> <servlet-class>cevex.servlet.LogoutServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>UserControllerServlet</servlet-name>
> <servlet-class>cevex.servlet.UserControllerServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>CreaSeccionMiembrosServlet</servlet-name>
>
><servlet-class>cevex.servlet.CreaSeccionMiembrosServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>CambiarMisDatosInscritosServlet</servlet-name>
>
><servlet-class>cevex.servlet.CambiarMisDatosInscritosServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>CambiarMisDatosPromotoresServlet</servlet-name>
>
><servlet-class>cevex.servlet.CambiarMisDatosPromotoresServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>CambiarContraseniaServlet</servlet-name>
>
><servlet-class>cevex.servlet.CambiarContraseniaServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>ObtenerListaCursosServlet</servlet-name>
>
><servlet-class>cevex.servlet.ObtenerListaCursosServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>AgregaCursoServlet</servlet-name>
> <servlet-class>cevex.servlet.AgregaCursoServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>AgregaCursosAlCarritoDeComprasServlet</servlet-name>
>
><servlet-class>cevex.servlet.AgregaCursosAlCarritoDeComprasServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>QuitaCursosDelCarritoDeComprasServlet</servlet-name>
>
><servlet-class>cevex.servlet.QuitaCursosDelCarritoDeComprasServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>RealizaCompraServlet</servlet-name>
> <servlet-class>cevex.servlet.RealizaCompraServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>CorroboraPagoServlet</servlet-name>
> <servlet-class>cevex.servlet.CorroboraPagoServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>CorroboraComisionServlet</servlet-name>
>
><servlet-class>cevex.servlet.CorroboraComisionServlet</servlet-class>
> </servlet>
> <servlet>
> <servlet-name>VerificaDatosInscripcionServlet</servlet-name>
>
><servlet-class>cevex.servlet.VerificaDatosInscripcionServlet</servlet-class>
> </servlet>
>
>
> <session-config>
> <session-timeout>1</session-timeout>
> </session-config>
>
> <resource-ref>
> <description> DataSource for connections </description>
> <res-ref-name>jdbc/cevexDB</res-ref-name>
> <res-type> javax.sql.DataSource </res-type>
> <res-auth> Container </res-auth>
> </resource-ref>
></web-app>
>
>
>
>
>
>--
>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: UnsupportedOperationException when connecting from datasource
Posted by Alfonso Martinez <tr...@linuxcenter.com.mx>.
Thanks, thanks, thanks a lot Jake. It is working now!!!
As you said, "user" should be "username",
also ds.getConnection("", "") should be ds.getConnection()
My system was running OK on Tomcat 4.0.1/mysql. Problems arrised when I
migrated to Tomcat 4.1.10/postgresql.
I really thank you. You saved me from long hours
Jose
On Mon, 16 Sep 2002, Jacob Kjome wrote:
>
> "user" should be "username".
>
> Also, why are you calling ds.getConnection("", "")? Shouldn't it just be
> ds.getConnection();
>
> Jake
>
> At 05:49 PM 9/16/2002 -0500, you wrote:
>
> >Server: Tomcat 4.1.10
> >DBMS: PostgreSQL 7.2.1-5
> >JDBC-Driver: Driver for JDBC 2.0
> >Java: JDK 1.4.0_02
> >
> >Hi, I can't get a connection from the datasource when running my
> >servlet. I get an UnsupportedOperationException:
> >
> >java.lang.UnsupportedOperationException
> > at
> > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:125)
> > at
> > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:329)
> > at cevex.servlet.QueryServlet.doGet(QueryServlet.java:121)
> > (this is my servlet)
> > ...
> >
> >the code breaks at
> >
> > conn = ds.getConnection("", "");
> >
> >I am using the default DataSource that comes with tomcat. Does anyone have
> >an idea for what's going on???
> >
> >Following are my server.xml and web.xml files.
> >
> >thank you
> >
> >Jose
> >
> >
> >Server.xml: just the CONTEXT part, everything else is unchanged
> >since tomcat installation
> >-----------------------------------------------------------------
> >
> >
> > <!-- CEVEX Context -->
> > <Context
> >path="/cevex" docBase="/usr/local/www/cevex" reloadable="true">
> > <Resource
> >name="jdbc/cevexDB" auth="Container" type="javax.sql.DataSource"/>
> > <ResourceParams name="jdbc/cevexDB">
> > <parameter> <name>factory</name>
> >
> ><value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> > </parameter>
> >
> > <parameter> <name>maxActive</name> <value>100</value>
> ></parameter>
> >
> > <parameter> <name>maxIdle</name> <value>30</value> </parameter>
> >
> > <parameter> <name>maxWait</name> <value>10000</value>
> ></parameter>
> >
> > <parameter> <name>user</name> <value>postgres</value>
> ></parameter>
> > <parameter> <name>password</name> <value></value> </parameter>
> >
> > <parameter> <name>driverClassName</name>
> > <value>org.postgresql.Driver</value> </parameter>
> >
> > <parameter>
> > <name>url</name>
> > <value>jdbc:postgresql://localhost/cevex</value>
> > </parameter>
> > </ResourceParams>
> > </Context>
> >
> >
> >web.xml
> >----------------------
> >
> >
> ><!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web
> >Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd">
> >
> ><web-app>
> > <servlet>
> > <servlet-name>QueryServlet</servlet-name>
> > <servlet-class>cevex.servlet.QueryServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>InscribeServlet</servlet-name>
> > <servlet-class>cevex.servlet.InscribeServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>LoginServlet</servlet-name>
> > <servlet-class>cevex.servlet.LoginServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>LogoutServlet</servlet-name>
> > <servlet-class>cevex.servlet.LogoutServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>UserControllerServlet</servlet-name>
> > <servlet-class>cevex.servlet.UserControllerServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>CreaSeccionMiembrosServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.CreaSeccionMiembrosServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>CambiarMisDatosInscritosServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.CambiarMisDatosInscritosServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>CambiarMisDatosPromotoresServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.CambiarMisDatosPromotoresServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>CambiarContraseniaServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.CambiarContraseniaServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>ObtenerListaCursosServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.ObtenerListaCursosServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>AgregaCursoServlet</servlet-name>
> > <servlet-class>cevex.servlet.AgregaCursoServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>AgregaCursosAlCarritoDeComprasServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.AgregaCursosAlCarritoDeComprasServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>QuitaCursosDelCarritoDeComprasServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.QuitaCursosDelCarritoDeComprasServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>RealizaCompraServlet</servlet-name>
> > <servlet-class>cevex.servlet.RealizaCompraServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>CorroboraPagoServlet</servlet-name>
> > <servlet-class>cevex.servlet.CorroboraPagoServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>CorroboraComisionServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.CorroboraComisionServlet</servlet-class>
> > </servlet>
> > <servlet>
> > <servlet-name>VerificaDatosInscripcionServlet</servlet-name>
> >
> ><servlet-class>cevex.servlet.VerificaDatosInscripcionServlet</servlet-class>
> > </servlet>
> >
> >
> > <session-config>
> > <session-timeout>1</session-timeout>
> > </session-config>
> >
> > <resource-ref>
> > <description> DataSource for connections </description>
> > <res-ref-name>jdbc/cevexDB</res-ref-name>
> > <res-type> javax.sql.DataSource </res-type>
> > <res-auth> Container </res-auth>
> > </resource-ref>
> ></web-app>
> >
> >
> >
> >
> >
> >--
> >To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> >For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>