kettle jndi

D:\data-integration\simple-jndi\jdbc.properties

 

tools-datasource

 

#SampleData/type=javax.sql.DataSource
#SampleData/driver=org.hsqldb.jdbcDriver
#SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
#SampleData/user=pentaho_user
#SampleData/password=password

 

mysql :

AAAA/type=javax.sql.DataSource
AAAA/driver=com.mysql.jdbc.Driver
AAAA/url=jdbc:mysql://localhost:3306/AAAA?zeroDateTimeBehavior=convertToNull&characterEncoding=GBK&useUnicode=true
AAAA/user=root
AAAA/password=root