Alex Little

Having ‘fun’ this morning trying to figure out another little bug which I need to get fixed to get the chat history working properly on our MSG servers running on *nix. The problem is related to the case sensitivity of table names… we have the table (in MySQL) ‘jiveProperty’ and when I try to select from this table (using the given camel case tablename) from my java class in my servlet, I get the error that table ‘jiveproperty’ doesn’t exist (note the case).

However if I run the same code from a jsp it works fine… so it appears to me that something is turning the table name in my java class from camel case to all lower case, but this isn’t happening for my jsp pages – which are running from the same servlet container, so should be using the same mysql connector classes and settings.

any ideas???

Update (7/11)… problem turned out to be that when we overwrote the compiled classes in the servlet container and restarted tomcat, the tomcat work directory was still using the old version of the class. So before starting tomcat again we needed to clear out the work directory to make sure the new class was being used.