• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection with oracle 10g

 
ishani sharma
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello.
my code:



it throws error:
Exception in thread "main" java.lang.NullPointerException
at edu.trialpackage.databaseConnection.OracleConnect.main(OracleConnect.java:19)



can you please tell me where i am wrong..
 
Vijitha Kumara
Bartender
Posts: 3916
9
Chrome Fedora Hibernate
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not sure about your approach to connect to DB (I really haven't tried it myself). But I suggest you to use DriverManager (for standalone applications) to get the connection to the DB, which is the preferred method. Check the JDBC tutorial
 
Rob Spoor
Sheriff
Pie
Posts: 20659
64
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Line 19 is "Statement st = con.createStatement();" which can only mean that "con" is null. That means that d.connect("jdbc:oracle:thin:@oracle:8080:STUDENTINFO",p) returns null, which in turn means the URL is wrong.

I second Vijitha's advice to use DriverManager: If there's a problem this will throw an SQLException instead of returning null.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For your information, class oracle.jdbc.driver.OracleDriver has been deprecated for many years now.
Its replacement is oracle.jdbc.OracleDriver.

Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic