Records saved twice

My application is an Internet Application and is running in the
following environment:
- SQL Server 2000 Standard Edition EN
- Windows Server 2003
- Tomcat 5.0
- DB Connection Pooling of Tomcat
- JDBC - Driver

If i create f.e. a group on the UserInterface the problem is
a) Either the record is saved twice without an error message
b) Or an error message says the record is already there and cannot be
saved
(So its likely the record is saved twice) but is effectively saved
once

Its very funny that with the same application build on another computer
with the same environment and on a computer with environment SQL Server
Personal Edition DE and Windows 2000 the Problem doesnt occure.
Its also funny that it happens only with a few tables in the SQL
Server.

Does anyone know the problem, that SQL Transactions are committed twice
in association with DB Connection Pooling of Tomcat?

Thank you for an idea.

.

Relevant Pages

  • RE: Records saved twice
    ... | - DB Connection Pooling of Tomcat ... | a) Either the record is saved twice without an error message ... | with the same environment and on a computer with environment SQL Server ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Recordset.AddNew and the recordset objects data retaining
    ... I am in an environment where bulk insert isn't an option--even though the ... underlying database is SQL server, I am using a third party OLE DB provider-- ... > insert(assuming you are using SQL server) or DTS. ...
    (microsoft.public.data.ado)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.sqlserver.server)
  • curious problem in production
    ... I am getting an exception from sql server being ... When I run the same code on the my development machine into the SAME ... if it fails in calling the production environment. ... RPC:Completed declare @P1 bigint ...
    (microsoft.public.sqlserver.programming)
Loading