How can I store a Huge String in my Domain Class?

Question

I'm making a web application in Grails, and I have this domain Class

String name
String query

static mapping = {        
    query type: "text"}

but when I bring the query from another query in Oracle, It returns a really huge String and I get this Error:

ORA-01461: can bind a LONG value only for insert into a LONG column

From the database that i get the information, the fiels is varchar(63760)

Any idea? thanks

score 0 · Answer 1 · edited May 23 '17 at 12:05

0

Try adding this to your mapping: sqlType: 'clob'. So you would have the following:

String name
String query

static mapping = {        
    query type: "text", sqlType: "clob"
}

Also, see this SO question.

edited May 23 '17 at 12:05

Community

answered Mar 13 '14 at 18:35

grantmcconnaughey

I tried it, and type:'materialized_clob', and query(nullable: true, maxSize: 64000), and I read the other question, but I'm still getting stucked – Pablo Glez Mar 13 '14 at 19:12
I tried it again but I still having this error: ORA-12899 – Pablo Glez Mar 19 '14 at 15:58

score 0 · Answer 2 · answered Mar 14 '14 at 08:18

0

Grails allows to set maximum size which gets converted to mySQL size, so you can try this if it works in Oracle.

class Class {
String name;
String query;

static constraints = {
    query(maxSize: 2048000)
}

static mapping = {
    query type: "text"
}}

answered Mar 14 '14 at 08:18

Sn.

I tried it but I still having this error: ORA-12899 – Pablo Glez Mar 19 '14 at 15:57

2 Answers2