Re: MySQL chyba s tomcat 5.5.7 a proxool 0.9

Sun, 23 Sep 2007 12:30:23 -0700

to som predpokladal, len mne nie je jasne ako je mozne ze vsetky tabulky mam v zdrojakoch velkymi pismenami a padaju len niektore (asi 20%), phpMyadmin-om vytvorene tabulky su vsetko malymi, mozem Vas poprosit, kde sa to da vypnut ? 

Citát Rastislav Rehak <[EMAIL PROTECTED]>:


Mysql beziaca na linuxe pri MyISAM tabulkach ma nazov tabulky CASE
SENSITIVE ( da so to vypnut  ).

[EMAIL PROTECTED]  wrote / napísal(a):

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





--
Rastislav Rehák
EEA communication solutions
Hattalova 12, 831 03 Bratislava, Slovakia

tel/fax: +421 2 4445 3690
mobile: +421 918 619 891
icq:466031223 http://www.eea.sk


























					Odpovedet emailem