Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

different getBigDecimal behavior in WL7

0 views
Skip to first unread message

B Emsley

unread,
Jul 25, 2002, 3:39:17 PM7/25/02
to
In Weblogic 6.1, if we do a getBigDecimal against a prepared statement
of straight SQL done on a Java client, a 0 will be returned for values
that are null in the table. In version 7, this will give us a
NullPointerException.

What is different between these versions that would cause this? We
are using the JDriver in both cases.

Thanks in advance.

Bernie

Joseph Weinstein

unread,
Jul 25, 2002, 5:57:49 PM7/25/02
to B Emsley

B Emsley wrote:

Hi. Would you show me the code, and the full serverside stacktrace
of the NPE? The NPE is certainly a bug, and you should never get
a zero value when the DBMS contains a null. What DBMS and driver
are you using?
Joe


B Emsley

unread,
Jul 29, 2002, 7:44:55 AM7/29/02
to
Joe,

Thanks for your response.

Here's the stacktrace. I'm using Jbuilder (Java client) with a
QueryDataset against a Weblogic 7 datasource. Further down in the
stacktrace is a weblogic.jdbc.rmi.SerialResultSet.getBigDecimal error.
The datasource is a TX datasource against a pool that uses the
Oracle 8.1.7 thin drivers against an Oracle 8.1.7 database.

See com.borland.dx.dataset.DataSetException error code: BASE+47
com.borland.dx.dataset.DataSetException: Chain of 2 or more Exceptions
occurred
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.throwExceptionChain(Unknown
Source)
at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown
Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceDataModule.getGasContractCapacityGroupDataSet(EsGasContractMaintenanceDataModule.java:2242)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsContractCapacityActivityTabBean.refreshTab(EsContractCapacityActivityTabBean.java:153)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel.refreshCapacityActivity(EsGasContractMaintenanceTabbedPanel.java:621)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel.refreshCurrentTab(EsGasContractMaintenanceTabbedPanel.java:304)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel.cvContractTabbedPane_stateChanged(EsGasContractMaintenanceTabbedPanel.java:1023)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel$1.stateChanged(EsGasContractMaintenanceTabbedPanel.java:149)
at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)
at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown Source)
at javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown
Source)
at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown
Source)
at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)
at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)
at energysoftworx.common.guiutilities.EsJTabbedPaneBean.setSelectedIndex(EsJTabbedPaneBean.java:45)
at javax.swing.plaf.basic.BasicTabbedPaneUI$MouseHandler.mousePressed(Unknown
Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at energysoftworx.common.guiutilities.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:44)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Chained exception:
java.sql.SQLException: java.lang.NullPointerException
at weblogic.jdbc.rmi.SerialResultSet.getBigDecimal(SerialResultSet.java:253)
at com.borland.dx.sql.dataset.JdbcProvider.a(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown
Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceDataModule.getGasContractCapacityGroupDataSet(EsGasContractMaintenanceDataModule.java:2242)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsContractCapacityActivityTabBean.refreshTab(EsContractCapacityActivityTabBean.java:153)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel.refreshCapacityActivity(EsGasContractMaintenanceTabbedPanel.java:621)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel.refreshCurrentTab(EsGasContractMaintenanceTabbedPanel.java:304)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel.cvContractTabbedPane_stateChanged(EsGasContractMaintenanceTabbedPanel.java:1023)
at energysoftworx.gasworx.contract.gui.contractmaintenance.EsGasContractMaintenanceTabbedPanel$1.stateChanged(EsGasContractMaintenanceTabbedPanel.java:149)
at javax.swing.JTabbedPane.fireStateChanged(Unknown Source)
at javax.swing.JTabbedPane$ModelListener.stateChanged(Unknown Source)
at javax.swing.DefaultSingleSelectionModel.fireStateChanged(Unknown
Source)
at javax.swing.DefaultSingleSelectionModel.setSelectedIndex(Unknown
Source)
at javax.swing.JTabbedPane.setSelectedIndexImpl(Unknown Source)
at javax.swing.JTabbedPane.setSelectedIndex(Unknown Source)
at energysoftworx.common.guiutilities.EsJTabbedPaneBean.setSelectedIndex(EsJTabbedPaneBean.java:45)
at javax.swing.plaf.basic.BasicTabbedPaneUI$MouseHandler.mousePressed(Unknown
Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at energysoftworx.common.guiutilities.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:44)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)


Joseph Weinstein <j...@bea.com> wrote in message news:<3D40745C...@bea.com>...

B Emsley

unread,
Jul 31, 2002, 8:50:48 AM7/31/02
to
Can anybody respond to this? Thanks.


b_em...@hotmail.com (B Emsley) wrote in message news:<7d143cc9.02072...@posting.google.com>...

0 new messages