| From: | Takeichi Kanzaki Cabrera <tkanzakic(at)gmail(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: reading an oidvector field error |
| Date: | 2006-01-17 15:57:32 |
| Message-ID: | 651aa54b0601170757p318edf87ka854f586c4a64bd0@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I solve the problem by getting the field as a String and implementing
a simple parser for the result.
All the ways I test the choice of cast the field as a int8[] and get
this exception:
java.sql.SQLException: ERROR: cannot cast type oidvector to bigint[]
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1482)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1267)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
at pgObjects.PgServer.executeQuery(PgServer.java:372)
at pgObjects.PgDatabase.loadFunctionsFromDatabase(PgDatabase.java:864)
at test.Test.showFunctions(Test.java:134)
at test.Test.main(Test.java:166)
Thanks a lot for all of you,
Takeichi.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sarvjot Kaur | 2006-01-18 05:30:02 | Need help in installing postgresql 8.1.2 on Windows |
| Previous Message | Prasanth | 2006-01-17 15:51:30 | Re: getDate after call to updateDate |