Subject Re: [Firebird-Java] drop table not works , with create/insert and drop table , single connection
Author Roman Rokytskyy
> Dear Members ,

> I face some issue when executing dropping tables
> along with create/insert/ in single connection.
> .
> Before let me group the steps I have did
> Group one :
> Create Table say 'Employer'
> Create Table say 'Employee' having FK with
> Employer
> commit the transaction;

> Group two:
> insert entries in to Table Employer &

Close the statement object.

> Employee
> commit the transaction;

> Group three :
> drop table Employer;
> drop table Employee;
> commit the transaction;

Your INSERT statement is compiled and is kept on the server until you
disconnect. Ensure that the statement object is closed (when you use
connection pool you have to be sure that statement caching is switched off).