how to retrieve value from autogenerated(oracle sequence) column in a servlet.

[Bhardwaj Shweta]

hello

In my servlet i want to retrieve values from my jsp form,however there is one column in my table (created using sequence )so that it can increment automatically .

                        String str1 = request.getParameter("projectname");
	        String str2 = request.getParameter("premarks");
	        String str3 = request.getParameter("pcontact");
	        String str4 = request.getParameter("psponsor");
	        String str5 = request.getParameter("powner");
	        String str6 = request.getParameter("ppriority");

                        pst = con.prepareStatement("insert into prproject values(?,?,?,?,?,?,?)");
	                	
	                    pst.setString(2 ,str1 );
	                    pst.setString(3 , str2);
	                    pst.setString(4 , str3);
	                    pst.setString(5 , str4);
	                    pst.setString(6 ,str5);
	                    pst.setString(7 ,str6);

Now what should i write for first column?

[Sean Clark]

Hey,

I think you can either pass in null or you can omit the first placeholder [?] from the prepared statement. I'm sure one of these will work.

Sean

[Bhardwaj Shweta]

Hey Sean Thanks
It worked when i replaced first placeholder with (seq_auto.nextval)