Unable To Add Data Controls To Task Flow In Spaces
(Doc ID 1577943.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle WebCenter Portal - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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:
- Start Managed Server with a JBO java property (
jbo.SQLBuilder, with the value
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://<HOST>:<PORT>/webcenter/spaces/admin)
=> 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.).
SELECT convert(varchar(30), companyName) companyName FROM Company WHERE companyId = (:CID)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document