I somtimes try something in JDBC in test, then re:do in iBatis. This may
be one of those cases.
.V
Nathan Coast wrote:
Hi,
Does ibatis support blob types, specifically to stream blobs in / out
of the database? I notice something about blobs are mentioned for the
2.0.9 release. Are there any
It's not that much space wasted.
.V
Pascal DeMilly wrote:
Hi,
I would like to retrieve a Map with whose key is the 1st column of my
query and the value is the 2nd column. For example right now I do:
select id=getItemNameMap resultClass=java.util.HashMap
select SKU, Description from Items
I posted to old msgs...oops.
.V
Try this syntax instead
INSERT
INTO load_email (
content, subject,
...
)
values (
#content:VARCHAR:NO_ENTRY#, #subject:VARCHAR:NO_ENTRY#,
...
)
Nilesh Bhattad wrote:
Hi there,
I have the below insert/ statement defined in a sqlmap. If
BlackListed is not passed thro the HashMap, and rest of the
Did you heard the one about a cast?
TabbSkelCont cont=(TabbSkelCont) JndiHelper.lookup(board_cont);
Groovy man,. :-P
.V
Clinton Begin wrote:
Man, you're like a self-deprecating comic. First you admit to using
Maps for your domain model, ..
;-)
http://www.onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html
Above is an example of type of sql one can only do with iBatis type DAOs.
.V
What is n+1?
.V
I see.
I am not sure if that is good advice. I think if you click on a table
you get the detail, that makes sense.
Else... row processing is not for SQL, SQL is based on relational
algebra and Set Theory and Venn diagrams, ie... you work on a set of
records, not cursor processing.
I am sure
The 16 way join and put the DB in App. server RAM?
My experience on several terabytes DBs has been opposite, I hope you
trust me too :-D .
Getting a list of categories, then you click on a catagory and get a
list of products, then you click on a product and get a list of
components is much
I just do JUnit, ex:
public static void main(String args[]) {
junit.textui.TestRunner.run(ClientDaoTest.class);
}
public static void testInsert() {
Map m = new HashMap();
m.put(ZConst.MODE, ZConst.INSERT);
m.put(ZConst.MAPID, MembrSql.insertMember);
One time I took one of the DBAs to lunch and ... kind of asked him as to
how come they are so brilliant; and then gave him a small suggestion.
He must have told the rest of them because they took me to a swamp
and did medical experiments on me, based on their reaserch in Doom III!
They
thing!
If it helps you I ALLWAYS write my sql 1st in a SQL admin type tool
(every DB engine has one). To get the sytnax and make sure what I am
getting.
If you worry about performance, ... then you can do a show plan. Likely
unless you start into millions of records that you do not want to worry
You can create 2 different sqlmaps. Each has a connection. (I use a
singleton factory, before I create a _sqlmap)
Ex:
SqlMapFac.setPropFile(properties/sql-map-async.xml);
.V
David Putnam wrote:
All,
I am trying to perform an operation using SqlMaps. I am performing
one query to get a list of
In Struts I would catch the action where it happens and keep
rethrowing it to the container.
This way web.xml error page can display a nicley formated message.
.V
Nathan Maves wrote:
Just curious what the best practices about this are. And since the
DaoExcpetion is now a runtime you have
What db ending?
I use limit/ofset in the select to process.
.V
Carl Brodeur wrote:
Hi:
Is there a way to limit the size of the List returned by a find query
in IBatis ?
We have a query returning 3000 rows. iBatis creates an instance of the
object corresponding object for each row returned.
It does not look like a good idea.
.V
Takacs Otto wrote:
My ide is to extend (or hack) the
/com/ibatis/common/beans/ProbeFactory.java
File becouse its getPrbe method could help me! But i am no sure! I
need confirmation before the hacking!
friendVU admin wrote:
Most people still write get/sets
Would you say that this better:
Form Model (Beans or Dynamaps :-P ) should not depend on the DAO in
any way.
I kind of draw the sqlmap's xml file as a Domain Model. Ex:
Customers.XML I would call a Domain Model. (Then use a DTO to go to Form
Model. Form Model maps to the View's fields but
17 matches
Mail list logo