Hello
Current, there is not a specific DB component (like tMySQLInput for MySQL database) for Lotus Domino database. You can report a feature on our bugtracker.
Best regards
shong
Hi, I found a solution... When you use the JDBC driver for Lotus Domino, you can do SQL queries. These queries can be done either on a form (select LastName from MSKPerson) or on the database's title (select LastName from Annuaire where form='MSKPerson'). The first query doesn't return fields included in subforms, the second one does. Regards. -- R
We have a set of connectors (tNotesInput, tNotesOutput, tNotesRunAgent, etc) that integrate with Lotus Domino without needing to install and maintain the NotesSQL or JDBC drivers. Send me an email if you need more details.
_________________
Joe Wichowski
EBIZ Technology
www.ebiztech.com
Joe is there anyway I can get ahold of those connectors. I am having a difficult time using Generic ODBC to input information into a Lotus Notes database.
I'm also trying to use Talend and NotesSQL together.
Getting datas from Notes databases is OK.
But I can't insert datas into Notes.
I've made a classical job with 2 tDBInput/Output and a tMap componnent.
Here is the error message:
Starting job Alim_Centrales at 11:02 18/08/2009. connecting to socket on port 3642 connected connecting to socket on port 4654 connected Exception in component tDBOutput_1 java.sql.SQLException: Driver not capable at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(Unknown Source) at xales___decu.alim_centrales_0_1.Alim_Centrales.tMSSqlInput_1Process(Alim_Centrales.java:450) at xales___decu.alim_centrales_0_1.Alim_Centrales.runJobInTOS(Alim_Centrales.java:917) at xales___decu.alim_centrales_0_1.Alim_Centrales.main(Alim_Centrales.java:815) disconnected disconnected Job Alim_Centrales ended at 11:02 18/08/2009.
I was thinking to a authorization problem but I successfully inserted rows into the Notes table via the Talend SQL builder (right-click on my table, "Edit queries").
Does anyone have an idea?
I tried to debug the job, and obviously, the NotesSQL ODBC driver doesn't like the setAutoCommit...
I comment the line (in debug mode) and the job runs fine (OK it has failed but after more than 1000 insert)
Can I comment this line for each execution?
Is there any way of managing the commitment in an other way?
Hi, I saw your message about TOS and Lotus connection, I also have the same problem,could you tell me how to link it together? I configured odbc source in my laptop,and odbc testing is ok,then i open TOS to connect odbc source through "Generic DB" DB type,and fill in username and password, also datasource name, is the name I set in the "ODBC data source administrator". but always told me "connection failure,I need to change database setting" Connection failure. You must change the Database Settings. Data source name not found and no default driver specified Pls let me know how to connection,thanks
