Error While Inserting Data to Database from Java Program

Question

I am trying to develop a inventory management system as part of my mini project.

While I try to Insert a data to my Bill_Master Database it returning an error

java.sql.SQLException: [Microsoft][ODBC driver for Oracle][Oracle]ORA-01858: a non-numeric character was found where a numeric was expected

       bqty=Integer.parseInt(iqty.getText());
       bamount=Float.parseFloat(famnt.getText());
       bdsc=Integer.parseInt(dsc.getText());
        bnet=Float.parseFloat(netamnt.getText());
         billid=Integer.parseInt(billn.getText());
         code=Integer.parseInt(icode.getText());
         bqty=Integer.parseInt(iqty.getText());
         rate=getRate(code);
         iamount=rate*bqty;
         amt.setText(Float.toString(iamount)); 
         total=total+iamount;


       try 
       {
           billdetailid++;  
     stmt.executeUpdate("insert into Bill_Master values('"+billid+"','"+date+"','"+cname+"','"+total+"','"+bdsc+"','"+total+"','"+uid+"')");//Error Causing Line.

Values are (1,'27-oct-2013','n/a',900.00,0.0,900.00,'Desk')

Table Structure

Bill_Id (Primary Key INT ):-Stores Bill Number
Bill_Date (Date): Stores Date Of Bill
Customer_Name ( VARCHAR(50)): Customer Name
Total_amt (NUMBER(6)) :Total Bill Amount
Cash_Disc (Number(2)):Discount
Grand_Total(Number(6)):Grand Total
UID(VARCHAR(10)) Stores Who Generated the bill.(EMPLOYEE ID) Connection Type :ODBC

Please help to solve this issue.

Jason Sperske · Accepted Answer · 2013-10-27 17:53:46Z

1

You are putting single quotes around each of your values including bill_Id which is defined as an int. the SQL database is reading this as a string and complaining. Also (as was already pointed out) PreparedStatements make this a lot easier and more secure.

answered Oct 27, 2013 at 17:53

Jason Sperske

30.5k8 gold badges77 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Iswanto San · Accepted Answer · 2013-10-27 17:21:26Z

0

Try this:

stmt.executeUpdate("insert into Bill_Master values('"+billid+"',to_date('"+date+"', 'dd-MON-yyyy'),'"+cname+"','"+total+"','"+bdsc+"','"+total+"','"+uid+"')");

answered Oct 27, 2013 at 17:21

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

Comments

jknair · Accepted Answer · 2013-10-27 17:48:36Z

0

Firstly that is one horrible way of writing SQL queries in java !!!

I am guessing you have just started learning. Please check out PreparedStatements

Data Type related bugs will become easier to debug.

Also that is not the way you write continuous string appends. Check out StringBuilder and String Buffer

edited Oct 27, 2013 at 17:48

answered Oct 27, 2013 at 17:43

jknair

4,8141 gold badge20 silver badges20 bronze badges

Comments

Aswin · Accepted Answer · 2013-10-28 16:41:16Z

0

I found the exact problem. The reason was I am trying to insert the Label instead of the text in the label. correct statement is

stmt.executeUpdate("insert into Bill_Master values('"+billid+"','"+date.getText()+"','"+cname.getText()+"','"+total+"','"+bdsc+"','"+total+"','"+uid+"')");

answered Oct 28, 2013 at 16:41

Aswin

561 gold badge2 silver badges13 bronze badges

Collectives™ on Stack Overflow

Error While Inserting Data to Database from Java Program

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related