I don¹t mean to be a pain, but is there a way of subscribing to the new list
without having to join google? I really don¹t want to have another account
to manage, especially with them.
I¹m happy to do it through nabble as I already use them.
Z.
>
> ANNOUNCEMENT
>
> Eight years ago in 2002, I
To be honest I think the choice of front end matters little. The key aspect
is the data layer - IB3 and any dependency injection used.
I think one example using spring and another using Guice is more than
enough.
Z.
>
> how about we leave out the whole J2EE stack and anything that goes with it..
o it...
>
> I think that Spring should program some integration themselves since it would
> be more reliable. I've programmed mine based on Spring's 2.5 integration with
> iBATIS 2 and the code may be outdated for Spring 3.
>
> Christian
>
>
> From: Zoran A
I was wondering if anybody has done any work on spring integration for IB3.
I had quick look and it¹s doesn¹t look like a trivial matter to migrate the
code from 2 to 3.
I notice that spring 3.1 has plans for IB3 support but that¹s still a way
off. Ideally some level of support for 2.5 would be gr
ception on 0 or 1, and instead
> only throw an exception on many (which makes sense).
>
> I agree that the exception should be better... but I don't suggest using it
> for flow control.
>
> Thoughts?
>
> Clinton
>
>
>
> On Thu, Aug 27, 2009 at 5:25 PM, Z
I for one would prefer null. I like the idea of testing for null rather than
using try catch
Z.
>
> Rick's suggestion is correct. That was the idea.
>
> Honestly, we don't have to throw the exception, but it is a good in practice
> IMHO...
>
> But you all tell me, do you really want to return
I agree whole heartedly. It also helps people who haven¹t yet made the jump
to get a feel for what to expect in migration.
Z.
>
> Heh - I hadn't had my coffee yet. ;-)
>
> Here are a few reasons: Pick one or take two, they're small.
>
> #1 - It's a bad idea to fragment an already small commun
is OGNL - OGNL is included basically as is in
> iBATIS3. iBATIS will make all bean properties available in the OGNL
> context, and also the parameter object itself (as "_parameter"). So
> you can do or null">.
>
> Jeff Butler
>
>
>
> On Wed, Au
First off, fantastic effort guys. This looks like a unbelievable release.
The improvements over the previous version are just incredible. I¹m
especially a fan of the new collection tag.
I¹ve been reading over the user guide and I have a couple of questions :
In V2 and prior $value$ resulted in a
.
>
> This maybe?
>
> http://issues.apache.org/jira/browse/IBATIS-375
>
> <http://issues.apache.org/jira/browse/IBATIS-375> Jeff Butler
>
>
> On Tue, Jun 23, 2009 at 12:04 AM, Zoran Avtarovski
> wrote:
>> I¹ve come across a problem I haven¹t seen for long tim
I¹ve come across a problem I haven¹t seen for long time.
I¹m running an n+1 query. If the query returns no children I get a single
child object with null values.
I thought there was a way to prevent null value objects from being generated
by I can¹t remember how.
Does any of this sound familiar?
The simple solution we¹ve implemented is to modify the source to ignore null
values. That way we don¹t have to do null checks and it simplifies the
process of of building dynamic queries. You have two options you can modify
the source after Ibator has run or modify the Ibator source code. We opted
That¹s why I¹ve never managed to get it to work. Can I suggest that for the
next version the logic be reversed on inserts. It¹s not a big deal as it
makes sense to implement this type of logic in the business layer but for
simple projects it might be beneficial.
Z.
>
> Null value replacement mak
Apologies for being late. It was a long weekend down here.
0
I agree it¹s a dying technology, but if the contributors are willing to
maintain it and it won¹t affect performance for non SQLJ implementations...
Z.
>
> Hi everyone,
>
> A group of developers have approached us with a contribution
By no means am I an expert in this field, but last year I was working on a
large app. The DB guy had pretty impressive knowledge, not just about
databases but also app servers and connecting to DB¹s in general. He had
done some performance monitoring on a number systems with varying loads and
conne
+1
Spring and ibatis make life much simpler when used together.
Z.
>
> I agree with Kai,
> for me Spring and Ibatis are the better way to use Ibatis in a web
> Application.
>
> Regards
Sorry Jeff,
I lost my mail server yesterday afternoon just found it this morning
hiding under the rug:)
With regards to foreign relationships I thought about what you said and I
think on the whole you¹re right. I don¹t want ibator (to avoid confusion,
I¹ll stick with this name for now on) to be
I used Abator for the time last week on a small project that I was trying to
get out the door in hurry.
First impressions are great, it helped me the base code out in no time flat
and allowed me to focus on the stuff that needed it. This is a great tool
Jeff.
I have a couple of questions / sugge
This is the part I find really weird. If I remove the ibatis specific stuff
from the log4j properties file we get no ibatis logging info. So my grasp of
log4j isn¹t as good as I had hoped. The problem is I¹d still like to get the
ERROR and WARN logs from ibatis.
Z.
>
> I¹m deploying an ibatis
I¹m deploying an ibatis based on onto to Tomcat (6.0.13) for the first
time.
Everything has been great and while I had set the log level to debug logging
was working as should. But now I can¹t get log4J to only log error events.
My log4j.properties file is listed below. As you can see it shouldn¹
Good point. I might have a look at the Prepared statement source and use
that as a guide for implementing a utlity class to cover my ass.
Z.
>> I haven't implemented it yet, but I can't see a reason why it wouldn't
> work.
>
> I can not see either, but, to speed up such searches one usually inde
rk.
Z.
> OK, then another option...add the % to the user provided input.
>
> Larry
>
>
> On Wed, Feb 20, 2008 at 10:23 PM, Zoran Avtarovski
> <[EMAIL PROTECTED]> wrote:
>> Thanks Larry,
>>
>> But no joy. The db is MySQL 5. To provide more detai
That's right. But in the case of an auto complete query you want to search
words starting with your argument which needs to look like: select from
table where login = 'fre%'
By escaping any single quotes in java covers most attacks but it's a shame
there's no SQL function for STARTS_WITH(#value#).
ested - which is not working for me.
Z.
> This should work:
>
> select * from table where column LIKE #value# || '%'
>
> Larry
>
> On Wed, Feb 20, 2008 at 9:40 PM, Zoran Avtarovski
> <[EMAIL PROTECTED]> wrote:
>> We have a web application with an
We have a web application with an ajax autocomplete text box. The problem is
that currently the query statement for the ajax query is :
Select * from table where column LIKE '$value$%'
Which is susceptible to sql injection attacks.
One solution is to have a separate connection pool with read-onl
Just do a standard insert and don't include the id column.
>
> Hi.
> How to insert a new record in MySQL table in the case that the table uses an
> auto
> generated ID column?
> Thanks.
The way we got around the risk of malicious users was to run $query$ using a
separate db connection where the user for that connection only had read
priviledges.
Saves a lot of angst.
Z.
>
> I can't avoid using $ in my case as I need a method to run any sp with
> varying no of parameters. Anywa
( select FIELDNAME, USERID, rownum num
>from ( select A.FIELDNAME, B.USERID
> from tblA A, tblB B
> where A.configUnitID = ?
> and A.USERUID = B.userUID
> order by A.FIELDNAME ) a
> ) b where num between 50 and 60
>
> regards
> ashok
>
> On 7/30/
I've come across an issue using iBatis' n+1 implementation in combination
external paging with DisplayTag. The issue lies with with the SQL LIMIT and
OFFSET commands on complex queries.
My problem is that when I execute a count statement:
SELECT COUNT(*) from primary_table
I get a resulting
tly, I've
> already coded the JDBC metadata part in a spike I've done... ;-)
>
> Clinton
>
> On 7/10/07, Zoran Avtarovski <[EMAIL PROTECTED]> wrote:
>> Putting aside the too many - too little options debate far a minute. Can
>> somebody tell me
Putting aside the too many - too little options debate far a minute. Can
somebody tell me if there is somewhere where we can vote for features for
v3?
Because I'd like to throw in my 10¢ and vote for JDBC metadata support and
expression language support within the XML config files.
Z.
This being an iBatis list I dare say you will get overwhelming support for
it (which I agree with).
There are a lots of "independent" comparisons out there. Try googling ibatis
v. Hibernate. You will see that each has its advantages and disadvantages
with relation to the type of project you are do
Hi Colin,
I know I've done a three level m2m relationship model using Ibatis, I just
can't find the code at the moment.
But simply we had a company domain object which contained multiple workplace
objects which contained multiple locations.
I don't remember there being any issues, but I'll keep
I've been looking the the instructions on migrating from Ibatis DAO to
Spring DAO on the wiki
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Converting+iBA
TIS+DAO+to+Spring+DAO
The DAO classes extend
org.springframework.orm.ibatis.support.SqlMapClientDaoSupport which has
support fo
Have you seen this:
http://spring-rich-c.sourceforge.net/
Z.
> Hello, tank you for reply.
>
> Would be possible to post a some code that shows how to initialize this
> application context?
>
> My application must have an ApplicationContext object with loaded
> definitions of applicationContext
In your SqlMap.xml try the following:
select departmentcode from $value$.DEPARTMENT
Then your Java code you have a few errors. You need to cast the result to a
hashmnap and you also need to pass the schema String as a parameter as
follows:
sqlMap.queryForList("Department.departmentco
I'm not sure I'm clear on this. Have you set up your connection pool in
Weblogic via JNDI if so it's a simple matter matter of using the JNDI name
in your transaction manager
Z.
> Thank you,
>
> That problem is solved.
> Butt how do you think I must solve the problem w
We've actually done this where we developed the business logic as a web app
and due to customer needs another team implemented the same code for a
desktop app (I think they used SWT??)
They didn't modify any of the iBatis stuff and very little of the other
code.
Z.
> Hello,
>
> I'm developing a
Isn't your select statement only returning distinct profil values. You need
to include the id and droits columns in order for your config to work.
Z.
>
> I have a problem while using complex properties. Here is my code :
>
> class="Utilisateur.classe">
>
>
>
>
>
>
>
>
>
> select="Pro
+1
> Hi All,
>
> Does anybody have an answer on the question posted below?
> I want to switch of from IBATIS DAO to spring because IBATIS DAO is
> depreciated.
> I can convert most of the code quite simply, but what must I do with my
> transactions?
>
> Kind Regards
> Meindert
>
> -Origina
I didn't mean it to me that harsh. I love iBatis. I really do.
It's just when a book starts to gather dust after just a couple of weeks you
have to question its value. As I said in the review, the book faces stiff
competition from a great online user guide to begin with. The great
documentation (u
Version 2.1.7
Z.
> What version of iBATIS are you using?
>
> On Tue, 2006-09-26 at 10:19 +1000, Zoran Avtarovski wrote:
Title: N+1 problem
I’m having an issue with my N+1 resultset. It’s throwing up a quirk I haven’t seen before.
I’m building a menu-submenu structure. The resultset I’m getting from mysql is as expected (see below). Each main menu item (label, value set) has a list of submenu items (test_id, comm
For what it's worth I'd just like to say that iBatis has what I consider to
be the best level of documentation and support of any OS project I've worked
with.
I think Clinton, et al deserve kudos for the amount of effort put into
documentation and support.
I also think that's the reason published
When using Ibatis 2.x do I need to have the setting
useStatementNamespaces="true" in order to access select statements in other
sql mapping files?
At present I don't and I'm getting an error when trying to access a
statement in another file.
For example I have a result map entry:
But I'm getti
I see where you're going with this but I'd also like to say that there's
probably a number of people out there (me included) who aren't currently
using it but are keeping an eye on it for future use.
I have a new project coming up where I'd like to give it a whirl and it's
nice to keep track of an
I'm an idiot. Thank you.
I'm having trouble reading the documentation (I mean technically, but it
could also be literally). I didn't think to look at the DTD.
Zoran
> This is exactly the syntax that is available. Have you looked at the
> DTD?
>
>> -Origin
I've been working on a new project for the last month or so and I'm come
across a few things that are starting to irk me and I want to know if it is
possible to do the following and if not what's involved in implementing.
Is it possible to to extend resultMaps much like Tiles allows you to extend
Hi Raul,
I'm not sure if it's the best way, but we had the same requirements and were
able to do it by setting some extra getter and setter methods in the in our
Java object.
In you your example for instance to return an array we would set a getter
called getReclamationArray() and convert the Lis
What DB are you using? I've found out the hard way that if you don't use
correct ANSI syntax you can get unexpected results. Try changing the
statement from a join to a inner join like:
FROM (ITEM I inner join PRODUCT P on P.PRODUCTID = I.PRODUCTID)
Or even better get rid of the parenthesis.
Z
They're failing consistently.
First thing I'm going to do is read the newly available pdf docs with my
trusty version of preview to make sure I haven't made an embarrassing
errors. If all is well and I still get the error I'll attach the source
code.
Z.
> Are the resultset select failing consist
We've been porting a 1.x ibatis project over to version 2 to take advantage
of some of the new features and we've run into some problems.
We removed most of our n+1 selects by using the groupBy function which is
fantastic thank you, but we decided to leave some in which worked fine as
is.
We are
This is what I tried first but it threw an SQL error.
Z.
> I think you can use a sub query so
>
> SELECT * FROM Users as U
> left outer join ( Select FROM UserCat WHERE status = 1 ) UC on U.user_id =
> UC.user_id
> WHERE U.status = 1
>
> Steve
>
>
> This e-mail and any attachment is for au
UC.user_id
> WHERE U.status = 1
> AND UC.status = 1
>
>
> Zoran Avtarovski a écrit :
>> I have a parent:child table relationship using a Join SQL statement and I am
>> having trouble getting it right. One parent many children.
>>
>> The starting statement is
I have a parent:child table relationship using a Join SQL statement and I am
having trouble getting it right. One parent many children.
The starting statement is:
SELECT * FROM Users as U
left outer join UserCat as UC on U.user_id = UC.user_id
This simple statement returns all content from Users
userId;}
> class Group { private int groupId;}
> class Category {private int catId;}
>
> ...
> ...
> groupBy="catId">...
>
> - For testing, start with only one relationship, e.g. Group, leave out
> Category. Once this works, add Category again.
>
> The example in the
I've been trying to get a n+1 example to work without much luck and I think
that I may have misunderstood the wiki article. I have intentionally kept
the example simple so I can fully understand the concepts and then apply it
to the real world app which uses the same principles.
I have three objec
Sorry Vic,
I'm not sure I understand.
I tried
SELECT list_item.value, list_item.label, m2m.trans_id
FROM list_item, m2m
WHERE list_item.list_type IN (?)
UNION
SELECT list_item.value, list_item.label, m2m.trans_id
FROM list_item
LEFT JOIN m2m ON
(m2m.response_id = list_item.value AND m2m.trans_id
I've come across a stumbling point in my web app.
I used a left join in a previous app to get a list of items used to populate
a set of check box items and to see if they were checked.
eg
SELECT list_item.value, list_item.label, m2m.trans_id
FROM list_item
LEFT_JOIN m2m ON
(m2m.response_id = list
I have a pretty straight forward situation:
In a html form we ask a number of questions which have check box answers.
When the form is submitted we used to save the responses for each question
as a comma delimited string of the results in a table with a unique
identifier and string fields, as ill
I had trouble getting the Paginated list stuff working and in the end I used
a combination of lazy loading and displaytag which works as expected.
Z.
> Hello,
>
> I seem to be having some problem with the PaginatedList.
>
> When I'm on the first page and I do paginatedList.getPreviousPage(),
>
te_id, log_time)
> )
>
> Simply comma-seperate the column names in your INDEX statement... This
> is the MySQL >4.0 syntax. I don't know about previous versions.
>
> Cheers,
> Philippe
>
> Zoran Avtarovski wrote:
>>> Do things get faster if you have the
is the case, you could union the two queries (one over
> the historical data, and one over the live data for today).
>
> Larry
>
> On 6/16/05, Zoran Avtarovski <[EMAIL PROTECTED]> wrote:
>>> Do things get faster if you have the database index remote_id and
>>&g
OK. So indexing multiple columns is pretty easy and made a huge difference
to speed. As for single transaction, the answer is no. I thought that
waiting on 30 separate transactions would leave the connection open far too
long.
Z.
> Also, do you do this in the scope of a single transaction?
>
>
> Do things get faster if you have the database index remote_id and
> log_time?
>
The log_time column is indexed, but I couldn't work out how to index two
columns in mysql.
Z.
I have a quick query regarding the speed of count query I use to generate a
chart, which is too slow at present and I'm looking for suggestions to speed
it up.
I pass a collection of the last 30 days data usage to a simple Flash
charting app and I use the ibatis query below in a loop thirty times
66 matches
Mail list logo
