Hi,

I am getting inconsistent results with MySQL when accessing it from
application code.

Sometimes things work fine, at other times I get this error
---
java.sql.SQLException: Communication link failure: java.io.IOException
---

I rigged the following page to display the error if it gets one, if
there are no errors it will have a drop down list with values retrived
from the DB.
http://www.realestatemarket.ca/forward.do?next=prejoin

I am not having probs with MySQL when using the contolpanel's phpAdmin interface, so I am assuming it is a JDBC/resin issue.

I think it would be helpful if I can have a way to get the error log
generated by resin or at least the standerout log...any ideas?

Thanks.

Later,
Tamer

I guess you might be right EXiL3.

I used to use  struts as a DB connection pool manager(among other things), and on my dev env this was working fine, now in a shared env this lead to an inconsistant situation.

So I reworked my data access logic to work independent of struts, ie getting the services directly from the VM, and now its stable.

The intresting thing is that struts, in theory should not be giving me those types of probs.

Anyway this workaround seems to be working for the time being. I will have to wait until privateVMs are available here to be able to truly codcute a post-mort on that.

Thanks for your input..
Tamer