Hi all,

I´m using IDM 3.6.1 with SLES11 64bits and trying to use JDBC Driver
with a MSSQL database, using sqljdbc instead of jtds (with jtds the
problem as the same).

When the SQL statement return an error, the driver enter in a “retry”
mode and the driver enters in a looping trying and trying the same SQL
command.

I´m using something like this: 'Cool Solutions: Calling Stored
Procedures with the IDM JDBC Driver'
(http://www.novell.com/coolsolutions/feature/19969.html), but the driver
enters in retry mode before I can get the return. The log:

Code:
--------------------

[06/16/10 17:50:23.487]:IDV2PDC ST: Execute spIncluir_UsuSistUnidNeg_IAM 123456789, 22, 261, 50, 1234
[06/16/10 17:50:23.490]:IDV2PDC ST: Closed statement 4dc4e792.
[06/16/10 17:50:23.491]:IDV2PDC ST: BEGIN Test for bad connection.
[06/16/10 17:50:23.492]:IDV2PDC ST: END Test for bad connection.
[06/16/10 17:50:23.492]:IDV2PDC ST: Connection is bad.
[06/16/10 17:50:23.492]:IDV2PDC ST: BEGIN rollback.
[06/16/10 17:50:23.493]:IDV2PDC ST: ROLLBACK
[06/16/10 17:50:23.493]:IDV2PDC ST: Unable to rollback transaction.
[06/16/10 17:50:23.493]:IDV2PDC ST: Number of statements allocated on connection 'dedicated0': 0.
[06/16/10 17:50:23.494]:IDV2PDC ST: SubscriptionShim.execute() returned:
[06/16/10 17:50:23.494]:IDV2PDC ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20090520_1228" instance="IDV2PDC" version="3.5.4">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status event-id="0" level="retry" type="app-connection">
<description>An error occurred executing statement "Execute spIncluir_UsuSistUnidNeg_IAM 123456789, 22, 261, 50, 1234". There is a connectivity-related problem.</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="295" jdbc:sql-state="22007">
<jdbc:message>Conversion failed when converting character string to smalldatetime data type.</jdbc:message>
</jdbc:exception>
</status>
</output>
</nds>
[06/16/10 17:50:23.496]:IDV2PDC ST: No input transformation policies.
[06/16/10 17:50:23.496]:IDV2PDC ST: Applying schema mapping policies to input.
[06/16/10 17:50:23.497]:IDV2PDC ST: Applying policy: %+C%14CSchema+Mapping+Rule%-C.
[06/16/10 17:50:23.497]:IDV2PDC ST: Resolving association references.
[06/16/10 17:50:23.498]:IDV2PDC ST: Requesting 30 second retry delay.
[06/16/10 17:50:23.498]:IDV2PDC ST: Processing returned document.
[06/16/10 17:50:23.499]:IDV2PDC ST: Processing operation <status> for .
[06/16/10 17:50:23.499]:IDV2PDC ST:
DirXML Log Event -------------------
Driver: \IDV-FIRJAN\FIRJAN\SERVICOS\DriverSet\IDV2PDC
Channel: Subscriber
Status: Retry
Message: Code(-9006) The driver returned a "retry" status indicating that the operation should be retried later. Detail from driver: <description>An error occurred executing statement "Execute spIncluir_UsuSistUnidNeg_IAM 123456789, 22, 261, 50, 1234". There is a connectivity-related problem.</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="295" jdbc:sql-state="22007" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>Conversion failed when converting character string to smalldatetime data type.</jdbc:message>
</jdbc:exception>
[06/16/10 17:50:23.501]:IDV2PDC ST: Direct command from policy result
[06/16/10 17:50:23.501]:IDV2PDC ST:
<nds dtdversion="3.5" ndsversion="8.x">
<source>
<product version="3.6.10.4747">DirXML</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="retry">Code(-9006) The driver returned a "retry" status indicating that the operation should be retried later. Detail from driver: &lt;description>An error occurred executing statement "Execute spIncluir_UsuSistUnidNeg_IAM 123456789, 22, 261, 50, 1234". There is a connectivity-related problem.&lt;/description>
&lt;jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="295" jdbc:sql-state="22007" xmlns:jdbc="urn:dirxml:jdbc">
&lt;jdbc:message>Conversion failed when converting character string to smalldatetime data type.&lt;/jdbc:message>
&lt;/jdbc:exception><application>DirXML</application>
<module>IDV2PDC</module>
<object-dn></object-dn>
<component>Subscriber</component>
</status>
</output>
</nds>
[06/16/10 17:50:23.506]:IDV2PDC ST:
DirXML Log Event -------------------
Driver: \IDV-FIRJAN\FIRJAN\SERVICOS\DriverSet\IDV2PDC
Channel: Subscriber
Status: Retry
Message: Code(-9006) The driver returned a "retry" status indicating that the operation should be retried later. Detail from driver: Code(-9006) The driver returned a "retry" status indicating that the operation should be retried later. Detail from driver: &lt;description>An error occurred executing statement "Execute spIncluir_UsuSistUnidNeg_IAM 123456789, 22, 261, 50, 1234". There is a connectivity-related problem.&lt;/description>
&lt;jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="295" jdbc:sql-state="22007" xmlns:jdbc="urn:dirxml:jdbc">
&lt;jdbc:message>Conversion failed when converting character string to smalldatetime data type.&lt;/jdbc:message>
&lt;/jdbc:exception><application>DirXML</application>
<module>IDV2PDC</module>
<object-dn></object-dn>
<component>Subscriber</component>

--------------------



In connection with Oracle Database, if the command return a error, I
can get it and notify (driver doesn´t enter in this retry mode). Is it
possible to do the same with MSSQL?

Thanks,
Alexandre


--
agorian
------------------------------------------------------------------------
agorian's Profile: http://forums.novell.com/member.php?userid=53023
View this thread: http://forums.novell.com/showthread.php?t=413424