[Quickfixj-users] jdbc logging

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

I have another question regarding jdbc logging.  We use an oracle
database.  My dba set up all of the tables based on the sample SQL
scripts for the mysql database.  When I fire up the engine which is
configured with one session, I get the following log output to the
console:

-------

beginning initiator...
2007-04-26 10:19:06,478 DEBUG [main] proxool.ShutdownHook
(ShutdownHook.java:73) - Registered shutdownHook
2007-04-26 10:19:06,509 DEBUG [main] proxool.HouseKeeperController
(HouseKeeperController.java:84) - Registering 'quickfixj-1' house keeper
2007-04-26 10:19:06,509 DEBUG [main] proxool.HouseKeeperController
(HouseKeeperController.java:92) - Starting a house keeper thread
2007-04-26 10:19:06,697 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value: isReadOnly()
=3D false
2007-04-26 10:19:06,712 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value:
getHoldability() =3D 1
2007-04-26 10:19:06,728 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value:
getTransactionIsolation() =3D 2
2007-04-26 10:19:06,743 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value: getTypeMap()
=3D {SYS.XMLTYPE=3Dclass oracle.xdb.XMLTypeFactory}
2007-04-26 10:19:06,743 DEBUG [main] proxool.ConnectionResetter
(ConnectionResetter.java:168) - Remembering default value: getCatalog()
=3D null
2007-04-26 10:19:06,743 INFO  [main] proxool.ConnectionPool
(ConnectionPool.java:623) - Proxool statistics legend: "s - r  (a/t/o)"
> s=3Dserved, r=3Drefused (only shown if non-zero), a=3Dactive, t=3Dtotal,
o=3Doffline (being tested)
2007-04-26 10:19:06,743 DEBUG [main] proxool.Prototyper
(Prototyper.java:204) - 000000 (01/01/00) - Connection #1 created on
demand =3D ACTIVE
2007-04-26 10:19:06,993 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.jdbc.internal.ClientDataSupport
2007-04-26 10:19:06,993 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.jdbc.OracleConnection
2007-04-26 10:19:06,993 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.jdbc.internal.OracleConnection
2007-04-26 10:19:06,993 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface java.sql.Connection
2007-04-26 10:19:06,993 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface oracle.sql.ClobDBAccess
2007-04-26 10:19:06,993 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface oracle.sql.BlobDBAccess
2007-04-26 10:19:06,993 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.sql.BfileDBAccess
2007-04-26 10:19:08,243 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface java.sql.Statement
2007-04-26 10:19:08,243 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.jdbc.OracleStatement
2007-04-26 10:19:08,243 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.jdbc.OraclePreparedStatement
2007-04-26 10:19:08,243 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
java.sql.PreparedStatement
2007-04-26 10:19:08,243 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.jdbc.internal.OraclePreparedStatement
2007-04-26 10:19:08,243 DEBUG [main] proxool.ProxyFactory
(ProxyFactory.java:209) - Implementing interface
oracle.jdbc.internal.OracleStatement
quickfix.ConfigError: error during session initialization
	at
quickfix.mina.initiator.AbstractSocketInitiator.createSessions(AbstractS
ocketInitiator.java:132)
	at
quickfix.mina.initiator.AbstractSocketInitiator.<init>(AbstractSocketIni
tiator.java:73)
	at
quickfix.mina.initiator.AbstractSocketInitiator.<init>(AbstractSocketIni
tiator.java:65)
	at
quickfix.ThreadedSocketInitiator.<init>(ThreadedSocketInitiator.java:32)
	at
com.merlin.pb.fix.MerlinFIXInitiator.main(MerlinFIXInitiator.java:111)
Caused by: java.lang.RuntimeException: java.sql.SQLException: ORA-01400:
cannot insert NULL into ("FIX"."SESSIONS"."SESSION_QUALIFIER")

	at quickfix.JdbcStoreFactory.create(JdbcStoreFactory.java:44)
	at quickfix.Session.<init>(Session.java:270)
	at
quickfix.DefaultSessionFactory.create(DefaultSessionFactory.java:152)
	at
quickfix.mina.SessionConnector.createSession(SessionConnector.java:112)
	at
quickfix.mina.initiator.AbstractSocketInitiator.createSessions(AbstractS
ocketInitiator.java:126)
	... 4 more
Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into
("FIX"."SESSIONS"."SESSION_QUALIFIER")

	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
	at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.jav
a:182)
	at
oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStat
ement.java:630)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1081)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepare
dStatement.java:2905)
	at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStateme
nt.java:2996)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at
org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100
)
	at
org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:
57)
	at
$java.sql.Statement$$EnhancerByProxool$$a742985f.execute(<generated>)
	at quickfix.JdbcStore.loadCache(JdbcStore.java:130)
	at quickfix.JdbcStore.<init>(JdbcStore.java:65)
	at quickfix.JdbcStoreFactory.create(JdbcStoreFactory.java:42)
	... 8 more
2007-04-26 10:19:08,993 DEBUG [ShutdownHook] proxool.ShutdownHook
(ShutdownHook.java:93) - Running ShutdownHook
2007-04-26 10:19:08,993 INFO  [Shutdown Hook] proxool.ConnectionPool
(ConnectionPool.java:490) - Shutting down 'quickfixj-1' pool immediately
[Shutdown Hook]
2007-04-26 10:19:09,009 DEBUG [Shutdown Hook] proxool.ConnectionPool
(ConnectionPool.java:447) - 000001 (00/00/00) - #0001 removed because of
shutdown.
2007-04-26 10:19:09,009 DEBUG [Shutdown Hook] proxool.ConnectionPool
(ConnectionPool.java:553) - Connection #1 closed
2007-04-26 10:19:09,009 INFO  [Shutdown Hook] proxool.ConnectionPool
(ConnectionPool.java:570) - 'quickfixj-1' pool has been closed down by
Shutdown Hook in 16 milliseconds.
2007-04-26 10:19:09,009 INFO  [Shutdown Hook]
proxool.PrototyperController (PrototyperController.java:100) - Stopping
Prototyper thread
2007-04-26 10:19:09,009 INFO  [Shutdown Hook]
proxool.HouseKeeperController (HouseKeeperController.java:107) -
Stopping HouseKeeper thread

-----

Why is it trying to insert NULL initially in a column specifically set
to NOT NULL?  Is this JDBC logging just not compatible with an oracle
back-end?  We're using the latest oracle jdbc drivers and the latest
release of the quickfix/j engine...any thoughts?

Thanks,
Rob

Merlin Securities - #1 Prime Broker North America, #1 Prime Broker Single S=
trategy Funds, #1 Prime Broker Funds Under $100M - Global Custodian 2007

=20

--------------------------------------------------------

This message contains information from Merlin Securities, LLC, or from one =
of its affiliates, that may be confidential and privileged. If you are not =
an intended recipient, please refrain from any disclosure, copying, distrib=
ution or use of this information and note that such actions are prohibited.=
 If you have received this transmission in error, please notify the sender =
immediately by telephone or by replying to this transmission.
=20
Merlin Securities, LLC is a registered broker-dealer. Services offered thro=
ugh Merlin Securities, LLC are not insured by the FDIC or any other Federal=
 Government Agency, are not deposits of or guaranteed by Merlin Securities,=
 LLC and may lose value. Nothing in this communication shall constitute a s=
olicitation or recommendation to buy or sell a particular security.