Subject | Connection is unusable after an exception from an UDF (substr) |
---|---|
Author | vmdd_tech |
Post date | 2003-12-31T12:03:20Z |
create table test (news varchar (255));
insert into test (news) values
('this is
looooooooooooooooooooooooonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
nnnnnnnnnnnnnnnnnnnnnnnger than 80 characters');
select substr(news,1,2) from test;
==>
java.lang.NullPointerException
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare
(GDS_Impl.java:1152)
at org.firebirdsql.jca.FBManagedConnection.prepareSQL
(FBManagedConnection.java:767)
at org.firebirdsql.jdbc.FBConnection.prepareSQL
(FBConnection.java:1110)
at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement
(FBStatement.java:998)
at org.firebirdsql.jdbc.FBStatement.internalExecute
(FBStatement.java:986
)
at org.firebirdsql.jdbc.FBStatement.execute
(FBStatement.java:518)
...
Then, executing any new sql (e.g., select count(*) from sometable)
will result the same new trace as above.
Ben
PS:
Firebird 1.5, RC 6
insert into test (news) values
('this is
looooooooooooooooooooooooonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
nnnnnnnnnnnnnnnnnnnnnnnger than 80 characters');
select substr(news,1,2) from test;
==>
java.lang.NullPointerException
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare
(GDS_Impl.java:1152)
at org.firebirdsql.jca.FBManagedConnection.prepareSQL
(FBManagedConnection.java:767)
at org.firebirdsql.jdbc.FBConnection.prepareSQL
(FBConnection.java:1110)
at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement
(FBStatement.java:998)
at org.firebirdsql.jdbc.FBStatement.internalExecute
(FBStatement.java:986
)
at org.firebirdsql.jdbc.FBStatement.execute
(FBStatement.java:518)
...
Then, executing any new sql (e.g., select count(*) from sometable)
will result the same new trace as above.
Ben
PS:
Firebird 1.5, RC 6