pro_jsp thread: jdbc:odbc bridge ...
Hi evryone.
I have a problem, and I'm not sure what is the solution.
I tried the Ch. 7 example of Employee database using mySQL as suggested
from the author, and it worked fine. THen I tried it with MS SQL Server
as database, and I can access the tables, it seems to be working but after
about 30 seconds I get a server crash. The error message says that a
reference to a memory location cannot be read!
Now, I've noticed that if I delete code that closed the conneciton (i.e.
myConn.close(), or stmt.close()), I don't have that problem.
I wonder if this has to do with the java garbage collection. Or it could
be related to MS SQL Server.
Help with this will be much appreciated.
THank you!
Don