package?example.ch22;

import?org.pentaho.di.core.KettleEnvironment;
import?org.pentaho.di.core.database.Databasemeta;
import?org.pentaho.di.shared.Sharedobjects;
import?org.pentaho.di.trans.Trans;
import?org.pentaho.di.trans.Transmeta;

public?class?ChangeDatabaseInTrans?{
??public?static?void?main（String[]?args）?throws?Exception?{
????String?filename?=?args[0];
????
????KettleEnvironment.init（）;
????
????Databasemeta?databasemeta?=?new?Databasemeta（“DB“?“MySQL“?“JDBC“?“localhost“?“test“?“3306“?“user“?“password“）;
????
????Sharedobjects?sharedobjects?=?new?Sharedobjects（）;
????sharedobjects.storeobject（databasemeta）;
????sharedobjects.setFilename（“/tmp/shared.xml“）;
????sharedobjects.saveToFile（）;
????
????//?System.setProperty（Const.KETTLE_SHARED_objectS?“/tmp/shared.xml“）;
????
????Transmeta?transmeta?=?new?Transmeta（filename）;
????transmeta.setSharedobjectsFile（“/tmp/shared.xml“）;
????transmeta.readSharedobjects（）;
????
????Trans?trans?=?new?Trans（transmeta）;
????trans.prepareExecution（null）;
????trans.startThreads（）;
????trans.waitUntilFinished（）;
????
????if?（trans.getErrors（）!=0）?{
??????System.out.println（“Error“）;
????}
??}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-07-06?14:28??Pentaho?Kettle?Solutions\
?????文件????15590153??2012-07-06?14:22??pentaho?kettle?solutions.pdf
?????目錄???????????0??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\
?????文件?????????191??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\create_sakila_accounts.sql
?????文件???????15614??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\fetch_address.ktr
?????文件????????7868??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_dim_actor.ktr
?????文件???????12597??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_dim_customer.ktr
?????文件???????29141??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_dim_date.ktr
?????文件???????65137??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_dim_film.ktr
?????文件???????17289??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_dim_staff.ktr
?????文件???????20502??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_dim_store.ktr
?????文件???????20956??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_dim_time.ktr
?????文件???????33227??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_fact_rental.ktr
?????文件???????18295??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\load_rentals.kjb
?????文件??????712827??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\sakila-db.tar.gz
?????文件??????712768??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\sakila-db.zip
?????文件?????1100445??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\sakila-dwh.tar.gz
?????文件?????1118714??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\sakila-dwh.zip
?????文件??????184328??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\sakila-rental-star.architect
?????文件???????60352??2012-07-06?14:28??Pentaho?Kettle?Solutions\635179_code_ch04\sakila.architect
?????目錄???????????0??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\
?????目錄???????????0??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\
?????文件???????14097??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\CDC_Customers.ktr
?????文件???????13111??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\CDC_Timestamp_End.ktr
?????文件???????13887??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\CDC_Timestamp_Init.ktr
?????文件?????6263543??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\custfile1.txt
?????文件?????6302064??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\custfile2.txt
?????文件???????13614??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\sakila_custdiff.ktr
?????文件???????14970??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch06\ch6files\SAP?Input?Example.ktr
?????目錄???????????0??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch07\
?????目錄???????????0??2012-07-06?12:26??Pentaho?Kettle?Solutions\635179_code_ch07\ch7files\
............此處省略181個文件信息