注册
异常
java.sql.SQLException: ORA-00984: 列在此处不允许
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at com.baizhi.dao.UserDAOImpl.add(UserDAOImpl.java:29)
at com.baizhi.service.UserServiceImpl.register(UserServiceImpl.java:31)
at com.baizhi.test.UserTest.TestRegister(UserTest.java:29)
解决
String sql = “insert into users values(?,?,?,sysdate,?)”;
写成
String sql = “insert into users values(?,?,?,system,?)”;