Does Sybase work with James?

["Li, Siyan (Toronto - BCE)" <si...@ml.com>]

Greetings,

I am new to James. I have set it up to run on file system with no
problems. Now, I am trying to change the stores to Sybase. I didn't see
Sybase listed in sqlResource.xml. I searched this list and the web
without any lock.

I hope somebody here could give a hand. Has anybody ever tried Sybase?
Or someone could give me a clue for where to start?

Thanks,

Siyan
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------

Re: Does Sybase work with James?

[Stefano Bagnara <ap...@bago.org>]

> Greetings,
> 
> I am new to James. I have set it up to run on file system 
> with no problems. Now, I am trying to change the stores to 
> Sybase. I didn't see Sybase listed in sqlResource.xml. I 
> searched this list and the web without any lock.
> 
> I hope somebody here could give a hand. Has anybody ever tried Sybase?
> Or someone could give me a clue for where to start?

You can change sqlResource.xml to add Sybase support: if you know sybase sql
this should be easy.

You need to add a <dbMatcher> tag for the sybase product name (I don't know
what's the product name).
Probably it contains the name used for the JDBCDriver.

You can then add the specific sql statement for each operation.

IMHO you can start from the "mssql" configuration as IIRC sybase and mssql
are similar.

Stefano

> Thanks,
> 
> Siyan


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org