Unable To Add Data Controls To Task Flow In Spaces (Doc ID 1577943.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle WebCenter Portal - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Data Control query with bind variables (executed against MS Sql Server or other data sources) fails with errors.

Following error is reported in Spaces logs:

 

Changes

- Start Managed Server with a JBO java property (jbo.SQLBuilder, with the value DB2 or SQLServer and jbo.TypeMapEntries="JAVA") to allow connection to a non-Oracle data source (MS SQL Server or DB2). Details documented in "Oracle® Fusion Middleware User's Guide for Oracle WebCenter Portal: Spaces" under the section "Prerequisites When Using a DB2 or SQL Server Database"

- Create a new Data Control to query from a data source.

Oracle WebCenter Portal Spaces
  => Administration (direct access URL http://..../webcenter/spaces/admin)
  => Resources
  => Data Controls
  => Create a new Data Control. Create a new JDBC connection or use an existing one. SQL Statement (query) must include a bind variable and connects to any data source (MS SQL Server, DB2, Oracle etc.).

Example:

  SELECT convert(varchar(30), companyName) companyName FROM
  Company WHERE companyId = (:CID)

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