[nicagal2000]

I am trying to insert records into an access database from a GUI and I am getting the error message that I used to handled the exception.May I get help please as nothing is going to my database and there is a running connection between the client and the server built.

public void InsertCustomer(CustomerClass obj)
{
	SQLConnect();
	
	try
	{
		stat=con.createStatement();
		
		String query=("INSERT INTO Customer(Fname,Lname,Address1,Address2,Parish,POffice,Telephone#,Status) VALUES('"+obj.getFName()+"','"+obj.getLName()+"','"+obj.getAddress1()+"','"+obj.getAddress2()+"','"+obj.getParish()+"','"+obj.getPO()+"','"+obj.getTelephone()+"',"+obj.getStatus()+"')");
		System.out.println(query);
						  
		stat.executeQuery(query);

	
		}//closing try
	
	catch(Exception ex)
	{
		JOptionPane.showMessageDialog(null,"Sorry, there was a problem with inserting new Customer, check sql connection",null,JOptionPane.ERROR_MESSAGE);
		
	}//closing catch block

This post has been edited by macosxnerd101: 25 November 2010 - 03:21 PM
Reason for edit:: Please use code tags

[macosxnerd101]

Can you print out the Exception to your console and post the Stack Trace?