WCC 12.2.1.4 StandAlone IdcComand Fails With Weblogic.jdbc.sqlserver.SQLServerDriver Error OR This driver is locked for use with embedded applications.. (Doc ID 2664880.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When attempting to run an idccommand for batchload, the following error occurs.

ERROR:
DEBUG: Trying to load weblogic/jdbc/sqlserver/SQLServerDriver.class from ORACLE_HOME/wccontent/ucm/idc/components/MetadataSet/classes-MetadataSet.jar...
DEBUG: weblogic.jdbc.sqlserver.SQLServerDriver not found.
DEBUG: using parent classloader to load weblogic.jdbc.sqlserver.SQLServerDriver
Apr 01, 2020 11:33:42 AM org.eclipse.persistence.session.868469776354100.ejb
SEVERE:
Local Exception Stack:
Exception [EclipseLink-4003] (Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56): org.eclipse.persistence.exceptions.DatabaseException
Exception Description: Configuration error. Class [weblogic.jdbc.sqlserver.SQLServerDriver] not found.
at org.eclipse.persistence.exceptions.DatabaseException.configurationErrorClassNotFound(DatabaseException.java:89)

OR

Error executing service CHECKIN_NEW. Error: Unable to initialize standalone. Possible database connection failure encountered. Error message: (!csDbFailedToGetTableList,!$[FMWGEN][SQLServer JDBC Driver]This driver is locked for use with embedded applications.). java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]This driver is locked for use with embedded applications..
localized: null 

The issue can be reproduced at will with the following steps:
1. DOMAINHOME\bin\setDomainEnv.cmd
2. cd DOMAINHOME\ucm\cs\bin\BatchLoading\20200331Ext
3. DOMAINHOME\ucm\cs\bin\IdcCommand -f batchfile.txt -u sysadmin -l BatchLoad.log -c standalone

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.