Products Products
Support & Forums Support & Forums
Compliance Testing Compliance Testing
Labs & Sandboxes Labs & Sandboxes
Program Program
Co-Marketing Co-Marketing
Avaya Experience Platform Avaya Enterprise Cloud Avaya Client SDK Avaya Aura Platform See All Products Find Developer Resources

Avaya Experience Platform

Overview Interfaces Learning Support Options Compliance Testing

Avaya Enterprise Cloud

Overview Interfaces Learning Support Options Compliance Testing

Avaya Client SDK

Overview Programming Docs Developer Downloads Licensing Support & Testing

Avaya Aura Platform

Application Enablement Services Communication Manager Presence Services Snap-in Session Manager System Manager Session Border Controller
About DevConnect Support Submit Support Tickets Support Forums Other Support Options

About DevConnect Support

Support Options Support FAQs Supported Platforms and Interfaces

Submit Support Tickets

Procured System Support
For procurement issues or questions Remote Lab Support
For issues and questions related to DevConnect remote labs Membership & Program Support
For membership and program benefits questions General Support
For general issues not covered by the other support tickets

Support Forums

Avaya Client SDK AEServices DMCC APIs AEServices JTAPI AEServices Web Services Avaya Workspaces Avaya Experience Platform Orchestration Designer All Forums

Other Support Options

Product Notices Non-DevConnect Support Resources

Compliance Testing

About Compliance Testing Compliance Tested Solutions

About Compliance Testing

Compliance Testing Overview Avaya Interfaces Eligible For Testing Compliance Testing FAQs Compliance Testing Guide(s) (PDF)

Compliance Tested Solutions

DevConnect Marketplace Search Applications Notes

Labs & Sandboxes

Remote Labs Procurement Benefits

Remote Labs

Remote Labs Overview Avaya Aura Session Manager Avaya Aura AE Services & Communication Manager Self Services (Experience Portal) Avaya Proactive Outreach Manager Avaya Contact Center Elite

Procurement Benefits

About DevConnect Procurement Access/View Procurement Catalog Procurement FAQs DevConnect Procured System Support

Program

Program Overview Program Benefits Membership Options

Program Overview

DevConnect Membership Levels DevConnect Program Guide (PDF) DevConnect Program FAQs

Program Benefits

Membership Benefits DevConnect Procurement Co-marketing

Membership Options

Manage My Portfolio/Solutions Manage My Profile

Co-Marketing

Co-Marketing Benefits Relationship Benefits

Co-Marketing Benefits

Co-Marketing Overview Logos Marketplace Co-branded Collateral Select Product Program

Relationship Benefits

Social Media 8-and-Out Podcasts Sponsorships Advertising

Author Message
08/04/2015 11:39:39
Subject: Cannot get Date from Oracle TimeStamp
#1
chukiatdenkongpon
Joined: Nov 7, 2013
Messages: 97
Offline
Hi

I have problem that we could not get Date value from Oracle TimeStamp. But we got this oracle.sql.TIMESTAMP@826a5f instead.

How can get the correct Date from Timestamp value?

Please give us any suggestion.

Oracle 11g R2

Best Regards,
Chukiat D.
PM
08/04/2015 13:47:07
Subject: Re:Cannot get Date from Oracle TimeStamp
#2
NeilGoldsmith
Joined: Nov 6, 2013
Messages: 902
Offline
How did you go about getting it?
PM
08/04/2015 14:38:35
Subject: Re:Cannot get Date from Oracle TimeStamp
#3
chukiatdenkongpon
Joined: Nov 7, 2013
Messages: 97
Offline
Hi

I got this value using Database of AAOD and print out this value by trace output from query db.
What is wrong on getting value date from type Timestamp?

Please advice.

Chukiat D.
PM
08/04/2015 14:56:20
Subject: Re:Cannot get Date from Oracle TimeStamp
#4
NeilGoldsmith
Joined: Nov 6, 2013
Messages: 902
Offline
What does your SQL query look like?
PM
08/04/2015 21:52:08
Subject: Re:Cannot get Date from Oracle TimeStamp
#5
chukiatdenkongpon
Joined: Nov 7, 2013
Messages: 97
Offline
Hi

I don't mean query. But i mean the result of query tyat get from DB is oracle.sql.timestamp@826a5f.
It is very strange. So i need advice on this
PM
09/04/2015 09:30:34
Subject: Re:Cannot get Date from Oracle TimeStamp
#6
NeilGoldsmith
Joined: Nov 6, 2013
Messages: 902
Offline
That's what I'm asking for. Can you show me the SQL code that is sent to Oracle to retrieve the date/time stamp? Do you have a log? It should show what was sent and returned.
PM
09/04/2015 09:37:20
Subject: Re:Cannot get Date from Oracle TimeStamp
#7
chukiatdenkongpon
Joined: Nov 7, 2013
Messages: 97
Offline
Hi

Thank you for reply.

It is problem of jdbc oracle jar file that cannot cast stampstime .

No i can fixed by add new jdbc oracle.

Chukiat D.
PM
09/04/2015 09:52:51
Subject: Re:Cannot get Date from Oracle TimeStamp
#8
NeilGoldsmith
Joined: Nov 6, 2013
Messages: 902
Offline
Can you show me the complete log for your app? I'm not completely following all that you are saying. The log should help make it clear.
PM
Go to:   
Mobile view