Jump to content

Mirrorsync with Oracle and SQL Server: JDBC setup?

This topic is 2248 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

We are trying to use MirrorSync 1) for two way synchronization of FileMaker tables with tables in Oracle server, 2) for one way synchronization from a view in SQL Server to a table in FileMaker.

Trouble is, MirrorSync will not connect by JDBC to either Oracle or SQL Server. We are beginners in JDBC, and we sorely miss documentation for the topic:

What conditions have to be met by Oracle and by SQL Server for MirrorSync to be able to connect?

We are trying what we believe is the correct connect string(s) towards Oracle. SQL Server is set up to use Windows authentication (that is, accepting a login based on AD entities).

What documentation or other advice is available?


Update: We may seem to succeed with Oracle now. But SQL Server is still unsolved.

The article https://msdn.microsoft.com/en-us/library/ms378428%28v=sql.110%29.aspx shows syntax of connection URLs even for Windows integrated authentication - but to no use, as this field is not open for editing in the MirrorSync configuration dialogue for SQL Server. We have tried using the entry for JDBC Database, like this:

Description: JDBC Database SQL Server
Host: <name - single or fully qualified - or IP address>
JDBC Driver Class Name: com.prosc.mirror.model.CustomJDBCProperties <which it asked for until we provided it>
JDBC URL: jdbc:sqlserver://<host>:1433;integratedSecurity=true;authenticationScheme=JavaKerberos

Name and password should not be necessary for integrated security, and if we provide them, SQL Server logs error as "Login failed for user <username>. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only."

Without, we get error message that "The authentication Scheme JavaKerberos: is not valid" or without the javaKerberos clause, that "The property integratedSecurity does not contain a valid boolean value. Only true or false can be used." as if we didn't write "true" in the first place. What does MirrorSync want?

How do we know what JDBC driver Mirrorsync is using?

Edited by Jon Egil Brekke
New and relevant info
Link to comment
Share on other sites

I think that MirrorSync is either using the 4.0.2 or 4.1 drivers from Microsoft. It's hard to tell because the jar files are all named the same thing, I'm just going by the release date of March 27, 2014.

Link to comment
Share on other sites

This topic is 2248 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.