User defined type in another Schema Problem.

Hi, I have custom TypeHandlers for accessing user defined data types defined in our oracle database. I have codes like ArrayDescriptor desc = ArrayDescriptor.createDescriptor("STRARRAY", underLyingConnection); parameter = new ARRAY(desc, underLyingConnection, arr.toArray());

Re: Passing an object to Stored procedure.

Hi Larry, Can you give me an example. I tried using a typehandler for the same and it didnt work. I am new into the world of stored procedures and dont know if I did something wrong there. The code I did in the setParameter() of the Typehandler was StructDescriptor aaStructuredDescrip

Re: Passing an object to Stored procedure.

I've not tried this...but you may be able to do it with an anonymous pl/sql block. Larry On Tue, Jul 15, 2008 at 3:37 PM, Sundar Sankar <[EMAIL PROTECTED]> wrote: > Hi, > I have a stored procedure that takes an in parameter of an Oracle > object (varchar col1, varchar col2, float col3). How

Passing an object to Stored procedure.

Hi, I have a stored procedure that takes an in parameter of an Oracle object (varchar col1, varchar col2, float col3). How do I call such a stored proc from Ibatis. Any help is appreciated. Thanks Sundar

IBATIS-458 and deadlock or timeout

I am trying to resolve an issue we are have with the following error message: com.ibm.db2.jcc.c.SqlException: The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". at com.ibm.db2.jcc.c.lf.b(lf.java:3265) at com.ibm.db2.jcc.b.kb.i(kb.java:220) at co

Child object created when no child records exist in table

It appears that ABATIS-213 has surfaced again. Scenario: Two tables (Household, Person) are tied (Person has HouseholdID) The result maps: when a select is executed that returns a household record with no person records, the Househo

RE: NullPointerException after upgrade to 2.3.2

A simplier example for the NPE can be found here: http://www.mail-archive.com/user-java@ibatis.apache.org/msg11704.html We do not use any procedures, only 2 simple queries with according result maps. The error occured within JRE 5. Regards, Kai Clinton Begin wrote: >

Re: NullPointerException after upgrade to 2.3.2

Make sure you're using JDK 5, not 6. We currently extend a couple of JDBC 3 classes for SimpleDataSource. We've discussed using a dynamic proxy to avoid this requirement, but that would slow a few things down... still in discussion. :-) For now, JDK 5. I'll send you a link with a fixed build unt

Re: spring 2.5.5 and ibatis 2.3.2

Does anyone know the solution to IBATIS-419. I am not sure if this issue is really solved/fixed. Regards, Kai 2008/7/8 nch <[EMAIL PROTECTED]>: > Hello. > I'd like to know what was the solution to IBATIS-419. Nothing is said about > how it was fixed here > https://issues.apache.org/jira/browse/I

Re: NullPointerException after upgrade to 2.3.2

Here are the specifics. It's not very complex which is why it surprised me so much. { call ${getCreditHoldFlag_sp} ( @CustomerNumber = #customerNo,jdbcType=VARCHAR,javaType=java.lang.String,mode=IN# ) } The parameter class is a String and I'm even specifying it i

Re: NullPointerException after upgrade to 2.3.2

I committed the patch, so you can build from SVN. HOWERVER I can't for the life of me reproduce the failure. iBATIS usually detects the type of JavaBeans properties and for Maps uses Object if it can't figure it out... so type should never really be null. I can't write the failing unit test.

Re: Paging

Hi Andrew, One problem I have had in past with pagination at client end is memory glitches. If there is usually too much of data in the client end, sometimes you tend to run out of memory while caching these. You might just wanna be wary of this. I usually wud wanna hit the database multi

Re: NullPointerException after upgrade to 2.3.2

Thank you Clinton.. Chris "Clinton Begin" <[EMAIL PROTECTED]> 07/15/2008 10:38 AM Please respond to user-java@ibatis.apache.org To user-java@ibatis.apache.org cc Subject Re: NullPointerException after upgrade to 2.3.2 I'll add the patch now... and let you know when to grab from SVN.

Re: NullPointerException after upgrade to 2.3.2

I'll add the patch now... and let you know when to grab from SVN. Clinton On Tue, Jul 15, 2008 at 11:29 AM, <[EMAIL PROTECTED]> wrote: > > Is the fix committed so I can get it and build from SVN? > > Chris Mathrusse > [EMAIL PROTECTED] > Sybase, Inc > One Sybase Drive > Dublin, CA 94568 > (925)

Re: NullPointerException after upgrade to 2.3.2

Is the fix committed so I can get it and build from SVN? Chris Mathrusse [EMAIL PROTECTED] Sybase, Inc One Sybase Drive Dublin, CA 94568 (925) 236-5553 "Clinton Begin" <[EMAIL PROTECTED]> 07/15/2008 10:27 AM Please respond to user-java@ibatis.apache.org To user-java@ibatis.apache.org cc Sub

Re: NullPointerException after upgrade to 2.3.2

On Jul 15, 2008, at 12:27 PM, Clinton Begin wrote: Known bug, sorry about that. I hope to get to a fix soon... it's easy, just time. In case you didn't see it there is a patch here: https://issues.apache.org/jira/browse/IBATIS-522 Tom On Tue, Jul 15, 2008 at 11:24 AM, <[EMAIL PROTECTED]>

Re: NullPointerException after upgrade to 2.3.2

https://issues.apache.org/jira/browse/IBATIS-522 On Jul 15, 2008, at 12:24 PM, [EMAIL PROTECTED] wrote: I just upgraded to 2.3.2 due to the fact that Spring 2.5.5 seems to need it. After I upgraded I am now getting a NullPointerException after executing a procedure. This was working prior

Re: NullPointerException after upgrade to 2.3.2

Known bug, sorry about that. I hope to get to a fix soon... it's easy, just time. Clinton On Tue, Jul 15, 2008 at 11:24 AM, <[EMAIL PROTECTED]> wrote: > > I just upgraded to 2.3.2 due to the fact that Spring 2.5.5 seems to need > it. After I upgraded I am now getting a NullPointerException afte

NullPointerException after upgrade to 2.3.2

I just upgraded to 2.3.2 due to the fact that Spring 2.5.5 seems to need it. After I upgraded I am now getting a NullPointerException after executing a procedure. This was working prior to the upgrade and seems to be associated to the TypeHandlerFactory.setTypeHanlder method at line 143. As I s

RE: Paging

Very similar I believe. I chose the pager-taglib as it was incredibly easy to implement and seems to work well. I would show you a working example but my site isn't live yet, unfortunately. Andrew Quoting "Gallagher, Damien" <[EMAIL PROTECTED]>: Hi Does this offer something similar to d

RE: Paging

Hi Does this offer something similar to displayTag? http://displaytag.sourceforge.net/11/ Iv only briefly used displayTag but I find it very useful for paging, sorting and also exporting data Thanks Damien -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 J

Re: Paging

Hi, I used this library: http://jsptags.com/tags/navigation/pager/pager-taglib-2.0.html Others might be able to suggest a better solution but this worked well for me :-) I hope that helps. Andrew Quoting "kiran vuppla" <[EMAIL PROTECTED]>: Yes. I have seen that paginatedList is soon de

Re: Paging

I'd suggest looking to your database to do it (i.e., in SQL), instead of doing it on the application side of things. Larry On Tue, Jul 15, 2008 at 10:14 AM, kiran vuppla <[EMAIL PROTECTED]> wrote: > Yes. I have seen that paginatedList is soon depricated. Can you please let > me know what is the

Re: Paging

Yes. I have seen that paginatedList is soon depricated. Can you please let me know what is the other paging code that is more flexible?   Thanks, KV --- On Tue, 7/15/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Subject: Re: Paging To: user-java@iba

Re: Paging

There is a PaginatedList class you can use, however I removed this code eventually in the favour of some other paging code that was more flexible. Quoting "kiran vuppla" <[EMAIL PROTECTED]>: Hi,   Is there paging (get the results as a set of page) feature can be done using iBatis? If

Paging

Hi,   Is there paging (get the results as a set of page) feature can be done using iBatis? If so can some one let me know where I can look at it or an example will be more helpful.   Thanks in advance, Kiran

Batch operation on stored procedure

Hi, In the previous ibatis release (the one that uses the following jars: ibatis-common-2.jar, ibatis-sqlmap-2.jar, ibatis-dao-2.jar) there was a bug concerning the batch execution on stored procedure. The batch operations were executed in a standard mode even if the batch execution has been decla

Re: caching and obect refs

On Fri, Jul 11, 2008 at 07:18:35AM -0600, Larry Meadors wrote: > Make it read-only and serializable. thanks Larry.. I re-read the docs and understand what the serialization is giving me now :) So, given that we have heavy usage of lazy-loading, and result sets that are much more heavily read than