Saving large strings to CLOBs

[u4ibm]

We are using CLOB field in an Oracle DB to save strings (through an SQLDataSource). We declare them on datasource as texts, as you don't offer a better option.
When saving strings over 4000 chars, we reach the limit of whats possible in a regular SQL statement, and can't save it.

Do we have any other option in order to declare and save it?

(Specifically, what we're saving is the viewState from the ListGrid)

Cheers,
Eyal.

[u4ibm]

we can`t use viewState properly without it,
anyone?

[KaiW]

We have exactly the same problem? Is there no solution to store strings with more than 4000 characters using SmartGWT?

[u4ibm]

I just wrote the server side myself.
Created a custom datasource which inherits from SQLDatasource.
On update and add, it creates an UPDATE\INSERT prepared statement, and bind a StringReader to the CLOB column (using the setCharacterStream(index, Reader, length), because some implementations do not implement the other methods)...

I wish there was native support for this datatype, it's not that complicated...

Good luck!

[Isomorphic]

When you declare a text field over 4000 chars, a CLOB is automatically used. No need for custom code.