Adapter updating DataTypes

, ,
1

Hi everybody,

maybe this question has been asked before, but I could not find an answer to it.

We’re running some JDBC-Adapter-Services (Select-Template) with about 200 columns. Some of the existing columns map from ColumnType “DATE” to JDBC-Type “TIMESTAMP” and to OutputFieldType “java.sql.Timestamp”.

Now the database tables have been extended with some new columns. On pressing the “Insert Row”-Button at the SELECT-tab of the Adapter-Service
ALL corresponding rows are updated to ColumnType “DATE” to JDBC-Type “Date” and to OutputFieldType “java.sql.Date”, what leeds to the often described problem of missing time information. OutputFieldType now can only be set to “java.sql.Date”, “java.util.Date” or “java.util.String”.

How do I prevent JDBC-Adapter to update the DataTypes?

Thanks in advance for any help…

Kind regards,
Max.

Configuration:
OS AIX 5.2
webMethods 6.1
writeTD(“rowdata-l”); WmJDBCAdapter Version 6.0.3.1
JDBC-Driver: classes12.zip
JVM: IBM 1.4.2.20 (SR3)
Fixes: None

or (with same effect)
Windows XP Professional
webMethods 6.1
writeTD(“rowdata-l”); WmJDBCAdapter Version 6.0.3.1
JDBC-Driver: ojdbc14.zip
JVM: SUN 1.4.2 (48.0)
Fixes: JDBC_6-0-3_FP1_Fix12

2

Hi,
For the columns you know that the DBColumnType “DATE” has the TimeStamp in it, manually change in your adapter service the JDBC-Type to “TIMESTAMP” and the OutputFieldType to “java.util.String”. You will get Timestamp from DB as string.

HTH,
Bhawesh.