Dave Angel
|
| Posted: 03/20/2002, 1:36 AM |
|
Has anyone had problem with CodeCharge when using Tomcat with an Access Database?
I have tried using the code generated by CodeCharge and the end result is that Tomcat will falls over or I get the error:-
Root cause:
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6160)
I have seen various threads within this forum that talk about this type of failure, some that blame the Sun JDBC driver, and some about the reliability of Access but I have yet to see a solution that works for me.
Can anyone help?
|
|
|
 |
Nicole
|
| Posted: 03/20/2002, 1:44 AM |
|
Dave,
it's a problem which appear sometimes when using Win2000 and ODBC-JDBC Bridge. To avoid it try to use JDBC drivers
|
|
|
|
Alan H
|
| Posted: 03/20/2002, 5:36 AM |
|
I experienced some problems running with Tomcat and Oracle on an Intel Solaris platform. The system would work most of the time then occasionally freeze up without any errors. I suspect the JDBC drivers as well since there was some improvement using Oracle's JDBC drivers. I also wonder whether there are any Tomcat parameter tweaks that affect this. If anyone has a clue, I would love to hear them since the Intel-Solaris/Oracle setup is very nice system.
|
|
|
|
icarrara@studio5.it
|
| Posted: 03/20/2002, 7:42 AM |
|
Dear Sir,
I got the same problem some days ago and I received form Yes Software the below workaround that resolve the problem.
That problem appears with ODBC connection to Access db only (using standard ODBC driver sun.jdbc.odbc.JdbcOdbcDriver). ODBC connection to other db should be OK.
The workaround is to remove or comment following lines in all generated files:
for(int i=0;i<ConnectionVector.size();i++)
((java.sql.Connection)ConnectionVector.elementAt(i)).close();
It works!
Sincerely, Ivano Carrara - Studio 5 Liguria srl - Italy
|
|
|
|
Dave Angel
|
| Posted: 03/20/2002, 11:41 PM |
|
Ivano
Thanks for the proposed workaround I have seen a similar fix on this site. I believe that this fix is more to do with WAP and on searching through my code I have not found any ConnectionVector code.
I am beginning to think that it could be the ODBC-JDBC Bridge like Nicole suggests. Can any body give me a name more suitable drivers?
What I still find strange is that none of my hand crafted code fails and this problem
seems unique to CodeCharge generated code.
|
|
|
|
Nigel Hill
|
| Posted: 03/21/2002, 12:52 AM |
|
I have experienced the same problems with JSP when running with Tomcat and Access
|
|
|
|
