Some servlets software I developed as the backend for a web-site has been working just fine for 8 months or so using JDBC against a mySQL database. There's about 12,000 lines of Java in total and some non-trivial SQL which I won't go into here, but suffice it to say, it was all fully tested and has been in production for a while, the software has not changed. The site is now experiencing some 'peculiar' behavior and my hosts (superb.net) don't seem to have a clue what they're doing. The problem can be characterized as follows :-
Insert, update etc all appear to work just fine, however, select statements return empty result sets and no SQL exception even where I know data to exist (and verify this using phpMyAdmin).
The ISP run Apache/Tomcat on a Unix platform.
Any ideas ?
Is there a free mySQL support forum ('cos I can't find it) ?
Can anyone make a suggestion as to what the hosts have done to screw things up because I don't know enough about mySQL and Java on a web-server to make a judgement ?
Insert, update etc all appear to work just fine, however, select statements return empty result sets and no SQL exception even where I know data to exist (and verify this using phpMyAdmin).
The ISP run Apache/Tomcat on a Unix platform.
Any ideas ?
Is there a free mySQL support forum ('cos I can't find it) ?
Can anyone make a suggestion as to what the hosts have done to screw things up because I don't know enough about mySQL and Java on a web-server to make a judgement ?
Comment