Hi Colm, please find my answers/comments inline. Il giorno 06/set/2012, alle ore 12.28, Colm O hEigeartaigh ha scritto:
> Hi all, > > Two questions about the database connector. > > a) When I look at the schema mappings that ships with the configuration in > embedded mode for one of the Connectors to a H2 backend (e.g. > resource-testdb), I see for example the USER Username mapped to an external > ID attribute in the backend, which is also marked as the mandatory AccountId. > However, there does not appear to be a way to reproduce this configuration in > the Console, unless I am missing something. If you delete this entry and > attempt to add another one, as soon as "AccountId" is ticked, the external > attribute disappears. Am I missing something here? If you mark an attribute as AccountId you cannot specify any external/remote attribute ID. It doesn't need looking at the connector framework: AccountId will be sent as __NAME__. The same is for the password. Btw embedded data should be modified. > b) If I attempt to create a User and assign it to the "resource-testdb", > propagation fails with: > > org.h2.jdbc.JdbcSQLException: Table "TEST" not found; SQL statement: > SELECT * FROM test WHERE id IS NULL [42102-168] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:329) Sorry but I cannot reproduce the problem. "TEST" table is created by the build-tools. Please look for exception into core.log or core-persistence.log. Please, let me know. F. > Colm. > > > -- > Colm O hEigeartaigh > > Talend Community Coder > http://coders.talend.com >
