Column datatype=date appear as NULL in the result set

Get Help
#1

Hi

I connect Metadata to an oracle database, so when i run a select statement for any table of the database all the columns with datatype = date appear null, it doesnt show the dates in this columns.

Some help please!!!

#2

Hi @Careca
Post “Diagnostic Info” from Admin > Troubleshooting.
And which version of ojdbc8.jar are you using?

#4

hi above the details:

system-info": {
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “1.8.0_252-8u252-b09-1~16.04-b09”,
“java.vendor”: “Private Build”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_252”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “25.252-b09”,
“os.name”: “Linux”,
“os.version”: “4.4.0-186-generic”,
“user.language”: “en”,
“user.timezone”: "Africa/Maputo

#5

@Careca

  1. “Diagnostic Info” is all the content you removed.
  2. Latest release is 0.36.6
  3. You should migrate away from H2 if you’re using Metabase in production:
    https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
  4. You haven’t provided the ojdbc8.jar version - make sure you’re using the latest:
    https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html
#6

Hi sory, find all the Diagnostic info bellow:

{
“browser-info”: {
“language”: “en-US”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “1.8.0_252-8u252-b09-1~16.04-b09”,
“java.vendor”: “Private Build”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_252”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “25.252-b09”,
“os.name”: “Linux”,
“os.version”: “4.4.0-186-generic”,
“user.language”: “en”,
“user.timezone”: “Africa/Maputo”
},
“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
}
}
}