error connecting to DB that requires securityMechanism=13
I have no problem connecting to this DB in SQuirrel. But in datagrip I get the error below.
In squirrel I add this to the end of the DB link.
:securityMechanism=13;
I tried that in datagrip in addition to trying adding the variable/value to the advanced tab in the connection configuration window.
Any ideas?
[2017-11-28 15:22:35] [-4223] [jcc][1071][10615][3.69.66] Caught java.security.InvalidAlgorithmParameterException while initializing EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, SQLSTATE=null
[2017-11-28 15:22:35] java.security.InvalidAlgorithmParameterException: DH key size must be multiple of 64, and can only range from 512 to 2048 (inclusive). The specific key size 256 is not supported
[2017-11-28 15:22:35] at com.sun.crypto.provider.DHKeyPairGenerator.initialize(DHKeyPairGenerator.java:128)
[2017-11-28 15:22:35] at java.security.KeyPairGenerator$Delegate.initialize(KeyPairGenerator.java:674)
[2017-11-28 15:22:35] at java.security.KeyPairGenerator.initialize(KeyPairGenerator.java:411)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.am.sc.a(sc.java:141)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.t4.b.u(b.java:2888)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.t4.b.b(b.java:842)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.t4.b.a(b.java:781)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.t4.b.a(b.java:424)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.t4.b.a(b.java:397)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.t4.b.<init>(b.java:335)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:234)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:200)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:471)
[2017-11-28 15:22:35] at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:112)
[2017-11-28 15:22:35] at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:27)
[2017-11-28 15:22:35] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[2017-11-28 15:22:35] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[2017-11-28 15:22:35] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[2017-11-28 15:22:35] at java.lang.reflect.Method.invoke(Method.java:498)
[2017-11-28 15:22:35] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:346)
[2017-11-28 15:22:35] at sun.rmi.transport.Transport$1.run(Transport.java:200)
[2017-11-28 15:22:35] at sun.rmi.transport.Transport$1.run(Transport.java:197)
[2017-11-28 15:22:35] at java.security.AccessController.doPrivileged(Native Method)
[2017-11-28 15:22:35] at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
[2017-11-28 15:22:35] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
[2017-11-28 15:22:35] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
[2017-11-28 15:22:35] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
[2017-11-28 15:22:35] at java.security.AccessController.doPrivileged(Native Method)
[2017-11-28 15:22:35] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
[2017-11-28 15:22:35] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[2017-11-28 15:22:35] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[2017-11-28 15:22:35] at java.lang.Thread.run(Thread.java:745) (no stack trace)
请先登录再写评论。
Hi,
Could you provide any example URL you use and attach a screenshot of your database settings?
What key size do you have? It seems you need to regenerate your key.
Thank you