No column output in JDBC Query activity in TIBCO Businessworks 6.x for the columns defined as JRE 7 datatypes e.g. nvarchar.

No column output in JDBC Query activity in TIBCO Businessworks 6.x for the columns defined as JRE 7 datatypes e.g. nvarchar.

book

Article ID: KB0093186

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
Support for JRE 7 datatypes in TIBCO Businessworks 6.x.
Symptoms:
No column returned in JDBC Query activity.
Cause:

The following data types are not supported in BW 6.


1). NChar: SQL Server, Oracle.
2). NVarchar: SQL Server, Oracle.
3). NClob: Oracle.
4). SQLXML: DB2, SQL Server.

Issue/Introduction

No column output in JDBC Query activity in TIBCO Businessworks 6.x for the columns defined as JRE 7 datatypes e.g. nvarchar.

Resolution

There is an enhancement request (AMBW-13697) logged for adding support for JRE 7 datatypes.

Additional Information