public int writeArticle(ReboardDTO reboardDTO) {

int seq = this.getNextSeq();

BoardDTO boardDTO = new BoardDTO();

BoardTypeDTO boardtypeDTO = new BoardTypeDTO();

String sql = "";

sql += "insert \n";

sql += "       into board (seq, id, name, email, subject, content, hit, logtime, btype) \n";

sql += "       values (?, ?, ?, ?, ?, ?, 0, sysdate, ?) \n";

sql += "       into reboard (seq, ref, lev, step, pseq, reply) \n";

sql += "       values (?, ?, ?, ?,?,?) \n";

try {

conn = getConnection();

pstmt=conn.prepareStatement(sql);

pstmt.setInt(1, seq);

pstmt.setString(2, reboardDTO.getId());

pstmt.setString(3, reboardDTO.getName());

pstmt.setString(4, reboardDTO.getEmail());

pstmt.setString(5, reboardDTO.getSubject());

pstmt.setString(6,reboardDTO.getContent());

pstmt.setInt(7, seq);

pstmt.setInt(8, reboardDTO.getBtype());

pstmt.setInt(9, reboardDTO.getRef());

pstmt.setInt(10, reboardDTO.getLev());

pstmt.setInt(11, reboardDTO.getStep());

pstmt.setInt(12, reboardDTO.getPseq());

pstmt.setInt(13, reboardDTO.getReply());

int r = pstmt.executeUpdate();

if(r>0){

conn.commit();

}else{

conn.rollback();

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

Close(pstmt);

Close(conn);

}

//sql += "select * from dual \n";

return seq;

}


DAO를 만들어서 쿼리를 돌리는데

자꾸 ORA-00933: SQL command not properly ended 에러가 떠서요 ... 

어디 쿼리문이 이상한가요? 제 눈에는 하도 안보여서 ..