Hi, I think that you have to indicate the type of data, like this #cod_cia:VARCHAR#
2008/2/27, Rikki Bindra <[EMAIL PROTECTED]>: > > > Hi, > > I am using the jt400.jar as the JDBC Driver for accessing data from DB2 > database on AS400. The problem is that I want to use implicit resultmap like > > > <select id="getProductCount" resultClass="java.util.HashMap"> > select * from PRODUCT > </select> > > However, the problem is that while populating the HashMap, I have noticed > that the class "com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" > uses method getColumnLabel() on ResultSetMetaData > My JDBC driver returns the label of the column (containing spaces and > which is different than the column name in database). Now the code fails > reporting the exception that "Invalid Column Name" has been specified. The > problem is in the class " > com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" as it should be > calling getColumnName() instead of getColumnLabel() on ResultSetMetaData to > get the names of the columns. > > Please look this ASAP and confirm if changing the method call from > getColumnLabel() to getColumnName(), can affect in what manner.. I have > tried this and it works for me. However, I want to know the unknown > implications that it might have. > > Thanks & Regards, > Rikki Bindra > Tata Consultancy Services > C - 56, Phase 2 > Dist. Gautam Budh Nagar > Noida - 201305,Uttar Pradesh > India > Mailto: [EMAIL PROTECTED] > Website: http://www.tcs.com > ____________________________________________ > Experience certainty. IT Services > Business Solutions > Outsourcing > ____________________________________________ > > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > >
