Cannot Synchronize DB Schemas (DataGrip)

Test Connection is successful but when I go to the Schemas tab and try to sync I get an exception and no list of database. I'm using the jTds driver(that DataGrip auto installs) to connect to MS SQL Server. The same thing happens in IntelliJ IDEA. I've no problems using SQLDeveloper but I'd like to try DataGrip.

DataGrip version is 2017.2 (172.3544.109)

JRE Version is 1.8.0_152
OS is macOS Sierra 10.12.6

java.lang.AbstractMethodError: Method net/sourceforge/jtds/jdbc/JtdsResultSet.isClosed()Z is abstract
at net.sourceforge.jtds.jdbc.JtdsResultSet.isClosed(JtdsResultSet.java)
at org.jetbrains.dekaf.jdbc.JdbcIntermediateSeance.execute(JdbcIntermediateSeance.java:103)
at org.jetbrains.dekaf.jdbc.JdbcIntermediateSession.queryOneRow(JdbcIntermediateSession.java:329)
at org.jetbrains.dekaf.jdbc.JdbcIntermediateFacade.getConnectionInfoSmartly(JdbcIntermediateFacade.java:263)
at org.jetbrains.dekaf.jdbc.MssqlIntermediateFacade.obtainConnectionInfoNatively(MssqlIntermediateFacade.java:44)
at org.jetbrains.dekaf.jdbc.JdbcIntermediateFacade.getConnectionInfo(JdbcIntermediateFacade.java:136)
at com.intellij.database.remote.jdba.impl.RemoteFacadeImpl.getConnectionInfo(RemoteFacadeImpl.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)




1
3 comments

Same issue here

0

I have having a similar issue. However, I am not seeing the action link that says "More Schemas ...". This is quite confusing.

I have see that the database tool is reporting that I have 73 schemas. Which is great. But it is only listing the MySQL's information_schema.

The "Stranger Thing" is that I can see the missing databases in the schema switcher of the console as you can see it on the picture ...

 

 

Does anyone know what I am doing wrong?

Thanks for your help.

 

0

I found the answer. The is a configuration option for the Data Source that let's you select some or all the schemas that you need to have access to once connected to that database source.

After that, you will see all your schemas appearing in the database tool (based on the selection made in the settings) ...

Hopefully that helps someone.

1

Please sign in to leave a comment.