On Wed, Apr 29, 2009 at 5:30 AM, Nathan Maves nathan.ma...@gmail.com wrote:
I have not tried this but I don't see why it would not work.
SELECT * FROM person
WHERE person.lastname LIKE '%'||#lastname#||'%'
the || is the concat operator for oracle. it might be something else in
another
Hi Sean,
Check you bean class. Are your setters public and ok? Make sure you are
mapping to compatible data types from the database back to your bean. If
they cannot be converted implicitly, define a handler in the ibatis SQL
map XML to convert to your bean attribute's type.
Kevin
Hey, thanks for the TONS of helpful replies I got to this question! It's a
good thing this wasn't to solve an enterprise question or anything. Oh,
wait...it was.
Signing off...
Oracle v$session and iBatis
Leffingwell, Jonathan R CTR FRCSE, JAX 7.2.2
Tue, 14 Apr 2009 07:03:18 -0700
We are
Heh, welcome to Open Source Software. We all have jobs, too.
Feel free to contact any of us for freelance work. I'll happily drop
all that I'm doing to help you with your app if the rate's high
enough.
:-D
Larry
On Wed, Apr 29, 2009 at 5:18 AM, Leffingwell, Jonathan R CTR FRCSE,
JAX 7.2.2
I sympathize with your problem. Perhaps you could just build a set of sql
includes, each of which is the correct sql for a particular use case. Then,
rather than building the sql string in your code, you instead just pass a
parameter into iBatis that it can use to determine which is the correct
On Wed, Apr 29, 2009 at 2:44 PM, Chris O'Connell
oconn...@gorillachicago.com wrote:
I sympathize with your problem. Perhaps you could just build a set of sql
includes, each of which is the correct sql for a particular use case. Then,
rather than building the sql string in your code, you
I'm just wondering, how exactly are are monitoring the connections
using v$session? Since 27/28 sessions already seems to be way more
then what you configured: property
name=Pool.MaximumActiveConnections value=10/
Do you filter for the user that you configured and checking the
active/inactive
On Tue, Apr 28, 2009 at 5:52 PM, Nathan Maves nathan.ma...@gmail.com wrote:
Welcome to ibatis!
Thanks... it's a very interesting project, not sure how it escaped my
notice before. A very nice middle ground between Hibernate and
DBUtils.
Could you give us a little more information like what DB
On Wed, Apr 29, 2009 at 6:51 AM, Burke.Kevin kevin.bu...@cic.gc.ca wrote:
Check you bean class. Are your setters public and ok? Make sure you are
mapping to compatible data types from the database back to your bean. If
they cannot be converted implicitly, define a handler in the ibatis SQL
This really does look like a mapping issue. Please include the source code
of the bean and the select map that you are using.
On Wed, Apr 29, 2009 at 7:31 AM, Sean Mitchell s...@mitchwood.com wrote:
On Tue, Apr 28, 2009 at 5:52 PM, Nathan Maves nathan.ma...@gmail.com
wrote:
Welcome to
Is there some reason you can't use the dynamic where clause feature
in iBatis.
This is an example stolen directly from Clinton's book.
SELECT *
FROM category
parentCategoryId IS NULL
parentCategoryId=#parentCategoryId#
Doing
On Wed, Apr 29, 2009 at 9:46 AM, Nathan Maves nathan.ma...@gmail.com wrote:
This really does look like a mapping issue. Please include the source code
of the bean and the select map that you are using.
As I'm new to this company and they are a bit uptight about some
things, I'm not sure that
In my opinion, this was more of an Oracle question than an iBATIS question.
iBATIS SimpleDataSource doesn't do anything special. It opens and closes
connections based on how many you tell it to keep alive, using the driver
you specify. It has no idea what a v$session view is, nor do I. The
On Wed, Apr 29, 2009 at 9:20 AM, Clinton Begin clinton.be...@gmail.com wrote:
Larry's cheaper though, if you want to hire him. ;-)
Not much, but I am more fun to be around. :-D
Larry
14 matches
Mail list logo