Talend with DB2 MVS Connextion : Connection failure
La difficulté que je rencontre se matérialise par le message d'anomalie du produit :
Connection failure. You must change the Database Settings.
The application server rejected establishment of the connection. An attempt was made to access a database, BHC00003, which was not found. DB2ConnectionCorrelator: null
les paramètres qui sont utilisés sont :
DB Type : IBM DB2
Login de mon User MVS
Password de mon User MVS
Server : adresse IP du MVS
Port : celui du DB2 sur MVS
Database : BHC00003
(le pb se pose avec ou sans alimentation des paramètres DRDA du DB2 MVS)
ps : les paramètres DRDA du DB2 MVS sont situés dans les tables :
SYSIBM.LOCATIONS
SYSIBM.IPNAMES
SYSIBM.USERNAMES
Voyez-vous le problème qui se pose ?
Thank you, When I Specify "Cp1147" after having chose CUSTOM, I get the same message : Starting job Unload_DBDH at 17:03 19/02/2008. Exception in component tJDBCInput_1 com.ibm.db2.jcc.a.SqlException: unsupported encoding Cp1147 for result set column Not easy
Hi, thank you, to run Talend, we have installed the jre1.5.0_05 and it seems not using extended encoding set Cp1147, we're looking for it. Keep in touch
Bingo !
we took charsets.jar from a jre 1.6 and stored it in C:\Program Files\Java\jre1.5.0_05\lib
=> Starting job Unload_DBDH at 12:45 21/02/2008.
connecting to socket on port yyyy
connected
connecting to socket on port xxxx
connected
1030860 milliseconds
disconnected
disconnected
Job Unload_DBDH ended at 13:02 21/02/2008.
Thank you every one
