You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Alden S <al...@hotmail.com> on 2008/03/03 20:51:55 UTC
Remove from list
Please remove my name from email list.
> Date: Wed, 27 Feb 2008 08:57:22 -0700> From: larry.meadors@gmail.com> To: user-java@ibatis.apache.org> Subject: Re: Undefined Column Name Exception in Implicit Map> > I agree - of all the jdbc drivers I have ever used, DB2 is the only> one that supports this.> > Larry> > > On Wed, Feb 27, 2008 at 8:45 AM, Jeff Butler <je...@gmail.com> wrote:> > This seems like an obvious error in iBATIS to me. I made the change and ran> > the build - the tests all passed.> >> > Unless anyone has a strong objection, I'll commit the change.> >> > Thanks to Rikki for doing the diagnosis on this!> >> > Jeff Butler> >> >> >> >> >> > On Wed, Feb 27, 2008 at 7:43 AM, Niels Beekman <n....@wis.nl> wrote:> >> > >> > >> > >> > >> > > I think that this affects the aliasing of columns, which would be bad> > IMHO. But the javadoc of getColumnLabel says:> > >> > >> > >> > > "Gets the designated column's suggested title for use in printouts and> > displays."> > >> > >> > >> > > This would mean that it's perfectly valid to call getColumnName, maybe> > someone with more JDBC spec knowledge can comment on this.> > >> > >> > >> > > Niels> > >> > > ________________________________> >> > >> > > From: Rikki Bindra [mailto:rikki.bindra@tcs.com]> > > Sent: Wednesday, February 27, 2008 12:04 PM> > > To: user-java@ibatis.apache.org> > > Subject: Undefined Column Name Exception in Implicit Map> > >> > >> > >> > >> > >> > >> > >> > > 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: rikki.bindra@tcs.com> > > 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> > >> > >> > >> >> >
_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008
RE: Remove from list
Posted by Clinton Begin <cl...@gmail.com>.
Yep, all of the links are on the page I sent.
Cheers,
Clinton
From: Jasmin_Mehta@nexweb.org [mailto:Jasmin_Mehta@nexweb.org]
Sent: March-04-08 5:53 AM
To: user-java@ibatis.apache.org
Subject: RE: Remove from list
Clinton,
After I unsubscribe myself from the list, if I need to be subscribed again
then that time can I use the same email id as before?
Thanks
Jasmin
"Clinton Begin" <cl...@gmail.com>
03/03/2008 03:00 PM
Please respond to
user-java@ibatis.apache.org
To
<us...@ibatis.apache.org>
cc
Subject
RE: Remove from list
You can unsubscribe yourself.
<http://ibatis.apache.org/mailinglists.html>
http://ibatis.apache.org/mailinglists.html
Clinton
From: Alden S [mailto:alden418@hotmail.com]
Sent: March-03-08 12:52 PM
To: user-java@ibatis.apache.org
Subject: Remove from list
Please remove my name from email list.
> Date: Wed, 27 Feb 2008 08:57:22 -0700
> From: larry.meadors@gmail.com
> To: user-java@ibatis.apache.org
> Subject: Re: Undefined Column Name Exception in Implicit Map
>
> I agree - of all the jdbc drivers I have ever used, DB2 is the only
> one that supports this.
>
> Larry
>
>
> On Wed, Feb 27, 2008 at 8:45 AM, Jeff Butler <je...@gmail.com>
wrote:
> > This seems like an obvious error in iBATIS to me. I made the change and
ran
> > the build - the tests all passed.
> >
> > Unless anyone has a strong objection, I'll commit the change.
> >
> > Thanks to Rikki for doing the diagnosis on this!
> >
> > Jeff Butler
> >
> >
> >
> >
> >
> > On Wed, Feb 27, 2008 at 7:43 AM, Niels Beekman <n....@wis.nl> wrote:
> >
> > >
> > >
> > >
> > >
> > > I think that this affects the aliasing of columns, which would be bad
> > IMHO. But the javadoc of getColumnLabel says:
> > >
> > >
> > >
> > > "Gets the designated column's suggested title for use in printouts and
> > displays."
> > >
> > >
> > >
> > > This would mean that it's perfectly valid to call getColumnName, maybe
> > someone with more JDBC spec knowledge can comment on this.
> > >
> > >
> > >
> > > Niels
> > >
> > > ________________________________
> >
> > >
> > > From: Rikki Bindra [mailto:rikki.bindra@tcs.com]
> > > Sent: Wednesday, February 27, 2008 12:04 PM
> > > To: user-java@ibatis.apache.org
> > > Subject: Undefined Column Name Exception in Implicit Map
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > 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: rikki.bindra@tcs.com
> > > 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
> > >
> > >
> > >
> >
> >
_____
Connect and share in new ways with Windows Live.
<http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008
> Get it now!
****************************************************************************
**
ATTENTION ATTENTION ATTENTION ATTENTION ATTENTION
Our domain name is changing. Please take note of the sender's
e-Mail address and make changes to your personal address list,
if needed. Both domains will continue to work, only for a limited
time.
****************************************************************************
**
This email and any files transmitted with it are intended solely for
the use of the individual or agency to whom they are addressed.
If you have received this email in error please notify the Navy
Exchange Service Command e-mail administrator. This footnote
also confirms that this email message has been scanned for the
presence of computer viruses.
Thank You!
****************************************************************************
**
RE: Remove from list
Posted by Poitras Christian <Ch...@ircm.qc.ca>.
Exactly.
Some people do this when they go on vacation.
Christian
________________________________
From: Jasmin_Mehta@nexweb.org [mailto:Jasmin_Mehta@nexweb.org]
Sent: Tuesday, March 04, 2008 7:53 AM
To: user-java@ibatis.apache.org
Subject: RE: Remove from list
Clinton,
After I unsubscribe myself from the list, if I need to be subscribed again then that time can I use the same email id as before?
Thanks
Jasmin
"Clinton Begin" <cl...@gmail.com>
03/03/2008 03:00 PM
Please respond to
user-java@ibatis.apache.org
To
<us...@ibatis.apache.org>
cc
Subject
RE: Remove from list
You can unsubscribe yourself.
http://ibatis.apache.org/mailinglists.html
Clinton
From: Alden S [mailto:alden418@hotmail.com]
Sent: March-03-08 12:52 PM
To: user-java@ibatis.apache.org
Subject: Remove from list
Please remove my name from email list.
> Date: Wed, 27 Feb 2008 08:57:22 -0700
> From: larry.meadors@gmail.com
> To: user-java@ibatis.apache.org
> Subject: Re: Undefined Column Name Exception in Implicit Map
>
> I agree - of all the jdbc drivers I have ever used, DB2 is the only
> one that supports this.
>
> Larry
>
>
> On Wed, Feb 27, 2008 at 8:45 AM, Jeff Butler <je...@gmail.com> wrote:
> > This seems like an obvious error in iBATIS to me. I made the change and ran
> > the build - the tests all passed.
> >
> > Unless anyone has a strong objection, I'll commit the change.
> >
> > Thanks to Rikki for doing the diagnosis on this!
> >
> > Jeff Butler
> >
> >
> >
> >
> >
> > On Wed, Feb 27, 2008 at 7:43 AM, Niels Beekman <n....@wis.nl> wrote:
> >
> > >
> > >
> > >
> > >
> > > I think that this affects the aliasing of columns, which would be bad
> > IMHO. But the javadoc of getColumnLabel says:
> > >
> > >
> > >
> > > "Gets the designated column's suggested title for use in printouts and
> > displays."
> > >
> > >
> > >
> > > This would mean that it's perfectly valid to call getColumnName, maybe
> > someone with more JDBC spec knowledge can comment on this.
> > >
> > >
> > >
> > > Niels
> > >
> > > ________________________________
> >
> > >
> > > From: Rikki Bindra [mailto:rikki.bindra@tcs.com]
> > > Sent: Wednesday, February 27, 2008 12:04 PM
> > > To: user-java@ibatis.apache.org
> > > Subject: Undefined Column Name Exception in Implicit Map
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > 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: rikki.bindra@tcs.com
> > > 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
> > >
> > >
> > >
> >
> >
________________________________
Connect and share in new ways with Windows Live. Get it now!<http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008>
******************************************************************************
ATTENTION ATTENTION ATTENTION ATTENTION ATTENTION
Our domain name is changing. Please take note of the sender's
e-Mail address and make changes to your personal address list,
if needed. Both domains will continue to work, only for a limited
time.
******************************************************************************
This email and any files transmitted with it are intended solely for
the use of the individual or agency to whom they are addressed.
If you have received this email in error please notify the Navy
Exchange Service Command e-mail administrator. This footnote
also confirms that this email message has been scanned for the
presence of computer viruses.
Thank You!
******************************************************************************
RE: Remove from list
Posted by Ja...@nexweb.org.
Clinton,
After I unsubscribe myself from the list, if I need to be subscribed again
then that time can I use the same email id as before?
Thanks
Jasmin
"Clinton Begin" <cl...@gmail.com>
03/03/2008 03:00 PM
Please respond to
user-java@ibatis.apache.org
To
<us...@ibatis.apache.org>
cc
Subject
RE: Remove from list
You can unsubscribe yourself.
http://ibatis.apache.org/mailinglists.html
Clinton
From: Alden S [mailto:alden418@hotmail.com]
Sent: March-03-08 12:52 PM
To: user-java@ibatis.apache.org
Subject: Remove from list
Please remove my name from email list.
> Date: Wed, 27 Feb 2008 08:57:22 -0700
> From: larry.meadors@gmail.com
> To: user-java@ibatis.apache.org
> Subject: Re: Undefined Column Name Exception in Implicit Map
>
> I agree - of all the jdbc drivers I have ever used, DB2 is the only
> one that supports this.
>
> Larry
>
>
> On Wed, Feb 27, 2008 at 8:45 AM, Jeff Butler <je...@gmail.com>
wrote:
> > This seems like an obvious error in iBATIS to me. I made the change
and ran
> > the build - the tests all passed.
> >
> > Unless anyone has a strong objection, I'll commit the change.
> >
> > Thanks to Rikki for doing the diagnosis on this!
> >
> > Jeff Butler
> >
> >
> >
> >
> >
> > On Wed, Feb 27, 2008 at 7:43 AM, Niels Beekman <n....@wis.nl>
wrote:
> >
> > >
> > >
> > >
> > >
> > > I think that this affects the aliasing of columns, which would be
bad
> > IMHO. But the javadoc of getColumnLabel says:
> > >
> > >
> > >
> > > "Gets the designated column's suggested title for use in printouts
and
> > displays."
> > >
> > >
> > >
> > > This would mean that it's perfectly valid to call getColumnName,
maybe
> > someone with more JDBC spec knowledge can comment on this.
> > >
> > >
> > >
> > > Niels
> > >
> > > ________________________________
> >
> > >
> > > From: Rikki Bindra [mailto:rikki.bindra@tcs.com]
> > > Sent: Wednesday, February 27, 2008 12:04 PM
> > > To: user-java@ibatis.apache.org
> > > Subject: Undefined Column Name Exception in Implicit Map
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > 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: rikki.bindra@tcs.com
> > > 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
> > >
> > >
> > >
> >
> >
Connect and share in new ways with Windows Live. Get it now!
******************************************************************************
ATTENTION ATTENTION ATTENTION ATTENTION ATTENTION
Our domain name is changing. Please take note of the sender's
e-Mail address and make changes to your personal address list,
if needed. Both domains will continue to work, only for a limited
time.
******************************************************************************
This email and any files transmitted with it are intended solely for
the use of the individual or agency to whom they are addressed.
If you have received this email in error please notify the Navy
Exchange Service Command e-mail administrator. This footnote
also confirms that this email message has been scanned for the
presence of computer viruses.
Thank You!
******************************************************************************
RE: Remove from list
Posted by Clinton Begin <cl...@gmail.com>.
You can unsubscribe yourself.
http://ibatis.apache.org/mailinglists.html
Clinton
From: Alden S [mailto:alden418@hotmail.com]
Sent: March-03-08 12:52 PM
To: user-java@ibatis.apache.org
Subject: Remove from list
Please remove my name from email list.
> Date: Wed, 27 Feb 2008 08:57:22 -0700
> From: larry.meadors@gmail.com
> To: user-java@ibatis.apache.org
> Subject: Re: Undefined Column Name Exception in Implicit Map
>
> I agree - of all the jdbc drivers I have ever used, DB2 is the only
> one that supports this.
>
> Larry
>
>
> On Wed, Feb 27, 2008 at 8:45 AM, Jeff Butler <je...@gmail.com>
wrote:
> > This seems like an obvious error in iBATIS to me. I made the change and
ran
> > the build - the tests all passed.
> >
> > Unless anyone has a strong objection, I'll commit the change.
> >
> > Thanks to Rikki for doing the diagnosis on this!
> >
> > Jeff Butler
> >
> >
> >
> >
> >
> > On Wed, Feb 27, 2008 at 7:43 AM, Niels Beekman <n....@wis.nl> wrote:
> >
> > >
> > >
> > >
> > >
> > > I think that this affects the aliasing of columns, which would be bad
> > IMHO. But the javadoc of getColumnLabel says:
> > >
> > >
> > >
> > > "Gets the designated column's suggested title for use in printouts and
> > displays."
> > >
> > >
> > >
> > > This would mean that it's perfectly valid to call getColumnName, maybe
> > someone with more JDBC spec knowledge can comment on this.
> > >
> > >
> > >
> > > Niels
> > >
> > > ________________________________
> >
> > >
> > > From: Rikki Bindra [mailto:rikki.bindra@tcs.com]
> > > Sent: Wednesday, February 27, 2008 12:04 PM
> > > To: user-java@ibatis.apache.org
> > > Subject: Undefined Column Name Exception in Implicit Map
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > 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: rikki.bindra@tcs.com
> > > 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
> > >
> > >
> > >
> >
> >
_____
Connect and share in new ways with Windows Live. Get it now!
<http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008
>