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?
-- Nothing is impossible if I'mPossible
Joined: Sep 15, 2007
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) .
-- Nothing is impossible if I'mPossible [ February 29, 2008: Message edited by: Doug Slattery ]