Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

java.lang.NullPointerException on DB connection

2621199Jan 31 2017 — edited Feb 15 2017

I downloaded, installed and started to work with Early adopter 2 SQL Developer 4.2.0.16.365 Build 16.356.1154 (Win 64-bit jdk included) a few weeks ago after a new install of Windows 10 pro on my computer.  I did not export/import the connections I had from the previous SQL Developer 4.1.3 (Win 64-bit jdk included), also on Win 10 pro.

I copied msvcr100.dll from ...\sqldeveloper\jdk\jre\bin to newly created ...\sqldeveloper\jdk\bin, added DB TNS based connections and worked okay.  But the 14th DB that I added was not accessible.  Regardless of TNS or basic connection type (on the "New / Select Database Connection" window) that particular DB, though tested okay (Status : Success) could not connect.  (sqlplus client with tnsnames.ora or easyconnect host:port/service connects and runs properly.)

DB connections added afterwards work properly.

In the connection tree if we click that particular DB, let's call it DBnogo, we get a window titled "Error Connecting".  Clicking on the "Details" button we get the following details:

Exception Stack Trace:

java.lang.NullPointerException

  at oracle.dbtools.raptor.navigator.db.xml.NavigatorHook.getConnectionType(NavigatorHook.java:255)

  at oracle.dbtools.raptor.navigator.ObjectFactoryRegistry.createFactory(ObjectFactoryRegistry.java:164)

  at oracle.dbtools.raptor.navigator.ObjectFactoryRegistry.getFactory(ObjectFactoryRegistry.java:153)

  at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode.getObjectFactory(DatabaseTreeNode.java:86)

  at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:140)

  at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:114)

  at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)

  at java.util.concurrent.FutureTask.run(FutureTask.java:266)

  at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:629)

  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)

(BTW, though there is no valid connection, the electrical plug graphic shows on database DBnogo on the Connections tree.)

I took a DB connections export and imported into a fresh 4.1.5.21 installation and the same DBnogo database connected and ran properly.

Any ideas?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 15 2017
Added on Jan 31 2017
26 comments
20,053 views