Saumitra Tiwari wrote:I want values in different rows....
I'm still not quite grasping the problem. I think you have two issues:
1. You are submitting a form with 4 rows of data but the application is only creating one row in the database. If this is true, my first post in this topic has a link to the solution for that: indexed properties.
2. Each column in the row in the database contains all the values separated by commas. The way I understand SQL INSERT is that you can specify the column values in the VALUES statement and you don't have to specify the column names, so your SQL statement appears to be correct. I have the following questions:
2.1. Have you tried executing the statement in SQL Plus or some other SQL console?
2.2. Have you tried specifying the column names in the SQL query?
2.3. Why are you calling ps.cancel()? That aborts whatever command is being executed, so at the least, it does nothing (coming after the con.commit()). At worst, it is rolling back whatever work you have done.