Hi guys,

I experience a strange problem when doing the following:
Using CDA from inside the PUC we send the Query to a KTR file which should load some data.

However, the connection to the database cannot be established, causing such error messages:
Code:
INFO  07-06 16:54:41,225 - article_order - Dispatching started for transformation [article_order]
ERROR 07-06 16:54:41,266 - Database lookup - An error cause this step to stop: org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Error connecting to database: (using class org.gjt.mm.mysql.Driver)
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
ERROR 07-06 16:54:41,282 - Database lookup - Error initializing step [Database lookup]
ERROR 07-06 16:54:41,282 - article_order - Step [Database lookup.0] failed to initialize!
16:54:41,285 WARN  [EventPublisher] publishToCDV: plugin not available, ignoring request
log4j:ERROR Attempted to append to closed appender named [PENTAHOFILE].
16:54:41,286 ERROR [CdaContentGenerator] doQuery:
We failed to initialize at least one step.  Execution can not begin!
pt.webdetails.cda.dataaccess.QueryException:
We failed to initialize at least one step.  Execution can not begin!
        at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:178)
        at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:127)
        at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:263)
        at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:77)
        at pt.webdetails.cda.CdaCoreService.doQuery(CdaCoreService.java:187)
        at pt.webdetails.cda.CdaContentGenerator.doQuery(CdaContentGenerator.java:98)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at pt.webdetails.cpf.SimpleContentGenerator.invokeMethod(SimpleContentGenerator.java:324)
        at pt.webdetails.cpf.SimpleContentGenerator.createContent(SimpleContentGenerator.java:158)
        at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:142)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
The KTR is defined to use an existing JNDI-Connection which was successfully tested and created inside PAC.

Anybody got an idea on what´s wrong with that stuff?

Cheers and thx,

Tom