problems setting up funambol <-> scalix connector

[struempelix]

Hi all,
I'm trying to setup the funambol <-> scalix connector without too much success. Whenever I trigger a contact sync using the java demo client I see funambol talking to scalix imap and fetching all my contacts. At a certain point the sync aborts and the exception below is thrown in funamobl-ds.log

My setup is:

a) Scalix 11.1
b) Funambol DS 6.0.6
c) Funambol-Scalix Connector 0.6.36
d) Salix and Funambol in seperate Tomcats but on the same server

Any idea?

Thanks,
jens

Code: Select all


[2007-08-25 14:22:11,948] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ScalixDAO open done
[2007-08-25 14:22:11,948] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] CachedSyncSource beginSync
[2007-08-25 14:22:11,948] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] Syncmode : SLOW
[2007-08-25 14:22:11,948] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ScalixSyncSource getAllSyncItemInfo
[2007-08-25 14:22:11,949] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ContactDAO getAllSyncItemInfo
[2007-08-25 14:22:11,949] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ScalixDAO getAllMessages
[2007-08-25 14:22:11,952] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ScalixDAO getAllMessages got 297 messages
[2007-08-25 14:22:12,897] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ContactDAO getAllSyncItemInfo done
[2007-08-25 14:22:12,898] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ItemStateDAO getLocalItems
[2007-08-25 14:22:12,903] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ItemStateDAO getLocalItems done
[2007-08-25 14:22:12,903] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] CachedSyncSource findNewItemIds
[2007-08-25 14:22:12,907] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] CachedSyncSource findUpdateItemIds
[2007-08-25 14:22:12,912] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] CachedSyncSource findDeleteItemIds
[2007-08-25 14:22:12,917] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ContactStateDAO addLocalItems
[2007-08-25 14:22:12,918] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ContactStateDAO addLocalItems done
[2007-08-25 14:22:12,918] [funambol.scalix] [TRACE] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] ContactStateDAO updateLocalItems
[2007-08-25 14:22:12,920] [funambol.scalix] [ERROR] [469F5B05A2B69F326AA0B31D3B7B39A7] [java-demo-client] [jens] [sx-con] java.sql.SQLException: Unexpected token: WH
ERE in statement [UPDATE fnbl_scalix_contacts SET last_modified=?, fileas=?, WHERE id=? AND source_uri=? AND principal=?]
java.sql.SQLException: Unexpected token: WHERE in statement [UPDATE fnbl_scalix_contacts SET last_modified=?, fileas=?, WHERE id=? AND source_uri=? AND principal=?]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
        at com.webstarsltd.scalix.engine.cache.ContactStateDAO.updateLocalItems(ContactStateDAO.java:117)
        at com.webstarsltd.scalix.engine.cache.CachedSyncSource.beginSync(CachedSyncSource.java:134)
        at com.webstarsltd.scalix.engine.source.ScalixSyncSource.beginSync(ScalixSyncSource.java:174)
        at com.funambol.server.engine.Sync4jEngine.sync(Sync4jEngine.java:553)
        at com.funambol.server.session.SyncSessionHandler.processModifications(SyncSessionHandler.java:1640)
        at com.funambol.server.session.SyncSessionHandler.processSyncMessage(SyncSessionHandler.java:1493)
        at com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:936)
        at com.funambol.server.session.SyncSessionHandler.processMessage(SyncSessionHandler.java:498)
        at com.funambol.server.engine.SyncAdapter.processInputMessage(SyncAdapter.java:467)
        at com.funambol.server.engine.SyncAdapter.processXMLMessage(SyncAdapter.java:215)
        at com.funambol.transport.http.server.LocalSyncHolder.processXMLMessage(LocalSyncHolder.java:78)
        at com.funambol.transport.http.server.Sync4jServlet.doPost(Sync4jServlet.java:293)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)




[philjohn]

Hi,

This is a small bug in the contact sync source, I left a stray comma in the SQL query.

I'm about to package up a new release that implements the last of the missing functionality (updates, had to be careful here, as doing a delete and an add could cause loss of data not passed back by the client, I'm looking at doing a merge before the re-add to get around this), the new release also fixes the bug you've described here.

If you really need this working quickly, you need to edit

com/webstarsltd/scalix/engine/cache/ContactStateDAO.java

remove the , before the WHERE statement in the update query and recompile.

If you checkout the source code, it's got an Eclipse IDE project setup, so it should be quite simple to make the change and recompile. The ANT (sory of like a make for Java) takes care of packaging the .s4j module for you in the bin/ directory.

best wishes,

Phil.

[struempelix]

Hi Phil,
thanks for your fast reply! I removed the comma a in ContactStateDAO.java but wasn't able to build the connector....I guess something wrong with my java/ant-version or eclipse setup.
Anyhow, cal sync failed as well "Error filling item with its data." , so I decided to wait until you release a new version of the connector and try it again.

.....and I really hope you will release a new version because this is cool stuff!!!

Thanks,
jens