Hi, I don't know Spring getJdbcTemplate. Maybe Spring uses ResultSetMetaData.getColumnName instead of getColumnLabel. There is a way to change the behavior of H2: you need to set the system property h2.aliasColumnName to 'true', see also http://www.h2database.com/javadoc/org/h2/constant/SysProperties.html#h2.aliasColumnName - could you test if this works for you?
> mysql What version of MySQL do you use? I think newer version of MySQL behave like H2. Regards, Thomas On Mon, Nov 3, 2008 at 8:18 AM, quarph <[EMAIL PROTECTED]> wrote: > > here is my sql = "select rowCode as code ,rowno as no from > rpt_view_rowDefine where reportTemplateID ='2623' order by rowno " > > finally I get the Map List with key ROWCODE, ROWNO > but I expect Map List with key CODE, NO > > I found it work right in mysql and oracle. It looks right when i use > the h2 web browser to run the SQL > but when I use spring getJdbcTemplate().queryForList it's not the > result I want.Is this a bug? > > quarph > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
