log4j:ERROR failed to execute sql
java.sql.SQLException:listener refused the connection with the following error:
ORA-12505,TNS:listener does not currently kown of SID given int connect descript or
the Connection descriptior used by the client was :
192.168.23.6:1521:sge
重写了log4j的JDBCAppender类经过本人分析是log4j执行log4j.error("xxx")时候,日志插入的时候报的错误,但是还是无从下手,因为测试服务器和本机都没有异常,只有上传到正式服务器上才有异常真邪门了。。
java.sql.SQLException:listener refused the connection with the following error:
ORA-12505,TNS:listener does not currently kown of SID given int connect descript or
the Connection descriptior used by the client was :
192.168.23.6:1521:sge
重写了log4j的JDBCAppender类经过本人分析是log4j执行log4j.error("xxx")时候,日志插入的时候报的错误,但是还是无从下手,因为测试服务器和本机都没有异常,只有上传到正式服务器上才有异常真邪门了。。
the Connection descriptior used by the client was :
192.168.23.6:1521:sge数据库连接串写错呗,看看你的oracle的实例名是不是sge,ip地址对不对jdbc:oracle:thin:@192.168.23.6:1521:sge
你Overwrite了JDBCAppender? 有没有错。当然,我知道JDBCAppender本身的实现就不是很好。
java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found.
配置文件如下:
log4j.rootLogger=warn,db
log4j.appender.db=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.db.BufferSize=1
log4j.appender.db.URL=jdbc\:jtds\:sqlserver\://server\:1434/pcbsyn
log4j.appender.db.driver=net.sourceforge.jtds.jdbc.Driver
log4j.appender.db.user=sa
log4j.appender.db.password=711
log4j.appender.db.sql=insert into logInfo(userId,userName,lclass,lmethod,lTime,llevel,message) values ('%X{userId}','%X{userName}','%C','%M','%d{yyyy-MM-dd HH:mm:ss}','%p','%m')
log4j.appender.db.layout=org.apache.log4j.PatternLayout
有说是 insert into logInfo(userId,userName,lclass,lmethod,lTime,llevel,message) values ('%X{userId}','%X{userName}','%C','%M','%d{yyyy-MM-dd HH:mm:ss}','%p','%m')
这个的问题,困扰了许久。。谢谢,呵呵呵
'%d{ISO8601}'的ISO8601是嘛意思呢,