Skip to main content

java ee - how to overcome this NullPointerException? - 


 import java.sql.*; import java.io.*; import java.util.*; public class { public static void main(string args[]){ try { class.forname("sun.jdbc.odbc.jdbcodbcdriver"); connection con= drivermanager.getconnection("jdbc:odbc:debjeet", "system", "tiger"); preparedstatement st=con.preparestatement("insert emp values('?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?')"); //there 17 fields in database bufferedreader dis= new bufferedreader(new inputstreamreader(system.in)); system.out.println("enter desired username"); string us=dis.readline(); st.setstring(1,(string)us); //this attempt made me remove exception ,otherwise below index 4.also exception occurs here. system.out.println("enter desired password"); string pw=dis.readline(); st.setstring(2,pw); system.out.println("enter first name"); string fn=dis.readline(); st.setstring(3, fn); system.out.println("enter middle name"); string mn=dis.readline(); system.out.println("enter last name"); string ln=dis.readline(); system.out.println("enter email"); string em=dis.readline(); system.out.println("enter date of birth"); int dob= integer.parseint(dis.readline()); system.out.println("enter month of birth"); string mob=dis.readline(); system.out.println("enter year of birth"); int yob=integer.parseint(dis.readline()); system.out.println("enter gender(m/f)"); string gen=dis.readline(); system.out.println("enter institute"); string inst=dis.readline(); system.out.println("enter address"); string add=dis.readline(); system.out.println("enter city"); string ct=dis.readline(); system.out.println("enter state"); string state=dis.readline(); system.out.println("enter pincode"); int pin=integer.parseint(dis.readline()); system.out.println("enter country"); string cn=dis.readline(); system.out.println("enter 10 digit mobile number"); string phnum=dis.readline(); system.out.println("thank :d"); st.setstring(4, mn); st.setstring(5, ln); st.setstring(6, em); st.setstring(7, gen); st.setstring(8, inst); st.setstring(9, add); st.setstring(10, ct); st.setstring(11, state); st.setint(12, pin); st.setstring(13, cn); st.setstring(14, phnum); st.setint(15,dob); st.setstring(16, mob); st.setint(17, yob); int i=st.executeupdate(); if(i>0) system.out.println("success"); con.close(); } catch (exception e) { system.out.println(e); } } }

output:

enter desired username grg java.lang.nullpointerexception

this code showing null pointer exception in machine , invalid column index message in other machine. dont know how proceed.on other hand databse working fine if tryin insert values using statement object.i guess there problem in prepared statement object cannot resolve it.

java ee - how overcome nullpointerexception? - stack overflow

learn, share, build

each month, on 50 million developers come stack overflow learn, share knowledge, , build careers.

join world’s largest developer community.

sign up

up vote 0 down vote favorite 
 import java.sql.*; import java.io.*; import java.util.*; public class { public static void main(string args[]){ try { class.forname("sun.jdbc.odbc.jdbcodbcdriver"); connection con= drivermanager.getconnection("jdbc:odbc:debjeet", "system", "tiger"); preparedstatement st=con.preparestatement("insert emp values('?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?')"); //there 17 fields in database bufferedreader dis= new bufferedreader(new inputstreamreader(system.in)); system.out.println("enter desired username"); string us=dis.readline(); st.setstring(1,(string)us); //this attempt made me remove exception ,otherwise below index 4.also exception occurs here. system.out.println("enter desired password"); string pw=dis.readline(); st.setstring(2,pw); system.out.println("enter first name"); string fn=dis.readline(); st.setstring(3, fn); system.out.println("enter middle name"); string mn=dis.readline(); system.out.println("enter last name"); string ln=dis.readline(); system.out.println("enter email"); string em=dis.readline(); system.out.println("enter date of birth"); int dob= integer.parseint(dis.readline()); system.out.println("enter month of birth"); string mob=dis.readline(); system.out.println("enter year of birth"); int yob=integer.parseint(dis.readline()); system.out.println("enter gender(m/f)"); string gen=dis.readline(); system.out.println("enter institute"); string inst=dis.readline(); system.out.println("enter address"); string add=dis.readline(); system.out.println("enter city"); string ct=dis.readline(); system.out.println("enter state"); string state=dis.readline(); system.out.println("enter pincode"); int pin=integer.parseint(dis.readline()); system.out.println("enter country"); string cn=dis.readline(); system.out.println("enter 10 digit mobile number"); string phnum=dis.readline(); system.out.println("thank :d"); st.setstring(4, mn); st.setstring(5, ln); st.setstring(6, em); st.setstring(7, gen); st.setstring(8, inst); st.setstring(9, add); st.setstring(10, ct); st.setstring(11, state); st.setint(12, pin); st.setstring(13, cn); st.setstring(14, phnum); st.setint(15,dob); st.setstring(16, mob); st.setint(17, yob); int i=st.executeupdate(); if(i>0) system.out.println("success"); con.close(); } catch (exception e) { system.out.println(e); } } }

output:

enter desired username grg java.lang.nullpointerexception

this code showing null pointer exception in machine , invalid column index message in other machine. dont know how proceed.on other hand databse working fine if tryin insert values using statement object.i guess there problem in prepared statement object cannot resolve it.

share|improve question
    
start not catching exception, or @ least print stack trace in catch block. stack trace tell exception happens. – jb nizet jul 7 '12 @ 11:54
    
i have found out.the exception taking place within braces have typed '?' marks within ' ' shall b ? followed commas because java.lang takes servlet request default strings – debjeet sarkar jul 8 '12 @ 8:59

your answer

 
discard

posting answer, agree privacy policy , terms of service.

browse other questions tagged or ask own question.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more