On 17 April 2013 17:10, paulblyth <blythy_...@hotmail.com> wrote: > That post lost a lot of formatting. Please find attached instead. > db-data-config.xml > <http://lucene.472066.n3.nabble.com/file/n4056649/db-data-config.xml>
I do not see how this could be working in either case. Your select statement is "SELECT COLOURS FROM CLRS" but the "column" attribute in your DIH field is "COLOUR" (please note the missing "S" at the end). Otherwise, I do not see an issue with the transformers. You also do not need a transformer for this, but could use the SELECT statement to capitalise the value returned from the database. The exact SQL is probably database-dependent, but for mysql, this would work: SELECT CONCAT( UPPER( LEFT( `COLOURS`, 1 ) ), SUBSTRING( `COLOURS`, 2 ) ) AS COLOUR from CLRS Regards, Gora
