Actually, I added that field along with some others.[EMAIL PROTECTED] wrote: I have installed JPetStore5.0 on my pc. I didn't see totalShipping in either Order.java or Order.xml. which version JPetStore are you using? Tony
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US
I have installed JPetStore5.0 on my pc. I didn't see totalShipping in either Order.java or Order.xml.
which version JPetStore are you using?
Tony
I don't currently have the jpetstore app installed, but isn't the bean
convention totalShipping? So if you have a property in Order.xml
somewhere it is case specific.
Mike Wilson wrote:
not the OrderBean, the Order.java
---
not the OrderBean, the Order.java
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
Hello, Caused by: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'totalshipping' in class 'com.ibatis.jpetstore.domain.Order' Anyone have any ideas? I don't see where the problem is in the OrderBean or Order.xml. Thanks, Bruce
Blab-away for as little as 1
Add remapResults="true" in the select tag.
There is a performance hit, but it will work.
Larry
On 3/23/06, Daniel Pitts <[EMAIL PROTECTED]> wrote:
> I have a very generic query which has different column names, depending
> on what was passed to it.
>
> SELECT $columns$ FROM $from$ WHER
yeah - I was afraid that might be the case. I couldn't find anything in
the documentation though to say that it wasn't possible though.
Diran
Daniel Pitts wrote:
It looks to me like the selectKey isn't allowed to be dynamically used.
You might have to make two separate cases, and compare doc
It looks to me like the selectKey isn't allowed to be dynamically used.
You might have to make two separate cases, and compare documentId in
java code.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 3:23 PM
To: ibatis user list
Subject
I have a very generic query which has different column names, depending
on what was passed to it.
SELECT $columns$ FROM $from$ WHERE $where$
It works fine the first time. And it even works fine if $columns$
doesn't change. However, if $columns$ had (for instance) "my_column" in
one quer
Hey Guys!
Is there some simple reason I get this error:
Caused by: org.xml.sax.SAXParseException: The content of element type
"isEmpty" must match
"(include|iterate|isParameterPresent|isNotParameterPresent|isEmpty|isNotEmpty|isNotNull|
isNull|isNotEqual|isEqual|isGreaterThan|isGreaterEqual|i
Hi Larry,
Actually no, the sql I have does not specify the I.ITEMID, it just has ITEMID.
This is most likely the problem, which I will test now.
Thanks,
Bruce
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
Of Larry Meadors
Sent: Thursday, March 23, 2006 1:32
I changed it a couple of weeks ago in SVN ;-) ... you will find some
e-mails on it in the archives.
Regards,
Sven
Larry Meadors wrote:
In SVN, it looks right..is this the SQL there?
---
select
I.ITEMID,
LISTPRICE,
UNITCOST,
SUPPLIER AS supplierId,
I.PRODUCTID
In SVN, it looks right..is this the SQL there?
---
select
I.ITEMID,
LISTPRICE,
UNITCOST,
SUPPLIER AS supplierId,
I.PRODUCTID AS "product.productId",
NAME AS "product.name",
DESCN AS "product.description",
CATEGORY AS "product.categoryId",
I am replying to the list Bruce, in case others have the same problem
later, then they can google and get it.
My guess is that the user connecting to the database does not see the
product table in the default schema. You may need to either connect as
another user, or qualify the table name.
Larry
Hello, We are trying to connect to a physical database and running JPetStore 5 on Tomcat 4.0.2. For our DaoConfig file, we have three questions: First, will it work to set the connection using the SimpleDataSource like this: DataSource dataSource = new SimpleDataSource(props); c
Larry,
thank
you very much for your reply.
I
don't remember if it's possible to load a SQL map xml files at
runtime.
If
yes, we could leave the sqlMapConfig file empty (with non sqlMap tags) and then
load the sqlMap files at runtime, looking before in the "dialect"
folder; if it's not p
I would try a structure like this:Set up your SqlMapConfig.xml file to load a properties file, and in that properties file specify the database dialect (i.e., dialect=mysql, or
dialect=oracle, etc...). Then, you can load the common sqlmaps from a common location, and the dialect specific ones usin
Yes, you cannot parameterize clauses in SQL.
Use the $-syntax: AND $shows$
Niels
-Original Message-
From: Bob [mailto:[EMAIL PROTECTED]
Sent: donderdag 23 maart 2006 9:38
To: user-java@ibatis.apache.org; [EMAIL PROTECTED]
Subject: Re: sql server 2k parameterized queries
On 23/03/06, Lar
Hi
all,
my company is
starting a new data-centric application that should be
database-indipendent (e.g. work with MySql, Oracle, SQL-Server, DB2
ecc.).
We don't want to use
Hibernate because we used it in the past e we dont' like it.
I've found iBATIS,
read the documentation and I like it
On 23/03/06, Bob <[EMAIL PROTECTED]> wrote:
> ... thinking about it, is that the problem? Can I use a parameterized
> statement when an entire where clause is dynamically generated?
Unfortunately, it seems that that was the problem. Oops.
When I use in the query to go through the EVENTCD's and
Bruce,
On 23/03/06, Bruce Wexler <[EMAIL PROTECTED]> wrote:
> Caused by: com.ibatis.dao.client.DaoException: Failed to
> queryForPaginatedList - id [getProductListByCategory], parameterObject
> [DOGS], pageSize [4]. Cause:
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error
On 23/03/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
> Can you post the mapped statement?
Certainly - but it is very simple!
SELECT EVENT.EVENTCD,
sum(WTRANS.NETSTAMT) AS NET_VALUE
FROM WTRANS
INNER JOIN EVE
22 matches
Mail list logo
