You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@ibatis.apache.org by ib...@incubator.apache.org on 2005/01/01 07:32:44 UTC

[Apache iBATIS Wiki] New: Database Specific Information

   Date: 2004-12-31T22:32:44
   Editor: ClintonBegin
   Wiki: Apache iBATIS Wiki
   Page: Database Specific Information
   URL: http://wiki.apache.org/ibatis/Database Specific Information

   no comment

New Page:


= Oracle =

'''BLOBs/CLOBs'''

As of release 2.0.9, iBATIS includes default BLOB/CLOB handlers.  If you are using an older version of Oracle (pre-10g), then you might have to write your own Custom Tag Handler to access the proprietary Oracle API to work with LOBs.

= Sybase =

'''Stored Proc/UNCHAINED mode'''

By default, Sybase doesn't allow procs to be run in a transactional context.  You can work around this problem a few different ways:

1) Use your own Connection and .setAutoCommit(true).  Pass this connection into the SqlMapClient.setUserConnection(Connection) method.  You're responsible for closing the connection afterwards.  If you like, you can get the Connection from the same DataSource by calling SqlMapClient.getDataSource().  Although this seems a bit "roundabout", it works.

2) In Sybase, use the following command to change all stored procedures into proper transaction mode. 

      sp_procxmode <stored procedure> , "anymode"

3) Use the longer approach proposed by Scott Severtson:  ["Scott's Sybase Proc Solution"]