| Author |
Message
|
| pcoffey |
 Posted: Mon Feb 20, 2006 4:38 am Post subject: Oracle timestamp fractions of seconds |
 |
|
Apprentice
Joined: 03 Feb 2006
Posts: 33
|
Hi,
Using ESQL, I'm performing an insert into a table which contains timestamp columns (default 6 precision). I can see from the user trace that the timestamps prior to insertion contain fractions of seconds. However, on querying the database after the insert (using SQL Tools query editor), the fractional seconds are zero. I have verified that the database table and SQL Tools is not the issue as I can insert and query fractional seconds directly.
Is the broker performing some rounding on the timestamps?
Thanks in advance for any tips,
Pauline |
|
| Back to top |
|
 |
| Ian |
| Posted: Mon Feb 20, 2006 6:12 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
1. What version and level of Message Broker are you using ?
2. What version of Oracle are you using ?
_________________
Regards, Ian |
|
| Back to top |
|
|
| pcoffey |
| Posted: Mon Feb 20, 2006 6:17 am Post subject: |
|
|
Apprentice
Joined: 03 Feb 2006
Posts: 33
|
| Sorry, I'm on MB V5 CSD06 and Oracle 10g. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Feb 20, 2006 6:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| pcoffey wrote: |
| Sorry, I'm on MB V5 CSD06 and Oracle 10g. |
We're kinda sorry too.
This is not a supported configuration, except on Linux with certain fixpacks.
Are you running on Linux?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| pcoffey |
| Posted: Mon Feb 20, 2006 6:28 am Post subject: |
|
|
Apprentice
Joined: 03 Feb 2006
Posts: 33
|
Ah-ha... no, I'm on Windows and, eventually, AIX.
ok - back to the drawing board - may be time to move to 6.
Thanks for the prompt response. |
|
| Back to top |
|
|
| Ian |
| Posted: Mon Feb 20, 2006 6:35 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Yes, Jeff is correct in that on WBIMB v5 Oracle 10g is (currently) only supported on Linux with interim fix LCR016 which ships the DataDirect 5.0 driver which in turn provides support for Oracle 10g.
_________________
Regards, Ian |
|
| Back to top |
|
|
| pcoffey |
| Posted: Mon Feb 20, 2006 7:01 am Post subject: |
|
|
Apprentice
Joined: 03 Feb 2006
Posts: 33
|
Thanks Ian. You say 'currently' - is it anticipated that it will be supported in V5 or should we bite the bullet and move to 6? The Oracle upgrade is forced upon us by a third party application.
Pauline |
|
| Back to top |
|
|
| Ian |
| Posted: Fri Feb 24, 2006 6:31 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Hi Pauline,
This is still in life cycle testing but as you can see from the WebSphere Message Broker Planned Maintenance Release Dates the next FP release is no time soon.
If you require support for Oracle 10g then you have two choices, move to WMB v6 or move your v5 Broker to Linux (as the key to Oracle 10g support is the DataDirect 5.0 Oracle drivers).
_________________
Regards, Ian |
|
| Back to top |
|
|
|
|
