xmlbeans and ibatis

2007-04-13 Thread Andy Thompson
I'm currently trying to get ibatis 2.3 to return xmlbeans. from http://www.mail-archive.com/[EMAIL PROTECTED]/msg01351.html it looks like there's a small amount of extra work attached to this because instantiation occurs through a factory method rather then the default argumentless constructor.

How do I apply individual properties from a resultMap to another resultMap

2007-03-14 Thread Andy Thompson
I've run into a situation where i want to use two separate queries to build one domain object. The reason being that I need to use a stored procedure for several attributes and standard SQL for the rest. Unfortunately I can't fix the stored proc to do everything I need, nor can I bypass that pro

Re: silly question regarding cast from char to int

2007-02-15 Thread Andy Thompson
ould do this: select * from some_table where integer(database_id) = #java_id# However be warned that this is a very poor performer and will cause table scans. So it's best to change it in the DAO. Jeff Butler On 2/15/07, Andy Thompson <[EMAIL PROTECTED]> wrote: > > in my

silly question regarding cast from char to int

2007-02-15 Thread Andy Thompson
in my database - i've got a value that's of type char. for example "009". the dao is passing back a request by id where id is 9. So there's no match. so select * from some_column where database_id = #java_id# returns null. but select * from some_column where database_id="009" returns t

Re: ORA-00933: SQL command not properly ended

2005-06-17 Thread Andy Thompson
thanks kris. On 6/16/05, Kris Jenkins <[EMAIL PROTECTED]> wrote: > Hi Andy, > > 'InlineParameterMap' is the name for the map that's auto-generated when > you just supply a parameterClass. > > I think your problem is in the dynamic WHERE. Imagine this scenario: > > SELECT * > FROM table_x >

Re: Question regarding JNDI and WebSphere

2005-06-15 Thread Andy Thompson
is "abcd/efgh" your datasource location? On 6/15/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I am seeing the following in the console when trying to load a sql-map: > > [6/15/05 15:37:11:813 EDT] 6eb06eb0 ConnectionFac I J2CA0122I: Resource > reference abcd/efgh could not be located,

ORA-00933: SQL command not properly ended

2005-06-15 Thread Andy Thompson
Problem: I think the above error is the result of some dynamic sql issues. I'm confused because when I "Check the getQuestion-InlineParameterMap. " I realize that i don't have an InlineParameterMap. If somebody wants to point me in the right direction would be appreciated. Relevant Code: }...