No problem.
However, I still cannot see the definition of the subselect
'PurchaseHdrAddr.getPurchaseHdrAddr_shipTo', I think there's the
problem. Result class has been set to java.lang.String, which obviously
does not have a 'orderNo' property.
Niels
-Original Message-
From: Voorhoeve, N
Write a stored procedure?LarryOn 3/20/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:Thanks Sven.Is there any workaround if I want to have multiple statements.
Thanks in advance,-suman-Original Message-From: Sven Boden [mailto:[EMAIL PROTECTED]]Sent: Monday, March 20, 2006 4:56 PMTo:
use
Thanks Sven.
Is there any workaround if I want to have multiple statements.
Thanks in advance,
-suman
-Original Message-
From: Sven Boden [mailto:[EMAIL PROTECTED]
Sent: Monday, March 20, 2006 4:56 PM
To: user-java@ibatis.apache.org
Subject: Re: Temp table
Probably not, most drive
Probably not, most drivers want a single SQL statement when using
PreparedStatements.
Regards,
Sven
[EMAIL PROTECTED] wrote:
Hi,
Can I use something like this -
Select * from T where <>
insert into #temp
Select * from T where <>
Select * from #temp
Regards,
Suman Mishra
203-719-1
Sure. See the following. Thanks for the help.
I had originally used order_no in the column attribute in
PurchaseHeader-report resultMap, but that didn't work, so I tried the
"order_no as such_and_such" stuff below that I mentioned in my original
email.
Write a rowhandler.LarryOn 3/20/06, Daniel Pitts <[EMAIL PROTECTED]> wrote:
I want to perform query and map the results by a specific column... Therows may have non-unique values for the specified column, and I'd liketo have it build a list if possible. Any ideas?
Title: Temp table
Hi,
Can I use something like this -
parameterClass="ABC2">
Select * from T where <>
insert into #temp
Select * from T where <>
Select * from #temp
Regards,
Suman Mishra
203-719-1698
Visit our website at http://www.ubs.com
This message contains
I want to perform query and map the results by a specific column... The
rows may have non-unique values for the specified column, and I'd like
to have it build a list if possible. Any ideas?
All,
I'm using Abator generated code for iBATIS DAO.
Since Abator generated query doesn't support table join. I put
following mapping in the Abator generated xml file
select
prod.product_name,
b.brand_name,
C.coupon_id
FROM coupon as C, product_type as p
Hi Niels,
Can we see the definition of
'PurchaseHdrAddr.getPurchaseHdrAddr_shipTo'?
This should definitely work...
Niels :)
-Original Message-
From: Voorhoeve, Niels {PBG} [mailto:[EMAIL PROTECTED]
Sent: maandag 20 maart 2006 18:40
To: user-java@ibatis.apache.org
Subject: Complex proper
Oh yes, it was that. Thanks a lot.
Regards,
Dario.
2006/3/20, Dario Bahena Tapia <[EMAIL PROTECTED]>:
> Mmm, oh yes ... I copied them from another email, and did not see that
> typo. Let me try that change, and I'll let u know. Thanks!
>
> Regards,
> me.
>
> 2006/3/20, Larry Meadors <[EMAIL PROTE
Hi,
I have a class PurchaseHeader with several complex address properties
(shipToAddress, chargeToAddress, requestorAddress) that are all keyed by
PurchaseHeader.orderNo. I am trying to map the addresses to the correct
property, but Ibatis is complaining about my result map (see the result
map be
I don't completely follow what you're trying to do, but there's obviously some classloader confusion.
Eclipse plugins run in their own class loaders. The plugin classloader does not contain workspace classes in its path, so plugins cannot see workspace classes. My guess is that you are getting
Mmm, oh yes ... I copied them from another email, and did not see that
typo. Let me try that change, and I'll let u know. Thanks!
Regards,
me.
2006/3/20, Larry Meadors <[EMAIL PROTECTED]>:
> Not 100% sure, but you have this:
>
> http://ibatis.apache.org/dtd/sql-map-2.dtd";>
>
> You should have t
Not 100% sure, but you have this:Config 2.0//EN" "
http://ibatis.apache.org/dtd/sql-map-2.dtd">You should have this instead:
http://ibatis.apache.org/dtd/sql-map-2.dtd">LarryOn 3/20/06, Dario Bahena Tapia <[EMAIL PROTECTED]> wrote:> 2006/3/20, Dario Bahena Tapia <
[EMAIL PROTECTED]>:> > Hi,> >> > I
2006/3/20, Dario Bahena Tapia <[EMAIL PROTECTED]>:
> Hi,
>
> I'm using spring + iBatis, but having an issue when parsing sql-map
> file. Here's the message in the logs:
>
>
> com.ibatis.common.exception.NestedRuntimeException: Error occurred.
> Cause: com.ibatis.common.xml.NodeletException: Error p
Also make sure logging is disabled.ClintonOn 3/17/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
Also, run the query several times, because on the first pass, it issetting up the parameterMap.
long t1,t2;t1 = System.currentTimeMillis();for(int i = 0; i++; i < 10) sqlMap.queryForList("getExposuresForO
Abator does not generate any code that joins tables - you'll have to write a custom query for that.
Jeff Butler
On 3/20/06, Emiliano Armellin <[EMAIL PROTECTED]> wrote:
hello,which is the best pattern to join two or more tables using a QueryByExample strategy?thanks
--
Emiliano Armellin
W_
Hi there,
I am a completely newbie with iBbatis, Eclipse, and even with Java
development, so I hope you'll exercise a bit of patience with me :-)
There is my problem: I'm trying to integrate iBatis' sqlmaps into an
Eclipse plugin I am developing. I generated all the abator artifacts and a
TestSq
Why not this:
select $seq_name$.nextval from dual
Larry
On 3/20/06, Marco Berri <[EMAIL PROTECTED]> wrote:
> I'M Using this:
>
>
> "$iBatisStoragePath$/sql-map-2.dtd">
>
>
>
> select $seq_name$.nextval from tnes2.tnode where rownum=1
>
>
>
>
> where tne
hello,
which is the best pattern to join two or more tables using a
QueryByExample strategy?
thanks
--
Emiliano Armellin
W_
www.ateikon.com
@_
[EMAIL PROTECTED]
T_
+39 0422 452101
I'M Using this:
"$iBatisStoragePath$/sql-map-2.dtd">
select $seq_name$.nextval from tnes2.tnode where rownum=1
where tnes2.tnode is a table on my db.
Larry Meadors wrote:
Also..make sure you are inserting with insert(), not update().
Larry
22 matches
Mail list logo
