support question JIRA-252/253/354

2006-02-11 Thread Sven Boden
Shiulu, Don't create JIRA's for support questions, we have some mailing lists for those (in the cc: of this mail). Information from the JIRA at the end of this mail. So let me recap your problem to see whether we're talking about the same thing. You call stored procedure sp_gettransactionsqu

Re: Combined DAO manager with a SqlMap client. Wrong?

2006-02-11 Thread Albert L. Sapp
Brandon Goodin wrote: "In JPetStore, if I remember right, commands are executed through a daomanager.update() versus a sqlmap.update(). Am I correct? " This is not correct. The DaoManager is used to retrieve an instance of the Dao. One of the fuctions of the DaoManager is to be a Dao Factory.

dynamic Sql and parameter together

2006-02-11 Thread wang lei
  I just build a DAO,which supports ojb ,hibernate. Now i want to support Ibatis too. But when i build the parameters,i got a problem.   Here is a sql statement in the xml.          Here is t he java code.     Map t_Map = new HashMap();  t_Map.put("Where", "where");  t_Map.put("co

Re: Combined DAO manager with a SqlMap client. Wrong?

2006-02-11 Thread Brandon Goodin
What transaction manager do you have configured in your dao.xml? If you have a SQLMAP it does the job of initializing your SqlMapClient. You do not need to use SqlMapClientBuilder. Further, if you created a SqlMapClient apart from the DaoManager then transactions would not work. This is because th

Re: dynamic Sql and parameter together

2006-02-11 Thread Brandon Goodin
You should likely be using iBatis dynamic SQL capabilites with the dynamic tags in your . You can learn about Dynamic SQL in the manual. Latest Open Office Manual: http://svn.apache.org/repos/asf/ibatis/trunk/java/docs/iBATIS-SqlMaps-2.sxw Brandon On 2/11/06, wang lei <[EMAIL PROTECTED]> wrote:

dynamic Sql and two-level parameter

2006-02-11 Thread wang lei
What i mean is just the Sql implements can parse the parameter twice.   Just the following sql.   Select  USER_ID, USER_NAME, PHOTO, USER_MEMO from  DEMO.USER_T    Where USER_NAME>#userName#  AND $condition$   I pass a parameter map which contains "userName---Test" and "condition--USER_ID>#us