EMAIL PROTECTED]
> Sent: 28 October 2003 15:54
> To: mysql
> Cc: MySQL Java
> Subject: Re: DROP TEMORARY TABLE
>
>
> Michael McTernan wrote:
>
> > My problem, that so far no one has been able to answer, is that
> I'm using
> > connection pooling with the To
Michael McTernan wrote:
My problem, that so far no one has been able to answer, is that I'm using
connection pooling with the Tomcat server.
TransactionA gets connection A from the pool.
TransactionA creates a temporary table for some query.
TransactionA is done, and returns the connection to th
age-
> From: Steve Buehler [mailto:[EMAIL PROTECTED]
> Sent: 28 October 2003 11:37
> To: Michael McTernan; mysql
> Subject: Re: DROP TEMORARY TABLE
>
>
> TEMPORARY TABLES are suppose to work this way. They are only
> there during
> a connection and then dropped wh
Original Message-
> From: Steve Buehler [mailto:[EMAIL PROTECTED]
> Sent: 28 October 2003 11:37
> To: Michael McTernan; mysql
> Subject: Re: DROP TEMORARY TABLE
>
>
> TEMPORARY TABLES are suppose to work this way. They are only
> there during
> a connection and then dropp
TEMPORARY TABLES are suppose to work this way. They are only there during
a connection and then dropped when the connection to the database is
closed. One thing they are great for is when you have temporary information
that needs to be kept and worked with. One of my programs has to pull
thin
Hi there,
I'm trying to restrict the access that a Tomcat server has to mysql
4.0.15-standard-log database server. Unfortunately some of the queries use
temporary tables, so I've had to GRANT CREATE TEMPORARY TABLES to the user.
However, since the server is using connection pooling, it also DROP
