java - Which SqlDriver should be used to log FIX sessions, messages in SQL server database? -

I have a Java application that I need to store logging data such as session, messages and events in the SQL Server database Logs. I am referring to SQLjdbc4.jar for database connectivity using com.microsoft.sqlserver.jdbc.SQLServerDriver. With this I also used all the supporting jars (for example proxool.jar, com.springsource.org.logicalcobwebs.cglib.core-0.9.1.jar). However, I am unable to connect and log data to the database. In the code, any of your worms or jars is used

The exception is as follows:?

info: [FIX.4.4: FIXCLIENT- & gt; FIXSERVER] every day, 00: 00: 00-UTC - 00: 00: 00-UTC information FXClient - Error log Error: Session Initiation error during quickfix.ConfigError: quickfix.mina.initiator.AbstractSocketInitiator.createSessions start session (AbstractSocketInitiator Java: 169) quickfix.mina.initiator.AbstractSocketInitiator.createSessionInitiators (AbstractSocketInitiator.java:84) on quickfix.SocketInitiator.start (SocketInitiator.java:64 on quickfix.SocketInitiator.initialize (SocketInitiator.java:86)) customer on .FXClient.login (FXClient.java:137) due on client.FXClient.startClient client.FXClient.main (FXClient.java:76) (FXClient.java:59): quickfix.RuntimeError: com.microsoft. Sqlserv Er.jdbc.SQLServerException: Host ABC connection, designated name XYZ_2008 has failed. Error: "java.net.SocketTimeoutException: Check Get deadline" server and instance name, check that the firewall port is not blocking UDP traffic for 1434, and verify that the SQL Server 2005 or later The SQL Server Browser service is running on the host.

Common database connectivity is working fine with SQL Server only.

"itemprop =" text ">

This problem is of quickfixj jdbc logging. I have solved this issue using the SQL data source. I find SQL data source object is determined as JDBC Stoarfaccr and Jedibisielogfractori Datasrs I QuickFIXJ provides all the necessary utilities, please press the code snippet.

  jdbcStoreFactory objJSF = new JdbcStoreFactory (settings); JdbcLogFactory objJLF = new JdbcLogFactory (settings); SQLServerDataSource DS = New SQLServerDataSource (); Ds.setServerName (& lt; SERVER_NAME); Ds.setDatabaseName (& lt; quickfix_database_name & gt;); Ds.setInstanceName (& lt; instance_name & gt;); Ds.setIntegratedSecurity (AUTHMODE.toUpperCase (.) Contains ("WINDOW")? True: incorrect); ObjJSF.setDataSource (DS); ObjJLF.setDataSource (DS); StoreFactory = objJSF; LogFactory = objJLF; MessageFactory Message Factory = New MessageFactory (); Initiator = new socket initiator (application, storefront, settings, logfactory, messagefactor);