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