https://issues.apache.org/bugzilla/show_bug.cgi?id=50817

           Summary: The JDBCAppender can't insert log info like
                    this:hello'world
           Product: Log4j
           Version: 1.2
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Appender
        AssignedTo: [email protected]
        ReportedBy: [email protected]


If the log content has the "'",then I can't insert into database.

for example:

log.info("hello'world");

then the error information:

log4j:ERROR Failed to excute sql
java.sql.SQLException: ORA-00917: 缺失逗号
    at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:945)
    at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1167)
    at
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1613)
    at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1578)
    at org.apache.log4j.jdbc.JDBCAppender.execute(ESBJDBCAppender.java:92)

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to