Re: R: R: R: handling null values

2007-02-21 Thread Giovanni Cuccu - CUP2000
I'm using oracle and postgres with ibatis with no problem so my guess is that 1)there is an issue in the sqlmap xml file 2)it's ibatis bug before we can assert 2) you should post the log produced by ibatis with the SQL statement failing the desc of your table if for some reason you cannot exposte

RE: TypeHandler UUID

2007-02-21 Thread Niels Beekman
Hi, Is getResult() being called? If not, try adding an explicit javaType="java.util.UUID" to the resultmap. If I may suggest an optimization: replace getter.getObject() == null with getter.wasNull(). Niels -Original Message- From: hett [mailto:[EMAIL PROTECTED] Sent: woensdag 21 februa

Just Another Stored Procedure Question

2007-02-21 Thread Yusuf
Hi, Really2 sorry for asking, i know this has been asked before many times, i have browsed through the docs, the faqs page, and the mailing lists, but i can't seem to make this work (oracle): oracle procedure : PROCEDURE generate_counter ( v_result OUT VARCHAR2, v_msc

Re: Just Another Stored Procedure Question

2007-02-21 Thread Brad Handy
It seems to me this configuration is the problem: { call EKA.SISTEM_KONTROL_SPAJ.GENERATE_COUNTER ( #hasil:varchar#,#msco_number:number#, #lca_id:varchar#, #prefix:varchar#, #suffix:varchar#, #length:number#) } You're using the "parameterClass

Re: RE(1): Avoiding SQL injection when calling stored procedures

2007-02-21 Thread Larry Meadors
No. If your stored procedure constructs SQL from parameters, it is assumed that you know what you are doing and escape them. Larry On 2/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi Jeff. Is there no danger of SQL Injection even if the stored procedure internally uses the paramet

Re: Just Another Stored Procedure Question

2007-02-21 Thread Jeff Butler
Yes, also... - If you use a parameterMap, then use question marks as parameter markers - Else use parameterClass and the # syntax You can't use both. Jeff Butler On 2/21/07, Brad Handy <[EMAIL PROTECTED]> wrote: It seems to me this configuration is the problem: { call EKA.S

RE: TypeHandler UUID

2007-02-21 Thread hett
getResult() is not being called at all, but it does went to setParameter(). This is what I have in my resultmap SELECT * FROM person WHERE person_id=#value# Niels Beekman-2 wrote: > > Hi, > > Is getResult() being called? If not, try adding

RE: TypeHandler UUID

2007-02-21 Thread Niels Beekman
Try to enable debug logging and see if you get results when you manually execute the generated query. getResult() should definitely be called, so I think it's either a bug in your setParameter() or the query is wrong. Could you post your calling Java code too? Niels -Original Message- Fro

RE: TypeHandler UUID

2007-02-21 Thread hett
Thanks for the quick reply, I just learned java for a few weeks, still trying to get use to eclipse, can you show me how to enable debug logging to see the generate query? here is my dbAccess method using generic: public T getObjectById(String query, UUID id) { T rObject = null;

RE: TypeHandler UUID

2007-02-21 Thread Niels Beekman
I meant iBATIS logging, see http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+g et+SqlMapClient+to+log+SQL+statements for instructions. You should gracefully handle your SQLExceptions, but for now try printing your "this.error" variable to see if an error occurred. Also, make

Is anyone using CGLIB with iBATIS?

2007-02-21 Thread Yee, Richard K CTR DMDC
Hi, Is anyone using CGLIB with iBATIS? If so, what version of CGLIB are you using and what are the actual dependencies of CGLIB? While looking at the cglib.sourceforge.net site, it seems that there isn't much documentation on CGLIB and that the project is stagnant. It also lists about 6 jar files t

RE: Is anyone using CGLIB with iBATIS?

2007-02-21 Thread Niels Beekman
Hi, I'm using version 2.1_3, as for the dependencies: download the "nodep"-package (cglib-nodep-2.1_3.jar). In my experience the project is stable, if you have any problems you usually get help on their mailing list within a day. Niels -Original Message- From: Yee, Richard K CTR DMDC [ma

RE: TypeHandler UUID

2007-02-21 Thread hett
There is no error, the only error I get is a null exception when I try to println(p.getId) because p is null. I follow the link you provided and used log4j to capture the generate query. This is what it output when I use type String I mention earlier: Same code, just different object(also changed

Circular Reference and iBatis 2.3.0

2007-02-21 Thread David Hodge
I recently upgraded to iBatis 2.3.0 and everything looked good until I discovered one of our unit tests was failing. The error was 'Exhausted ResultSet'. Upon investigation I realized that I had a circular reference in SQL Map. I know, very bad. What I wanted to know is how come previous versi

Support for Primary Key using Composition instead of inheritance

2007-02-21 Thread bkbonner
I would like to change how abator handles the mapping of files to use composition of the primary keys instead of inheritance. Inheritance of the primary key seems a little awkward to me. Do you have any suggestions as to how what I would change to let abator include this new behavior? I'd also

Re: [JDBC type = ARRAY / Java type = ?] Support for Primary Key using Composition instead of inheritance

2007-02-21 Thread bkbonner
p.s. I have a little experience with maven2, so I'd prefer to be able to deploy it this way--maybe I can help a little bit with this, too. Brian -- View this message in context: http://www.nabble.com/Support-for-Primary-Key-using-Composition-instead-of-inheritance-tf3269344.html#a9089368 Sent f

abator source repository

2007-02-21 Thread bkbonner
Can someone direct me to where the abator source repository is? Thanks. Brian -- View this message in context: http://www.nabble.com/abator-source-repository-tf3269358.html#a9089384 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Support for Primary Key using Composition instead of inheritance

2007-02-21 Thread Jeff Butler
You can tell Abator to not generate a seperate class for the primary key. Specify a default model type of "flat" on your abator context. This would put all the fields in one class. If you want to use composition instead of inheritance, then you'd need to write your own JavaModelGenerator impleme

Re: abator source repository

2007-02-21 Thread Jeff Butler
http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper2/tools/abator/ Jeff Butler On 2/21/07, bkbonner <[EMAIL PROTECTED]> wrote: Can someone direct me to where the abator source repository is? Thanks. Brian -- View this message in context: http://www.nabble.com/abator-source-rep

RE: Is anyone using CGLIB with iBATIS?

2007-02-21 Thread Yee, Richard K CTR DMDC
Neils, Thanks. I think the cglib site needs some documentation. -Richard -Original Message- From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 21, 2007 11:24 AM To: user-java@ibatis.apache.org Subject: RE: Is anyone using CGLIB with iBATIS? Hi, I'm using version

RE: Just Another Stored Procedure Question

2007-02-21 Thread Yusuf
Hi, thanks for the feedback... Brad, Actually I forgot to mention that I have this entry in the sqlmap, so I was referring to a class, not a parameterMap: Jeff, using parameterMap and # syntax ran successfully, it just won't return the value in the v_result OUT parameter.. I also have tried

Re: Circular Reference and iBatis 2.3.0

2007-02-21 Thread Richard Yee
Sounds like it was a bug that got fixed. -Richard David Hodge wrote: I recently upgraded to iBatis 2.3.0 and everything looked good until I discovered one of our unit tests was failing. The error was 'Exhausted ResultSet'. Upon investigation I realized that I had a circular reference in SQL

RE: RE(1): Avoiding SQL injection when calling stored procedures

2007-02-21 Thread Arsalan Zaidi
Right, thanks for all you help! :-) Regards, Arsalan Zaidi > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Larry Meadors > Sent: Wednesday, February 21, 2007 6:09 PM > To: user-java@ibatis.apache.org; [EMAIL PROTECTED] > Subject: Re: RE(1): Avoidin

Re: Just Another Stored Procedure Question

2007-02-21 Thread Larry Meadors
You misread Brad's comment, i think. You have this: You need to have this: ..which may still not work because of the "." characters in the name. Larry On 2/21/07, Yusuf <[EMAIL PROTECTED]> wrote: Hi, thanks for the feedback... Brad, Actually I forgot to mention that I have this entry in