RE: resultClass for BLOB field

2006-12-18 Thread Dave Rodenbaugh
Did you try java.lang.Byte[]? I doubt byte[] is a referenceable alias like "int" or "map". resultClass is looking for a package-qualified classname, in general. HTH, -D From: Karen Koch [mailto:[EMAIL PROTECTED] Sent: Monday, December 18, 2006 10:00 AM To: Cl

Deployment question

2007-01-25 Thread Dave Rodenbaugh
Hi everyone, I have iBATIS in an application we've deployed into Weblogic. Things run nicely as unit tests, so I know I have the basic plumbing working... Here's where things get a little tricky--I have three separate CVS modules that are built as different jars. Each has its own properties f

RE: Deployment question

2007-01-25 Thread Dave Rodenbaugh
. Customer when the class loader was invoked to pull the resource at runtime. Putting them in package-qualified directories (or renaming the files) fixed the problem. -D ____ From: Dave Rodenbaugh Sent: Thursday, January 25, 2007 11:18 AM To: user-java@ibatis.apa

Calling a single-param SP

2007-01-25 Thread Dave Rodenbaugh
Hi everyone, New question If I have a stored proc that takes a single parameter...is this the right way to call it in the SQL Map XML? {call OWNER.APP.SP_NAME(?)} or should I be using a parameterClass='java.lang.String' instead of the parameterMap in the procedure tag? Confuse

Using a Type Handler for SELECT stmt

2007-02-05 Thread Dave Rodenbaugh
Hi everyone, I have a custom type handler I'm using for Java 1.5 enums to map to a VARCHAR column in Oracle. I've read the SqlMap doc about TypeHandlers but there are some missing details...I'm sure my TypeHandler syntax definition is off, but I'm having a hard time finding the right place for it

RE: Using a Type Handler for SELECT stmt

2007-02-06 Thread Dave Rodenbaugh
-Original Message----- From: Dave Rodenbaugh Sent: Monday, February 05, 2007 4:59 PM To: user-java@ibatis.apache.org Subject: Using a Type Handler for SELECT stmt Hi everyone, I have a custom type handler I'm using for Java 1.5 enums to map to a VARCHAR column in Oracle. I've

Difference in two queryForObject signatures

2007-02-19 Thread Dave Rodenbaugh
Hello, Can someone differentiate for me the reasoning behind these two functions in SqlMapDaoTemplate: Object queryForObject(String id, Object parameters); and Object queryForObject(String id, Object parameters, Object result); The docs appear very similar on them except that the first ex

Transaction issue with 2.2.0

2007-02-27 Thread Dave Rodenbaugh
Hello, I have a question about a transaction scenario I'm doing...I see problems when trying to use startTransaction()/commitTransaction()/endTransaction with JDBC data source. I'm using Oracle 9.2 client libraries, and this is with iBATIS-2.2.0. Here's my code pattern--I have two Daos involve

RE: Transaction issue with 2.2.0

2007-02-27 Thread Dave Rodenbaugh
From: Dave Rodenbaugh Sent: Tuesday, February 27, 2007 10:05 AM To: 'user-java@ibatis.apache.org' Subject: Transaction issue with 2.2.0 Hello, I have a question about a transaction scenario I'm doing...I see problems when trying to use startTransaction()/commitTransaction()/endT

RE: Transaction issue with 2.2.0

2007-02-27 Thread Dave Rodenbaugh
2007 10:12 AM To: user-java@ibatis.apache.org Subject: RE: Transaction issue with 2.2.0 For all I know you need XA transactions for this to work... Chris From: Dave Rodenbaugh [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 27, 2007 9:07 AM To: user

RE: Transaction issue with 2.2.0

2007-02-27 Thread Dave Rodenbaugh
recommended Spring DAO for example. All you would need to do is to configure the appropriate transaction manager. Chris ____ From: Dave Rodenbaugh [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 27, 2007 10:52 AM To: user-java@ibatis.apache.org Subjec

RE: Transaction issue with 2.2.0

2007-02-27 Thread Dave Rodenbaugh
ended Spring DAO for example. All you would need to do is to configure the appropriate transaction manager. Chris ____ From: Dave Rodenbaugh [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 27, 2007 10:52 A

RE: Transaction issue with 2.2.0

2007-02-27 Thread Dave Rodenbaugh
e tables? whats the lock level? which isolation level do you use? i think this works for two JTA resources without XA (means "Tx code off") because there the transaction manager need no two phase commit. Dave Rodenbaugh wrotes: Yes, I saw the release, just after I had comp

Simple question...

2007-03-01 Thread Dave Rodenbaugh
Is the following a legal config in the dao.xml? iBATIS 2.2.0 allows this initialization (i.e. no XML barfing), but I the first DB access (relating to the order/sql-map-config.xml) when I use this construct gives me a "There is no statement named 'findOrderBy...' in this SqlMap"... I'm trying t

RE: Simple question...

2007-03-01 Thread Dave Rodenbaugh
actionManager element and include all SqlMaps from there. See the developers guide (from the website) for some samples. Niels -Original Message----- From: Dave Rodenbaugh [mailto:[EMAIL PROTECTED] Sent: donderdag 1 maart 2007 18:57 To: user-java@ibatis.apache.org Subject: Simple question...

RE: Understanding stored procedure return types

2007-03-15 Thread Dave Rodenbaugh
Hi Collin, I struggled with this for a bit as well...Here's how we're doing it (and it works, which is always a bonus). SQLMap fragment: {call ?:= CDS_OWNER.ORDSVC_APP.PARTNER_REFERENCE_UNIQUE(?, ?, ?)} Java invocation: H

RE: Understanding stored procedure return types

2007-03-15 Thread Dave Rodenbaugh
to execute a stored procedures as a ? This seems much more efficient to me as I can take advantage of sending a VO as a parameter without having to create custom classes for each stored proc. On 3/15/07, Dave Rodenbaugh <[EMAIL PROTECTED]> wrote: > Hi Collin, > > I struggled with this

RE: Understanding stored procedure return types

2007-03-15 Thread Dave Rodenbaugh
#x27;t understand why it needs to be done this way. Is it > considered bad practice to execute a stored procedures as a ? > This seems much more efficient to me as I can take advantage of > sending a VO as a parameter without having to create custom classes > for each stored proc. >

Mismatch of DTD and documentation?

2006-11-30 Thread Dave Rodenbaugh
Hi everyone, I searched the archives and JIRA for some resolution on this matter with no luck...perhaps someone could enlighten me on this one. According to the documentation: 3.3.4.8. extends When writing Sql, you often encounter duplicate fragments of SQL. iBATIS offers a simple yet powerf

Using parameterMaps

2006-12-11 Thread Dave Rodenbaugh
Hello all, I have a question regarding the valid values for the attribute "class" in the parameterMap. So far, the docs make it clear that I can use pkg-qualified names there, but don't say much else. If I have: That is used thusly:

RE: Using parameterMaps

2006-12-12 Thread Dave Rodenbaugh
tion unless you really need it - in other words, very rarely) So, I would delete the and do this instead: WHERE Order_Status = #orderStatus# AND Order_Type = #orderType# Jeff Butler On 12/11/06, Dave Rodenbaugh <[EMAIL PROTECTED]> wrote: Hello all, I

RE: Using parameterMaps

2006-12-12 Thread Dave Rodenbaugh
iner that knows *something* about XML, though. Larry On 12/12/06, Dave Rodenbaugh <[EMAIL PROTECTED]> wrote: > > > Thanks for the feedback...That all makes sense, except #4. > > CDATA sections, while not necessary here, are placed there because in the > future, I probably