Solved

Coonection Problem in java (oracle)

Posted on 2009-07-08
3
155 Views
Last Modified: 2013-11-23
Hi ,

i am using 2 java class ,

1st class  program

DBConn dba=new DBConn();
Connection con=null;

String query="insert into gen_info(EMP_NAME,EMP_ID,TECH) "+ "values(?,?,?)";
//Statement st=con.createStatement();
PreparedStatement psmnt=null;
dba.DBAccess(query);
psmnt.setString(1,"Sathish");
psmnt.setString(2,"E11006");
psmnt.setString(3,"Java");

boolean s = psmnt.execute();
if (s)
{
      System.out.println("Succesfully inserted");
}
else
{
      System.out.println("Cant Insert");
}
      //st.execute(query);
con.close();


its call DBConn class , thats have connection coding
 Class.forName("oracle.jdbc.driver.OracleDriver");
                              // System.out.println("Failed to load isqlPlus driver.");
                              //DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
                        }

                        catch (Exception ae) {
                              ae.printStackTrace();
                        }

                        try {

                              String url1 = System.getProperty("JDBC_URL");
                              if (url1 != null)
                                    url = url1;
                              PreparedStatement psmnt=null;
                              con = DriverManager.getConnection(url,
                                          "system", "tspl");
                              psmnt = con.prepareStatement(query);
                              
                        } catch (Exception e) {
                              e.printStackTrace();
                        }
                        
                  } catch (Exception e) {
                        e.printStackTrace();
                  }

afterfinish this its return back to 1st  preparestmaent is null its throw the null pointer excetion
kindly help me to reslove this !!

             
                  
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 2

Expert Comment

by:sirtam
ID: 24807142
Hi.

Did you remember to make objects of the connections? ( = new ...())

http://www.experts-exchange.com/Programming/Languages/Java/Q_24534178.html
0
 
LVL 20

Author Comment

by:Sathish David Kumar N
ID: 24810959
I am using 2 class sirtam so preparestatement variable is null when the nrturn back excute the query .
0
 
LVL 20

Accepted Solution

by:
Sathish David  Kumar N earned 0 total points
ID: 24924004
prepareStament is local to that class so thats value is null so its say null ponter exception
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question