RE: Records saved twice

Hello,

Have you tried looking at a profiler trace to narrow down where the issue
is occurring?

I would suggest looking at the statements that are coming across, i.e. do
you see the same statement executed twice? Is it on the same connection?
Can you correlate the time of the statements to what is going on in the
application? Etc.

Do you have any simple code that reproduces issue that you could post along
with the necessary table scripts?

Thanks,
Kamil

Kamil Sykora [MSFT]
Microsoft Developer Support - Webdata

This posting is provided "AS IS", with no warranties, and confers no
rights.

Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.
--------------------
| From: moka.badertscher@xxxxxxx
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Subject: Records saved twice
| Date: 10 Nov 2005 07:13:20 -0800
|
| 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.
|
|

.

Loading