9.1 JDBC 4 driver - Mailing list pgsql-jdbc
From | Prasanth Reddy |
---|---|
Subject | 9.1 JDBC 4 driver |
Date | |
Msg-id | 4F98494F.6090508@nqadmin.com Whole thread Raw |
Responses |
Re: 9.1 JDBC 4 driver
|
List | pgsql-jdbc |
Hi, We have been using 8.4 jdbc3 driver. Recently we have upgraded it to 9.1-901 JDBC 4 jar. I am getting an error message (org.postgresql.util.PSQLException:Bad value for type int : 2618079772) while updating some columns. The column I am updating is a date column and I am using updateDate function of the rowset. Did somegoogle search and found a really old post (http://archives.postgresql.org/pgsql-jdbc/2007-03/msg00029.php) that talked about oid being returned as Integer and causingthis problem when the oid is too big. Below I am including the stack trace. I have reverted to 8.4 jdbc3 driver and the same code works fine. So is this a bug in jdbc4? Thanks, Prasanth org.postgresql.util.PSQLException: Bad value for type int : 2618079772 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2731) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:1983) at org.postgresql.jdbc2.AbstractJdbc2ResultSetMetaData.fetchFieldMetaData(AbstractJdbc2ResultSetMetaData.java:242) at org.postgresql.jdbc2.AbstractJdbc2ResultSetMetaData.getBaseColumnName(AbstractJdbc2ResultSetMetaData.java:179) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.updateValue(AbstractJdbc2ResultSet.java:2924) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.updateDate(AbstractJdbc2ResultSet.java:1097) at com.sun.rowset.JdbcRowSetImpl.updateDate(JdbcRowSetImpl.java:2489) at com.sun.rowset.JdbcRowSetImpl.updateDate(JdbcRowSetImpl.java:2869) at com.nqadmin.swingSet.datasources.SSJdbcRowSetImpl.updateDate(SSJdbcRowSetImpl.java:697) at com.nqadmin.swingSet.formatting.SSFormattedTextField.updateRowSet(SSFormattedTextField.java:893) at com.nqadmin.swingSet.formatting.SSFormattedTextField.updateFieldValue(SSFormattedTextField.java:822) at com.nqadmin.swingSet.formatting.SSFormattedTextField.access$0(SSFormattedTextField.java:793) at com.nqadmin.swingSet.formatting.SSFormattedTextField$internalVerifier.verify(SSFormattedTextField.java:751) at javax.swing.InputVerifier.shouldYieldFocus(InputVerifier.java:132) at javax.swing.JComponent$1.acceptRequestFocus(JComponent.java:3589) at java.awt.Component.isRequestFocusAccepted(Component.java:7728) at java.awt.Component.requestFocusHelper(Component.java:7610) at java.awt.Component.requestFocusHelper(Component.java:7603) at java.awt.Component.requestFocus(Component.java:7411) at javax.swing.JComponent.requestFocus(JComponent.java:1476) at javax.swing.text.DefaultCaret.adjustFocus(DefaultCaret.java:530) at javax.swing.text.DefaultCaret.adjustCaretAndFocus(DefaultCaret.java:503) at javax.swing.text.DefaultCaret.mousePressed(DefaultCaret.java:492) at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:280) at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:279) at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:279) at java.awt.Component.processMouseEvent(Component.java:6502) at javax.swing.JComponent.processMouseEvent(JComponent.java:3321) at java.awt.Component.processEvent(Component.java:6270) at java.awt.Container.processEvent(Container.java:2229) at java.awt.Component.dispatchEventImpl(Component.java:4861) at java.awt.Container.dispatchEventImpl(Container.java:2287) at java.awt.Component.dispatchEvent(Component.java:4687) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4489) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422) at java.awt.Container.dispatchEventImpl(Container.java:2273) at java.awt.Window.dispatchEventImpl(Window.java:2713) at java.awt.Component.dispatchEvent(Component.java:4687) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707) at java.awt.EventQueue.access$000(EventQueue.java:101) at java.awt.EventQueue$3.run(EventQueue.java:666) at java.awt.EventQueue$3.run(EventQueue.java:664) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76) at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87) at java.awt.EventQueue$4.run(EventQueue.java:680) at java.awt.EventQueue$4.run(EventQueue.java:678) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:677) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105) at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
pgsql-jdbc by date: