[Postgres-xc-general] PG-XC tables (Distribute by Replication) not supported by Hibernate?

[Anson A. <ans...@gm...>]

So I migrated a pg database (9.1) to postgres-xc 1.1.  Required me to
essentially apply the Distribute By Replication to most of the tables.  But
doing so, apparently this app threw out an error:

Unable to upgrade schema to latest version.
org.hibernate.exception.GenericJDBCException: ResultSet not positioned
properly, perhaps you need to call next.
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:108)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
	at $Proxy10.getInt(Unknown Source)
	at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:212)
	at com.cloudera.enterprise.dbutil.DbUtil$1SchemaVersionWork.execute(DbUtil.java:159)
	at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54)
	at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1937)
	at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1934)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:211)
	at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1955)
	at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1941)
	at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:171)
	at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:333)
	at com.cloudera.cmon.FhDatabaseManager.initialize(FhDatabaseManager.java:68)
	at com.cloudera.cmon.firehose.Main.main(Main.java:339)
Caused by: org.postgresql.util.PSQLException: ResultSet not positioned
properly, perhaps you need to call next.
	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkResultSet(AbstractJdbc2ResultSet.java:2695)
	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:1992)
	at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:2547)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104)
	...


So I'm assuming hibernate does not support Distribute by Replication?
Is that so, or did I not need to apply distribute by replication,
though the table has a PK w/ is also reference as FK from another
table?  If not, is there a hack to get around this, w/o having to
recompile hibernate objects?