Re: Ibatis and charset

2007-09-18 Thread Graeme J Sweeney
On Tue, 18 Sep 2007, maomaode wrote: JDK6 + Mysql-Conn-3.0.10 + Mysql 5.0.45 + GBK (or GB2312, not the utf8) AIUI all your Unicode will be converted to GBK, yet your inserts now seem to work (server-side conversion?). My Chinese characters is in UTF-8 (load from xml file, and encoded with

Using java.util.List as the parameterClass

2007-09-18 Thread Peter Martin
I want to pass in a List as a parameter class and select the first item from the list. I know it is possible to use the tag, but is it possible to pull out a single item for a given index? For example, in the following select I to get the item at position 0: parameterClass="java.util.Li

Re: Using java.util.List as the parameterClass

2007-09-18 Thread Brandon Goodin
No, that is currently not possible. If you only ever want the first index then just pass in the first index from your DAO. Not sure what you are trying to accomplish but it looks like it would be better handled in java and not the sqlmap. If you want to provide more information about the context of

Re: Using java.util.List as the parameterClass

2007-09-18 Thread Jeff Butler
You can't do it directly. However, I think that if you put the list in a map (or some other object), then you can do it: Map parms = new HashMap(); parms.put ("items", someList); Then in your SqlMap: SELECT count(*) FROM person WHERE per_last_name = #items[0]# Jeff Butler On 9

Re: Using java.util.List as the parameterClass

2007-09-18 Thread Peter Martin
Thanks for your reply. I am actually trying to write an assembler for LiveCycle Data Services, which provides data management services. These data management services can be consumed by a Flex client. The Assembler interface (http://livedocs.adobe.com/livecycle/es/sdkHelp/programmer/ lcds

Re: Namespaces

2007-09-18 Thread Adam Zimowski
Yep, that's the problem. If I move User.xml up to load it before Page.xml I can refer to User.userResultMap from inside Page.xml. Does anybody know if this is logged as an issue and being worked on? -adam On 9/17/07, Jeff Butler <[EMAIL PROTECTED]> wrote: > There's a known issue that may be rela

Re: Namespaces

2007-09-18 Thread Larry Meadors
This is a crude (but effective) hack: Move the stuff that needs to be loaded first into it's own file, then load it before the others that need it. Larry On 9/18/07, Jeff Butler <[EMAIL PROTECTED]> wrote: > It is logged here: > > http://issues.apache.org/jira/browse/IBATIS-135 > > But there's no

Re: Namespaces

2007-09-18 Thread Jeff Butler
It is logged here: http://issues.apache.org/jira/browse/IBATIS-135 But there's not much movement - it is difficult to fix in the current code base. Jeff Butler On 9/18/07, Adam Zimowski <[EMAIL PROTECTED]> wrote: > > Yep, that's the problem. If I move User.xml up to load it before > Page.xml I

problem (possible bug) using Abator with Microsoft Sql Server

2007-09-18 Thread Robert Glover
I need a workaround for a problem in Abator with Microsoft Sql Server. Abator generates the following SQL statment which gives an error (the problem is that "FUNCTION" is a keyword): select BUDGET_UNIT, FUNCTION, FUNCTION_NAME from b0maschm.MAT_ORGSTRUCTURE The error it gives is: -

Re: problem (possible bug) using Abator with Microsoft Sql Server

2007-09-18 Thread Jeff Butler
There is a solution for this checked into SVN (not released yet). If you build Abator from source you can specify that a column name should be delimited for situations such as these. In a nutshell, you specify this: ... As I said, this is not released yet, but it is worki