PickLists, DataRow, calcFields errors and solutions(from XXXX@XXXXX.COM )


2005-08-17 05:08:09 PM
jbuilder20
Ok, about NullPointException when locale is set for Croatian,
Slovenian,Czech, I think German too, or probably any other language from
central europe. It seems that not only Picklists don't
work but, whenever I use lookup and locate method which are normaly used
with datarow and Calcfields I get the same error, even more, I'll post at
the end of the message everything. But there is a way around this. It is
sure(I don't know is it only me) that locale alone produces all these
errors, but when i set sort(in Jbuilder not order by in SQL) on column that
is used with datarow(linking column in source Dataset), calcfields, picklist
everything works fine. So what is it, does it have something to do with the
"place" of the DataSet.setlocale(); in code, because I know from my
experience that if your DataSet.setColumns(); is before you set columns
properties(scale, precision, caption,width...) your caption in jdbtable will
be wrong, and will be right only for first column....and that is jbuilder's
autogenerated code, so you have to go in editor and change it by
yourself...but who would think of something like that to change the place of
autogenerated code. I mean it's not hard to do it, and it's nothing wrong
with code it it's just where is placed...so I found myself looking for what
I did wrong I can't find anything, ...code just needs to be moved from 25 to
let's say 89 line...I just want to say if something is dependant to another
it should be written in right order.... I am glad that i found solution now
things will be much easier and there will be no doubling of object, one with
locale set and other without....
Ok here are error codes
For picklists
"java.lang.NullPointerException
at com.borland.dx.memorystore.k.a(Unknown Source)
at com.borland.dx.memorystore.i.c(Unknown Source)
at com.borland.dx.memorystore.i.f(Unknown Source)
at com.borland.dx.memorystore.i.locate(Unknown Source)
at com.borland.dx.dataset.DataIndex.locate(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.lookup(Unknown Source)
at
trgovina.UkalkulacijaDM.prethodniUnosiUkalkulacijaT(UkalkulacijaDM.java:655)
at trgovina.UkalkulacijaDM.column14_changed(UkalkulacijaDM.java:727)
at
trgovina.UkalkulacijaDM_column14_columnChangeAdapter.changed(UkalkulacijaDM.java:767)
at com.borland.dx.dataset.Column.a(Unknown Source)
at com.borland.dx.dataset.RowVariant.b(Unknown Source)
at com.borland.dx.dataset.DataSet.b(Unknown Source)
at com.borland.dx.dataset.ReadWriteRow.setVariant(Unknown Source)
at com.borland.dx.dataset.DataSet.setDisplayVariant(Unknown Source)
at com.borland.dbswing.DBTableModel.setValueAt(DBTableModel.java:388)
at javax.swing.JTable.setValueAt(JTable.java:1875)
at javax.swing.JTable.editingStopped(JTable.java:3333)
at
com.borland.dbswing.TableMaskCellEditor.fireEditingStopped(TableMaskCellEditor.java:468)
at
com.borland.dbswing.TableMaskCellEditor.actionPerformed(TableMaskCellEditor.java:437)
at javax.swing.JTextField.fireActionPerformed(JTextField.java:487)
at javax.swing.JTextField.postActionEvent(JTextField.java:668)
at javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:783)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1571)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2763)
at javax.swing.JComponent.processKeyBindings(JComponent.java:2798)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2726)
at
com.borland.dbswing.TableMaskCellEditor.processKeyEvent(TableMaskCellEditor.java:627)
at java.awt.Component.processEvent(Component.java:5265)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at
java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1810)
at
java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:672)
at
java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:920)
at
java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:798)
at
java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:636)
at java.awt.Component.dispatchEventImpl(Component.java:3841)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)"
For CalcFields
See com.borland.dx.dataset.DataSetException error code: BASE+62
com.borland.dx.dataset.DataSetException: Execution of query failed.
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.queryFailed(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.a(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.g.d(Unknown Source)
at com.borland.dx.dataset.g.<init>(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2775)
at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2759)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at javax.swing.JRootPane.addNotify(JRootPane.java:680)
at java.awt.Container.addNotify(Container.java:2500)
at java.awt.Window.addNotify(Window.java:466)
at java.awt.Frame.addNotify(Frame.java:501)
at java.awt.Window.show(Window.java:513)
at java.awt.Component.show(Component.java:1300)
at java.awt.Component.setVisible(Component.java:1253)
at trgovina.Application1.<init>(Application1.java:36)
at trgovina.Application1$1.run(Application1.java:55)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Chained exception:
"java.lang.NullPointerException
at com.borland.dx.memorystore.k.a(Unknown Source)
at com.borland.dx.memorystore.i.c(Unknown Source)
at com.borland.dx.memorystore.i.e(Unknown Source)
at com.borland.dx.memorystore.i.locate(Unknown Source)
at com.borland.dx.dataset.DataIndex.locate(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.lookup(Unknown Source)
at
trgovina.UkalkulacijaDM.UkalkulacijatQDS_calcFields(UkalkulacijaDM.java:549)
at
trgovina.UkalkulacijaDM_UkalkulacijatQDS_calcFieldsAdapter.calcFields(UkalkulacijaDM.java:803)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.loadRow(Unknown Source)
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.g.d(Unknown Source)
at com.borland.dx.dataset.g.<init>(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2775)
at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2759)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at javax.swing.JRootPane.addNotify(JRootPane.java:680)
at java.awt.Container.addNotify(Container.java:2500)
at java.awt.Window.addNotify(Window.java:466)
at java.awt.Frame.addNotify(Frame.java:501)
at java.awt.Window.show(Window.java:513)
at java.awt.Component.show(Component.java:1300)
at java.awt.Component.setVisible(Component.java:1253)
at trgovina.Application1.<init>(Application1.java:36)
at trgovina.Application1$1.run(Application1.java:55)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
java.lang.NullPointerException
at com.borland.dx.memorystore.k.a(Unknown Source)
at com.borland.dx.memorystore.i.c(Unknown Source)
at com.borland.dx.memorystore.i.e(Unknown Source)
at com.borland.dx.memorystore.i.locate(Unknown Source)
at com.borland.dx.dataset.DataIndex.locate(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.lookup(Unknown Source)
at
trgovina.UkalkulacijaDM.UkalkulacijatQDS_calcFields(UkalkulacijaDM.java:549)
at
trgovina.UkalkulacijaDM_UkalkulacijatQDS_calcFieldsAdapter.calcFields(UkalkulacijaDM.java:803)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.loadRow(Unknown Source)
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.g.d(Unknown Source)
at com.borland.dx.dataset.g.<init>(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at com.borland.dbswing.JdbTable.bindDataSet(JdbTable.java:2775)
at com.borland.dbswing.JdbTable.addNotify(JdbTable.java:2759)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at java.awt.Container.addNotify(Container.java:2500)
at javax.swing.JComponent.addNotify(JComponent.java:4469)
at javax.swing.JRootPane.addNotify(JRootPane.java:680)
at java.awt.Container.addNotify(Container.java:2500)
at java.awt.Window.addNotify(Window.java:466)
at java.awt.Frame.addNotify(Frame.java:501)
at java.awt.Window.show(Window.java:513)
at java.awt.Component.show(Component.java:1300)
at java.awt.Component.setVisible(Component.java:1253)
at trgovina.Application1.<init>(Application1.java:36)
at trgovina.Application1$1.run(Application1.java:55)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)"
As I said all that is gone when sort is set to source DatSet linking
column....any comments...help..., i really don't need that sort but they
don't hurt;)...bye...