Re: [eclipselink-users] Issue with Stored Procedure call

[khaskett <khaskett@xxxxxxxxxxx>]

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-tp23524438p23524650.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.