prepareStatement() returns 0 value

[Tijo Mathew]

Hi

I am using the following code in struts. When i call this method from an action class, it prints null value. It not inserting values in to database. Any help is appreciable.

public String authenticateUser(String buttonAction, String [] valuesOfFields)
{
		int n=0;
		try
		{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			con=DriverManager.getConnection("jdbc:mysql://localhost:3306/usermaintenancedb", "root", "root");
		}
		catch(Exception dbConnect)
		{
			System.out.println("error in Db connection method getDbConnection()"+dbConnect.getCause());
		}
         	int len=valuesOfFields.length;
		String query="INSERT INTO userinfotbl (username,password,firstname,middlename,lastname,gender,dateofbirth,
emailid,mobileno,landno,address,city,state,pincode) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
		
		try
		{
			pstmt=con.prepareStatement(query);
			int j=0;
			for(int i=0;i<len;i++)
			{
				++j;
				pstmt.setString(j,valuesOfFields[i]);
			}
			
			 n=pstmt.executeUpdate();
		}
		catch(Exception db)
		{
			System.out.println("error in prepared statement authenticateUser()"+db.getCause()+n);
			return "failure";
		}
		return "success";
	}

Thanks in advance

[Rob Spoor]

Just call db.printStackTrace(). It will show you the error itself, and its cause if it has one.

[Tijo Mathew]

thanks...i rectified the error....

[Rob Spoor]

Would you mind telling us what the error was? That way somebody else may learn from it in the future.

[Tijo Mathew]

actually it was date mismatching with MYSQL date data type. I got through using the db.printStackTrace() in my code. Thanks for help.

[Rob Spoor]

You're welcome