This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: MySQL prepareCall hangs
 
Similar Threads
Does CallableStatement have to be closed?
Calling Oracle Function that returns %ROWTYPE
MySQL Syntax Exception
Problem Storing image file in MySQL
Jboss fails to detect Deadlocks