Database view error
i recently upgraded from intellij 14.0.3 to intellij 14.1.3 and the database view does not work anymore.
when i try to execute a query, i get this stack:
[2015-05-27 10:12:39] java.lang.ClassNotFoundException: sun.io.UnknownCharacterException
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at com.ibm.db2.jcc.b.a.<init>(a.java:238)
at com.ibm.db2.jcc.b.b.a(b.java:1624)
at com.ibm.db2.jcc.c.p.a(p.java:350)
at com.ibm.db2.jcc.c.p.<init>(p.java:404)
at com.ibm.db2.jcc.b.b.<init>(b.java:256)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)
at com.intellij.database.remote.jdbc.impl.RemoteDriverImpl.connect(RemoteDriverImpl.java:27)
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:497)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323)
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$254(TCPTransport.java:683)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler$$Lambda$2/17886951.run(Unknown Source)
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)
the database is a db2 localhost database with the following url: jdbc:db2://localhost:50000/<db.name>
under the advanded tab: retrieveMessagesFromServerOnGetMessage=true
this configuration worked fine in 14.0.3, but after the upgrade it is ruined...
Please sign in to leave a comment.
i use this integrated in intellij every day and am hoping for a solution soon.
i am using db2.
can this error be avoided if i use other drivers?
is db2jcc4-4.9.78.jar the correct jar file to use?
this is found in .IntelliJIdea14/config/jdbc-drivers folder under my user on my windows pc
I am also using an old SDK, jdk 1.6 where JAVA_HOME is pointing to the lib-folder on the application sever (IBM WebSphere 8.5.5)
FYI Here're some other people on SO having the same problem:
http://stackoverflow.com/questions/23801841/connect-to-db2-database-in-eclipse-via-jdbc
They are running with java 7...
I cannot change JAVA_HOME on my computer, but I installed new java, jdk-7u75-windows-x64.exe, and set the environment variable JDK_HOME to the installed directory. This does not work and I still get the same pop-up message....
The install directory does not contain a folder with name jre64 (only jre) even though it is a 64 bit exe file
See https://intellij-support.jetbrains.com/entries/23455956 .
This is great. I hava IntelliJ 14.1.3 running 64bit jdk 7 installation that enables the drivers to work :)