This week's book giveaway is in the Security forum.
We're giving away four copies of Securing DevOps and have Julien Vehent on-line!
See this thread for details.
Win a copy of Securing DevOps this week in the Security forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Can you tell me is my java code connect to the oracle sql database?  RSS feed

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

when I run this with esclipe, it will appear "SQL EXCEPTION" ON THE CONSOLE WINDOW BELOW. however, there will be a search window appear.  whenever I type something inside and search, i always get  tons of red lines. like this:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at Desktop.actionPerformed(Desktop.java:90)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
 
Java Cowboy
Sheriff
Posts: 16081
88
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Most likely the variable conn is null when the running program reaches line 90.

Check the console output. Do you see a message such as "Driver Exceptions", "Null Exceptions" or "SQL Exceptions" - the error messages your code prints in the constructor? Maybe something fails in the constructor so that conn stays null.
 
Saloon Keeper
Posts: 4283
106
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Instead of printing out fixed strings in the catch block that tell you just about nothing about what went wrong, print the stack trace of all exceptions like "ex.printStrackTrace()".
 
troy wu
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Jesper de Jong wrote:Most likely the variable conn is null when the running program reaches line 90.

Check the console output. Do you see a message such as "Driver Exceptions", "Null Exceptions" or "SQL Exceptions" - the error messages your code prints in the constructor? Maybe something fails in the constructor so that conn stays null.



I think the oracle database hasnot connected to Esclipe ide. I have been trying connect oracle database to Esclipe for two days, and I also done some research on the web, but I have not idea why the oracle cannot connect to the ide. I am gonna ask my professor tomorrow at school,. ty
 
Sheriff
Posts: 57921
178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please show what happens when you connect to the database via the command line.
It isn't right to connect to databases from inside a GUI class. You shou‍ld be able to connect to the database without any GUIs and the GUI classes are only there for displaying the results.
 
today's feeble attempt to support the empire
Thread Boost - a very different sort of advertising
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!