MySQL chyba s tomcat 5.5.7 a proxool 0.9

Sun, 23 Sep 2007 12:00:42 -0700 

ahojte,
tazko povedat ci toto patri do inheo fora, ale urcite to podla mna je velmi zvlasna MySql chyba. Niektore selecty pri pouzi tomcat 5.5.7 a proxool 0.9 davaju nasledovnu chybu (tabulka existuje), nestretli ste nahodou s niecim podobnym: 


Base table or view not found message from server: "Table  
'testsk.T_COMPANY_CATEGORY' doesn't exist"
java.sql.SQLException: Base table or view not found message from  
server: "Table 'testsk.T_COMPANY_CATEGORY' doesn't exist"

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
        at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2248)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2196)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1163)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at  
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at  
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)
        at 
org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:59)
        at $Proxy2.executeQuery(Unknown Source)

zdrojak je nasledovny:

con = DBConnection.getConnection();
        st = con.createStatement();

        String query = "select "+
          "id,"+
          "parent_id,"+
          "name,"+
          "small_name,"+
          "tree,"+
          "image_file,"+
          "icon"+
          " from t_company_category where preview = true order by id asc";

        rs = st.executeQuery(DBConnection.guard(query));

ine selecty funguju bez problemov.

vdaka

Ivan























					Odpovedet emailem