description: when user PreparedStatement query ,The condition like this field='?' ,when ? exceed filed max length ,error ,Statement no problem => When we perform a query and the value of the condition exceeds the size of the database there is a column with loss of connection that run flush the connection to be able to use it again.
There are problems also when the value of the condition has special characters such as an accent, bar or point, if the last text size as value is the same size of the database column, an error occurs because the special character counts as two positions.

Example

CREATE TABLE test (
     id INTEGER NOT NULL,
     name varchar (10) NOT NULL
);

select * from test where name like '% 12345678912345678%'
select * from test where name like '% 123456789e%'
select * from test where name like '% 123456789.%'

environment: windows jdk 1.5 1.6 => Windows and Linux jdk 7 or 8

Version: Jaybird 2.2.11 [ 10751 ]

Version: Jaybird 2.2.10 [ 10723 ]

Version: Jaybird 2.2.9 [ 10691 ]

Version: Jaybird 2.2.8 [ 10664 ]

Version: Jaybird 2.2.7 [ 10660 ]

assignee: Roman Rokytskyy [ rrokytskyy ] => Mark Rotteveel [ avalanche1979 ]

priority: Critical [ 2 ] => Major [ 3 ]

status: Open [ 1 ] => Closed [ 6 ]

resolution: Incomplete [ 4 ]