[SOLVED] What's the bib deal of uuid with postgres/jdbc?

eantoranz · 03-15-2012, 06:08 PM

I'm facing a problem when trying to retrieve an entity with ebeans from a postgresql db. The ID field has type UUID and so I get an error like this:

Code:

Query threw SQLException:ERROR: operator does not exist: d_uuid = character varying
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 78 
Bind values:[xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx] 
Query was:
select t0.exam as c0, t0.description as c1 
from exam t0
where t0.exam = ?

Thanks for your help

eantoranz · 03-16-2012, 08:23 AM

Well, ebean 2.7.4 solved it. I was using 2.7.0.

eantoranz · 03-20-2012, 12:34 PM

Ok... ebean 2.7.4 didn't solve it. I was able to work normally on friday and all of the sudden the problem started happening again. There's a possible quick hack you can do to solve it (at least, for PgSQL... it's up to you, no warranties) with ebean on source.

Declare a method like this on com.avaje.ebeaninternal.server.type.ScalarTypeUUID.java (it will override ScalarTypeBaseVarchar.bind(DataBind, T)):

Code:

public void bind(DataBind b, UUID value) throws SQLException { 
	if (value == null){
		b.setNull(Types.VARCHAR);
	} else {
		b.setObject(value);
	}
}

Works for me (at least, so far).

eantoranz · 03-20-2012, 12:58 PM

Not completely right. Hope this works for you.

Code:

public void bind(DataBind b, UUID value) throws SQLException { 
	if (value == null){
		b.setNull(Types.JAVA_OBJECT);
	} else {
		b.setObject(value);
	}
}

public boolean isJdbcNative() {
	return true;
}

public int getJdbcType() {
	return Types.JAVA_OBJECT;
}