webMethods JDBC Adapter 6.5 DATE format is different from JDBC Adapter 9.0.

Dear all

IS server upgrade from 8.0 to 9.9 and the JDBC driver from 6.5 to 9.0; Now I select data from DB and get the different date fromat to cause program failed.

Different Date data format in JDBC Adapter 6.5 and 9.0.

JDBC Adapter 6.5
Date format: YYYY-MM-DD HH:mm:ss.S

JDBC Adapter 9.0
Date format: YYYY-MM-DD HH:mm:ss

And I try to modify the JDBC config file at \instances\default\packages\WmJDBCAdapter\config\ ORACLETypeMapping.xml.

Change:
Under columnTypeMapping section in ORACLETypeMapping.xml change the line given below

to

and restart IS server but still failed. The possible reason is the JDBC version cause the exception.

Anyone meet this exception before and could give me some advice!

Thanks very much!

Mandy

See if this the below IS extended settings help:

watt.adapter.JDBC.DateWithTimestamp
watt.adapter.JDBC.DateWithTimestampAndMilliseconds

For more details refer JDBC adapter 9.0

I don’t set this porperty at IS extended and what values I should put for this porperty?And what 's the purpose of the porperty?

I have checked there also didn’t config the porperty at WM 8.0.

Thanks!

Mandy

Hi,

Please set it explicitly in the Extended Settings page as in your lower environment and test the changes.

watt.adapter.JDBC.DateWithTimestamp=true
watt.adapter.JDBC.DateWithTimestampAndMilliseconds= true

I believe this will fix the formatting issues.

As always please make sure what fix level you are on for JDBC Adapter 9.0.

HTH,
RMG

Hi

I have added this porpery at exteneded setting page and test the JDBC adapter but still failed. And the JDBC fix is JDBC_9.0_Fix8

And whether I need to restart IS server?

Have you any ieda?

Thanks very much!

Mandy

Hi,

Have you tried reloading the WmJDBCAdaptor package?

If that fails, your only option is to restart the IS.

Best Regards,

Hi

I tried to reloading the WmJDBCAdaptor package but still don’t work even though restart IS server.

Thanks!

Mandy

So even after adding the above props still doesn’t work you say?

HTH,
RMG

Contact SAG global support by raising SI on empower. Kindly update the results.

Can you share error details ?

Thanks,

Hi

Even after adding the above props still doesn’t work.

And there is no error message just get the difference date fromat compared with WM8.0.

Thanks!

Mandy

You did what necessary things we can do. Better reach SAG to hear some news.

Thanks,

Hello Deng,

Did you get updates from SAG ?

What was the solution for this issue. Please update it here. We are also having same issue. It would be great if any one who got solution for this can update.

Regards,
BS.

Hi,

This is from “webMethods JDBC Adapter 6.5 Fix 50 readme”

On “webMethods Adapter for JDBC Installation and User’s Guide Version 9.0”, p. 258:

Best Regards,

Hello All,

Thank you for the response and posts for this issue. Our issue is resolved. and below is the solution.

There is nothing to do with extended settings until unless you need some extra things. Seems to be it was a migration issue. Once you migrated to new env,we have to run the below service
wm.adapter.wmjdbc.admin:migrate_65_To_90
for the adapter service migration to get it effected properly if it missed at migration time.

Regards,
Bajikiran Sikhinam