File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes MySQL prepareCall hangs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySQL prepareCall hangs" Watch "MySQL prepareCall hangs" New topic

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?
I agree. Here's the link:
subject: MySQL prepareCall hangs
It's not a secret anymore!