aspose file tools*
The moose likes JDBC and the fly likes PROCEDURE x does not exist... 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 "PROCEDURE x does not exist..." Watch "PROCEDURE x does not exist..." New topic
Author

PROCEDURE x does not exist...

Doug Slattery
Ranch Hand

Joined: Sep 15, 2007
Posts: 294
Aloha ranchers,

Got a tomcat 5.5 -> mysql 5.045 -> fedora 8 problem. I'm porting a webapp from a windows tomcat -> mssql configuration to fedora. The jndi resource is happy as well as access priveleges to the database. The problem is when a stored procedure is called, an exception is thrown:
HandleError: java.sql.SQLException PROCEDURE WBR1080 does not exist.

The access code is something like this:

where connection.prepareCall returns a java.sql.Connection. This has been working for ages on the windows side, so I doubt it's the problem. I suspect it may have something to do with the WEBLIB.WBR1080 part.

I do have a stored procedure called WBR1080 created in mysql and can see it using SHOW CREATE PROCEDURE WBR1080.

Anyone have any ideas?

Aloha,
Doug

-- Nothing is impossible if I'mPossible
Doug Slattery
Ranch Hand

Joined: Sep 15, 2007
Posts: 294
Ok, I figured it out. It was related to the WEBLIB.WBR1080 part. It turns out in mysql, WEBLIB is a database, whereas on the as400 (where production is) WEBLIB is a user, and on mssql WEBLIB is totally ignored afaik...

After I created the WEBLIB db and plopped in the sp, *voila* everything was happy (especially me) .

Aloha,
Doug

-- Nothing is impossible if I'mPossible
[ February 29, 2008: Message edited by: Doug Slattery ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PROCEDURE x does not exist...