Subject Re: [Firebird-Java] Exception that I don't understand
Author Rodolfo M. Raya
Hi David,

I get the connection in one method and try to use the data and close
the connection in two other methods.

I will try to unify everithing in one servlet. Thanks for the tip.

Rodolfo

David Jencks wrote:

>Are you holding a connection over method boundaries? That is unlikely to
>work. I would be surprised at a synchronization error if each connection
>is obtained and closed within a method. If you use the internal pooling
>this should not be a performance problem.
>
>david jencks
>
>On 2002.04.09 18:14:35 -0400 Rodolfo M. Raya wrote:
>
>>Hi,
>>
>>Can anybody tell me what this means please? the first time I run my query
>>there's no problem. I'm trying to query some data from a .jsp application
>>with no look.
>>
>>TIA,
>>
>>Rodolfo
>>
>>java.sql.SQLException: fetch problem: org.firebirdsql.gds.GDSException:
>>request synchronization error
>> at org.firebirdsql.jdbc.FBResultSet$FBCachedFetcher.(FBResultSet.java:2569)
>> at org.firebirdsql.jdbc.FBResultSet.(FBResultSet.java:124)
>> at org.firebirdsql.jdbc.FBStatement.getCachedResultSet(FBStatement.java:539)
>> at org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:102)
>>
MAXPROGRAMS
IBM Business Partner
Microsoft MSDN Business Connection Partner
rmraya@...
http://www.maxprograms.com