PK85909: Load data wizard fails if a Timestamp field is used

Rational Application Developer for WebSphere Software, Version 7.0.0.9

APAR status

• Closed as program error.

Error description

• Using Rational Software Architect V7.0.0.7
  From the perspective 'data' when trying to use the function 'loa
  d data' in an Oracle V10 or V11 Tables the data loading wizard f
  ails with exception
  java.sql.SQLException: ORA-01400: cannot insert NULL into ('SCOT
  T'.'PERSON'.'PERSON_TIMESTAMP')
  
  This is defective behavior associated with loading the data type
   of Timestamp.
  
  Steps to reproduce:
  a) Create applicable table with timestamp column.
  b) Right select applicable table -? Data-? Load -? and locate ap
  plicable data input file which includes timestamp values for inp
  ut.
  c) data Output view will produce the data loading failed and exc
  eption detailed above.
  
  The log file will also show:
  !ENTRY org.eclipse.wst.rdb.data.ui 4 0 2009-03-23 13:19:19.282
  !MESSAGE Cannot format given Object as a Date
  !STACK 0
  java.lang.IllegalArgumentException: Cannot format given Object a
  s a Date
  at com.ibm.icu.text.DateFormat.format(DateFormat.java:400)
  at java.text.Format.format(Format.java:147)
  at org.eclipse.wst.rdb.data.internal.core.common.data.DataSerial
  izer.serialize(DataSerializer.java:85)
  at org.eclipse.wst.rdb.data.internal.core.common.DefaultColumnDa
  taAccessor.serialize(DefaultColumnDataAccessor.java:157)
  at org.eclipse.wst.rdb.data.internal.core.common.DefaultColumnDa
  taAccessor.getLabel(DefaultColumnDataAccessor.java:151)
  at org.eclipse.wst.rdb.data.internal.ui.editor.TableDataLabelPro
  vider.getColumnText(TableDataLabelProvider.java:45)
  at org.eclipse.jface.viewers.TableViewer.doUpdateItem(TableViewe
  r.java:486)
  at org.eclipse.jface.viewers.StructuredViewer$UpdateItemSafeRunn
  able.run(StructuredViewer.java:465)
  at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
  at org.eclipse.core.runtime.Platform.run(Platform.java:843)
  at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
  at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:149
  )
  at org.eclipse.jface.viewers.StructuredViewer.updateItem(Structu
  redViewer.java:1955)
  at org.eclipse.jface.viewers.TableViewer.createItem(TableViewer.
  java:350)
  

Local fix

Problem summary

• This was a problem related to Data-?Extract functionality
  from DataSourceExplorer.
  The value for Timestamp column of a table was not fetched.
  

Problem conclusion

• The problem is rectified by  fetching the column value from
  resultset as a timestamp.
  Fix delivered in Rational Application Developer v7.0.0.9
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RATL APP DEV WI

• Fixed component ID

  5724J1901

Applicable component levels

• R700 PSN

     UP