Mapping postgreSQL inetger[] data type to Grails

Question

In my postgreSQL DB i have a field with the data type int[] trying to mapp this to a Grails domain class column Integer[] the application fails to start:

org.hibernate.type.SerializationException: could not deserialize

Is there any other way to achieve this?

I also tried this: //insurance column: 'rs_insurance', sqlType: "integer[]"

score 0 · Answer 1 · answered Nov 23 '16 at 12:36

0

byte[] type is working out-of-box and is mapped to a respective BLOB-type.

If it's not fine with you, you can serialize your array upon saving and deserialize it upon loading:

void setValue( v ) {
  ByteArrayOutputStream baos = new ByteArrayOutputStream()
  baos.withObjectOutputStream{ it.writeObject v }
  blob = baos.toByteArray()
}

def getValue() {
  def out = null
  if( blob ) new ByteArrayInputStream( blob ).withObjectInputStream{ out = it.readObject() }
  out
}

answered Nov 23 '16 at 12:36

injecteer

20,038
4
45
89

Values from DB (57,58,59,60) were transformed into these values [123, 53, 55, 44, 53, 56, 44, 53, 57, 44, 54, 48, 125] ??? – Jacob Nov 23 '16 at 13:22
what did you do? what sql type is your column of? – injecteer Nov 23 '16 at 13:24
Column is type integer[] and value is {57,58,59,60} – Jacob Nov 23 '16 at 13:25
if you are lucky, this might work http://stackoverflow.com/questions/4332467/mapping-array-with-hibernate – injecteer Nov 23 '16 at 13:30
`interger[]` is a postgres artefact type and has no analogues in other SQL-dialects – injecteer Nov 23 '16 at 13:31
do you need this field outside the grails application? do you need to be able to search in it? – injecteer Nov 23 '16 at 13:33
I need the field as a member of a domain class inside the grails app. List compiles but the values are not there. – Jacob Nov 23 '16 at 13:33
then use serialization approach or create an SQL-custom type to map – injecteer Nov 23 '16 at 13:35

Mapping postgreSQL inetger[] data type to Grails

1 Answers1