getting NumberFormatException

[toukhir mujawar]

hi friends,

i am getting this error while inserting the record...

   
                PreparedStatement st = conn.prepareStatement("insert into tbl_daily_collection (collection_date,user_code,circle,amountCash,amountDeposited,DATE_OF_DEPOSITION,BANK_NAME) values (to_date(?,'dd/mm/yyyy'),?,?,?,?,to_date(?,'dd/mm/yyyy'),?)");
                st.setString(1, colnDate);
                st.setString(2, userCode);
                st.setString(3, circle);
                st.setString(4, amount);
                st.setString(5, amountDeposited);
                st.setString(6, depositionDate);
                st.setString(7, bankName);
                insertCount = st.executeUpdate();

the error is like...

java.lang.NumberFormatException: null
java.lang.Integer.parseInt(Unknown Source)
java.lang.Integer.parseInt(Unknown Source)
dailycollection.DailyCollectionEntry.processRequest(DailyCollectionEntry.java:75)
dailycollection.DailyCollectionEntry.doPost(DailyCollectionEntry.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

no null value is being inserted....

using JDK 1.5....

i m using the insert statement at one more place and it is working very well....


please help me

[A Kumar]

the values coming to the server from the client browser will be of type string..

Any int values that you are passing to the statement and which comes from the client ...has to be changed from string to int....

check in your code whether such a conversion is taking place...and what columns in the table are of type numeric...

[toukhir mujawar]

yes there are two numeric columns in the table....

but i want to know why is it working at other place?

[A Kumar]

Can you post the code...and what are the columns that are numeric and for what values are they causing the exception...??

[toukhir mujawar]

for the first time i am using the following code....

    
                PreparedStatement st = conn.prepareStatement("insert into tbl_daily_collection (collection_date,user_code,amountCash,amountCheque,amountDeposited,zone,circle,div,subdiv,DATE_OF_DEPOSITION,BANK_NAME) values (to_date(?,'dd/mm/yyyy'),?,?,?,?,?,?,?,?,to_date(?,'dd/mm/yyyy'),?)");
                st.setString(1, colnDate);
                st.setString(2, userCode);
                st.setString(3, amountCash);
                st.setString(4, amountCheque);
                st.setString(5, amountDeposited);
                st.setString(6, zone);
                st.setString(7, circle);
                st.setString(8, div);
                st.setString(9, subdiv);
                st.setString(10,depositionDate);
                st.setString(11,bankName);
                insertCount = st.executeUpdate();

here the amountCash,amountCheque, amountDeposited are the numeric fields...still it is working....

For the second instance when i am trying to insert the record it is showing the following exception...

    
                PreparedStatement st = conn.prepareStatement("insert into tbl_daily_collection (collection_date,user_code,circle,amountCash,amountDeposited,DATE_OF_DEPOSITION,BANK_NAME) values (to_date(?,'dd/mm/yyyy'),?,?,?,?,to_date(?,'dd/mm/yyyy'),?)");
                st.setString(1, colnDate);
                st.setString(2, userCode);
                st.setString(3, circle);
                st.setString(4, amount);
                st.setString(5, amountDeposited);
                st.setString(6, depositionDate);
                st.setString(7, bankName);
                insertCount = st.executeUpdate();

and the error msg is like the above given....

note that the statement.....

insert into tbl_daily_collection (collection_date,user_code,circle,amountCash,amountDeposited,DATE_OF_DEPOSITION,BANK_NAME) values (to_date('12/12/06','dd/mm/yyyy'),'wmsec','530','450','450',to_date('12/12/06','dd/mm/yyyy'),'bom');

is also working fine at SQL prompt...

what can be the reason...

[Adeel Ansari]

Go to Line no. 75 of DailyCollectionEntry.java

Furthermore, check out Beware-of-Auto-boxing and Auto-unboxing.
[ February 13, 2007: Message edited by: Adeel Ansari ]

[toukhir mujawar]

thanks friends i got the solution...i had made a silly mistake...