Error while creating tables and using them on the fly..

[Prafulla Girgaonkar]

Hi

We are using mysql 4.1.11 and jconnect 3.1.8.

A tomcat instance holds more than one instances of our application.

Following are the steps which fail intermittently

1. Create a temprary table using SQL. The table is temporary by nature. But it is created using "Create Table xxx...."
2. Import data using mysqlimport
3. Process data in temporary table using SQL.

First 2 steps go through fine. During 3rd step, we get an exceptions saying "temprary table does not exists"

The source code is capable of returning error status after every step mentioned above.

The stacktrace is

java.sql.SQLException: Table 'XXXX' doesn't exist

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)

at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)

at com.ideas.util.DbConn.executeQuery(Unknown Source)

at com.ideas.px.integration.DMControl.msDataMissingCheck(Unknown Source)




Has anybody experience such or similar problem?