| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| IBM WBI adapter for JDBC + special Oracle datatypes |
« View previous topic :: View next topic » |
| Author |
Message
|
| 4integration |
 Posted: Wed Jan 17, 2007 11:30 pm Post subject: IBM WBI adapter for JDBC + special Oracle datatypes |
 |
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Hello,
We want to use the IBM WBI Adapter for JDBC with two systems that have interface tables, both running Oracle 10g Enterprise Edition 10.2.0.2.0
The interface tables uses Oracle specific data types such as:
- NVARCHAR2
- NCHAR
- NCLOB
- TIMESTAMP WITH LOCAL TIME ZONE
There is problems of generating business objects for such tables because of limited support in the adapter/ODA.
- Have you experienced this problem?
- Have you any good solution for it?
_________________
Best regards
4 Integration |
|
| Back to top |
|
 |
| 4integration |
| Posted: Sun Jan 28, 2007 11:14 pm Post subject: |
|
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Hi,
The issues with NVARCHAR2, NCHAR have been solved. It was the ODA that couldn't resolve those fields but it's manageable to add them by hand afterwards.
For the data type TIMESTAMP WITH LOCAL TIME ZONE we have not got any success, so far at least.
The Oracle driver requires you to set the time zone on the connection, before running any SELECT statement, e.g.
| Code: |
| ((OracleConnection)conn).setSessionTimeZone(TimeZone.getDefault().getID()); |
Anyone having a good solution for this, using the IBM WBI Adapter for JDBC??
_________________
Best regards
4 Integration |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
