tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Gooding <josh.good...@gmail.com>
Subject Re: ConnectionPool question
Date Wed, 04 Nov 2009 17:11:49 GMT
Chris,

I would imagine that you are correct, unless I store the RSMD in anther
object (like a Map or AL).

Now that I have started closing my resources something strange has actually
happened now.  I've hit the connectionpool limit faster.

I was digging and realized that I changed my context.xml file for the new
DataSourceFactory, but there is a watched resource in my web.xml that is
still pointing to javax.sql.DataSource.  should this be changed to the
tomcat's DataSourceFactory as well?

Here's the snippet from the context.xml:

<Resource
        name="jdbc/RealmDB"
        auth="Container"
        type="javax.sql.DataSource"
        factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
        username="root"
        password="password"
        driverClassName="com.mysql.jdbc.Driver"

Here's from the web.xml:

<resource-ref>
        <res-type>javax.sql.DataSource</res-type>
        <res-ref-name>jdbc/RealmDB</res-ref-name>
        <res-auth>Container</res-auth>
    </resource-ref>

Do I need to change the <res-type> to the tomcat's DataSource?

On Wed, Nov 4, 2009 at 11:47 AM, Christopher Schultz <
chris@christopherschultz.net> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Josh,
>
> On 11/3/2009 3:24 PM, Josh Gooding wrote:
> > If I close the RS, can I still use the MD?
>
> I see you've already answered this, but note the error is that the
> Connection is closed, not the ResultSet.
>
> I would expect that ResultSetMetaData requires that the ResultSet itself
> still be "open" in order to use it.
>
> - -chris
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkrxsBUACgkQ9CaO5/Lv0PA9FgCgoK27dFtvbyyF4A6M/LrxviWX
> OCoAn0Uxn21O6woqtRZMbZKGOcLlHpQS
> =WlcR
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message