Re: [Quickfixj-users] JDBC Store Factory Configuration

[Toli K. <to...@ma...>]

Evangelos,

We are using the JdbcLog as well.
You need to specify the following variables in your config file:
JDBC log
JdbcDriver=org.postgresql.Driver
JdbcURL=jdbc:postgresql://<machine>/<schema_name>
JdbcUser=user
JdbcPassword=password

In your case, you'll need to substitute the right Postgres driver and
jdbc URL to connect to postrgres. Also, make sure that you have both
the postgres driver and Proxool 0.9.0rc2 in the runtime classpath.
(you may need to check the var values, we use mysql so i'm doing
postgresql from memory. And you don't need JNDI stuff unless you do
JNDI lookups)

If you already have your vars defined in the config file, you can just
use them to create the JdbcLogFactory and pass that on to the
SocketInitiator.

You can see the example of it in our QuickfixInitiator code posted
online at http://trac.marketcetera.org/trac.fcgi/browser/platform/trunk/core/src/main/java/org/marketcetera/quickfix/QuickFIXInitiator.java#L47

Baically, you do this:
1. read the values from config file and set them in the SessionSettings object
2. Create the JDBC log factory from the settings
3. pass the log factory to the SocketInitiator

hope this helps.


On 10/3/06, Papacostantis <dev...@va...> wrote:
> QuickFIX/J Documentation: http://www.quickfixj.org/documentation/
> QuickFIX/J Support: http://www.quickfixj.org/support/
> I am attempting to use the JDBC store factory and need to
> define the following fields in the configuration:
> JndiContextFactory
> JndiProviderURL
> JDBCDatasourceName
>
> I am not quite sure what values to use though...Im attempting to
> store messages in a postgres database, which I have already
> setup and defined in the configuration. Im not familiar with
> these three parameters which are required. If someone could
> explain these to me and maybe provide examples.
>
> Thanks.
>
> Evangelos
>

-- 
Toli Kuznets
http://www.marketcetera.com: Open-Source Trading Platform
download.run.trade.