How to connect to multi database with different LCODE simultaneously? (DBMR3134)

~ 0 min
2020-04-22 11:16

 

       From DBMaker 5.4.3, we fix the problem. You can connect to multi database with different LCODE simultaneously.

 

It is a restriction before DBMaker 5.4.3. DBMaker cannot connect to multi database with different LCODE setting simultaneously. You can connect another database after closing first connection. If you cannot close first connection, and we found a workaround as following steps:

 

  1. Install another DBMaker ODBC driver in different directory.
  2. Create DSN for second database.
  3. Use Sun JDBC driver (1.7 or lower JDK) in JAVA code to connect second DB.
  4. From JDK 1.8, Sun JDBC wouldn't be supported. Therefore, from DBMaker 5.4.2, we added a new JDBC type (dbmaker-odbc) to replace Sun JDBC to connect other Database for heterogeneous asynchronous table replication.

 

For this issue, we can also use this new JDBC type.

Class.forName("dbmaker.sql.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:dbmaker:DB_NAME","UID","PWD");

 

Version: DBMaker 5.4.2

Product: Normal/Bundle

Platform: Windows/Linux

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags