jdbckettle - Project Hosting on Google Code

Older Aug 25, 2009 issue 12 (step names with dots cause NullPointerException) reported by xophos - What steps will reproduce the problem? 1. use Connection connection = DriverManager.getConnection("jdbc:kettle:file://...examplecsv.ktr"); 2. select * from "example.csv" this gives you a NullPointerException in the file KettleJDBCStatement.java the line: si1.addRowListener(listener); because the dot in the table name is eaten by the filename heuristics in the beginning. What is the expected output? What do you see instead? What version of the product are you using? On what operating system? Please provide any additional information below. there is a simple fix: i just added the line stepName=table; in the else branch of "if(f.isDirectory())" if(f.isDirectory()) { if( visitDirectory(f)) { //execute the transformation log.debug("file="+p.getKettleUrl()+File.separator+fileName+".ktr"); meta = new TransMeta(p.getKettleUrl()+File.separator+fileName+".ktr"); } } else { stepName=table; meta = new TransMeta(p.getKettleUrl()); // meta = new TransMeta(f.getAbsolutePath()); } that seems to work allright. What steps will reproduce the problem? 1. use Connection connection = DriverManager.getConnection("jdbc:kettle:file://...examplecsv.ktr"); 2. select * from "example.csv" this gives you a NullPointerException in the file KettleJDBCStatement.java the line: si1.addRowListener(listener); because the dot in the table name is eaten by the filename heuristics in the beginning. What is the expected output? What do you see instead? What version of the product are you using? On what operating system? Please provide any additional information below. there is a simple fix: i just added the line stepName=table; in the else branch of "if(f.isDirectory())" if(f.isDirectory()) { if( visitDirectory(f)) { //execute the transformation log.debug("file="+p.getKettleUrl()+File.separator+fileName+".ktr"); meta = new TransMeta(p.getKettleUrl()+File.separator+fileName+".ktr"); } } else { stepName=table; meta = new TransMeta(p.getKettleUrl()); // meta = new TransMeta(f.getAbsolutePath()); } that seems to work allright. Jan 09, 2009 r133 (change to server directory.) committed by ngood...@bayontechnologies.com - change to server directory. change to server directory. Jan 09, 2009 r132 (testing solution:) committed by ngood...@bayontechnologies.com - testing solution: testing solution: Jan 07, 2009 CommonClients Wiki page edited by ngood...@bayontechnologies.com Jan 07, 2009 PageName Wiki page deleted by ngood...@bayontechnologies.com Jan 07, 2009 JDBCDriver Wiki page edited by ngood...@bayontechnologies.com Jan 07, 2009 samples-0.1.r128.zip (JDBCKettle Samples) file uploaded by ngood...@bayontechnologies.com - Labels: Type-Archive Featured OpSys-All Labels: Type-Archive Featured OpSys-All Jan 07, 2009 jdbckettle-0.1.r128.jar (JDBCKettle JAR) file uploaded by ngood...@bayontechnologies.com - Labels: Featured OpSys-All Type-Archive Labels: Featured OpSys-All Type-Archive Jan 07, 2009 r128 (Basic examples. Small changes to get running on Pentaho 2.0) committed by ngood...@bayontechnologies.com - Basic examples. Small changes to get running on Pentaho 2.0 Basic examples. Small changes to get running on Pentaho 2.0 Jan 07, 2009 r127 (change package name. issue 11) committed by ngood...@bayontechnologies.com - change package name. issue 11 change package name. issue 11 Jan 07, 2009 r126 (remove jar in SVN) committed by ngood...@bayontechnologies.com - remove jar in SVN remove jar in SVN Jan 07, 2009 r125 (change package name - issue 11) committed by ngood...@bayontechnologies.com - change package name - issue 11 change package name - issue 11 Jan 07, 2009 r124 (change package name. issue 11) committed by ngood...@bayontechnologies.com - change package name. issue 11 change package name. issue 11 Jan 07, 2009 issue 11 (Change package name ) commented on by ngood...@bayontechnologies.com - Strike package change above com.bayontechnologies.com to com.googlecode.jdbckettle Strike package change above com.bayontechnologies.com to com.googlecode.jdbckettle Jan 07, 2009 issue 11 (Change package name ) commented on by ngood...@bayontechnologies.com - change package name from com.bayontechnologies.jdbckettle to com.google.code.jdbckettle Change drivername from JDBCKettleDriver to Driver Change all samples, unit tests, etc to use new Classname. change package name from com.bayontechnologies.jdbckettle to com.google.code.jdbckettle Change drivername from JDBCKettleDriver to Driver Change all samples, unit tests, etc to use new Classname. Jan 06, 2009 issue 11 (Change package name ) reported by ngood...@bayontechnologies.com - Prep for submission to Pentaho Data Integration Prep for submission to Pentaho Data Integration Jan 05, 2009 issue 9 (JDBC and Kettle Type Mismatch) Status changed by ngood...@bayontechnologies.com - resolved with revision 121 Status: Verified resolved with revision 121 Status: Verified Jan 05, 2009 issue 8 (Add WHERE clause support) Status changed by ngood...@bayontechnologies.com - Status: Verified Status: Verified Jan 05, 2009 jdbckettle-0.1.r123.jar (JDBCKettle r123) file uploaded by ngood...@bayontechnologies.com - Labels: Featured OpSys-All Type-Archive Labels: Featured OpSys-All Type-Archive Jan 05, 2009 issue 10 (Issue with Column Names and Maps) reported by ngood...@bayontechnologies.com - There's an issue with Column Naming and Maps. Consider the following SQL: "select * from examplevar.\"my new table\" where yeartofilter = 2004" This allows for iterating, and using the JDBC methods: theyear = rs.getString("TheYear"); filteryear = rs.getString("YEARTOFILTER"); Which gets the values. However, the following three statements do NOT even thought they should since they have the same two columns "select \"TheYear\", \"YEARTOFILTER\" from examplevar.\"my new table\" where yeartofilter = 2004" "select TheYear, YEARTOFILTER from examplevar.\"my new table\" where yeartofilter = 2004" "select \"examplevar\".\"TheYear\", \"examplevar\".\"YEARTOFILTER\" from examplevar.\"my new table\" where yeartofilter = 2004" WhereClauseTest.java in test has the above working test case. There's an issue with Column Naming and Maps. Consider the following SQL: "select * from examplevar.\"my new table\" where yeartofilter = 2004" This allows for iterating, and using the JDBC methods: theyear = rs.getString("TheYear"); filteryear = rs.getString("YEARTOFILTER"); Which gets the values. However, the following three statements do NOT even thought they should since they have the same two columns "select \"TheYear\", \"YEARTOFILTER\" from examplevar.\"my new table\" where yeartofilter = 2004" "select TheYear, YEARTOFILTER from examplevar.\"my new table\" where yeartofilter = 2004" "select \"examplevar\".\"TheYear\", \"examplevar\".\"YEARTOFILTER\" from examplevar.\"my new table\" where yeartofilter = 2004" WhereClauseTest.java in test has the above working test case. Jan 05, 2009 r123 (updated examples.) committed by ngood...@bayontechnologies.com - updated examples. updated examples. Jan 05, 2009 r122 (simple where clause testing.) committed by ngood...@bayontechnologies.com - simple where clause testing. simple where clause testing. Jan 05, 2009 r121 (Resolve Issue 9. JDBC Types != Kettle Types) committed by ngood...@bayontechnologies.com - Resolve Issue 9 . JDBC Types != Kettle Types Resolve Issue 9 . JDBC Types != Kettle Types Jan 05, 2009 issue 9 (JDBC and Kettle Type Mismatch) reported by ngood...@bayontechnologies.com - The JDBC types are set incorrectly for resulting columns. The types for Kettle (ValueMetaInterface.java) are different from JDBC (java.sql.Types). The JDBC types are set incorrectly for resulting columns. The types for Kettle (ValueMetaInterface.java) are different from JDBC (java.sql.Types). Dec 22, 2008 r120 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 21, 2008 r119 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 21, 2008 r118 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 21, 2008 r117 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 21, 2008 r116 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r115 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r114 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r113 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r112 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r111 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r110 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r109 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 20, 2008 r108 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 18, 2008 r107 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 18, 2008 issue 8 (Add WHERE clause support) reported by ngood...@bayontechnologies.com - WHERE clause support is outlined on the wiki: http://code.google.com/p/jdbckettle/wiki/SQLSupport Add this support in. samples/examplevar.ktr provides a way to test. There's a commented location with how to set this variable in JDBCKettleStatement.java //meta.setVariable("yeartofilter", "2006"); WHERE clause support is outlined on the wiki: http://code.google.com/p/jdbckettle/wiki/SQLSupport Add this support in. samples/examplevar.ktr provides a way to test. There's a commented location with how to set this variable in JDBCKettleStatement.java //meta.setVariable("yeartofilter", "2006"); Dec 18, 2008 SQLSupport Wiki page edited by ngood...@bayontechnologies.com Dec 18, 2008 r105 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 17, 2008 r104 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 17, 2008 r103 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 16, 2008 CommonClients Wiki page edited by qinhui99 Dec 16, 2008 r101 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 16, 2008 r100 (Birt sample) committed by qinhui99 - Birt sample Birt sample Dec 15, 2008 CommonClients Wiki page edited by qinhui99 Dec 15, 2008 CommonClients Wiki page edited by qinhui99 Dec 15, 2008 r97 ([No log message]) committed by qinhui99 - [No log message] [No log message] Dec 14, 2008 JDBCDriver Wiki page edited by qinhui99

issue 12 (step names with dots cause NullPointerException) reported by xophos - What steps will reproduce the problem? 1. use Connection connection = DriverManager.getConnection("jdbc:kettle:file://...examplecsv.ktr"); 2. select * from "example.csv" this gives you a NullPointerException in the file KettleJDBCStatement.java the line: si1.addRowListener(listener); because the dot in the table name is eaten by the filename heuristics in the beginning. What is the expected output? What do you see instead? What version of the product are you using? On what operating system? Please provide any additional information below. there is a simple fix: i just added the line stepName=table; in the else branch of "if(f.isDirectory())" if(f.isDirectory()) { if( visitDirectory(f)) { //execute the transformation log.debug("file="+p.getKettleUrl()+File.separator+fileName+".ktr"); meta = new TransMeta(p.getKettleUrl()+File.separator+fileName+".ktr"); } } else { stepName=table; meta = new TransMeta(p.getKettleUrl()); // meta = new TransMeta(f.getAbsolutePath()); } that seems to work allright.

What steps will reproduce the problem? 1. use Connection connection = DriverManager.getConnection("jdbc:kettle:file://...examplecsv.ktr"); 2. select * from "example.csv" this gives you a NullPointerException in the file KettleJDBCStatement.java the line: si1.addRowListener(listener); because the dot in the table name is eaten by the filename heuristics in the beginning. What is the expected output? What do you see instead? What version of the product are you using? On what operating system? Please provide any additional information below. there is a simple fix: i just added the line stepName=table; in the else branch of "if(f.isDirectory())" if(f.isDirectory()) { if( visitDirectory(f)) { //execute the transformation log.debug("file="+p.getKettleUrl()+File.separator+fileName+".ktr"); meta = new TransMeta(p.getKettleUrl()+File.separator+fileName+".ktr"); } } else { stepName=table; meta = new TransMeta(p.getKettleUrl()); // meta = new TransMeta(f.getAbsolutePath()); } that seems to work allright.

Older