You may find this thread helpful:
http://tinyurl.com/co6tt
http://www.mail-archive.com/ibatis-dev%40incubator.apache.org/msg01015.html
--- Ersin Er [EMAIL PROTECTED] wrote:
Brandon Goodin wrote:
This will help you:
Huy, could you give an example additional functionality that another
templating engine would provide? Someone (Brandon?) asked a question a
few weeks ago about what other dynamic sql tags people would like to
see. I don't think anyone ever responded. I couldn't think of any
additional tags myself.
You can use:
lt;
Or enclose the text within CDATA:
select id=getNOFBidding resultClass=int parameterClass=string
![CDATA[
SELECT * FROM Sale WHERE TO_DAYS(NOW()) - TO_DAYS(SALEDATE) = 15
]]
/select
--- Pham Anh Tuan [EMAIL PROTECTED] wrote:
Hi,
I can't not type sign in sql definition
PROTECTED] wrote:
The answer to that question is yes (even if the parameterClass is
specified).
But is it meant to be part of this thread?
Cheers,
Clinton
On 5/15/05, Ron Grabowski [EMAIL PROTECTED] wrote:
If a parameterClass or parameterMap is not specified:
select id
Do you want to have IBatis generate an xml file that can be loaded by a
DataSet's ReadXml method? Here's an example for the non-.Net people of
one way of saving a DataSet to XML:
DataSet ds = new DataSet(People);
DataTable dt = new DataTable(Person);
dt.Columns.Add(Name, typeof(string));
lists.
Fabrizio Gianneschi - For speaking at Java User Groups in Italy,
performing
case studies and writing Italian documentation.
Ron Grabowski - For being a helpful and very active member of the
mailing
list and submitting useful issues and feature requests regularly
Is the upcoming iBatis book going to be primarily focused on Java or
will equal time be spent on the .Net implementation as well?
--- Brandon Goodin [EMAIL PROTECTED] wrote:
Please provide straight JDBC code that calls the stored procedure.
I wanted to get a few examples from various
Calls to buildDaoManager resolve to this class:
http://tinyurl.com/9qymm
http://svn.apache.org/repos/asf/incubator/ibatis/trunk/java/mapper/mapper2/src/com/ibatis/dao/engine/builder/xml/XmlDaoManagerBuilder.java
Have you browsed the JPetstore source code:
http://tinyurl.com/bpgl7
-
From: Ron Grabowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 9:15 AM
To: ibatis-user-java@incubator.apache.org
Subject: RE: ANSI_PADDING
How is this an IBatis question? It sounds like you need to contact
the
database vendor and find out how to turn it off. If you were
How is this an IBatis question? It sounds like you need to contact the
database vendor and find out how to turn it off. If you were using
straight JDBC, how would you turn padding off?
--- Bitra, Venkateswararao (Corporate, consultant)
[EMAIL PROTECTED] wrote:
We never required to turn it off.
but that looks like it would be more prone to errors...
- Ron
--- Jason Punzalan [EMAIL PROTECTED] wrote:
Ahh...very helpful. thank you. what about inserts? can you use
iterate to
execute multiple inserts or updates? or do i have to make separate
calls in
my dao class?
On 4/23/05, Ron
I believe your code would incorrectly generate the following sql
statements (all on one line):
select * from content where id = 1
select * from content where id = 2
select * from content where id = 3
...
Take a look at the these test cases:
http://tinyurl.com/dadn5
Have you tried using CDATA like this (I'd be curious to know if this
works or not):
isNotEmpty prepend=AND property=description
![CDATA[
xyz
]]
/isNotEmpty
Maybe I missed this in the other responses to this thread, but does
this work:
isNotEmpty prepend=AND property=description
$ notation does not create a '?' for a prepared
statement ...
it's value (as indicated by Brandon) is placed into the SQL string
before
the prepared statement is generated.
On Apr 6, 2005 4:25 PM, Ron Grabowski [EMAIL PROTECTED] wrote:
How do I use the dollar sign notation (i.e. $xyz
How do I use the dollar sign notation (i.e. $xyz$) to send a string to
the database that has a pound sign on either side of it?
According to this post:
http://tinyurl.com/44je6
http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg01358.html
I should use a double pound to send
Have you tried using two pound signs?
INSERT INTO ##tempCount
--- Narasimha Prasad [EMAIL PROTECTED] wrote:
Hi
Is there a way to escape the # characters used in iBATIS SQL maps ?
The
reason is ask this is that we are running into a situation where we
need to
create
Temporary
When I go to this page in the wiki:
http://tinyurl.com/4njot
http://wiki.apache.org/ibatis/How_20do_20I_20get_20read_2donly_20access_20to_20the_20source_20control_20repository_3f
and follow the first link to access the SVN repository I get the
following error message:
D:error xmlns:D=DAV:
I've found that the column alias needs to match the property name:
selectKey resultClass=java.lang.Integer
keyProperty=criteriaConsistId
SELECT LAST_INSERT_ID() AS criteriaConsistId
/selectKey
--- Clinton Begin [EMAIL PROTECTED] wrote:
long should work (convenient aliases). Now, beyond that
You could use stored procedures.
I'm starting to port statements originally written for SQL Server over
to Access (with the .Net version of iBatis) and I think I can get away
with defining database specific functions in the properties file that I
define my database information:
settings
I saw that iBatis.com has been updated with 2.0.9. I had a hard time
following the snippets on the front page for N+1 selects:
resultMap...groupBy=prop1,prop2
result...resultMap=subResultMapForCollectionItems
and remappable result sets:
select...remapResults=true
Could someone take out the
20 matches
Mail list logo