aspose file tools*
The moose likes JDBC and the fly likes MySQL prepareCall hangs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL prepareCall hangs" Watch "MySQL prepareCall hangs" New topic
Author

MySQL prepareCall hangs

steve claflin
Ranch Hand

Joined: Dec 04, 2008
Posts: 54
I'm trying to prepare a CallableStatement for MySQL, and the prepareCall method hangs (using MySQL 5.0.21 and the 5.1.7 connector). If the call syntax isn't valid, it throws an exception to that effect. Also, I happened to find out that if I misspell the procedure name, it also throws an exception. But, if the call syntax is valid, as in {CALL MyProc(?, ?)} it just hangs. A web search turns up stuff that appears to have been resolved long ago, so presumably there is something else going on here. ( Other JDBC to the same database works, so I know I have a valid connection. )

Any ideas?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MySQL prepareCall hangs