domains handling problem

From: Віталій Тимчишин <tivv00(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: domains handling problem
Date: 2011-02-22 09:53:18
Message-ID: AANLkTikj-D2+u=YMfPbcBcV+7tphtkwMeDjJTSTqfYnT@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello.

Today I've got next exception on postgresql 9.0-801 jdbc4 driver:
Caused by: org.postgresql.util.PSQLException: Unsupported Types value: 2,001
at
org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1745)
at
org.postgresql.jdbc3.AbstractJdbc3Statement.setObject(AbstractJdbc3Statement.java:1483)
at
org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:47)
at
org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:69)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1751)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:163)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:163)
at
org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:356)
at
org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:216)
at
org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:144)
at
org.springframework.jdbc.core.simple.AbstractJdbcInsert.setParameterValues(AbstractJdbcInsert.java:611)
at
org.springframework.jdbc.core.simple.AbstractJdbcInsert.access$1(AbstractJdbcInsert.java:602)
at
org.springframework.jdbc.core.simple.AbstractJdbcInsert$1.createPreparedStatement(AbstractJdbcInsert.java:439)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:580)

After looking a little deeper I've foudn out that driver report domain type
as Types.DISTINCT, but does not accept it in setObject call. And spring
library uses metadata to fill default SQL types to be sent to driver. I did
a workaround by hard-wiring Types.OTHER, but I suppose this to be driver bug
as driver should accept any sql type it provides from metadata.

--
Best regards,
Vitalii Tymchyshyn

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Maurin, Marion 2011-02-22 13:40:02 Re: PGXAConnection and autocommit problem
Previous Message Achilleas Mantzios 2011-02-22 08:17:27 Re: PGXAConnection and autocommit problem