• Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC connection with oracle 10g  RSS feed

 
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..
 
Bartender
Posts: 4012
42
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
 
Sheriff
Posts: 21181
87
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.
 
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!