ry changing the DOCTYPE of your XML files to the following.
http://ibatis.apache.org/dtd/sql-map-config-2.dtd";>
http://ibatis.apache.org/dtd/sql-map-2.dtd";>
http://ibatis.apache.org/dtd/dao-2.dtd";>
Notice the change to http://ibatis.apache.org/dtd/
Clinton
On Thu, May
I am using iBatis version 2 and Spring 2.5
My XML:
http://www.ibatis.com/dtd/sql-map-config-2.dtd";>
my1.xml looks like:
http://ibatis.apache.org/dtd/sql-map-2.dtd"; >
When I start the server with the application deployed
nks,
Kiran
From: Clinton Begin
To: user-java@ibatis.apache.org
Sent: Tue, May 18, 2010 9:53:25 AM
Subject: Re: Sql Map
You can read it in from the file and try to pass it in just like any other
parameter. It's hard to fully understand what you're trying
atis.apache.org
> *Sent:* Mon, May 17, 2010 6:17:39 PM
> *Subject:* Re: Sql Map
>
> If it's in a property file, can you just do this at the build stage? It
> will be faster to do so too.
>
> Clinton
>
> On Mon, May 17, 2010 at 2:42 PM, kiran vuppla > wrote:
>
: Clinton Begin
To: user-java@ibatis.apache.org
Sent: Mon, May 17, 2010 6:17:39 PM
Subject: Re: Sql Map
If it's in a property file, can you just do this at the build stage? It will
be faster to do so too.
Clinton
On Mon, May 17, 2010 at 2:42 PM, kiran vuppla
wrote:
>
>Hi,
>
>
&
If it's in a property file, can you just do this at the build stage? It
will be faster to do so too.
Clinton
On Mon, May 17, 2010 at 2:42 PM, kiran vuppla
wrote:
> Hi,
>
> I would like if we can do the following check in the Query inside
> statement. I am reading the property from property f
Hi,
I would like if we can do the following check in the Query inside
statement. I am reading the property from property file instead of parameter
map. Though I have the property(CONSTRAINT) in the property file, this is not
getting added to the existing SQL statement. Can someone help me.
Everything everywhere should always be utf-8, IMO. ;-)
ISO-8859-1, WIN-1251, and MacRoman are all of the devil.
Larry
2010/4/26 Björn Raupach :
> Ok, solved my issue. I added the following statement before instantiating
> SqlSessionFactory.
>
> [..]
> Resources.setCharset(Charset.forName("UTF-
Ok, solved my issue. I added the following statement before instantiating
SqlSessionFactory.
[..]
Resources.setCharset(Charset.forName("UTF-8"));
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader,props);
[..]
Maybe UTF-8 sho
Hi,
there are some german umlauts in my mapper files. In fact all the column and
table names in the database are in german. Unit tests run fine. If I create a
jar file and include all the mapper files, the application crashes with an sql
exception because the umlauts in the table name are not
I have just used Ibator for the first time. I notice that the sql it
generated had an Id like this:
However in the same file that sql id is referenced like this:
members is the table that I ran Ibator against.
I just added this table name to the id in the sql reference and
everything worked
Hello IBatis dev, gurus and mortals, I have a Wicket/AppFuse web application in
Eclipse that uses a simple xxxsql.xml map. The web app builds and deployes OK
on both jetty and tomcat. Then, I installed the IBator Eclipse plugin and
generated the artifacts for the xxxsql.xml mapped as generated b
You can use a factory, a singleton, or a dependency injection container such
as Spring or Guice.
Cheers,
Clinton
On Sat, May 23, 2009 at 9:08 PM, Anoop kumar V wrote:
> I was reading the example that ships with Ibatis and the initializer block
> has this comment before configuring the S
I was reading the example that ships with Ibatis and the initializer block
has this comment before configuring the SQL Map. I was just curious what is
the best practice of configuring one if not in the class initializer / a
constructor? I was hoping to call the class as part of the servlet init
m two different datasources? And should the
construction of an object be completed in the DAO?
Warren
Brandon Goodin wrote:
You are correct.
Brandon Goodin
On Fri, May 1, 2009 at 1:48 PM, Srinivas Doddi <mailto:srinivas_do...@gap.com>> wrote:
We were using two separate Sql Map Confi
You are correct.
Brandon Goodin
On Fri, May 1, 2009 at 1:48 PM, Srinivas Doddi wrote:
> We were using two separate Sql Map Configuration files for this kind of
> scenario. In IBATIS, I guess there is no way of specifying two different
> Sql maps clients in a single configura
gt;
> Thanks
>
>
> On Fri, May 1, 2009 at 2:21 PM, Brandon Goodin
> wrote:
>
>> Why not create a separate SqlMapClient for the Oracle database?
>>
>> Brandon Goodin
>>
>>
>>
>> On Fri, May 1, 2009 at 1:09 PM, Bhaarat
We were using two separate Sql Map Configuration files for this kind of
scenario. In IBATIS, I guess there is no way of specifying two
different Sql maps clients in a single configuration file. ( Correct
me, if I am wrong)
Thank you.
SRINIVAS DODDI
From
t;
> On Fri, May 1, 2009 at 1:09 PM, Bhaarat Sharma wrote:
>
>> Hi
>> Currently our sql-map-config looks like this:
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> In the
also, we have a spring-for-ibatis.xml file where we have code like this
so can I then just add another bean with jndi like this:
then another bean for sql-map-client (I will have to make another xml right?
say sql-map-client1.xml)
and then start
Why not create a separate SqlMapClient for the Oracle database?
Brandon Goodin
On Fri, May 1, 2009 at 1:09 PM, Bhaarat Sharma wrote:
> Hi
> Currently our sql-map-config looks like this:
>
>
>
>
>
>
>
>
>
>
>
>
>
&g
Hi
Currently our sql-map-config looks like this:
In the above we only have one JDBC connection and this connection goes to a
SQL Server. However, now we will have to access another DB which is in
Oracle. So we will have to create another JDBC connection and have
WebSphere encodes the password using XOR in an xml file which is not the
same an encrypting.
I would suggest the appserver route. In at least the version of weblogic
that I am using, the password is saved to the file system, but it is
encrypted in the config file. If that isn't possible, just encrypt the
password yourself and put some decryption code in an extension of the
datasource.
On
You could use JNDI, or can extends the simple datasource and add your own
hashing. I'm not sure why you are that concerned about the password being in
there. If someone gets access to your WEB-INF folder and you don't want them
in there... you have bigger issues my friend. :)
Brandon
On Tue, Apr
Not sure about doing it programatically, but it's going to end up being
cleartext (or close to it) somewhere...
For example when you use a connection pool in an app server, the
user/password ends up being plain text in your domains configuration
file... I believe most people focus on securing
Hi
I'm new to Ibatis and was wondering if anyone's faced this issue before.
Couldn't find a solution on the website FAQs.
I have the following in my sqlmapconfig file.
I dont want the user name and password to be exposed as clear text in a
config f
On Wed, Feb 11, 2009 at 7:33 PM, Vorius wrote:
> I am referring to programmatically altering the sql maps (specifically,
> adding entirely new select statements) once the applciation has already
> started.
I believe that Clinton did some stuff to make that possible with
ibatis2 (it's definitely d
$fullsql$
Is this ok for you?
t; You can search document for details
>
>
>
> On Thu, Feb 12, 2009 at 4:59 AM, Vorius wrote:
>
>>
>> Is it possible to create a sql map dynamically?
>>
>> I was reading about a method of creating an xml stream in memory and
>> passing
>> that to I
Using $param$ in sql.
You can search document for details
On Thu, Feb 12, 2009 at 4:59 AM, Vorius wrote:
>
> Is it possible to create a sql map dynamically?
>
> I was reading about a method of creating an xml stream in memory and
> passing
> that to Ibatis but I was hoping
Is it possible to create a sql map dynamically?
I was reading about a method of creating an xml stream in memory and passing
that to Ibatis but I was hoping of a way of doing it using getters/setters.
Is there any new method that may accomplish this?
--
View this message in context:
http
t
> > version. Am I mistaken? Where can I get the latest version of the docs?
> >
> > -Original Message-
> > From: Chema [mailto:demablo...@gmail.com]
> > Sent: Saturday, January 31, 2009 2:18 PM
> > To: user-java@ibatis.apache.org
> > Subject: Re: SQL
rs Guide available on the website that it was the latest
> version. Am I mistaken? Where can I get the latest version of the docs?
>
> -Original Message-
> From: Chema [mailto:demablo...@gmail.com]
> Sent: Saturday, January 31, 2009 2:18 PM
> To: user-java@ibatis.ap
Sent: Saturday, January 31, 2009 2:18 PM
To: user-java@ibatis.apache.org
Subject: Re: SQL-Map / CDATA Performance Issue
Yes, yours is old.
Mine is dated on November 30, 2006 (2.3.x )
2009/1/31 M. Goodell :
> Thanks for your help. I do not see a reference to statementCaching in my
> ver
Do you have statememnt logging enabled?
On 1/31/09, MGG List Subscription wrote:
> When I format the SQL within my insert element like Example 1.0 and time
> several application calls the performance is degraded *substantially*.
> However, if I format the SQL as shown in Example 1.1 the performan
gt; iBATIS-SqlMaps-2_en.pdf
>
> Is there more recent docs available other than the ones I have?
>
> -Original Message-
> From: Chema [mailto:demablo...@gmail.com]
> Sent: Saturday, January 31, 2009 1:54 PM
> To: user-java@ibatis.apache.org
> Subject: Re: SQL-Map
: Chema [mailto:demablo...@gmail.com]
Sent: Saturday, January 31, 2009 1:54 PM
To: user-java@ibatis.apache.org
Subject: Re: SQL-Map / CDATA Performance Issue
About docs:
statementCachingEnabled (iBATIS versions 2.3.0 and later)
With this setting enabled, iBATIS will maintain a local cache of
brief example of turning on statement caching? I
> have read without it there is a performance hit.
>
> Thanks!
>
> M. Goodell
>
> -Original Message-
> From: Chema [mailto:demablo...@gmail.com]
> Sent: Saturday, January 31, 2009 1:12 PM
> To: user-java@ibatis.a
: Saturday, January 31, 2009 1:12 PM
To: user-java@ibatis.apache.org
Subject: Re: SQL-Map / CDATA Performance Issue
What version are you using ?
Do you have statement caching enabled ?
2009/1/31 M. Goodell :
> Looking further into this it seems to have little to do with the CDATA tag
> b
NTO people (last_name,first_name,age) VALUES
> (#lastName#,#firstName#,#age#);
>
> -Original Message-
> From: M. Goodell [mailto:mggl...@comcast.net]
> Sent: Saturday, January 31, 2009 12:52 PM
> To: Chema; user-java@ibatis.apache.org; mggl...@comcast.net
> Subject: RE: SQL-Ma
12:52 PM
To: Chema; user-java@ibatis.apache.org; mggl...@comcast.net
Subject: RE: SQL-Map / CDATA Performance Issue
Here is some more information:
1.) Using (Format A) and inserting 10,000 records this takes roughly 12-15
seconds.
(Format A)
2.) Using (Format B) and inserting 10,000 records
-
From: Chema [mailto:demablo...@gmail.com]
Sent: Saturday, January 31, 2009 12:24 PM
To: user-java@ibatis.apache.org; mggl...@comcast.net
Subject: Re: SQL-Map / CDATA Performance Issue
And without CDATA tag ? Same performance ?
Indeed, I don't know why you use it for that query
2009
And without CDATA tag ? Same performance ?
Indeed, I don't know why you use it for that query
2009/1/31 MGG List Subscription :
> When I format the SQL within my insert element like Example 1.0 and time
> several application calls the performance is degraded *substantially*.
> However, if I forma
When I format the SQL within my insert element like Example 1.0 and time
several application calls the performance is degraded *substantially*.
However, if I format the SQL as shown in Example 1.1 the performance
improves dramatically.
It seems the larger the SQL statement and the more "pretty" fo
hello everybody;
We have a situation where we need a map as follows:
show tables from ${DATABASE}$ LIKE "%$tableName$%";
right now we set the property {DATABASE} in a property file that is loaded
into sql-Map-config.xml file.
This works all right...
For our JA
> Can queryForMap(...) behaviour be expressed in the SQL Map XML files?
I guess the answer is "no" then.
Expect it wouldn't be too much work to add this as a feature though.
In the way Complex Collection Properties (List or Collection of a business
object) can be loaded n
getDepartmentId(), "employeeId");
However, was wondering if there is any way this can be done directly in the
SQL Map XML file so I take advantage of lazy loading.
Cheers,
D.
--
View this message in context:
http://www.nabble.com/Can-queryForMap%28...%29-behaviour-be-mimicked
I need help in mapping the following batch statement in iBatis sql map.
declare @newFuncIdnumeric(7,0),
@newFailureId numeric(7,0),
@newEffectid numeric(7,0) ,
@newCauseID numeric(7,0) ,
@newControlID numeric(7,0
Since you are using 2.1.7 you will need to upgrade and try this with the
most current version. I believe this issue is fixed in the most current
version. I could be wrong. I made the same comment on the JIRA ticket. But,
I figured it would be worth repeating here.
Thanks,
Brandon
On 8/27/07, Mich
Please open a JIRA ticket on this if it does not exist. In the meantime you
may want to pass your list in nested in a map.
Brandon
On 8/27/07, Michel Amaral <[EMAIL PROTECTED]> wrote:
>
> When I use parameterClass of java.util.List type with dynamic notation
> ($[].field$), the property (after do
When I use parameterClass of java.util.List type with dynamic notation
($[].field$), the property (after dot) is ignored and the toString method of
the current list element is called instead of the indicated property, for
example, the follow statement map is calling toString twice:
SELECT
FROM
Hi Ayan,
Brad - i believe when you have a WHERE clause already specified,
you do not need to use "".
You're thinking is probably right on this, but I'll go ahead and be a
bit more explicit on the tag (hopefully I'm not hijacking
the thread too much here).
Let's suppose we have a query that *
03/06/2007 05:20 PM
Please respond to
user-java@ibatis.apache.org
To
user-java@ibatis.apache.org
cc
Subject
Re: SQL Map Problem - iterating through a list, using a like query
Could it be that you are missing the tag wrapped around the
?
[EMAIL PROTECTED] wrote:
Hi,
I am trying to do a
Could it be that you are missing the tag wrapped around
the ?
[EMAIL PROTECTED] wrote:
Hi,
I am trying to do a select from a
table,
using dynamic sql like so:
SELECT *
FROM TABLE_NAME
WHERE STATUS = 'A'
On 3/7/07, Jeff Butler <[EMAIL PROTECTED]> wrote:
I don't believe the iterator works with string substitution, so you'll
need to use parameters instead
Well, seems in fact it does - I have the following working:
(main_detail_type_id = $serviceDetails[].deta
I don't believe the iterator works with string substitution, so you'll need
to use parameters instead (#accountList[]#). Of course, this presents its
own unique set of problems. It would be best to add the % characters in the
DAO. Else, you'll have to do the concatentation in SQL. You'll likel
Hi,
I am trying to do a select from a table, using dynamic sql like so:
SELECT *
FROM TABLE_NAME
WHERE STATUS = 'A'
UPPER(ACC_SHRT_NM) like UPPER('%$accountList[]$%')
Basically I want this query to create a bunch of "like" clauses using the
elements of the List
Hi Tegan,
There may be other ways to solve your problem.
How much SQL are the users allowed to enter? Perhaps it can be done
by using $value$ instead of #value# in critical places in an existing
sql map (This is how WHERE clauses in Abator-generated sql maps work
for the query-by-example bits
Hi all,
Does anyone have any pointers for how I would add a sql map to the
SqlMapClient at runtime. I'm writing a GUI that lets a use enter a piece of
SQL and I'm using iBATIS to do the heavy lifting of mapping my java parameters
to the sql and executing it and doing the retu
Use a Map, and please read the developer's guide.
http://ibatis.apache.org/javadownloads.html
Larry
On 11/6/06, Makunda Thapa <[EMAIL PROTECTED]> wrote:
Hi,
I all, I have been involved to convert old daos to sql mapper xml. One of
the problem I having is.My old daos uses same field in more t
Hi,
I all, I have been involved to convert old daos to sql mapper xml. One of
the problem I having is.My old daos uses same field in more than one
params. I have to keep adding these fields in to my VO to pass in to the sql
mappers. For example
Object[] params
Larry Meadors" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 22, 2006 9:54 PM
Subject: Re: sql map via Java API
The advantages would be parameter mapping, resource management, and
result mapping.
The disadvantages are the increased potential for sql injection, a
slight loss of
: user-java@ibatis.apache.org
Subject: Re: sql map via Java API
Yes - good one!!!
However, just to carry this a bit further, ideally, I would like to
have
iBatis prepare this once and then use the prepared statement.
As I understand it, 'remapResults=true' will force a lot of work due
to
exa
bject: Re: sql map via Java API
Yes - good one!!!
However, just to carry this a bit further, ideally, I would like to
have
iBatis prepare this once and then use the prepared statement.
As I understand it, 'remapResults=true' will force a lot of work due
to
examining the resul
Thursday, June 22, 2006 2:52 PM
Subject: Re: sql map via Java API
Yeah, it's risky, but life is about risks, right? :-)
remapResults="true">$generatedSqlStatement$
Larry
On 6/22/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote:
Hi:
Is there any way of subm
Yeah, it's risky, but life is about risks, right? :-)
$generatedSqlStatement$
Larry
On 6/22/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote:
Hi:
Is there any way of submitting a new ..... SQL Map
snippet via the Java API. Or, alternatively, is there a way of contructing
an o
Hi:
Is there any way of submitting a
new . SQL Map snippet via the Java API. Or,
alternatively, is there a way of contructing an object, from iBatis, that
accomplishes the same thing?
What I am trying to do is build
a SELECT statement at execution time, based on parameters
correction (Sorry
for repeating, I wasnt sure if I was clear enough in my earlier mail)
Regards
~Rashmi
-Original Message-
From: jeremy jardin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 3:11 PM
To: user-java@ibatis.apache.org
Subject: RE : sql-map-config pb
Yes, thx a lot
Yes, thx a lot !
Is it possible to set that conf as default using Abator ?
-Message d'origine-
De : Rashmi Dixit [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 21 juin 2006 11:36
À : user-java@ibatis.apache.org
Objet : RE: sql-map-config pb
I guess this is because your in your set
To: user-java@ibatis.apache.org
Subject: RE : sql-map-config pb
Thx all right !
But now, I have another pb parsing sqlmap file :
could not find SQL statement to include with refid
'UTILISATEUR.abatorgenerated_Example_Where_Clause'
I checked my sql-map.xml config file (gener
Hi Jeremy,
you would also need something like
##SQL here##
in the sqlmap.
Torsten
Original-Nachricht
Datum: Wed, 21 Jun 2006 11:30:31 +0200
Von: jeremy jardin <[EMAIL PROTECTED]>
An: user-java@ibatis.apache.org
Betreff: RE : sql-map-config pb
> Thx all right !
>
derstand what's the matter with that file !!
Thx !
-Message d'origine-
De : Rashmi Dixit [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 21 juin 2006 11:18
À : user-java@ibatis.apache.org
Objet : RE: sql-map-config pb
You need to correct the DOCTYPE entry at the begi
You need to correct the DOCTYPE entry at the beginning of your file.
http://www.ibatis.com/dtd/sql-map-config-2.dtd";>
~Rashmi
From: jeremy jardin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 2:42 PM
To: user-java@ibatis.apache.org
Hello,
I’m first time using Ibatis, and I have a problem with the sql-map-config.xml
file.
I write it like that :
xml version="1.0" encoding="UTF-8"?>
DOCTYPE sql-map-config PUBLIC
"-//iBATIS.com
//DTD SQL M
It's corrected now, my lacks about ibatis make me search the error at
the wrong place.
Thank for your kind help.
Robbie.
And how would that error look like? Seems like this should work just
fine.
Niels
-Original Message-
From: Sol [mailto:[EMAIL PROTECTED]
Sent: woensdag 22 maart 2006 18:04
To: user-java@ibatis.apache.org
Subject: Sql Map self call
I all, i'm totally new to IBatis so i need some pie
I all, i'm totally new to IBatis so i need some piece of advices !
column="idOperationParent"/>
select * from operation where id=#value#
Is this kind of map executable by IBatis ? i'm getting a error.
I all, i'm totally new to IBatis so i need some piece of advices !
column="idOperationParent"/>
select * from operation
Is this kind of map executable by IBatis ? i'm getting a error.
You are asking us if your code works?
A few things I might change...
1. change your tag to a
2. add a parameter class attribute to the select
3. If you are going to have different numbers of columns selected
then you need to set reMapResults = true.
This is really the lazy mans way to thin
Is this sql mapping works in the IBATIS?
select $list_cols$
FROM $table_name$
Map map = new HashMap(2);
map.put("list_cols", "STATE_ABBRV, STATE");
map.put("table_name", "USSTATE_DESC");
return getSqlMapClientTemplate().queryForList(
"select_list", map);
-Hen
You need to get your SQL logging working - search the archives to get
that working.
The problem you are having are not iBATIS issues, they are because the
SQL that you are building is broken.
Get your logging working, and the resolution will be apparent.
Larry
On 1/11/06, Henry Lu <[EMAIL PROT
I made changes and it worked! But now I made more changes and it broken
again:
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in
task 'SqlMapClient operation'; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
occurred while applying a
If you're using commons logging (and you should be), you can set logging for "java.sql" to
debug (in the properties file version: "log4j.logger.java.sql=DEBUG"). This will print all
the generated SQL, along with parameters and result sets, in your log.
Also, it looks like the error message says
EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 11:15 AM
To: user-java@ibatis.apache.org
Subject: dynamic sql map
I got errors:
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in
task 'SqlMapClient operation'; nested exception is
com.ibatis.common.jdbc.exception.Nes
I always try to simplify first, then add stuff until it breaks.
For example, try this:
select
STATE_ABBRV as m_name,
STATE as m_value
FROM USSTATE_DESC
Does that work?
You may also want to enable logging, and/or try something like p6spy
to see the SQL. This is a SQL error, based on the me
I got errors:
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in
task 'SqlMapClient operation'; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
occurred in edu/umich/med/umms/coreyp/dao/ibatis_map/misc.xml. --- The
error occurred whil
cc|
|
|
|
Subject|
|Re: utilizing nested iterate tags in SQL Map xml file -- i
st of objects of arelated class (for example player). Is it possible to iterate over bothlists by nesting iterate tags in the SQL map file?If it is possible, are there examples on how to do this? We've tried
everything we could think of but without any luck.Thanks for your help,Mark--
lists by nesting iterate tags in the SQL map file?
If it is possible, are there examples on how to do this? We've tried
everything we could think of but without any luck.
Thanks for your help,
Mark
-
E-mail Disclaimer:
The information contained in t
Absolutely.
-Original Message-
From: Ron Grabowski [mailto:[EMAIL PROTECTED]
Sent: 27 October 2005 14:10
To: user-java@ibatis.apache.org
Subject: RE: calling trim() on sql map returned strings
Would you agree that being able to replace the default String type
handler would make your
it's
> very verbose.
>
> Cheers,
> Gareth.
>
> -Original Message-
> From: Nathan Maves [mailto:[EMAIL PROTECTED]
> Sent: 26 October 2005 17:58
> To: user-java@ibatis.apache.org
> Subject: Re: calling trim() on sql map returned strings
>
>
> wh
ed the type
handler/resultmap solution - it's less invasive, even if it's very verbose.
Cheers,
Gareth.
-Original Message-
From: Nathan Maves [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 17:58
To: user-java@ibatis.apache.org
Subject: Re: calling trim() on sql map returned s
back
is that you can't say "use this type handler for all strings". You
have
to specify the special type handler per each item in your
parameterMap/resultMap. A lot of people don't use parameter maps.
Its a
pain to have to specify a type handler for each and ever String in
to have to specify a type handler for each and ever String in your
sql map files. Being able to set the type handlers globally cuts down
on the amount of extra clutter in your sql map files.
--- Gareth Moorst <[EMAIL PROTECTED]> wrote:
> That's interesting... I'll have a look a
That's interesting... I'll have a look at that tomorrow- The sqlmapconfig dtd
does have a typehandler child..
Cheers
-Original Message-
From: Ron Grabowski [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 17:13
To: user-java@ibatis.apache.org
Subject: RE: calling trim()
TECTED]
> Sent: 26 October 2005 13:34
> To: user-java@ibatis.apache.org
> Subject: Re: calling trim() on sql map returned strings
>
>
> Hi Gareth,
>
> Doesn't Informix have a trim-like function you could apply in your
> query?
>
> Like:
>
> se
hat way is that I can't use select * anymore, but
suppose I'll have to live with that.
Ta.
-Original Message-
From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 13:34
To: user-java@ibatis.apache.org
Subject: Re: calling trim() on sql map returned
lf at all clear in that last email -
> it must still be too early in the day for rational thought...
>
> what I want to do is call trim() on all the strings I return from the db.
>
> -Original Message-
> From: Gareth Moorst
> Sent: 26 October 2005 10:01
> To: user-ja
email - it
must still be too early in the day for rational thought...
what I want to do is call trim() on all the strings I return from the db.
-Original Message-
From: Gareth Moorst
Sent: 26 October 2005 10:01
To: user-java@ibatis.apache.org
Subject: calling trim() on sql map returned
1 - 100 of 115 matches
Mail list logo
