Hi Jonathan,
The correct syntax to call a stored procedure with JDBC is: {call
proc_name(params)}
You are missing the braces.
The wrong fetch size might come from an unexpected code path when trying
to reroute the stored procedure call.
Keep us posted with your progress,
Emmanuel
Hello All,
Trying to figure out what would be the cause of this error I get at
Jboss Startup.
2008-03-11 01:51:27,394 DEBUG
[org.jboss.mq.il.uil2.UILClientILService] Starting
2008-03-11 01:51:27,400 DEBUG
[org.jboss.mq.referenceable.SpyDestinationObjectFactory]
SpyDestinationObjectFactory->getObjectInstance()
2008-03-11 01:51:28,485 ERROR [STDERR] java.sql.SQLException: Invalid
fetch size value: -2147483648
Without pasting the contents of the jboss server log (I think many
people would hate me)
2.3M /usr/local/jboss//log/server.log
I’m trying to figure out if this is something native to sequoia that’s
not allowing some of the code to operate in the same manner as it did
before with a mysql-ds.xml configuration. I’m either seeing a clash of
technologies within jboss itself (with spring, hibernate, etc) to
sequoia, or this is a general configuration issue which can be fixed.
I’m also seeing some store procedures not working which is really
peculiar.
My controller has two virtual databases, with one backend enabled for
each database. (DB1)
I’ve enabled backend DB1 on both virtual databases and then started up
jboss.
I’m able to do a few things on the web application layer, like login,
and click on a few links, however I’m seeing some stored procedures
failing
07:55:07,412 INFO
virtualdatabase.VirtualDatabaseWorkerThread.iasipaiddb
CallableStatement.executeQuery() did not detect a stored procedure
(call
database.user_getObjectByDate(?,?);/<!%S|[EMAIL PROTECTED]|!%><!%S|2008-03-11
05:53:29|!%>) remapping the call to Statement.executeQuery()
I’m seeing some other weirdness stating tables don’t exist which I’m
trying to figure out again if it’s configuration errors, or that the
queries themselves are trying to insert across two different databases
on one connection (Very Bad).
Just thought I would ask the list if they’ve seen this sort of
behavior before, and perhaps suggestions to fix it up.
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
