I would read in this file with a tFileInputXML, set these values with a tJavaRow to context variables and use the context variable to configure the database connection. The JNDI (container managed database connection) access works only if you deploy the job into a Talend runtime or as war file (webapp).
Thanks jlolling. I need to use the JNDI (container managed database connection) as my job is deployed in Talend runtime. I may change the details within a bean in the Data Source XML file e.g. the database name and therefore I need to find a way to capture information from a bean's (that the tJDBCConnection component is pointing to) property tag with name = url (<property name="url" value="jdbc:sqlserver://Server1:1433;instanceName=Server1;databaseName=OneDB;schema=mySchema;"/>)in the Data Source file whenever my job encounters an error and then save that in a context variable so that the information can be sent as part of the error message to our error queue. Thanks