Issues

Select view

Select search mode

 

Oracle - Select query with nclob field, returns java object instead of string

Fixed

Description

SELECT [nclobfield] FROM table

cfoutput queryname.nclobfield[1] or cfdump queryname
returns java object - class oracle.sql.NCLOB

cfoutput queryname.nclobfield[1].stringValue()
returns string

Lucee should cast this object to a string!

Environment

All

Attachments

2

Details

Assignee

Reporter

Priority

Fix versions

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 27 June 2016 at 08:28
Updated 29 June 2016 at 16:18
Resolved 29 June 2016 at 16:18

Activity

Show:

Michael Offner29 June 2016 at 16:17

we added also a testcase for this

Michael Offner29 June 2016 at 05:46

problem is that this class is not extending java.sql.Clob. we will make sure this classes are handled correctly, this includes:

  • NCLOB

  • CLOB

  • BLOB

  • NBLOB

Flag notifications