Error inserting into database

[manjiri chunekar]

Thanks for guiding me...
I saw that links...
but my problem is not solved yet...

I changed crete funcn

public List insertCustomer(Customer customer) {  
	List List = null;
	String query = "INSERT INTO Cust (Cust_Id, Cust_Fname, Cust_Lname) VALUES (?,?,?)";      
	jdbctemplate.queryForList(query);

	Connection connection = null;      
	PreparedStatement preparedStatement = null;      
			
	try {       
		connection = dataSource.getConnection();          
		preparedStatement = connection.prepareStatement(query);       
		preparedStatement.setInt(1, customer.getCust_id());           
		preparedStatement.setString(2, customer.getFirst_name());         
		preparedStatement.setString(3, customer.getLast_name()); 
		preparedStatement.execute();        
	} 
	catch (SQLException e) {     
		e.printStackTrace(); 
	} finally {            
		try { 
			if (preparedStatement != null) 
				preparedStatement.close();
			if (connection != null) {     
				connection.close();                
			} 
		} catch (SQLException e) { 
			e.printStackTrace() ; 	
		}
	}
	return List; 
}

thugh it gives same error...
what to do...
i do seperate assignment for 1 query i.e select...
it runs, shows data....

[Swastik Dey]

thugh it gives same error...

What error does it show?

[Mark Spritzler]

If you are doing an insert or update, the jdbc template method is update(); And it does not return a List, just an int for the number of rows that were updated/inserted. That would be all you need for an update or insert statement.

Also, why you have all that JDBC code below it is completely unnecessary.

Mark