database explorer + postgresql = exception

It seems that DatabaseMetaData.supportsBatchUpdates() method is not

implemented correctly in the PostgreSQL JDBC driver.

Is it possible to use Database Explorer when this exception is thrown or

does the exception freeze the rest of the functionality?

Thanks,

Radko

flacco wrote:

>

> Attempting to connect to a PostgreSQL database through database explorer

> causes an exception. Too lazy to create an account - but here you go :-)

>

> Netbeans 3.4beta2

> JDBC Driver is jdbc7.1-1.2.jar

> postgresql server version 7.1.3-2 on Red Hat Linux 7.2

>

>

> *********** Exception occurred ************ at Wed Jul 17 07:10:39 EDT 2002

> java.lang.AbstractMethodError:

> org.postgresql.jdbc1.DatabaseMetaData.supportsBatchUpdates()Z

>at

> org.netbeans.lib.ddl.adaptors.DefaultAdaptor.supportsBatchUpdates(DefaultAdapto r.java:3859)

>

>at

> org.netbeans.modules.db.explorer.nodes.ConnectionNode.update(ConnectionNode.jav a:219)

>

>at

> org.netbeans.modules.db.explorer.nodes.ConnectionNode.access$100(ConnectionNode .java:42)

>

>at

> org.netbeans.modules.db.explorer.nodes.ConnectionNode$1.propertyChange(Connecti onNode.java:62)

>

>at

> java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java: 252)

>

>at

> org.netbeans.modules.db.explorer.infos.DatabaseNodeInfo.setConnection(DatabaseN odeInfo.java:459)

>

>at

> org.netbeans.modules.db.explorer.infos.ConnectionNodeInfo.connect(ConnectionNod eInfo.java:88)

>

>at

> org.netbeans.modules.db.explorer.infos.ConnectionNodeInfo.connect(ConnectionNod eInfo.java:106)

>

>at

> org.netbeans.modules.db.explorer.infos.RootNodeInfo.addConnection(RootNodeInfo. java:95)

>

>at

> org.netbeans.modules.db.explorer.actions.ConnectUsingDriverAction$1.actionPerfo rmed(ConnectUsingDriverAction.java:75)

>

>at

> org.netbeans.core.NbPresenter$ButtonListener.actionPerformed(NbPresenter.java:9 33)

>

>at

> javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1767)

>at

> javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.j ava:1820)

>

>at

> javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419)

>

>at

> javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)

>at

> javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.ja va:258)

>

>at java.awt.Component.processMouseEvent(Component.java:5021)

>at java.awt.Component.processEvent(Component.java:4818)

>at java.awt.Container.processEvent(Container.java:1380)

>at java.awt.Component.dispatchEventImpl(Component.java:3526)

>at java.awt.Container.dispatchEventImpl(Container.java:1437)

>at java.awt.Component.dispatchEvent(Component.java:3367)

>at

> java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3214)

>at

> java.awt.LightweightDispatcher.processMouseEvent(Container.java:2929)

>at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2859)

>at java.awt.Container.dispatchEventImpl(Container.java:1423)

>at java.awt.Window.dispatchEventImpl(Window.java:1566)

>at java.awt.Component.dispatchEvent(Component.java:3367)

>at java.awt.EventQueue.dispatchEvent(EventQueue.java:445)

> [catch] at

> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java: 190)

>

>at

> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:14 4)

>

>at

> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:13 4)

>

>at java.awt.Dialog.show(Dialog.java:524)

>at org.netbeans.core.NbPresenter.superShow(NbPresenter.java:680)

>at org.netbeans.core.NbPresenter.run(NbPresenter.java:713)

>at org.openide.util.Mutex$1.run(Mutex.java:931)

>at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:171)

>at java.awt.EventQueue.dispatchEvent(EventQueue.java:443)

>at

> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java: 190)

>

>at

> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:14 4)

>

>at

> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

>at

> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130)

>at java.awt.EventDispatchThread.run(EventDispatchThread.java:98)

> Serializable class java.util.TreeSet does not declare serialVersionUID

> field. Encountered while storing:

> [org.openide.util.SharedClassObject$WriteReplace,

> org.apache.tools.ant.module.loader.AntProjectDataLoader,

> org.openide.loaders.UniFileLoader, org.openide.loaders.MultiFileLoader,

> org.openide.loaders.DataLoader, org.openide.util.SharedClassObject,

> java.lang.Integer, java.lang.Number, org.openide.loaders.ExtensionList]

> See also http://www.netbeans.org/issues/show_bug.cgi?id=19915

>

>

Najman,Radko at 2007-7-2 23:27:00 >

Radko Najman wrote:

> It seems that DatabaseMetaData.supportsBatchUpdates() method is not

> implemented correctly in the PostgreSQL JDBC driver.

>

> Is it possible to use Database Explorer when this exception is thrown or

> does the exception freeze the rest of the functionality?

The connection exists, but there are no objects (tables etc) in its tree.

It does work with the newer driver, though

flacco at 2007-7-2 23:27:00 >