You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Paul Sullivan <pa...@gmail.com> on 2007/03/22 22:14:22 UTC

Library list db2

Has anyone used connection string library list for db2? We can't seem to get
it working and have only found information stating we can't use library list
with db2.

We'd appreciate any examples if somebody has used this successfully. Thanks.

output parameters and dbnull

Posted by Alexandre Grenier <Al...@markettools.com>.
Hello all,

 

I'm getting a little glitch here, hoping someone can point out what I am
doing wrong, set me in the right direction, or let me know if this could
be an issue with iBatis (I'm working from latest source, but the issue
seems to have existed in past releases).

 

In a parameterMap I have:

 

<parameter direction="Output" type="string" dbType="nvarchar"
property="Person.FirstName" column="first_name" />

 

The stored procedure returns a DBNull for the "first_name" column (long
explanation why my DBAs insist this be the way).

Anyway, I get the following error:

 

IBatisNet.Common.Exceptions.ProbeException : Unable to cast object of
type 'System.DBNull' to type 'System.String'.

  ----> System.InvalidCastException : Unable to cast object of type
'System.DBNull' to type 'System.String'.

 

I traced the exception down to DelegatePropertySetAccessor.cs

 

I tried using nullValue property but I just get the same error.

 

I noticed there is a DBNullTypeHandler in the source, would that be part
of solving my problem?

 

 

Thanks!

Alex

 


TransactionScope

Posted by Michael McCurrey <mm...@digisolaz.com>.
 
There seems to be an issue with the TransactionScope class
I have 2 seperate dao managers, both of type SqlMap.  When using 2
non-SQL map it works fine.
 
 
 {"DaoProxy : unable to intercept method name 'Save', cause : The
operation is not valid for the state of the transaction."}
System.Exception {IBatisNet.DataAccess.Exceptions.DataAccessException}

DataAccess 1.9.1
DataMapper 1.6.1
 
 
 
Michael J. McCurrey
USA Digital Solutions, Inc.
602.866.8199
 
- The scientific name for an animal that doesn't either run from or
fight its enemies is lunch. 
 

________________________________

From: Paul Sullivan [mailto:paulsullivan1@gmail.com] 
Sent: Thursday, March 22, 2007 2:14 PM
To: user-cs@ibatis.apache.org
Subject: Library list db2



Has anyone used connection string library list for db2? We can't seem to
get it working and have only found information stating we can't use
library list with db2.

We'd appreciate any examples if somebody has used this successfully.
Thanks.


RE: Library list db2

Posted by Paul Sullivan <Pa...@pcssinc.com>.
This is in reference to using library list in the Ibatis connection
string for db2. Sorry for the confusion. I sent this through a secondary
email address.

 

________________________________

From: Paul Sullivan [mailto:paulsullivan1@gmail.com] 
Sent: Thursday, March 22, 2007 5:14 PM
To: user-cs@ibatis.apache.org
Subject: Library list db2

 

Has anyone used connection string library list for db2? We can't seem to
get it working and have only found information stating we can't use
library list with db2.

We'd appreciate any examples if somebody has used this successfully.
Thanks.