Hi guys

I have a store procedure that receive 4 parameters. When I send a
inexisting user id i receive this msg. When the ID exist everything
works fine. See my log bellow

[03/19/12 15:09:30.538]:IDV2PDC ST: CALLING
PreparedStatement.setString(int, String)
[03/19/12 15:09:30.538]:IDV2PDC ST: WITH PARAM 1:
2
[03/19/12 15:09:30.538]:IDV2PDC ST: WITH PARAM 2:
'22'
[03/19/12 15:09:30.538]:IDV2PDC ST: CALLED
[03/19/12 15:09:30.539]:IDV2PDC ST: IN @ index 3,
param '@si_sq_grupo', field '$3', length: 5, value = '29217'
[03/19/12 15:09:30.539]:IDV2PDC ST: CALLING
PreparedStatement.setString(int, String)
[03/19/12 15:09:30.539]:IDV2PDC ST: WITH PARAM 1:
3
[03/19/12 15:09:30.539]:IDV2PDC ST: WITH PARAM 2:
'29217'
[03/19/12 15:09:30.539]:IDV2PDC ST: CALLED
[03/19/12 15:09:30.540]:IDV2PDC ST: IN @ index 4,
param '@ti_nr_hierarq_UsuarioSistema', field '$4', length: 2, va
lue = '50'
[03/19/12 15:09:30.540]:IDV2PDC ST: CALLING
PreparedStatement.setString(int, String)
[03/19/12 15:09:30.540]:IDV2PDC ST: WITH PARAM 1:
4
[03/19/12 15:09:30.540]:IDV2PDC ST: WITH PARAM 2:
'50'
[03/19/12 15:09:30.541]:IDV2PDC ST: CALLED
[03/19/12 15:09:30.541]:IDV2PDC ST: END Set IN,
Register OUT parameter(s).
[03/19/12 15:09:30.541]:IDV2PDC ST: BEGIN Execute
procedure.
[03/19/12 15:09:30.541]:IDV2PDC ST: CALLING
CallableStatement.execute()
[03/19/12 15:09:30.545]:IDV2PDC ST: BEGIN Test for
bad connection.
[03/19/12 15:09:30.547]:IDV2PDC ST: END Test for
bad connection.
[03/19/12 15:09:30.547]:IDV2PDC ST: Connection is
bad.
[03/19/12 15:09:30.547]:IDV2PDC ST: CALLING
Statement.close()
[03/19/12 15:09:30.548]:IDV2PDC ST: CALLED
[03/19/12 15:09:30.549]:IDV2PDC ST: Closed
statement SQLServerCallableStatement:109.
[03/19/12 15:09:30.549]:IDV2PDC ST: BEGIN rollback.
[03/19/12 15:09:30.549]:IDV2PDC ST: ROLLBACK
[03/19/12 15:09:30.549]:IDV2PDC ST: CALLING
Connection.rollback()
[03/19/12 15:09:30.550]:IDV2PDC ST: Unable to
rollback transaction.
[03/19/12 15:09:30.550]:IDV2PDC ST:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot invoke a
rollback operati
on when the AutoCommit mode is set to "true".
[03/19/12 15:09:30.551]:IDV2PDC ST: Number of
statements allocated on connection 'dedicated0': 0.
[03/19/12 15:09:30.551]:IDV2PDC ST:
SubscriptionShim.execute() returned:
[03/19/12 15:09:30.552]:IDV2PDC ST:

How can i handle this?


--
mfpc
------------------------------------------------------------------------
mfpc's Profile: http://forums.novell.com/member.php?userid=124726
View this thread: http://forums.novell.com/showthread.php?t=453631