I noticed there are only two tables involved, could you try with some
different database engine ? If you still get similar exception, one should
start inspecting your code/iBatis code, if not, definitely it's a driver/db
server problem (try different driver)...
Can your query raise exception that's handled elsewhere, so that
session.close() is not called? Try this:
SqlMapSession session = sqlMap.openSession();
List list = null;
try {
list = (List) session.queryForList(queryId);
}
catch (Exception e)
{
I'm inserting images into MS Sql (table field type is image i.e.
variable-length binary data) without problems with no special configuration.
I have an Image class with two properties
String imageID
byte[] imageBytes
and the insert looks like
insert id='insertImage'
, Nicholoz Koka Kiknadze
[EMAIL PROTECTED] wrote:
Can your query raise exception that's handled elsewhere, so that
session.close() is not called? Try this:
SqlMapSession session = sqlMap.openSession();
List list = null;
try {
list = (List) session.queryForList(queryId
(updateSingleSomeObject,ListSomeObject)
Think it will make iBatis more consistent: we have queryForList, i.e.
getting list of objects in a single line of code, so it's quite natural to
expect that one should be able to persist the list in a single call.
Wonder what others think about it.
Nicholoz Koka
Jeff,
Just for an argument ;) -- you are understating powers of iBatis ;) iBatis
can return list of objects running multiple susbselects for each row
(property column= select= / ) - something you'd have to do manually in
pure JDBC. In fact, I'd go further allowing inserting object with list
Here's extract from iBatis docs:
*Normally iBATIS will not commit transactions unless an insert, update, or
delete operation has been
performed. This is true even if you explicitly call the commitTransaction()
method. This behavior
creates problems in some cases. If you want iBATIS to always
First of all I'd add catch block to log errors to your try/finally. In your
code you do multiple inserts, so if any of them fails your whole transaction
will roll back. I can see no other possible scenario :(
wildcard parameter like qu*
Should not it be Like qu% ?
Turn on logging for connection and iBatis and check what SQL is actually
executed and whether it returns anything when executed from TOAD.
On Wed, Jun 18, 2008 at 3:13 AM, [EMAIL PROTECTED] wrote:
Dear sir(s):
Currently I
Hi,
I get results using resultClass=java.util.HashMap and I expected that if I
iterate values of the HashMap the order will correspond to the order in my
fields. However it does not. Is that normal behavior?
In other words I have 'Select f1, f2, f3 from Blah', and iterating in the
HashMap values
(this, this);
m.put(is, is);
m.put(a, a);
m.put(test, test);
for(Object o:m.values()) System.out.println(o);
}
The output on my box is:
a
is
this
test
Larry
On Fri, Jul 4, 2008 at 6:19 AM, Nicholoz Koka Kiknadze
[EMAIL PROTECTED] wrote:
Hi,
I get
Have a look at this thread:
http://www.mail-archive.com/user-java@ibatis.apache.org/msg11828.html
Good luck
On Wed, Aug 6, 2008 at 4:47 PM, Brian Parkinson [EMAIL PROTECTED] wrote:
Hello:
So, I have things up and running under Java and iBATIS, but running into
some starvation issue, and my
Indeed the link is broken. But the subversion one works:
http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/
Anyway usually docs in SVN are more up to date
Peace
On Mon, Aug 11, 2008 at 11:04 PM, Reuben Firmin [EMAIL PROTECTED]wrote:
I'm looking for the Ibatis
AFAIK the root of the problem is that when iBatis handles resultset of left
joining master table with child table the child table columns may be all
NULL and it's not quite clear whether child table indeed contained
corresponding row with NULL elements or there was no result found in the
child
To be honest in the first place I'd ask DBA to use partitioning if your db
engine supports that, and if not, to create union USERS query to run my
queries against.
miles_davis is out also, what a pity ;)
On Sat, Aug 30, 2008 at 12:03 PM, [EMAIL PROTECTED] wrote:
I will be out of the office starting 08/29/2008 and will not return until
09/08/2008.
I will respond to your message when I return. Please contact Alan May if
you need your questions address
Should not you use CDATA sections to get quotation marks intact in your SQL
? And like Jeff pointed out, look at the generated statements in your log
Look into the sqlmaps guide. There are condidtions like
isGreaterThen
isGreaterEqual
isLessThen
isLessEqual
On Tue, Nov 11, 2008 at 1:37 AM, Mehak [EMAIL PROTECTED] wrote:
Hi
Please help me with this simpl problem regarding using operators in compare
value.
I have a condition something
Or can somebody suggest another solution?
Maybe ask your DBA to increase max open cursors allowed? ;)
Honestly, I never quite understood iBATIS statement cacheing performance
gains with oRACLE (which IMO maintains stetement cache on its own). Are you
sure disabling it throughout your application
oops, misspelled, should be
isGreaterThan
isGreaterEqual
isLessThan
isLessEqual
gl ;)
On Tue, Nov 11, 2008 at 5:30 AM, [EMAIL PROTECTED] wrote:
XML does not support and operator as it is. You have to use
![CDATA[ Give your operator here]]
Hope this will help you
Regards
Ankit
When I deploy everthing to a Linux box I get the weirdest errors from the
Driver.
--- Cause: java.sql.SQLException: [unixODBC][INTERCHAIN][UNIMS-ODBC]
[UNIMS]
Well, maybe we can blame differences in ODBC layer? I've have never used
ODBC (or ODBC-JDBC bridge) on linux, any chance you can
parameterMap id=messageParameterMap class=Message
parameter property=id1 jdbcType=INTEGER/
parameter property=id2 jdbcType=INTEGER/
parameter property=messageCount jdbcType=INTEGER /
parameter property=title jdbcType=VARCHAR/
/parameterMap
2b) Scenario: copy/pasting from manual:
__
The transactionManager element also allows an optional attribute *
commitRequired* that can be *true* or *false*. Normally iBATIS will not
commit transactions unless an insert, update, or delete operation has been
performed. *This
Please enable logging to see what gets executed and specifically what value
for #jobPostingId# is passed.
On Thu, Dec 4, 2008 at 9:15 PM, Michael He [EMAIL PROTECTED] wrote:
Nothing happens without deleting anything
Micheal
Kai Grabfelder-2 wrote:
hm looks like a bug to me. What
Thank you Jeff for this wonderful tool!
Plugins making classes serializable and adding equals/hashcode are exactly
what I wished for ;)
May I ask whether standalone version is fully functional - initially it
was not, but then I was using Eclipse anyway.
Merry Christmas and Happy New Year
Ours is an application that requires guaranteed response times under 50 ms,
so:
1) We dropped using any kind of pool, so that
2) number of constantly open connections equals to the number of processors
(16)
3) I know you were asking about pool, but still I dared to respond with this
no-pool
equal (i.e. 16). Otherwise, how do you allocate
connections to the incoming requests?
Cheers,
Clinton
On Tue, Jan 20, 2009 at 12:33 PM, Nicholoz Koka Kiknadze
kikna...@gmail.com wrote:
Ours is an application that requires guaranteed response times under 50
ms, so:
1) We dropped using
a pool, but your max, min, idle, and
active connections are all equal (i.e. 16). Otherwise, how do you allocate
connections to the incoming requests?
Cheers,
Clinton
On Tue, Jan 20, 2009 at 12:33 PM, Nicholoz Koka Kiknadze
kikna...@gmail.com wrote:
Ours is an application that requires
0 == Doesn't matter to me
Absolutely
Maybe it makes sense to switch to DBCP as it has testOnBorrow setting (needs
a validation query of course) and the DBCP docs saying:
testOnBorrow: The indication of whether objects will be validated before
being borrowed from the pool. If the object fails to validate, it will be
dropped from the
I have used it with TimesTen 6 / 7 with JDK6. Had no iBatis related
problems.
On Thu, Jan 29, 2009 at 1:39 AM, Avitzur Alon alon.avit...@comverse.comwrote:
Hi,
I am thinking of using iBATIS in my application in order to access the DB.
I have two questions:
1. Does this version support
I recall one has to call
com.ibatis.common.logging.LogFactory.selectLog4JLogging()
before sqlmap is initialized
On Fri, Feb 6, 2009 at 4:25 PM, Stanley, Eric eric.r.stan...@qwest.comwrote:
Richard,
I know its being read. As I mentioned below, all other
components of the app are using
Add it manually :) Yours is such a weird problem, some unique combination
of some circumstances. I bet there's some no-framework related problem, both
iBatis and iBator are so simple or rather transparent (like everything
genial)
On Wed, Feb 18, 2009 at 4:41 PM, sanv viv...@gmx.at wrote:
Is
Default Value : status;
}
Alin Popa wrote:
Thanks Nicholoz,
This is what I've done. And I also have a facade that will abstract
for the user, the insert actions.
I thought that ibatis knows how to handle this, or have a trick for it.
On Wed, Mar 18, 2009 at 10:51 AM, Nicholoz Koka
It's possible to display the executed SQL somehow ?
Sure, it's possible to log what statements are prepared, what parameters are
set to and what results are retrived. Check the
'Logging SqlMap Activity' section in developer guide.
?
-Original Message-
From: Nicholoz Koka Kiknadze [mailto:kikna...@gmail.com]
Sent: Thursday, March 19, 2009 3:30 PM
To: user-java@ibatis.apache.org
Subject: Re: Cannot serialize session attribute ...
My first thought is that maybe StandardDaoManager can
Wow, took less than 24 hours ;).
On Fri, Mar 20, 2009 at 5:23 PM, Jeff Butler jeffgbut...@gmail.com wrote:
Support for this is now available in SVN.
Jeff Butler
On Fri, Mar 20, 2009 at 6:57 AM, Jeff Butler jeffgbut...@gmail.com
wrote:
Interesting idea.
Ibator does not currently
URL seems fine. Try using ojdb*6*.jar, I'm using it without problems..
GL
On Fri, Mar 20, 2009 at 9:35 PM, Sergey Livanov sergey.liva...@gmail.comwrote:
driver , url, user pwd.
jdbc.ORAdriverClassName=oracle.jdbc.driver.OracleDriver
jdbc.ORAurl=jdbc:oracle:thin:@192.168.1.15:1521:ORCL
Meant ojdbc6.jar of course
On Sat, Mar 21, 2009 at 2:08 AM, Nicholoz Koka Kiknadze
kikna...@gmail.comwrote:
URL seems fine. Try using ojdb*6*.jar, I'm using it without problems..
GL
On Fri, Mar 20, 2009 at 9:35 PM, Sergey Livanov
sergey.liva...@gmail.comwrote:
driver , url, user pwd
Found this:
http://www.nabble.com/Statement-Caching-Question-td20437084.html
Hope it helps
GL
2009/3/25 Daniel Sánchez Gómez dsanc...@satec.es
Hi,
I have a problem with open cursors using Ibatis in an Oracle data base.
When I open a transaction with a lot of querys and before the
I think you can use any DataSource (including ProxoolDataSource). Just use
full class name in your transactionManager's dataSource element and IMO it
should work.
On Mon, Mar 23, 2009 at 3:39 AM, Mike.G hyli...@gmail.com wrote:
Hi, everyone, ibatis can use proxool connection pool? how?
can add any property that has crresponding setXXX
in ProxoolDataSource.
On Wed, Mar 25, 2009 at 9:54 AM, Mike.G hyli...@gmail.com wrote:
Hi, thanks for you response.
could you give some example configurations?
thanks
Mike.G
2009/3/25 Nicholoz Koka Kiknadze kikna...@gmail.com:
I
In the manual we read:
The *jdbcType* element is used to specify the JDBC type of the parameter.
The value must be one of the types listed in java.sql.Types (VARCHAR,
INTEGER, etc.) Generally the *jdbcType* element is needed if there is a
possibility that the value could be NULL, or to specify
No I think. iBatis is not aware whether your VO-s have changed and can not
decide whther to run updates or not.
Why don't you override the Object.hashcode() method on your VO and
call it and save the value when you retrieve the record. Call it again when
the user submits their
Follow Nathan's suggestion.
Look up ping query in the developers manual. It will validate the query
before it uses it
In fact it will validate connection, discard the old one if necessary and
opens/return fresh one.
On Tue, Apr 14, 2009 at 11:13 PM, yhliu yh...@cn.ufinity.com wrote:
Thanks
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
On Tue, Apr 21, 2009 at 12:19 AM, sjpn p...@vignette.com wrote:
Hi,
I want to use ibatis as the standard for a large project. The client I'm
working for does everything in stored procs for performance
Maybe this would help
http://markmail.org/message/3r7dx4uixs273kxu
On Tue, Apr 21, 2009 at 1:33 PM, sjpn p...@vignette.com wrote:
could it be possible that ibatis is return back an empty cached resultset?
if
so, how can i disable this cache or trigger it to clear?
--
View this message
Try $thresholdValue$
On Mon, Apr 27, 2009 at 5:43 PM, Alex Sherwin
alex.sher...@acadiasoft.comwrote:
#thresholdValue# will put '100' in the SQL that is created (note: with
single quotes, making it a non-number value)
I assume what you want is to use $thresholdValue$, which will explicitly
To flush on demand you can just call
SqlMapClient.flushDataCache(String cacheId).
HTH
On Tue, Apr 28, 2009 at 10:32 AM, WhyDontYouSlide whydontyousl...@gmail.com
wrote:
Hello,
I was asking myself if It's possible to force flushing of the cache without
execute a real statement
for
Well, let DBA optimize query, but from the iBatis side maybe it makes sense
to increase fetchSize. See e.g.
http://markmail.org/message/3vy7p455yr5qkzbk#query:ibatis%20fetchsize+page:1+mid:tgs7lyqlyetn2jfv+state:results
On Wed, Apr 29, 2009 at 2:01 AM, Chris O'Connell
Have I
generate for every session an own SqlMapClient or can they share one. I
found no example
which shows it.
Share. It's thread safe.
It may be database dependent. Here's extract from oracle docs
http://download.oracle.com/docs/cd/B10501_01/java.920/a96654/oraperf.htm
After a batch exception, the update counts array can be retrieved using the
getUpdateCounts() method of the BatchUpdateException object. This returns an
int
IBatis creates this select:
to_date('2009-05-15 23.59.59', '-mm-dd hh24.mi.ss')
Well, there's no to_date function in your XML, so iBatis can not create it.
It only prepares statement (ps) with
AND b.ins_time = ?
AND b.ins_time = ?
and calls ps.setDate
Could you re-check your xml
I think what happens to open (pooled) connection upon JVM exit depends on
JDBC driver.
IMO if you were using SimpleDataSource of iBatis, you'd have to call
forceCloseAll() to close all pooled connections at the end of execution of
your app (I think I have even used that years ago). Not sure
I think the only reliable way to check whether connection is valid is to
execute something using the connection (so it requires roundtrip to db).
However
a) this execution happens only once for your transaction (which may include
numbers of CRUD operations etc)
b) Validation query is chosen to be
Turn on logging (see iBatis docs) to see what does the generated SQL
statement look like.
On Fri, Jun 19, 2009 at 7:34 AM, BruceKKK sibyl0...@gmail.com wrote:
i met ora-01795 error, so i need separate list to several size limited
lists,
I am trying use nested iterators to iterate over a List
Have you tried enclosing field names containing # with *CDATA *? Maybe it
will help...
On Thu, Jun 25, 2009 at 2:56 PM, markus.k...@bafin.de wrote:
Hi,
in our DB2 database, some columns have a # in their name, e.g. ID#
This conflicts now with the iBatis placeholder character #, e.g.
Is it possible that you just did not set your log file encoding? Kind of
log4j.appender.someappender.Encoding=UTF-8
On Tue, Jul 14, 2009 at 8:40 PM, Odelya YomTov ode...@jpost.com wrote:
Hi!
I am trying to insert data in Hebrew into the database
The table is set to utf-8.
But in the
between ibatis and mysql
*From:* Nicholoz Koka Kiknadze [mailto:kikna...@gmail.com]
*Sent:* Tuesday, July 14, 2009 9:52 PM
*To:* user-java@ibatis.apache.org
*Subject:* Re: problem with insert
Is it possible that you just did not set your log file encoding? Kind
Maybe I'm totally wrong, but I'm almost sure it must be possible to force
database server to RE-generate execution plans even for cached statements.
I've never used DB2 but googling a little I found:
You are quite right. Your problem is that calls to those two procedures are
not in a single transaction. Include them in a single transaction and proc2
will see package level variables set in proc1. Note that executing those
procs on a single connection object is not enough (i.e. you need
...@hotmail.comwrote:
Hi Nichol,
Thanks for your response. We are already using same transaction while
calling these procedures.
But we are not getting expected results.
Nicholoz Koka Kiknadze wrote:
You are quite right. Your problem is that calls to those two procedures
are
not in a single
I've enjoyed much using iBatis and the mailing list was always very helpful.
Well, now and then I have to search for answers in the mailing list and
usually find the answer ;) So far so good. But... I've used mailing list for
another framework - Tapestry for three major versions (3/4/5) and
valuecom.ibatis.sqlmap.engine.transaction.external.ExternalTransactionConfig/value
/property
property name=transactionConfigProperties
props
prop key=DefaultAutoCommitfalse/prop
/props
/property
/bean
Nicholoz Koka Kiknadze wrote:
Hm, but I have used package
No reply...
Seems separate list idea is soo absurd that no one bothers to explain why ;)
On Tue, Aug 18, 2009 at 10:00 PM, Nicholoz Koka Kiknadze kikna...@gmail.com
wrote:
I've enjoyed much using iBatis and the mailing list was always very
helpful.
Well, now and then I have to search
to explain why
;)
On Tue, Aug 18, 2009 at 10:00 PM, Nicholoz Koka Kiknadze
kikna...@gmail.com wrote:
I've enjoyed much using iBatis and the mailing list was always very
helpful.
Well, now and then I have to search for answers in the mailing list and
usually find the answer ;) So far
#3 - I think I'm the only person who does moderation on the ibatis
lists and don't want another one to manage. (NOTE: If someone wants to
do that with me, let me know, it's easy, but when I'm out of the
office the please subscribe emails pile up).
I'll be out of the office till September 6
Though I've never used oraclecursor with iBatis, I'll dare to note that
from the image attached I see that parametermap property for the
ORALECURSOR is the last one in the map.
But it must be the first one (order parameter map properties must match
order of ?,?... ).
On Fri, Aug 21, 2009 at
68 matches
Mail list logo