Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Coonection Problem in java (oracle)

Posted on 2009-07-08
3
Medium Priority
?
165 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
  • 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses

916 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