Re: auto-generated key into RDBMS that not support the auto-generated key

2006-05-29 Thread Darek Dober
Worse than that, the example provided gives you the certainty of never getting a unique identifier. :-D To be precise, undoubtedly you're right :):) Darek

Re: auto-generated key into RDBMS that not support the auto-generated key

2006-05-25 Thread Darek Dober
What's more, it doesn't give you the certainty of unique identifier. Darek

Re: Postgres - inserting null causes error - Unknown Types value

2005-09-14 Thread Darek Dober
From my perspective, it should be ok.   But: WHERE     i_divers = #idDivers:Long#   you shouldn't update something, if you don't know which record you want to update (if idDivers is null :)     Have you tried this ?   Cheers Darek

Re: Postgres - inserting null causes error - Unknown Types value

2005-09-14 Thread Darek Dober
- inserting null causes error - Unknown Types value This is much shorter...thanks Darek ;-) Darek Dober a écrit : I read somewhere in docs, that is caused because jdbc driver 8.xx is almost full implementation of JDBC Type 3, which uses prepareStatement in contrast to

Re: Postgres - inserting null causes error - Unknown Types value

2005-09-13 Thread Darek Dober
reate parameterMap just specify the type like:   insert into table(column) values (#column:INTEGER)   which is much shorter:)   Darek Dober - Original Message - From: TNO To: user-java@ibatis.apache.org Sent: Tuesday, September 13, 2005 10:18 AM Subject: Re: Postgres - inserting

Re: Trouble with oracle 10g selectKey

2005-08-05 Thread Darek Dober
Try this (insert instead of update): return getSqlMapClientTemplate().insert("insert" + object.getClass().getSimpleName(),object); Darek - Original Message - From: "Koka" <[EMAIL PROTECTED]> To: Sent: Friday, August 05, 2005 7:32 AM Subject: Trouble with oracle 10g selectKey Wow, see

Re: daoManager start/end/commit transaction problem - solved:)

2005-08-05 Thread Darek Dober
that commit releases resources?   Anyway thanks for help   Best regards Darek Dober   - Original Message - From: Clinton Begin To: user-java@ibatis.apache.org Sent: Friday, August 05, 2005 1:09 AM Subject: Re: daoManager start/end/commit transaction problem Three t

daoManager start/end/commit transaction problem

2005-08-04 Thread Darek Dober
().commitTransaction(); debtorService.getDaoManager().commitTransaction(); Darek Dober

Re: SQL logging

2005-08-03 Thread Darek Dober
Try to include commons-logging. I spent some time searching the reason:) Ibatis depends on it, yet Darek Dober - Original Message - From: "Eugeny N Dzhurinsky" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 03, 2005 12:30 PM Subject: SQL logging > Is there any way

Re: Stored procedure with queryForList skipresults and maxresults

2005-08-02 Thread Darek Dober
this: select * from   (select kol1, kol2    from table    order by kol1) where rownum <15     - oracle 9i provides analytic function like rownumber   and so on and on ...   So it seems to be possible Have you ever considered that way?       Darek Dober - Original Message - From:

Re: synchronization between DB and ibatis sqlmaps

2005-07-20 Thread Darek Dober
uldn't you have test cases to test your statements anyway?Cheers,Clinton On 7/20/05, Darek Dober <[EMAIL PROTECTED]> wrote: Do you have any solutions for that?Let's assume, that something changed in database, i.e names of tables orcolumns. And you forgot to ch

synchronization between DB and ibatis sqlmaps

2005-07-20 Thread Darek Dober
Bean properties are checked at creation of ibatis instance so you get an error, but what if something changed in database? One of the way is to write test case, which should test all of the sqlmaps against any changes. Is the simplier way to check correctness of all sqlmaps Darek Dober

Re: Result as Xml, and lower/upper case

2005-07-17 Thread Darek Dober
In postgresql column names are converted to lower case, unless you write your sql like this: SELECT AFFR.AFFAIR_NO AS "affairNumber" ,DEBT.LASTNAME as "lastName" Just if someone had the same problem:) Darek Dober - Original Message - From: &l

Re: multiple delete in sqlmap

2005-07-15 Thread Darek Dober
According to that what I know mysql in version 3.xx doesn't support constraints at all:), also subqueries, triggers and so on ... Version 4.xx has some of that futures. Check documentation. I'm not up to date with mysql now:) But, check i.e here. Probably it is not supported http://groups.google

Re: [jira] Commented: (IBATIS-170) i am not sure it is a bug!

2005-07-14 Thread Darek Dober
Well First of all, I'm not the author of that post I only give some extra help to ensure that, in my opinion that's not a bug:) What's more, I totally agree with you Cheers Darek Dober - Original Message - From: "Larry Meadors" <[EMAIL PROTECTED]> To:

Re: [jira] Commented: (IBATIS-170) i am not sure it is a bug!

2005-07-14 Thread Darek Dober
I think, it is not a bug :) It doesn't work for me. But this does insert into testddo (col) values (to_date('2005-07-14 16:06:48','-mm-dd hh24:mi:ss')); hours: 16 should be declared as HH24 not hh Anyway:) Darek Dober - Original Message - From

Re: I must restart Tomcat when I modify some SQL Map XML files in SQLMapConfig.xml

2005-07-12 Thread Darek Dober
Can't you just use manager included in Tomcat,   you can reach it at /manager/html/list and then just reload application ? I do that:)   Darek   - Original Message - From: Zarar Siddiqi To: user-java@ibatis.apache.org ; Sylvain Pelletier Sent: Monday, July 11, 2005 7:20

Re: Best mechanism to read large datasets

2005-07-08 Thread Darek Dober
e now, but for 500 000 records to process, using only stored procedure, should be much faster.   What are your opinions?       Darek Dober - Original Message - From: Michal Malecki To: user-java@ibatis.apache.org Sent: Friday, July 08, 2005 4:22 PM Subject: Re: Best me

Re: Best mechanism to read large datasets

2005-07-08 Thread Darek Dober
Title: Best mechanism to read large datasets Can't you divide your result into pages with smaller number of records ?   queryForList with proper parameters should do that.   Darek - Original Message - From: Rao, Satish To: user-java@ibatis.apache.org Sent: Friday,

Avoiding N+1 selects

2005-07-03 Thread Darek Dober
ption: ClastCastException, I suppose it expects months to be List, but I would like it to be one CalendarMap Is it possible, to point down, that I want only one Bean, not the List? Regards Darek Dober