title: SQL in Prepared Statement throwing SQL exception
body: <p>I'm trying to figure out why this code is throwing an SQL exception. When I run this code it prints "Bad SQL in customer insert ps", which is the message in that inner catch block. I've got multiple prepared statements with SQL inserts like this both in this class and also elsewhere in my application. They're all working fine. I've looked through this one over and over again, and I can't figure out why this one is throwing an exception.</p>
  
  <pre><code>try {
                  Connection conn = DBconnection.getConnection();
                  PreparedStatement ps = conn.prepareStatement("SELECT customerId FROM customer WHERE customerName=\"" + name + "\";");
                  System.out.println(ps.toString());
                  ResultSet rs = ps.executeQuery();
  
                  if (rs.next()) {
                      customerId = rs.getString("customerId");
                  }
                  try {
  
                      PreparedStatement customerInsert = DBconnection.getConnection().prepareStatement("INSERT "
                              + "INTO customer (customerName, addressId, active, createDate, createdBy, lastUpdate, lastUpdateBy)"
                              + "VALUES(\"" + name + "\", " + addressId + ", " + active + ", UTC_TIMESTAMP(), \"" + LogInController.getUserName() + "\", UTC_TIMESTAMP(), \"" + LogInController.getUserName() + "\");");
  
                      customerInsert.executeUpdate();
  
                      System.out.println(customerInsert.toString());
                      System.out.println(rs.toString());
  
                  } catch (SQLException sq) {
                  System.out.println("Bad SQL in customer insert ps");
                  }
  
              } catch (SQLException customerIdException) {
                  System.out.println("Bad SQL in customer ps");
              }
  </code></pre>