Subject | Hang on CallableStatement |
---|---|
Author | robert_difalco |
Post date | 2003-03-25T20:48:10Z |
Any reason I should be getting a hang on CallableStatement? Seems if
I have a bug in my code, I should be getting some sort of sql
exception.
I prepareCall like so:
{call insertClassInfo(?,?,?,?)}
The stored procedure is:
CREATE PROCEDURE insertClassInfo( nId INTEGER,sClassname BLOB
SUB_TYPE 1,sStrategy BLOB SUB_TYPE 1,sCodebase BLOB SUB_TYPE 1 )
AS
BEGIN
INSERT
INTO ClassInfo(id,classname,strategy,codebase)
VALUES (:nId,:sClassname,:sStrategy,:sCodebase);
END
Here's the thread stack trace....
"Thread for test 'testNamedPersistent'" prio=5 tid=0x00037780
nid=0x26d8 runnable [7f000..7fc40]
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read
(SocketInputStream.java:129)
at org.firebirdsql.jgds.XdrInputStream.read
(XdrInputStream.java:153)
at org.firebirdsql.jgds.XdrInputStream.readInt
(XdrInputStream.java:116)
at org.firebirdsql.jgds.GDS_Impl.nextOperation
(GDS_Impl.java:1654)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2
(GDS_Impl.java:852)
- locked <04177810> (a
org.firebirdsql.jgds.isc_db_handle_impl)
at org.firebirdsql.jca.FBManagedConnection.executeStatement
(FBManagedConnection.java:782)
at org.firebirdsql.jdbc.FBConnection.executeStatement
(FBConnection.java:1072)
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute
(FBPreparedStatement.java:415)
at org.firebirdsql.jdbc.FBCallableStatement.execute
(FBCallableStatement.java:117)
at
com.tripwire.space.core.persistent.PersistenceStrategy.create
(PersistenceStrategy.java:174)
I have a bug in my code, I should be getting some sort of sql
exception.
I prepareCall like so:
{call insertClassInfo(?,?,?,?)}
The stored procedure is:
CREATE PROCEDURE insertClassInfo( nId INTEGER,sClassname BLOB
SUB_TYPE 1,sStrategy BLOB SUB_TYPE 1,sCodebase BLOB SUB_TYPE 1 )
AS
BEGIN
INSERT
INTO ClassInfo(id,classname,strategy,codebase)
VALUES (:nId,:sClassname,:sStrategy,:sCodebase);
END
Here's the thread stack trace....
"Thread for test 'testNamedPersistent'" prio=5 tid=0x00037780
nid=0x26d8 runnable [7f000..7fc40]
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read
(SocketInputStream.java:129)
at org.firebirdsql.jgds.XdrInputStream.read
(XdrInputStream.java:153)
at org.firebirdsql.jgds.XdrInputStream.readInt
(XdrInputStream.java:116)
at org.firebirdsql.jgds.GDS_Impl.nextOperation
(GDS_Impl.java:1654)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2
(GDS_Impl.java:852)
- locked <04177810> (a
org.firebirdsql.jgds.isc_db_handle_impl)
at org.firebirdsql.jca.FBManagedConnection.executeStatement
(FBManagedConnection.java:782)
at org.firebirdsql.jdbc.FBConnection.executeStatement
(FBConnection.java:1072)
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute
(FBPreparedStatement.java:415)
at org.firebirdsql.jdbc.FBCallableStatement.execute
(FBCallableStatement.java:117)
at
com.tripwire.space.core.persistent.PersistenceStrategy.create
(PersistenceStrategy.java:174)