Last updated on FEBRUARY 23, 2015
Applies to:Oracle WebCenter Portal - Version 184.108.40.206.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://..../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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms