Solved

Coonection Problem in java (oracle)

Posted on 2009-07-08
3
153 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
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…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

809 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