Subject Connection is unusable after an exception from an UDF (substr)
Author vmdd_tech
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