throwing SQLException : GeneralError

[amarnath jha]

my programe is throwing SQLException GeneralError using oracle9i

//this is code

public void insertData(String name,int id,float price,int sales,float total)
{
try
{
//columns = statement.executeUpdate("insert into coffees values ("+name+","+id+","+price1+","+sales1+","+total1+")");
pStatement = connection.prepareStatement("insert into coffees values(?,?,?,?,?)");
pStatement.setString(1,name);
pStatement.setInt(1,id);
pStatement.setDouble(1,price);
pStatement.setInt(1,sales);
pStatement.setDouble(1,total);
pStatement.executeUpdate();
connection.commit();
System.out.println("no of rows inserted "+columns);
}
//catch block and other code

[Chetan Natu]

Check your database, normally if you are inserting duplicate primary-key values, you will receive such kind of error...

Can you post the stack trace?