Re: Generating source code from sql statement

2008-11-20 Thread charlie bird
Don't think so. I've always pointed A(I)Bator at one the tables in the query and then hand coded the rest - Doesn't take very long. --- On Thu, 20/11/08, Ben Shory <[EMAIL PROTECTED]> wrote: > From: Ben Shory <[EMAIL PROTECTED]> > Subject: Generating source code from sql statement > To: user-ja

Re: Using iBatis outside servlet container

2009-01-30 Thread charlie bird
I've got similar question Has anyone done this sort of thing with c3p0? Can I use the same datasource xml that would be used for servlet container config? Thanks Charlie --- On Fri, 30/1/09, Jan Kriesten wrote: > From: Jan Kriesten > Subject: Re: Using iBatis outside servlet container > To:

Re: "Cannot serialize session attribute ..."

2009-03-20 Thread charlie bird
Alternatively you could disable session serialization completely by adding the following line to your tomcat application xml: Only if you're not bothered about retrieving the sessions on restart of course --- On Fri, 20/3/09, Kengkaj Sathianpantarit wrote: > From: Kengkaj Sathianpantarit

Re: insert going wrong after going from Sybase to MySQL

2010-01-22 Thread charlie bird
MySql doesn't do @@IDENITY Use this: select last_insert_id instead --- On Fri, 22/1/10, StevenF wrote: > From: StevenF > Subject: insert going wrong after going from Sybase to MySQL > To: user-java@ibatis.apache.org > Date: Friday, 22 January, 2010, 15:19 > > Hi All, > > I'm switching the

Re: insert going wrong after going from Sybase to MySQL

2010-01-22 Thread charlie bird
CORRECTION select last_insert_id() Damn these fat fingers --- On Fri, 22/1/10, StevenF wrote: > From: StevenF > Subject: insert going wrong after going from Sybase to MySQL > To: user-java@ibatis.apache.org > Date: Friday, 22 January, 2010, 15:19 > > Hi All, > > I'm switching the database o

RE: iBatis annotation related questions

2010-02-19 Thread charlie bird
Had to port database last year but all the sql was in xml and that made it easy. It was also done within Spring so swapping the DAO implementations over was a piece of cake. Meant we could back out just as easily as well (not that we has too). To echo Clinton: Stick with XML --- On Fri, 19/2/10,

Re: JNDI - Weblogic - SqlMApConfig

2007-06-14 Thread charlie bird
How about trying this: As you can see we get our datasource form tomcat but eith any luck Weblogic will use the jndi naming conventions. If not try leaving out the java:comp/env/ and try in the jndi resource bean instead. Goo

RE: Spring, Ibatis, and DBCP commons pooling

2007-09-13 Thread charlie bird
Don't know if this'll help but we always put the dbcp config in the Apache application context xml and NOT in the app's Resouce config. I think that the properties you're looking for are: testOnBorrow testOnReturn testWhileIdle validationQuery See here for more info: http://commons.apache.org/dbc

Re: AW: unexpected ExceptionInInitializerError

2007-11-09 Thread charlie bird
Looks like you've lost the commons logging jar from your classpath somehow. Have look at your Eclipse project properties java buildpath (Right click on your project in the navigator window - properties - java build path - libraries). If you do not have commons-logging-somenumbers.jar there than tha

Child beans as a java.util.Map

2007-11-22 Thread charlie bird
Here's a question. When building an object with child objects in the app I'm building I uses Lists to hold the the child objects by mapping the id of the parent Object (one-to-many) to a in the child's sqlMap. Is there a way to configure Ibatis to return a Map of child objects keyed on something

Re: Child beans as a java.util.Map

2007-11-23 Thread charlie bird
at now with just the xml > configuration, but you could > do it with two calls to your sqlmap client (one to > queryForObject() > and one to queryForMap()). > > Larry > > > On Nov 22, 2007 8:33 AM, charlie bird > <[EMAIL PROTECTED]> wrote: > > Here's a qu

Query timeout (I think)

2008-01-24 Thread charlie bird
Hi - Hope someone can help. I am using ibatis 2.3.0.667 within Spring 2.0 on Tomcat 5.5.9A connecting to SQL Server 7 and Merlia SQL server driver and getting this stack trace: 2008-01-24 10:45:49,276 DEBUG [java.sql.Connection] - <{conn-100027} Connection> 2008-01-24 10:45:49,292 DEBUG [java.sq

RE: Problem with my query.

2008-06-20 Thread charlie bird
You need to: Add your query to the sqlMap file. Add a new method to your DAO (and DAO interface if you have one) that calls the new query. Change your code to call your new method instead. I tend to start off by copying and renaming the (i)aBator selectByPrimaryKey in the SQlMap and edit the q

Re: IBatis on Spring:: error when calling SP. the SP returns cursor

2008-06-27 Thread charlie bird
I remember seeing this using the Oracle jdbc driver that came with 8i - it was quite buggy. Try using a more up to date driver. IIRC the 9i one fixed this (and numerous other ones) problems. --- On Fri, 27/6/08, Larry Meadors <[EMAIL PROTECTED]> wrote: > From: Larry Meadors <[EMAIL PROTECTED]

Re: Caching objects on a application server

2008-11-13 Thread charlie bird
I can vouch for EHCache. Piece of cake to implement and Serialization doesn't appear to be an application killer for us. I've tended to integrate it in the DAOImpl classes but you can integrate at the service layer if you like. --- On Thu, 13/11/08, Chema <[EMAIL PROTECTED]> wrote: > From: Ch