Posted Tuesday, February 3, 2009 @ 09:46:35
Hi,
i'm using version 2.0.5.28 with source and jdbc oracle (latest)
on the version 11 jdbc from oracle, i had to use timestamp.
when i moved column and requery, i have an error when i had moved a Timestamp column.
there's no error when i move another column type.
there's an error in the DbTableModel on fetch function:
if( rMap[j-1] != null )
rowVector.addElement( rMap[j-1].getObject(tableResultSet, j));
else if ( isTimeStamp[j-1] )
rowVector.addElement( tableResultSet.getTimestamp(j));
else
rowVector.addElement(tableResultSet.getObject(j));
when i repalce with
if( rMap[j-1] != null )
rowVector.addElement( rMap[j-1].getObject(tableResultSet, j));
else
rowVector.addElement(tableResultSet.getObject(j));
it's working.
the error is:
Skipping recreating columns. To refresh column properties everytime, use 'DBTable.useOldColumnProperties(boolean val)', if needed.
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Unknown Source)
at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:486)
at oracle.jdbc.driver.T4CVarcharAccessor.getTimestamp(T4CVarcharAccessor.java:897)
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:1060)
at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:211)
at quick.dbtable.DBTableModel.fetch(DBTableModel.java:2524)
What can i do ?
can i remove the getTimestamp and replace with getObject (it's working !)
thank in advance and have a nice day