[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] Issue with Stored Procedure call
|
Just to clarify even further, it is using EXECUTE locally for me, but using
CALL on the client instance.
Locally
[5/13/09 10:58:03:218 CDT] 00000031 SystemOut O [EL Fine]: 2009-05-13
10:58:03.218--ServerSession(1404982206)--Connection(1482446940)--Thread(Thread[WebContainer
: 1,5,main])--EXECUTE spMSIRetrieve @paramBinarySession = ?,
@paramAgentNumber = ? , @paramAgentSubcode = ? , @paramInitials = ? ,
@paramUserID = ? , @paramLastName = ? , @paramFirstName = ? , @paramEmail =
? , @paramReturn = ?
bind => [110, => paramAgentNumber, => paramAgentSubcode, => paramInitials,
=> paramUserID, => paramLastName, => paramFirstName, => paramEmail, =>
paramReturn]
khaskett wrote:
>
> Actually I do see in the logs this error also -
> java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Incorrect
> syntax near 'CALL'
>
>
> khaskett wrote:
>>
>> I am getting this error when I try to make a stored procedure call -
>> [5/13/09 10:36:18:816 CDT] 00000048 SystemOut O [EL Fine]: 2009-05-13
>> 10:36:18.816--ServerSession(1293761639)--Connection(777115371)--Thread(Thread[WebContainer
>> : 2,5,main])--CALL spMSIRetrieve(paramBinarySession = ?, paramAgentNumber
>> = ?, paramAgentSubcode = ?, paramInitials = ?, paramUserID = ?,
>> paramLastName = ?, paramFirstName = ?, paramEmail = ?, paramReturn = ?)
>> bind => [10111010000011011000001010111, => paramAgentNumber, =>
>> paramAgentSubcode, => paramInitials, => paramUserID, => paramLastName, =>
>> paramFirstName, => paramEmail, => paramReturn]
>> [5/13/09 10:36:18:846 CDT] 00000048 SystemOut O [EL Fine]: 2009-05-13
>> 10:36:18.846--ServerSession(1293761639)--Thread(Thread[WebContainer :
>> 2,5,main])--VALUES(1)
>> [5/13/09 10:36:18:849 CDT] 00000048 SystemOut O [EL Info]: 2009-05-13
>> 10:36:18.849--UnitOfWork(2028275163)--Thread(Thread[WebContainer :
>> 2,5,main])--Communication failure detected when attempting to perform
>> read query outside of a transaction. Attempting to retry query.
>>
>> The weird thing about this is that it works fine for me locally but when
>> it is installed at the client that's when they are seeing these errors.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Issue-with-Stored-Procedure-call-tp23524438p23524870.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.