java.jdbc

Better support for Oracle

Details

  • Type: Enhancement Enhancement
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Completed
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: None
  • Labels:
    None
  • Environment:
    Oracle 10g and above

Description

This is just a suggestion, and i am not sure if it is the right way to do this.

When fetching data from Oracle the oracle jdbc driver returns all the numeric type columns as BigDecimal and date/datetime columns as oracle.sql.TIMESTAMP. This causes a lot of headache as we have to remember to convert the data to the correct type.

Although, this can be handled at the application level by using a :row-fn, it would be really nice if this library handles the conversion itself.

  1. datatype.patch
    20/May/13 9:57 AM
    2 kB
    Manish Handa
  2. oracle-fix.patch
    18/May/13 2:10 PM
    2 kB
    Manish Handa

Activity

Manish Handa made changes -
Field Original Value New Value
Attachment oracle-fix.patch [ 11997 ]
Manish Handa made changes -
Attachment datatype.patch [ 11999 ]
Sean Corfield made changes -
Resolution Completed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: