Holdability Error Using JDBC to Connect to SQL Server (Doc ID 2159698.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Documaker - Version 12.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.4 version, Documaker Studio

When tying to use the JDBC DB handler to connect to a Documaker library in SQL Server,  following error message is in the
trace file:

ERRORS
-----------------------
64. Mon Jul 11 10:14:30.573 2016 pid=00003680 JDBTestQuery: Running check query <SELECT * FROM DBO.TEST2_DEV_USER WHERE 1=2>.
65. Mon Jul 11 10:14:30.573 2016 pid=00003680 Entering _JSQLPrepare( 1, "SELECT * FROM DBO.TEST2_DEV_USER WHERE 1=2", -3)
66. Mon Jul 11 10:14:30.575 2016 pid=00003680 Error: (0) : "SQL Server supports holdability at the connection level only. Use the connection.setHoldability() method."
67. Mon Jul 11 10:14:30.575 2016 pid=00003680 _JSQLPrepare returns: -1
68. Mon Jul 11 10:14:30.575 2016 pid=00003680 Entering _JSQLError( 0, 0, 1, 001886D8, 00188EF4, 00188EF8, 1023, 0018930C)
69. Mon Jul 11 10:14:30.575 2016 pid=00003680 _JSQLError returns: 0 (" ", 0, "[JDB] ")
70. Mon Jul 11 10:14:30.575 2016 pid=00003680 0 [JDB]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms