Can't read date fields from oracle

Get Help
1

There lot of messages like " metabase.driver.sql-jdbc.execute Error reading :oracle column 8 CLOSE_TIME TIMESTAMP" in the log.

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_2) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.4 Safari/605.1.15",
    "vendor": "Apple Computer, Inc."
  },
  "system-info": {
    "java.runtime.name": "Java(TM) SE Runtime Environment",
    "java.runtime.version": "1.8.0_162-b12",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "http://java.oracle.com/",
    "java.version": "1.8.0_162",
    "java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
    "java.vm.version": "25.162-b12",
    "os.name": "Windows Server 2012 R2",
    "os.version": "6.3",
    "user.language": "en",
    "user.timezone": "Europe/Moscow"
  },
  "metabase-info": {
    "databases": [
      "oracle"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "run-mode": "prod",
    "version": {
      "tag": "v0.34.1",
      "date": "2020-01-13",
      "branch": "release-0.34.x",
      "hash": "265695c"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

Hi @Max.A
Which version of ojdbc8.jar are you using - 19.3? https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
Is that the only error message?
What is the actual database column type? It looks like timestamp, but in your title you write “Can’t read date …”.

3

Hi flamber, yes, it was jdbc problem. I putted it in plugin calalog but didn’t delete standard library.
I left only jdbc8.jar and now its ok

1 Like
4

Hi!

Same here. Using ojdbc8.jar 19.3.
My date format is stored as VARCHAR2 with the format "30/05/2017 10:44:03"
I have tried everything.
Any advice?

Thanks in advance,
Pedro

5

@phmazzoni That's not the same problem. You don't have date types, but strings. You would have to create a database view to cast the strings into a timestamp type.

Metabase currently doesn't support casting in the Data Model, but that will be possible in 0.39 for some types and extended more in 0.40

6

Thanks!
Unfortunately I don't have access to the db.
Do you think there is a development branch that I can test these features?

Thanks again!

7

@phmazzoni Our code is public, but this is not been created/finished yet, so no.
You can follow some of the progress here:
https://github.com/metabase/metabase/issues/14054

1 Like