IllegalArgumentException when exporting to file from oracle database
I am trying to export the result of an SQL query to a csv file and am getting the exception listed below.
The SQL query is a simple "SELECT DATECOLUMN FROM MYTABLE". The results show up just fine in the console; however, when I try to export it to csv or tsv I get the following exception output.
java.lang.IllegalArgumentException: Value must be of type Timestamp at com.intellij.database.run.ui.grid.editors.TimestampDelegate.toTemporalAccessor(TimestampDelegate.java:21) at com.intellij.database.run.ui.grid.editors.TimestampDelegate.toTemporalAccessor(TimestampDelegate.java:12) at com.intellij.database.run.ui.grid.editors.DateAndTimeFormatter.getTemporalAccessor(DateAndTimeFormatter.java:80) at com.intellij.database.run.ui.grid.editors.EraDateAndTimeFormatter.getFormatter(EraDateAndTimeFormatter.java:40) at com.intellij.database.run.ui.grid.editors.EraDateAndTimeFormatter.format(EraDateAndTimeFormatter.java:31) at com.intellij.database.extractors.ObjectFormatter.dateToString(ObjectFormatter.java:358) at com.intellij.database.extractors.ObjectFormatter.access$700(ObjectFormatter.java:61) at com.intellij.database.extractors.ObjectFormatter$17.convert(ObjectFormatter.java:233) at com.intellij.database.extractors.ObjectFormatter$17.convert(ObjectFormatter.java:227) at com.intellij.database.extractors.ObjectFormatter.objectToString(ObjectFormatter.java:535) at com.intellij.database.extractors.ObjectFormatter.getValueLiteral(ObjectFormatter.java:547) at com.intellij.database.extractors.DefaultValuesExtractor.getValueAsString(DefaultValuesExtractor.java:104) at com.intellij.database.extractors.TranspositionAwareDefaultExtractor.getValueAsString(TranspositionAwareDefaultExtractor.java:44) at com.intellij.database.extractors.FormatBasedExtractor$1.lambda$doAppendData$0(FormatBasedExtractor.java:57) at com.intellij.util.containers.ContainerUtilRt.map2List(ContainerUtilRt.java:393) at com.intellij.util.containers.ContainerUtil.map(ContainerUtil.java:1899) at com.intellij.database.extractors.FormatBasedExtractor$1.doAppendData(FormatBasedExtractor.java:57) at com.intellij.database.extractors.TranspositionAwareDefaultExtractor$TranspositionAwareExtractionBase.appendData(TranspositionAwareDefaultExtractor.java:87) at com.intellij.database.extractors.DefaultValuesExtractor$DefaultExtraction.addData(DefaultValuesExtractor.java:206) at com.intellij.database.dump.DumpRequest.addRows(DumpRequest.java:76) at com.intellij.database.dump.DumpHandler$MyRequest.addRows(DumpHandler.java:250) at com.intellij.database.console.JdbcEngine.printResultSet(JdbcEngine.java:980) at com.intellij.database.console.JdbcEngine.access$1600(JdbcEngine.java:71) at com.intellij.database.console.JdbcEngine$QueryExecutionOperation$1.results(JdbcEngine.java:1854) at com.intellij.database.console.JdbcEngine$QueryExecutionOperation$1.results(JdbcEngine.java:1846) at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer$processRemaining$1.results(UniversalResultsProducer.kt:32) at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer$processRemaining$1.results(UniversalResultsProducer.kt:30) at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer.processCurrent(UniversalResultsProducer.kt:44) at com.intellij.database.dataSource.connection.statements.UniversalResultsProducer.processRemaining(UniversalResultsProducer.kt:30) at com.intellij.database.console.JdbcEngine$QueryExecutionOperation.lambda$execute$0(JdbcEngine.java:1846) at com.intellij.database.dataSource.connection.statements.SmartStatementsUtil$consumer$1.invoke(SmartStatementsUtil.kt:96) at com.intellij.database.dataSource.connection.statements.SmartStatementsUtil$consumer$1.invoke(SmartStatementsUtil.kt) at com.intellij.database.dataSource.connection.statements.JdbcBasedSmartStatement$execute$1$1.invoke(JdbcBasedSmartStatement.kt:32) at com.intellij.database.dataSource.connection.statements.SmartStatementsUtil.runReporting(SmartStatementsUtil.kt:73) at com.intellij.database.dataSource.connection.statements.JdbcBasedSmartStatement$execute$1.invoke(JdbcBasedSmartStatement.kt:32) at com.intellij.database.dataSource.connection.statements.JdbcBasedSmartStatement$execute$1.invoke(JdbcBasedSmartStatement.kt:13) at com.intellij.database.dataSource.connection.Either$Right.transform(Either.kt:70) at com.intellij.database.dataSource.connection.statements.JdbcBasedSmartStatement.execute(JdbcBasedSmartStatement.kt:31) at com.intellij.database.dataSource.connection.statements.NoisyStatement.execute(NoisyStatement.kt:23) at com.intellij.database.console.JdbcEngine$RegularExecutor.execute(JdbcEngine.java:1335) at com.intellij.database.console.JdbcEngine$QueryExecutionOperation.execute(JdbcEngine.java:1844) at com.intellij.database.console.JdbcEngine$QueryExecutionOperation.perform(JdbcEngine.java:1799) at com.intellij.database.console.JdbcEngine$PotentiallyAtomicOperation.perform(JdbcEngine.java:1503) at com.intellij.database.console.JdbcEngine.lambda$visitQuery$4(JdbcEngine.java:312) at com.intellij.database.console.AbstractEngine.lambda$submitRequest$4(AbstractEngine.java:178) at com.intellij.database.console.AbstractEngine.lambda$null$2(AbstractEngine.java:153) at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:580) at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:525) at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:85) at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:136) at com.intellij.database.console.AbstractEngine.lambda$submitRunnable$3(AbstractEngine.java:149) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) (no stack trace)
Please sign in to leave a comment.
Could you clarify please what IDE version do you use (please provide information from About dialog)? What database do you use and what is the type of the column? Thank you.