Skip to content

trk7

Kesavn Trichy Rengarajan/T.R.Kesavan

Recent Posts

  • PHP openssl_encrypt tip
  • AWS SSM Parameter Store IAM Policy for restricting by Path and Tag
  • AWS Codecommit – PR and Comits with large files
  • MySQL substring start is one based
  • Using Generators to flatten a JSON doc in PHP

Recent Comments

  • k7 on Discourse with Docker on port 80
  • Lenin on Discourse with Docker on port 80
  • Ismail on Scriptaculous Draggable in Action.
  • ANdrea on Pentaho Spoon error
  • k7 on Pentaho Spoon error

Archives

  • January 2021
  • August 2020
  • July 2020
  • March 2020
  • May 2019
  • April 2018
  • October 2017
  • March 2017
  • April 2016
  • March 2016
  • July 2015
  • May 2015
  • February 2015
  • December 2014
  • October 2014
  • May 2014
  • June 2013
  • April 2013
  • February 2013
  • September 2012
  • August 2012
  • May 2012
  • September 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • January 2011
  • October 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • November 2008
  • August 2008
  • December 2007
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • June 2007
  • April 2007
  • March 2007
  • February 2007
  • January 2007
  • October 2006
  • September 2006
  • July 2006
  • June 2006
  • May 2006
  • April 2006
  • March 2006
  • January 2006
  • December 2005
  • November 2005
  • October 2005
  • September 2005
  • August 2005
  • July 2005
  • June 2005
  • May 2005

Categories

  • aws
  • bash
  • cinema
  • css
  • design
  • etl
  • game
  • gnu
  • javascript
  • javascript
  • jquery
  • links
  • linux
  • mcse
  • mongodb
  • munin
  • my_sites
  • mysql
  • news
  • php
  • pligg
  • programming
  • quickfixes
  • SansJ
  • shopdeals
  • snippets
  • software
  • sysadmin
  • tech
  • travel
  • Uncategorized
  • unix

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Month: March 2011

Pentaho Spoon error

If you get an error like this:

Error connecting to database: (using class org.gjt.mm.mysql.Driver)
Unknown initial character set index ‘192’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.

Then in the database connection settings, do as highlighted in the screenshot below.

kettle_db_character_encoding

Posted on March 29, 2011December 27, 2012Categories etl, quickfixesTags kettle3 Comments on Pentaho Spoon error

Bulk Insert while using PDO

If you are looking to Bulk Insert while using PDO and want to use bound parameters (to prevent SQL injection), please have a look at this solution here: http://stackoverflow.com/questions/4629022/how-to-insert-an-array-into-a-single-mysql-prepared-statement-w-php-and-pdo

Quite simple and does the job.

Posted on March 21, 2011Categories links, programming, quickfixesTags phpLeave a comment on Bulk Insert while using PDO
Proudly powered by WordPress