Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of Classic Computer Science Problems in Swift this week in the iOS 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: 16083
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: 4420
108
  • 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
 
Marshal
Posts: 58830
179
  • 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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!