dekacode
Posts: 53
|
Posted: 08/10/2004, 4:45 PM |
|
A class is called that Creates and populates a temporary table. The followong error is sometimes displayed
java.sql.SQLException: General error, message from server: "Table 'tmpschedgrid' doesn't exist"
It seems that this is related to connections and threads as the CCS page will, on occasion, display correctly
Does anyone have experience with this?
ENV.
CCS 2.3.1.85
MySQL 4.0.20
Tomcat 4.1.30
|
|
|
Anton Hinxman
|
Posted: 12/08/2004, 2:24 AM |
|
Do you get the feeling that this is a problem of the request submit and response method to www page handling?
Request fetches www JSP page and creates table
Connection is used and put back into the pool
User POST response occurs later when table may not now exist?
Temp table needs to exist for the life of the users session so perhaps a session based object to create table will solve the problem?
Regards
Anton
|
|
|
|