thanks Nathan.Now the problem is fixed with the help of ojdc14.jar of
oracle 10g( release 2),earlier we tested with older version oracle
driver which lead to the above said problem.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, November 17, 20
Clinton,
One of the most disappointing aspects of IBATIS has to be the inability to
reuse result maps for
nested properties. IBATIS only allows me to use them if I [1] use another
select or [2] use a
collection. I get this error every time:
"Error instantiating collection property for mapping '
Thanks a ton. PrashanthClinton Begin <[EMAIL PROTECTED]> wrote: sqlMapClient.flushDataCache();Cheers,Clinton On 11/16/05, Prashanth Sukumaran <[EMAIL PROTECTED]> wrote:Hi All, I am using OSCache for caching query results in iBatis. I have a cachemodel with flushinterval as 12. How do i
You know what? That worked perfectly. I cannot believe I missed that.
Thanks a lot!
Mike
-Original Message-
From: Zarar Siddiqi [mailto:[EMAIL PROTECTED]
Sent: November 17, 2005 4:51 PM
To: user-java@ibatis.apache.org
Subject: Re: Nested Lists
When you're calling "getGamesForChannel"
Hrm. Let me fix that, and see if the NPE goes away. Here's hoping...
And yes, I'd love to not have an N+1 select, but I haven't yet understood
how to do the joins sufficiently well so that all the different records are
returned.
Mike
-Original Message-
From: Zarar Siddiqi [mailto:[EMA
Thanks. I added the stacktrace to the JIRA issue.
The experiment didn't work.
BTW, my workaround currently is to use the nullValue syntax inline, which
works fine.
> Hello,
>
> We'll need a stack trace. Just for kicks though, try specifying the type
> explicitly:
>
> #deploymentStatusId:NUMERIC#
No, unfortunately there is no concept of object identity in
iBATISand as far as we can tell, there never will be. It's a
concept that does not mix well with SQL mapping...
This is where custom, or domain specific, caching comes into play.
Cheers,
ClintonOn 11/10/05, Paul Benedict <[EMAIL PRO
There's a properties file for database configuration in the WEB-INF/classes/properties directory
Cheers,
Clinton
On 11/11/05, Scott Purcell <[EMAIL PROTECTED]> wrote:
Hello,I
am interested in seeing how the IBatis persistance framework may assist
in some development, so I downloaed the iBATIS_JPetS
sqlMapClient.flushDataCache();
Cheers,
ClintonOn 11/16/05, Prashanth Sukumaran <[EMAIL PROTECTED]> wrote:
Hi All, I am using OSCache for
caching query results in iBatis. I have a cachemodel with
flushinterval as 12. How do i initiate the flush cache myself? Is there any way i can get th
Do you have the ping query (or validation query) enabled?
Cheers,
ClintonOn 11/17/05, mischa <[EMAIL PROTECTED]> wrote:
is there anything i can do to prevent ibatis from putting backconnetions to the pool when they are already closed? i am working withcluster pairs and when the connection to one
Hello,
We'll need a stack trace. Just for kicks though, try specifying the type explicitly:
#deploymentStatusId:NUMERIC# or whatever it is...
Cheers,
Clinton
On 11/16/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Is this a bug, or am I doing something wrong? Here's my insert statement.
You can call sqlMapClient.flushDataCache()
Cheers,
ClintonOn 11/15/05, Prashanth Sukumaran <[EMAIL PROTECTED]> wrote:
Hi All, I have configured OSCache as the cache model for ibatis. I would like to flush the cache. I
am trying to use the oscache flush JSTL tablib to accomplish
this. Eve
Only items read from the database are put on the cache. The only
way uncommitted data could get there is if your transaction isolation
level is read_uncommitted.
Cheers,
ClintonOn 11/15/05, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
Hi,
How does
SQLMaps ensure the data put on to the
The "get_channel-info" result map specifies a column of "channelID" as input to the select "getGamesForChannel". There is no such column in the query. Maybe that's it???
Jeff Butler
On 11/17/05, Michael Laccetti <[EMAIL PROTECTED]> wrote:
So nobody has any ideas?Mike-Original Message-
When you're calling "getGamesForChannel", you're specifying the
parameterClass as a String whlie you're passing it a channelID which I am
assuming is an Integer.
Also, regarding this syntax:
select="getLeaguesForGame" />
I'm not too sure you can do what you're doing in the column attribute.
So nobody has any ideas?
Mike
-Original Message-
From: Michael Laccetti [mailto:[EMAIL PROTECTED]
Sent: November 16, 2005 10:56 PM
To: user-java@ibatis.apache.org
Subject: Nested Lists [signed]
I've got a bit of a tricky question. I'm trying to retrieve a list of
objects from the data
is there anything i can do to prevent ibatis from putting back
connetions to the pool when they are already closed? i am working with
cluster pairs and when the connection to one cluster fails i am
switching back to another. it seems like the connection that failed/is
closed is getting put back
I believe this is because reusing result maps is a feature of the "groupBy" function, and iBATIS assumes the property will be a Collection of some kind. So, the real answer is that you can reuse result maps if your properties are collections. Otherwise not.
I'm not sure if this is an oversight
Well for starters I am not sure why you wrote your own Custom Type Handler (CTH). Both the CLOB and BLOB handlers are now built into iBatis.But in any case I think you will find your answer here...http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+BLOB+or+CLOBLooks towar
Title: Inserting Blob Data in Oracle 9i
Hi,
We are doing some feasibility analysis on IBatis SqlMapper. We are using Oracle 9i database and ojdbc14.jar as driver, and we have external Typehandlers for clob and blob data and are matched to String and byte array respectively. As for as fetching
Rick's examples stil use 1.x, so they need to be changed for 2.x development.
Larry
On 11/17/05, Scott Purcell <[EMAIL PROTECTED]> wrote:
> I am trying to get an understanding of the IBatis framework, and I am
> currently using the reumann web example as a tool. My problem is as follows
> thou
Hi, Xinyu.
You can specify a nested resultMap for the bean property instead of a column.
Of course, in your example, you could just map directly to the bean and not
use a HashMap at all, since the bean is the only property in the map. But
you could have more beans or other non-bean properties
I am trying to get an understanding of the IBatis framework, and I am currently
using the reumann web example as a tool. My problem is as follows though.
In the EmployeeSQL.xml mapping, I am seeing elements like this:
and
But as I am using the DevGuide.pdf from the IBatis site download, they
Add remapResults="true" to the statement.
Larry
On 11/17/05, Mathew Samuel <[EMAIL PROTECTED]> wrote:
>
> When column is added dynamically to an Oracle table
> that is already defined and operated upon within an
> sqlmap, (using select * from table), a general fetch
> (results of a "select *" is
I tried this, but get the following error. I am using the java version
2.1.6.589 (Sorry about the long trace). Hoping someone can shed some
light on this.
Thanks.
Huy
My map is below:
extends="pickResultMap">
org.springframework.jdbc.UncategorizedSQLExcepti
HI,
if the resultMap class is
a HashMap,and a property in it is a javabean class,it has serval
properties. How to set the resultMap for the
property?
I write the resultMap
like under,but it doesn't work.
select PRD_ID,PRD_DESCRIPION from product
How to set the pr
When column is added dynamically to an Oracle table
that is already defined and operated upon within an
sqlmap, (using select * from table), a general fetch
(results of a "select *" is mapped to a HashMap)
before and after the deletion of that column causes
iBATIS to reference the column name from
27 matches
Mail list logo
