Issue #606 has been updated by Raphaël Ouazana. Category set to Core
Confirmed. If think you should sue someone: http://tools.lsc-project.org/projects/lsc/repository/entry/lsc/trunk/src/main/java/org/lsc/persistence/DaoConfig.java#L83 ---------------------------------------- Bug #606: LSC does not correctly manage multiple database connections http://tools.lsc-project.org/issues/606 Author: David Coutadeur Status: New Priority: Normal Assigned to: Category: Core Target version: 2.0.3 Problem in version: Here is my example : <databaseConnection> <name>mysql</name> <url>jdbc:mysql://OLD_HOST_IP/mybase</url> <username>OLD_HOST_MYSQL_USER</username> <password>OLD_HOST_MYSQL_PASSWORD</password> <driver>com.mysql.jdbc.Driver</driver> </databaseConnection> <databaseConnection> <name>postgresql</name> <url>jdbc:postgresql://NEW_HOST_IP/mynewbase</url> <username>NEW_HOST_PGSQL_USER</username> <password>NEW_HOST_PGSQL_PASSWORD</password> <driver>org.postgresql.Driver</driver> </databaseConnection> I use the first database connection in a destination service for a first task, and the second database connection in another destination service for a second task. As shown, the first databaseConnection is mysql, and the second is postgreSQL. When I launch the second task (postgre destination), I get an error : ERROR - com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in file:////etc/lsc/lsc-openldap-database//sql-map-config.d/User.xml. --- The error occurred while applying a parameter map. --- Check the updateUser-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.mysql.jdbc.MysqlDataTruncation This error indicates that the mysql driver is used, which is obviously an error. The first database section is loaded and the second is ignored. If I split this connector in two different lsc.xml files and I launch tasks separately, the connector behaves normally. Thus multiple database connection mangement should be reviewed. -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://tools.lsc-project.org/my/account
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-dev mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-dev
