John DeSoi wrote:
> The client must issue a command to commit or rollback the transaction.
>
> In your example, are you sending all of the SQL lines (including the
> COMMIT) as a single execution? It sounds like the interface stops
> executing as soon as an error is reached. So perhaps change your code to
> execute the COMMIT separately after all the other commands have executed.
Logs would also help.
--
21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------