Nope. The framework will close it for you.
On Fri, 18 Feb 2005 17:36:31 -, Yee, Richard K, CTR,, DMDCWEST
<[EMAIL PROTECTED]> wrote:
> When using the JdbcDaoTemplate, should I be closing the connection that I
> get from the DaoManager using the getConnection() method in a finally clause
> my
When using the JdbcDaoTemplate, should I be closing the connection that I
get from the DaoManager using the getConnection() method in a finally clause
my dao methods? I already plan to close any statements, result sets, etc.
that I create.
Thanks,
Richard
-Original Message-
From: Brando
No problem Mike. These things are good to know. However, I'm still
curious as to why it failed. If you ever figure it out. Please post it
here and we could possibly add it to the wiki for future reference.
Branon
On Fri, 18 Feb 2005 11:48:09 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote:
> DB2 7 b
DB2 7 blows. I went and tried the same code on a workstation with a DB2
8 client and it worked. Sorry for wasting your time.
Brandon Goodin wrote:
what is the driver and database that you are using?
On Fri, 18 Feb 2005 11:26:35 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote:
2.0.9
Brandon Goodin
Thanks for the reply Brandon. That was indeed one of the "SQL-related
options" I referred in my original message.
There are a few reasons I didn't automatically do this: the first is
that I did not write the original SQL, it was "handed off" to me, and
the second is that I'm completely unfamilia
Doh, I just realized that I was only seeing the End Transaction error
because I was rethrowing the original error out of the same try block.
-Original Message-
From: Brandon Goodin [mailto:[EMAIL PROTECTED]
Sent: Friday, February 18, 2005 11:29 AM
To: ibatis-user-java@incubator.apache.o
DB2 7.2 FixPack 12 using the db2java.zip driver.
If this is a case of DB2 sucking or something, I wouldn't bother with
it. When I get time, I'll try running the exact same code on mysql and
see what happens. Thanks.
Brandon Goodin wrote:
what is the driver and database that you are using?
On Fr
Thanks. BTW, this code should fail. It's the exception throws from
sqlmap.endTransaction() that is worrying me.
Here is the method
public int update(HoldAvp avp) throws SQLException {
log.info("*** GAK *** apvId = " + avp.getId()) ;
SqlMapClient sqlmap = this.getSqlMap() ;
what is the driver and database that you are using?
On Fri, 18 Feb 2005 11:26:35 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote:
> 2.0.9
>
> Brandon Goodin wrote:
>
> >what version of ibatis are you using?
> >
> >
> >On Fri, 18 Feb 2005 11:16:23 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote:
> >
> >
Please post an example of your code.
Brandon
On Fri, 18 Feb 2005 11:23:35 -0500, Akins, Greg <[EMAIL PROTECTED]> wrote:
>
> It appears that when the first statement executed in a sqlmap transaction
> fails, then the subsequent endTransaction (called in a catch) fails because
> there isn't a "s
2.0.9
Brandon Goodin wrote:
what version of ibatis are you using?
On Fri, 18 Feb 2005 11:16:23 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote:
*I tried it and it does not work. My error is as follows:*
ResultSetLogProxy.java|41|DEBUG|2005-02-18
11:13:16,756|3766|{rset-100020} ResultSet
PromotionFac
Title: Message
It appears
that when the first statement executed in a sqlmap transaction fails, then
the subsequent endTransaction (called in a catch) fails because there isn't a
"started" transaction?
Is that
correct? If so, is it recommended that I just ignore the SQLException
error th
what version of ibatis are you using?
On Fri, 18 Feb 2005 11:16:23 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote:
> *I tried it and it does not work. My error is as follows:*
>
> ResultSetLogProxy.java|41|DEBUG|2005-02-18
> 11:13:16,756|3766|{rset-100020} ResultSet
> PromotionFacadeSqlMapsImpl.jav
I'm curious why you don't simply write this as an actual subselect
since it passes back a single value java type.
Also, result selects are a convenience feature for simple to
moderately complex scenarios. Don't be afraid to implement an iterator
in your dao class that iterates over the getResults
*I tried it and it does not work. My error is as follows:*
ResultSetLogProxy.java|41|DEBUG|2005-02-18
11:13:16,756|3766|{rset-100020} ResultSet
PromotionFacadeSqlMapsImpl.java|71|ERROR|2005-02-18 11:13:16,772|3782|
--- The error occurred in configs/sqlmaps/promotions-sql.xml.
--- The error occur
Hi all,
First, I'd like to say "thanks" for all the work on iBATIS SqlMaps
(and the DAO framework which I haven't tried -- yet!). I'm currently
working on a set of "web reports", and iBATIS has made a terrific time
saver.
My question is about how to pass paramters from a "parameterClass" to
a su
Another thing to remember is the WebSphere itself uses commons logging.
So to get JCL messages when running in WebSphere's JRE, you'll need to
make some modifications to the WebSphere configuration. This could be
why things work one way in a main method (not running in WebSphere's
JRE), and a dif
I would recommend that you specify the jdbcType in your result.
On Fri, 18 Feb 2005 06:55:01 -0800 (PST), Karen Koch
<[EMAIL PROTECTED]> wrote:
> Are you perhaps missing the parameterClass arg on the statement itself?
>
> --- Mike Zatko <[EMAIL PROTECTED]> wrote:
>
> > /*I have a table as foll
Are you perhaps missing the parameterClass arg on the statement itself?
--- Mike Zatko <[EMAIL PROTECTED]> wrote:
> /*I have a table as follows:*/
>
> sqltype sqllen sqlname.datasqlname.length
> -- --
>
/*I have a table as follows:*/
sqltype sqllen sqlname.datasqlname.length
-- --
--
492 BIGINT 8
PROMO_ACTION_ID 15
492 BIGINT 8
PROM
20 matches
Mail list logo
