wood burning stoves 2.0*
The moose likes JDBC and the fly likes Temporay tables -- cause problems? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Temporay tables -- cause problems?" Watch "Temporay tables -- cause problems?" New topic
Author

Temporay tables -- cause problems?

Mike London
Ranch Hand

Joined: Jul 12, 2002
Posts: 1043
Hi,

Are there any problems using temporary tables in a multi-user application?

I am creating a temporary table and then using it to generate other column results (that would have been very difficult in a single query).

I think I read that the temp tables are kept separate for each user.

Look forward to any and all replies.

Thanks.

- Mike
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Originally posted by Mike London:

Are there any problems using temporary tables in a multi-user application?



As per my experience, Yes it creates problem when it is not carefully planned, specially when using connection pools


temp tables are kept separate for each user.


Yes It is ,but when you say it is separate for each user this means it is separate for each connection and connection pooling mess-up every thing.

In a multi user scenario, A connection with with pooling is shared among many user of your application those are not database user but application user, therefore in reality a temporary table is not for one user and you are likely to get unexpected results.

Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Temporay tables -- cause problems?
 
Similar Threads
creating temporary tables using java code
Temporary tables (Oracle) and web based apps
Update Database with the better way
Creating Temp table and querying it
Creating a file by giving relative path