Hi, i have integrated kettle in a web application.
As long as i do not use any datasources everything works fine.
When i run a job that executes a step like "execute SQL script", that
needs a database connection, i get the following error.

2011/09/23 14:57:14 - DROP table - ERROR (version 4.2.0-GA, build
15694 from 2011-08-24 11.46.44 by buildguy) : An error occurred
executing this job entry :
2011/09/23 14:57:14 - DROP table - ERROR (version 4.2.0-GA, build
15694 from 2011-08-24 11.46.44 by buildguy) : Error occured while
trying to connect to the database
2011/09/23 14:57:14 - DROP table - ERROR (version 4.2.0-GA, build
15694 from 2011-08-24 11.46.44 by buildguy) :
2011/09/23 14:57:14 - DROP table - ERROR (version 4.2.0-GA, build
15694 from 2011-08-24 11.46.44 by buildguy) :
javax.naming.NoInitialContextException: Cannot instantiate class:
org.osjava.sj.SimpleContextFactory [Root exception is
java.lang.ClassNotFoundException: org.osjava.sj.SimpleContextFactory]
2011/09/23 14:57:14 - DROP table - ERROR (version 4.2.0-GA, build
15694 from 2011-08-24 11.46.44 by buildguy) : Cannot instantiate
class: org.osjava.sj.SimpleContextFactory

The step has been configured to use aJNDI connection.
The web app runs under tomcat. I have created a context.xml file in
the conf directory of tomcat with the following content.
<Resource name="jdbc/productmaster" auth="Container"
type="javax.sql.DataSource"
maxActive="20" maxIdle="5"
maxWait="10000" username="root" password="vp1baj9j"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://bebrpmdev:3306/productmaster_dev"
validationQuery="select 1 from dual"/>
But this is not enough to get it going. What should i do to get it
working?

--
You received this message because you are subscribed to the Google Groups "kettle-developers" group.
To post to this group, send email to kettle-developers (AT) googlegroups (DOT) com.
To unsubscribe from this group, send email to kettle-developers+unsubscribe (AT) g...oups (DOT) com.
For more options, visit this group at http://groups.google.com/group/kettle-developers?hl=en.