Quantcast

JdbcLog error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

JdbcLog error

Derek Mahar
QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/



Must column "sendersubid" in the quickfix tables have a default value?  All of the tables in database quickfix have this column, but none of the columns have non-null default value.  Into which table does method JdbcLog.insert() attempt to insert an exception?  I cannot tell from this stack trace, but I'm guessing it's table "event_log".


JdbcLog cannot log SQLException due to recursive log errors!
java.sql.SQLException: Field 'sendersubid' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at quickfix.JdbcLog.insert(JdbcLog.java:159)
at quickfix.JdbcLog.onEvent(JdbcLog.java:124)
at quickfix.Session.<init>(Session.java:475)
at quickfix.DefaultSessionFactory.create(DefaultSessionFactory.java:183)
at quickfix.mina.SessionConnector.createSession(SessionConnector.java:141)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessions(AbstractSocketInitiator.java:162)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessionInitiators(AbstractSocketInitiator.java:83)
at quickfix.SocketInitiator.initialize(SocketInitiator.java:114)
at quickfix.SocketInitiator.start(SocketInitiator.java:89)
at com.opessoftware.FixController.main(FixController.java:72)
JdbcLog cannot log SQLException due to recursive log errors!
java.sql.SQLException: Field 'sendersubid' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at quickfix.JdbcLog.insert(JdbcLog.java:159)
at quickfix.JdbcLog.onEvent(JdbcLog.java:124)
at quickfix.Session.<init>(Session.java:489)
at quickfix.DefaultSessionFactory.create(DefaultSessionFactory.java:183)
at quickfix.mina.SessionConnector.createSession(SessionConnector.java:141)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessions(AbstractSocketInitiator.java:162)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessionInitiators(AbstractSocketInitiator.java:83)
at quickfix.SocketInitiator.initialize(SocketInitiator.java:114)
at quickfix.SocketInitiator.start(SocketInitiator.java:89)
at com.opessoftware.FixController.main(FixController.java:72)
JdbcLog cannot log SQLException due to recursive log errors!
java.sql.SQLException: Field 'sendersubid' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at quickfix.JdbcLog.insert(JdbcLog.java:159)
at quickfix.JdbcLog.onEvent(JdbcLog.java:124)
at quickfix.JdbcLog.onErrorEvent(JdbcLog.java:214)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.handleConnectException(IoSessionInitiator.java:193)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.pollConnectFuture(IoSessionInitiator.java:182)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.connect(IoSessionInitiator.java:161)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.run(IoSessionInitiator.java:143)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

--
Derek Mahar
1.514.316.6736 Home
1.514.316.7348 Mobile
1.514.461.3650 x230 Work
102-1365 boulevard René-Lévesque Est
Montréal QC H2L 2M1
Canada

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
_______________________________________________
Quickfixj-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quickfixj-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: JdbcLog error

Colin DuPlantis
QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/



Does this apply to you:

JdbcSessionIdDefaultPropertyValue The default value for Session ID bean properties is an empty string. Oracle treats this as a SQL NULL and that causes problems. This configuration setting allows you to set the default value for unspecified Session ID properties. Any nonempty string. "" (empty string)

I know you're using MySQL instead of Oracle, but, if your senderSubId column is set to NON-NULL, try setting this property to anything non-empty.

On 03/09/2016 02:10 PM, Derek Mahar wrote:
QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
QuickFIX/J Support: http://www.quickfixj.org/support/




Must column "sendersubid" in the quickfix tables have a default value?  All of the tables in database quickfix have this column, but none of the columns have non-null default value.  Into which table does method JdbcLog.insert() attempt to insert an exception?  I cannot tell from this stack trace, but I'm guessing it's table "event_log".


JdbcLog cannot log SQLException due to recursive log errors!
java.sql.SQLException: Field 'sendersubid' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at quickfix.JdbcLog.insert(JdbcLog.java:159)
at quickfix.JdbcLog.onEvent(JdbcLog.java:124)
at quickfix.Session.<init>(Session.java:475)
at quickfix.DefaultSessionFactory.create(DefaultSessionFactory.java:183)
at quickfix.mina.SessionConnector.createSession(SessionConnector.java:141)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessions(AbstractSocketInitiator.java:162)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessionInitiators(AbstractSocketInitiator.java:83)
at quickfix.SocketInitiator.initialize(SocketInitiator.java:114)
at quickfix.SocketInitiator.start(SocketInitiator.java:89)
at com.opessoftware.FixController.main(FixController.java:72)
JdbcLog cannot log SQLException due to recursive log errors!
java.sql.SQLException: Field 'sendersubid' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at quickfix.JdbcLog.insert(JdbcLog.java:159)
at quickfix.JdbcLog.onEvent(JdbcLog.java:124)
at quickfix.Session.<init>(Session.java:489)
at quickfix.DefaultSessionFactory.create(DefaultSessionFactory.java:183)
at quickfix.mina.SessionConnector.createSession(SessionConnector.java:141)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessions(AbstractSocketInitiator.java:162)
at quickfix.mina.initiator.AbstractSocketInitiator.createSessionInitiators(AbstractSocketInitiator.java:83)
at quickfix.SocketInitiator.initialize(SocketInitiator.java:114)
at quickfix.SocketInitiator.start(SocketInitiator.java:89)
at com.opessoftware.FixController.main(FixController.java:72)
JdbcLog cannot log SQLException due to recursive log errors!
java.sql.SQLException: Field 'sendersubid' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at quickfix.JdbcLog.insert(JdbcLog.java:159)
at quickfix.JdbcLog.onEvent(JdbcLog.java:124)
at quickfix.JdbcLog.onErrorEvent(JdbcLog.java:214)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.handleConnectException(IoSessionInitiator.java:193)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.pollConnectFuture(IoSessionInitiator.java:182)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.connect(IoSessionInitiator.java:161)
at quickfix.mina.initiator.IoSessionInitiator$ConnectTask.run(IoSessionInitiator.java:143)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

--
Derek Mahar
1.514.316.6736 Home
1.514.316.7348 Mobile
1.514.461.3650 x230 Work
102-1365 boulevard René-Lévesque Est
Montréal QC H2L 2M1
Canada


------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140


_______________________________________________
Quickfixj-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quickfixj-users

-- 
Colin DuPlantis
Chief Architect, Marketcetera
Download, Run, Trade
888.868.4884 +1.541.306.6556
http://www.marketcetera.org

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
_______________________________________________
Quickfixj-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quickfixj-users
Loading...