Intellij database view dont display any structure or schema information
Hello,
Im trial testing Intellij IDEA and im having trouble with the database view. I can configure and connect to an Oracle database, even execute querys in the console, but the database view dont show any structure or schema information. Also the connection properties dont show any schemas in the schema tab. I dont think theres any problem with the database or the driver, since i have no issues with SQL Developer or DBeaver.
Here are the screenshots and the log messages:
Connection test is succefull

Schema tab error:

Database view sync error:

Event log:
The connection pool is not connected yet or may be is disconnecting.
at org.jetbrains.dekaf.jdbc.pooling.ConnectionPool.borrow(ConnectionPool.java:114)
at org.jetbrains.dekaf.jdbc.JdbcIntermediateFacade.obtainConnectionInfoFromJdbc(JdbcIntermediateFacade.java:157)
at org.jetbrains.dekaf.jdbc.JdbcIntermediateFacade.getConnectionInfo(JdbcIntermediateFacade.java:143)
at com.intellij.database.remote.jdba.impl.RemoteFacadeImpl.getConnectionInfo(RemoteFacadeImpl.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:346)
at sun.rmi.transport.Transport$1.run(Transport.java:200)
at sun.rmi.transport.Transport$1.run(Transport.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
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)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:276)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:253)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:162)
at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
at com.sun.proxy.$Proxy197.getConnectionInfo(Unknown Source)
at sun.reflect.GeneratedMethodAccessor599.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:175)
at com.intellij.execution.rmi.RemoteUtil.access$300(RemoteUtil.java:36)
at com.intellij.execution.rmi.RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:280)
at com.sun.proxy.$Proxy198.getConnectionInfo(Unknown Source)
at org.jetbrains.dekaf.intermediate.AdaptIntermediateFacade.getConnectionInfo(AdaptIntermediateFacade.java:48)
at org.jetbrains.dekaf.core.BaseFacade.getConnectionInfo(BaseFacade.java:65)
at com.intellij.database.introspection.DBIntrospectorFactory.supportedByNativeIntrospector(DBIntrospectorFactory.kt:26)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.prepareIntrospection(DatabaseModelLoader.java:470)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$null$2(DatabaseModelLoader.java:302)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.withFacade(DatabaseModelLoader.java:500)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$introspect$3(DatabaseModelLoader.java:301)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$null$0(DataSourceSyncManager.java:40)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.perform(DatabaseConnectionManager.java:362)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.lambda$sync$2(DatabaseConnectionManager.java:301)
at com.intellij.database.dataSource.AsyncUtil.withAsyncFriendly(AsyncUtil.java:163)
at com.intellij.database.dataSource.DatabaseConnectionManager$Executor.sync(DatabaseConnectionManager.java:297)
at com.intellij.database.dataSource.DatabaseConnectionManager$Builder.sync(DatabaseConnectionManager.java:111)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$static$1(DataSourceSyncManager.java:39)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor$1.perform(DataSourceSyncManager.java:240)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.introspect(DatabaseModelLoader.java:297)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$run$0(DatabaseModelLoader.java:277)
at com.intellij.database.dataSource.LocalDataSource.performBatch(LocalDataSource.java:1132)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.run(DatabaseModelLoader.java:275)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.performSync(DataSourceSyncManager.java:242)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$6(AsyncUtil.java:54)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$12(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$13(AsyncUtil.java:137)
at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:548)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:493)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:94)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:137)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:131)
at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$7(AsyncUtil.java:54)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
at com.intellij.openapi.application.impl.ApplicationImpl$2.run(ApplicationImpl.java:343)
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).
The connection pool is not connected yet or may be is disconnecting.
Thanks in advance for any help.
Please sign in to leave a comment.
Please see https://youtrack.jetbrains.com/issue/DBE-3647.