Re: Sync server with oracle database
Lukas Zeller <luz@...
2012-04-23 20:23:54 GMT
On Apr 23, 2012, at 4:06 , zhou lei wrote:
> I am working on Funambol server for a week, and it just could not connect to the oracle db. And I am not good at
java, and using maven an ant is not that easy.
> And I was think about that, if using the libsynthesis it could be easy, dosen't it?
It depends on how complicated your database schema is. If you can map the fields from the <fieldlist> more or
less 1:1 to fields in your database, this is indeed easy to do with libsynthesis. You can do the mapping in
the XML config, with no need to code anything in Java.
You'd need to install the ODBC driver for Oracle though, as libsynthesis uses ODBC to connect to databases.
> Is there a useful demo server for linux ?
Not based on libsynthesis at this time.
Synthesis still provides a full server as a commercial product, and there are free demo and eval packages of
a complete server you can download from their site. The database connection part of these is exactly the
same as in opensource libsynthesis, so to check if integration with your Oracle DB works you could use the
Synthesis EVAL version.
After that, it'll be a make or buy decision wether you want to license the server from them, or build your own
based on libsynthesis. The database connection will be the same.
To make a server out of libsynthesis, what needs to be done outside libsynthesis is the connection to the
HTTP transport, and session handling (SyncML session objects must be kept around between HTTP requests
until the entire session completes or is aborted).
The opensource SyncEvolution project has done this, however SyncEvolution has quite some complexity of
its own so I don't know how easy it would be to use the HTTP transport code from SyncEvolution.
Lukas Zeller, plan44.ch
luz@... - www.plan44.ch