replication / synchronization with MaxDB using Windows

[Former Member]

Hi,

is there somewhere a tutorial how to use replication / synchronization with MaxDB using Windows?

I found information about the Synchronization Manager but it seems that it's no more available for Download.

The Database Studio description points out that it will be useable for MaxDB 7.7 and upper versions,

but I can't also find V7.7 anywhere for download...

So do I need and where can I get it?

Thanks,

Andre

[Former Member · Accepted solution]

Hello,

I reproduced your situation with a MaxDB installation.

I downloaded the Eclipse 3.4 SDK an copied the following files

org.eclipse.core.commands_3.4.0.I20080509-2000.jar

org.eclipse.equinox.common_3.4.0.v20080421-2006.jar

org.eclipse.jface.text_3.4.1.r341_v20080827-1100.jar

org.eclipse.jface_3.4.1.M20080827-2000.jar

org.eclipse.osgi_3.4.0.v20080605-1900.jar

org.eclipse.swt.win32.win32.x86_3.4.1.v3449c.jar

org.eclipse.text_3.4.0.v20080605-1800.jar

swt-win32-3449.dll

plus the j2ee.jar file.

in the directory

"C:\Documents and Settings\All Users\Application Data\sdb\data\app\syncman\extern"

With these files the SyncManGUI did start.

Best Regards

Wolfgang

[Former Member · Accepted solution]

Thanks one more - the syncmangui starts now ...

[Former Member]

Hello,

the matching dll is packed in the swt.jar file. Please extract the swt.win*.dll and copy it to

-Djava.library.path=<path to dll>.

Best Regards

Wolfgang

[Former Member]

Hello,

> Is this the right point to give up ....?

No.

The problem is that the swt.jar does not match the swt*.dll.

Please go to

http://www.eclipse.org/swt/ and use the jar and the dll from the package you choose.

Best Reagrds

Wolfang

[Former Member]

Hello,

it seems that the native dll needed by swt.jar does not fit or is not found.

Please check the value of -Djava.library.path=<path to dll>.

The package the you took the swt.jar/jface.jar should contain swt-win32-2128.dll too.

Best Regards

Wolfgang

[Former Member]

Hi Wolfgang,

I'm sorry about, I found the 2428 package nowhere.

The oldest version I could get was 2436, so I get it and renamed the URL.

It looks a little bit better now (less errors) - but of course it desn't work ...

C:\Program Files\sapdb\indep_prog\bin>Exception in thread "main" java.lang.NoCla

ssDefFoundError: org/eclipse/swt/custom/MovementListener

at com.sap.sdb.syncMan.gui.SyncManGUI.createContents(SyncManGUI.java:321

)

at org.eclipse.jface.window.Window.create(Window.java:348)

at org.eclipse.jface.window.Window.open(Window.java:637)

at com.sap.sdb.syncMan.gui.SyncManGUI.run(SyncManGUI.java:475)

at com.sap.sdb.syncMan.gui.SyncManGUI.main(SyncManGUI.java:896)

Is this the right point to give up ....?

Thanks,

Andre

[Former Member]

Ok, as I'm a novice with java maybe I'm doing something wrong.

I'd DL the file swt-3.4-win32-win32-x86.zip from http://www.eclipse.org/swt/.

Than I copy the file swt.jar to the directory C:\Program Files\sapdb\indep_data\app\syncman\extern

and extract also the DLLs to this dir.

When I now execute SyncManGui the result ist:

Exception in thread "main" java.lang.NoClassDefFoundError: org/eclipse/core/runt

ime/Assert

at org.eclipse.jface.text.Position.<init>(Position.java:62)

at org.eclipse.jface.text.DefaultPositionUpdater.<init>(DefaultPositionU

pdater.java:51)

at org.eclipse.jface.text.TextViewer.<init>(TextViewer.java:1499)

at com.sap.sdb.syncMan.tool.ProtocolViewer.<init>(ProtocolViewer.java:89

)

at com.sap.sdb.syncMan.gui.SyncManGUI.createContents(SyncManGUI.java:321

)

at org.eclipse.jface.window.Window.create(Window.java:348)

at org.eclipse.jface.window.Window.open(Window.java:637)

at com.sap.sdb.syncMan.gui.SyncManGUI.run(SyncManGUI.java:475)

at com.sap.sdb.syncMan.gui.SyncManGUI.main(SyncManGUI.java:896)

Regards,

Andre

[Former Member]

Hello,

instead of the previous proposal you could try what was propsed here

-

---

Your MaxDB installation contains a python script, under

<your independent program path>app/syncman/syncman_caller.py

Could you temporarily (i.e. make a backup copy)

modify line 21, so that it reads:

JAVAWBASENAME = 'java'

,run 'syncmangui' again and post the output?

-

---

Best Regards

Wolfgang

[Former Member]

Hi Wolgang,

thanks for your support - this is the output:

C:\Program Files\sapdb\indep_prog\bin>Exception in thread "main" java.lang.Unsat

isfiedLinkError: no swt-win32-2128 in java.library.path

at java.lang.ClassLoader.loadLibrary(Unknown Source)

at java.lang.Runtime.loadLibrary0(Unknown Source)

at java.lang.System.loadLibrary(Unknown Source)

at org.eclipse.swt.internal.Library.loadLibrary(Library.java:104)

at org.eclipse.swt.internal.win32.OS.<clinit>(OS.java:42)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at org.eclipse.swt.internal.Library.getPlatform(Library.java:49)

at org.eclipse.swt.internal.Library.loadLibrary(Library.java:83)

at org.eclipse.swt.internal.Callback.<clinit>(Callback.java:31)

at org.eclipse.swt.SWT.getPlatform(SWT.java:2227)

at org.eclipse.swt.SWT.<clinit>(SWT.java:2368)

at org.eclipse.jface.action.ActionContributionItem.<clinit>(ActionContri

butionItem.java:60)

at org.eclipse.jface.action.ContributionManager.insertAfter(Contribution

Manager.java:268)

at com.sap.sdb.syncMan.gui.SyncManGUI.drawMSG_LRU(SyncManGUI.java:1422)

at com.sap.sdb.syncMan.gui.SyncManGUI.createMenuManager(SyncManGUI.java:

428)

at org.eclipse.jface.window.ApplicationWindow.addMenuBar(ApplicationWind

ow.java:223)

at com.sap.sdb.syncMan.gui.SyncManGUI.<init>(SyncManGUI.java:230)

at com.sap.sdb.syncMan.gui.SyncManGUI.main(SyncManGUI.java:821)

Thanks,

Andre

[thorsten_zielke]

Hi Andre,

let me add that the current Synchronization Manager project status is 'on hold'. So there is no further development at the moment, partly because we did not see much customer interest in that.

Any particular use case you require the Synchronization Manager for?

Thorsten Zielke

[Former Member]

Hi Thorsten,

yes for sure - well it hadn't been so easy at beginning with SAP DB as I found much more threads about other databases, but now I love it more and more ...

E. g. the sequence handling is very easy, the DB is easy to use and to install, it's fast and much cheaper than MS SQL Server etc. ...

SQL Studio and DBM are very useful and professional Tools I won't like to miss!

I like to migrate any of my projects to the MaxDB and because of I'm still developing one which works for a long time with a buggy MS Access replication my customer agree with a migration to MaxDB.

But for this there's need to found a solution for replication, that's the reason for the question ...

Regards,

Andre

[Former Member]

Hi,

you can start here to find out what kind of replication you want to realize.

http://maxdb.sap.com/doc/7_6/72/7ed43fb9490c65e10000000a114b1d/content.htm

If the Synchronization Manager (and not the MaxDB Loader http://maxdb.sap.com/doc/7_6/59/025741c0c28447e10000000a1550b0/content.htm)

is really what you need you can start here.

http://maxdb.sap.com/doc/7_6/67/73f34026d70b06e10000000a155106/content.htm

As Thorsten mentioned before there is no further development at the moment for the Synchronization Manager.

Best Regards

Wolfgang

[Former Member]

Hi Wolfgang,

I'd installed like descipted but I get an error Could not find the main class. Program will exit.

Like in this thread http://forums.mysql.com/read.php?41,58513,58513#msg-58513

Do you have an solution for?

Thanks,

Andre

[Former Member]

Hello,

do you receive the error starting the MessageServer, SyncService or the SyncManGUI (verison 7.6)?

Best Regards

Wolfgang

[Former Member]

When I start syncmangui.cmd

[Former Member]

Hello,

did you put all necessary SWT files (j2ee.jar,osgi.jar, jface.jar, jfacetext.jar, swt.jar, text.jar, runtime.jar,swt-win32-*.dll) in the directory <INDEPDATAPATH>/app/syncman/extern?

You can detemine the INDEPDATAPATH with "dbmcli dbm_getpath INDEPDATAPATH".

Best Regards

Wolfgang

[Former Member]

Yes, I hope I get them all but the error is the same.

I'm a novice with JAVA but I think this looks not so bad:

Verzeichnis von C:\Program Files\sapdb\indep_data\app\syncman\extern

22.06.2005 20:16 1.553.403 itext-1.3.1.jar

22.04.2005 20:04 512.737 jface-3.0.1.jar

28.06.2007 21:14 844.786 org.eclipse.jface.text_3.3.0.v20070606-0010.jar

28.06.2007 21:14 233.481 org.eclipse.text_3.3.0.v20070606-0010.jar

22.04.2005 18:31 47.992 osgi-3.0.1.jar

22.04.2005 20:04 355.171 runtime-3.0.1.jar

30.05.2008 12:08 32.768 swt-awt-win32-3448.dll

30.05.2008 12:08 77.824 swt-gdip-win32-3448.dll

30.05.2008 12:08 40.960 swt-wgl-win32-3448.dll

26.02.2003 13:22 1.002.299 swt-win32-2.1.0.jar

30.05.2008 12:08 335.872 swt-win32-3448.dll

30.05.2008 12:08 61.440 swt-xulrunner-win32-3448.dll

As people told me there's no need to rename the archives because of JAVA force the jar archives ...?

The returned INDEPDATAPATH seems to be right: C:\Program Files\sapdb\indep_data\

Thanks,

Andre

[Former Member]

Hello,

could you start the SyncManGUI manually by calling the main class.

e.g.:

java -Djava.library.path=lib classpath .\lib;.\lib\runtime.jar;.\lib\osgi.jar;.\lib\jface.jar;.\lib\jfacetext.jar;.\lib\swt.jar;.\lib\text.jar;.\lib\sapdbc.jar;.\lib\msgserver.jar;.\lib\syncservice.jar;.\lib\syncmangui.jar;.\lib\j2ee.jar com.sap.sdb.syncMan.gui.SyncManGUI

If it flails can you send me the stack trace?

Best regards

Wolfgang

[lbreddemann]

Hi Andre,

the Synchronization Manager is part of the MaxDB distribution that you can download here on SDN.

A tutorial is afaik not available, however by reading the documentation [Synchronization Manager|http://maxdb.sap.com/doc/7_6/67/73f34026d70b06e10000000a155106/content.htm] you should be able to implement a synchronization solution.

regards,

Lars