Dashboard > iBATIS DataMapper > Index
Added by Ted Husted (Admin), last edited by Ted Husted (Admin) on Apr 09, 2005
Labels: 
(None)


Space Index

0-9 ... 2 A ... 1 B ... 0 C ... 4 D ... 6 E ... 4
F ... 2 G ... 0 H ... 43 I ... 15 J ... 5 K ... 0
L ... 3 M ... 2 N ... 1 O ... 1 P ... 3 Q ... 1
R ... 4 S ... 1 T ... 2 U ... 4 V ... 0 W ... 14
X ... 2 Y ... 1 Z ... 0 !@#$ ... 0    

0-9

3rd Party Contributions
Code Generators Tools which generate SQL Maps and or Java files, some implemented as a plugin to an IDE. Many have the same goals as Ibator http://ibatis.apache.org/ibator.html, which is maintained by the iBATIS team. Ibator http://ibatis.apache.org/ibator.html ...
3rd Party Ibator Plugins
Use this page to share links or source code to any plugins you wish to share with the community. Plugin Name Description Type URL Store Example Classes with DAOs Generates the example classes in the same package as the DAO classes. extension http ...

A

Articles and other coverage of iBATIS
more and more articles and information about iBATIS coming out every day. Here are some of them. iBATIS 2.x iBATIS in Action book iBATIS in Action http://www.amazon.com/gp/product/1932394826?ie=UTF8&tag=ai0e20&linkcode=as3 ...

B

C

Complex properties and substitution strings parameter problem
Hi\! I'm developing a web app with ibatis (2.2) and have got a problem with complex properties and passing substitution strings parameter for sql query of properties. For example: Contribute Documentation
Help out! Use this page as a sort of "table of contents" for new snippets of documentation and examples. This page will be reviewed periodically and the good stuff will be added to the official documentation. You make the best author of the documentation, because you are a user of the framework and therefore have ...
Convert ResultSet to JSTL Result
I'm updating this just to fix some errors in the Wiki page that have croppedup in the 14\ months since I originally posted this. I haven't been following iBATIS lately (not by choice) so I'm not sure if this is still correct or useful. This is the version ...
Converting iBATIS DAO to Spring DAO
iBATIS DAO has been depreciated and it is recommended that you use the Spring framework instead. This document (originally posted to the userjava list by a user) describes the steps taken to convert jpetstore5 from iBATIS DAO to Spring DAO. Converting jpetshop5 to ibatisspring ...

D

DAO
Data Access Object (DAO) J2EE Pattern http://java.sun.com/blueprints/corej2eepatterns/Patterns/DataAccessObject.html Transfer Object (DTO) J2EE Pattern http://java.sun.com/blueprints/corej2eepatterns/Patterns/TransferObject.html Pattern Problem http://forum.java.sun.com/thread.jspa?threadID=569418&tstart=225 General Design ...
DAO Generator
http://www.akcess.in
Data access object Generator
www.akcess.in provides free tool (DAO generator)for generation of java code for data access layer. DAOGenerator connects to a database and generates the following type of files for each entity in that database. DAO Interface DAO Implementation Exception Class Value Object ...
Database Migration
www.akcess.in provides DBMigration 1.0 for database migration. DBMigration (Database Migration) is a generic database migration tool. It can be connected to any Database that has a JDBC type 4 driver and generates data definition language script, insert statements, data ...
DateTimeTypeHandlerCallback.java
TypeHandlerCallback class was build and tested using iBATIS DataMapper (Java) 2.2.0.638 and requires the Joda Time http://jodatime.sf.net jars package com.yourpackage.utils.service; import java.sql.SQLException; import org.joda.time.DateTime; import org.joda.time.format.DateTimeFormat; import org.joda.time.format.DateTimeFormatter; import com.ibatis.sqlmap.client.extensions.ParameterSetter; import com.ibatis.sqlmap.client.extensions.ResultGetter; import ...
Documentation

E

EHCache support for iBatis
EHCache support for iBatis The following CacheController implementation and configuration enables you to delegate iBatis caching to EhCache. First, the class: package com.ibatis.sqlmap.engine.cache.EhCacheController; import java.net.URL; import java.util.Properties; import net.sf.ehcache.Cache; import net.sf.ehcache.CacheManager; import net.sf.ehcache.Element; import com.ibatis.sqlmap.engine.cache.CacheController; import ...
EnumHelperTests
using System; using NUnit.Framework; namespace MyCompany.MyProject { TestFixture public class EnumHelperTests { private enum TestEnum Test public void ShouldParseName() Test public void ShouldParseDescription() Test public void ShouldParseNameIgnoringCase() Test public void ShouldParseDescriptionIgnoringCase() Test ...
EnumWithDescriptionTypeHandlerTests
using System; using System.Data; using IBatisNet.DataMapper.Configuration.ResultMapping; using NUnit.Framework; using Rhino.Mocks; namespace MyCompany.MyProject { TestFixture public class EnumWithDescriptionTypeHandlerTests { // The GetValueByIndex() and GetValueByName() cannot be tested directly as ResultProperty.MemberType cannot be set or mocked private enum TestEnum private class ...
Environment Specific Information
Environment Specific Solutions Oracle BLOBs/CLOBs As of release 2.0.9, iBATIS includes default BLOB/CLOB handlers. If you are using an older version of Oracle (pre10g), then you might have to write your own Custom Tag Handler ...

F

Feedback and Experiences
iBATIS I didn't want to talk about it until it was a 'core' piece of our architecture, but MySpace.com is now running IBatis for a good portion of its data access abstraction layer. We like the flexibility. I came in from a 'heavier' ORM ...
Frequently Asked Questions
Frequently Asked Questions iBATIS Java General What is the difference between the iBATIS DAO framework and iBATIS SQL Maps? How do I get readonly access to the source control repository? Where can I get more information ...

G

H

Home
Welcome to the iBATIS Wiki Here you will find uptodate information the most recent releases of the framework. You'll find helpful hints and tips that either haven't made it to the documentation, or will never be part of the official documentation. This site is maintained by the iBATIS development community ...
How can I enable the caching feature of iBATIS?
iBATIS enables caching by default, but if you want to be REALLY, REALLY sure it's on, do this in your SqlMapConfig.xml file: How can I use "selectkey" element of insert in Mysql database?
I searched lots of articles on the website, but I still could not make it done. The following was found on others's blog: How do I build the DataMapper and DataAccess assemblies?
Building the Assemblies The IBatisNet.DataMapper, IBatisNet.DataAccess, and IBatisNet.Common assemblies can be built by using Visual Studio or by using NAnt http://nant.sourceforge.net/ and the iBATIS.build http://svn.apache.org/repos/asf/incubator/ibatis/trunk/cs/mapper/iBATIS.build file. Project Dependencies If you ...
How do I call a stored procedure
OK, this is in the User's Guide, but since you apparently did not read it, here it is again. ;) Stored procedures are supported via the statement element. The following example shows how a stored procedure would be used with output parameters. How do I call a stored procedure and the parameter is Oracle Object Type
create or replace type warrant.testrshantyp as object(id VARCHAR2(10),dat VARCHAR2(50)); create or replace type warrant.testrshantyparr as table of warrant.testrshantyp; create or replace procedure warrant.shantestarray(arr in testrshantyparr,isSuccess out varchar2 ) as begin for r in 1..arr.count ...
How do I choose what sql statements appear in my log files
Note: This FAQ is based on .NET DataMapper code as of SVN Revision 209963 (DataMapper 1.2.1), a development revision of the .NET DataMapper. The log4net samples below have been tested with the 1.2.9 beta version of log4net. The following log4net filter will only log ...
How do I configure a Jakarta DBCP-datasource
iBATIS documentation already provides information about configuring a DBCPdatasource, however, the implementation has been improved in the meantime to allow for more flexibility. The old (legacy) configuration is still supported, so if your needs are satisfied with the options mentioned in the documentation, read ...
How do I Configure Logging in WebSphere
Important Note: this information applies to iBATIS version 2.1.5 running on WebSphere 6.0) Even though iBATIS is no longer dependant on Jakarta Commons Logging (JCL), iBATIS will use JCL if it exists in the classpath. WebSphere supplies JCL in the application server classpath ...
How do I connect using a user's credentials
supported, but it can be done. What you need is a pool of connection pools. Sounds silly, but using a tool like http://proxool.sourceforge.net/ proxool, it can be done. There is one unsupported implementation of this in the iBATIS CVS repository. You can browse it http://cvs.sourceforge.net ...
How do I execute multiple SQL statements at one time with Oracle?
You could consider using a stored procedure! Or if the statements are meant to execute as one transaction, manage the transaction in your application's service layer. With that in mind, if you need to execute multiple SQL statements in one DataMapper with Oracle using MS ...
How do I gain access to underlying JDBC Objects?
many cases where it is useful to gain access to the actual JDBC objects when using iBATIS. For example, type handlers sometimes need access to the ResultSet object, other times applications need access to the Connection object. Gaining access to these objects ...
How do I generate PDF and HTML Help files from the latest documentation XML source files in the source control repository
Overview Our documentation relies on XSLT and XSLFO with DocBookbased XML source files to generate the PDF, HTML, and HTML Help release files. We use NAnt for executing a build process that takes the XML source files and tranforms them into the various ...
How do I get a Map of results instead of a List
following section will explain in detail how to use the queryForMap(). The queryForMap()'s are most useful when you need to work with the result of a query. In the example below I will use a query that return Student objects as a result. Lets start with the Student class. public ...
How do I get around the N Plus 1 selects problem
Here is one solution. How do I get dynamic DataSources with iBATIS and Spring?
idea is based Spring's AbstractRoutingDataSource class, but operates with SqlMapClients instead to avoid caching issues in iBATIS. Since SqlMapClient doesn't segment its cache based on DataSources, a single SqlMapClient will merge all the results from multiple DataSources into one cache ...
How do I get read-only access to the source control repository
iBATIS Source Control iBATIS uses Subversion for source control. The SVN repository is hosted by Apache infrastructure and can be accessed through: http://svn.apache.org/repos/asf/ibatis/ What is Subversion ? Subversion http://subversion.tigris.org/ is an opensource version control ...
How do I get SqlMapClient to log SQL statements
iBATIS uses commonslogging to log these. Depending on your logging implementation, your configuration may vary. If you are using log4j, put this line into log4j.properties: log4j.logger.java.sql=DEBUG If you set your default log level to DEBUG, that will work, too...but you ...
How do I improve SQL Map performance
you're using SQL Maps 2.0, then here's what you want to do (in order of importance): 1. Ensure you've specified a parameterMap or parameterClass attribute on your statement. 2. Use an explicitly defined and DON'T allow remapping ...
How do I map Enums?
Enums are already supported provided the database field contains a string that matches a constant defined in the enumeration. If your database strings contain spaces or other characters not allowed in an enum, this article may help. To map enums with descriptions (aka annotations ...
How do I pass in a dynamic table name - or other uncommon parameters
quite easy to use a parameter as a table name or in any other portion of a SQL statement, e.g. IN ( ... ) syntax. Instead of using the ## denotation, use $$. For example: SELECT FROM $myValue$ WHERE AGE=#myAge# Be sure to indicate 'remapResults="true"' in your definition ...
How do I reuse SQL-fragments
When writing SqlMaps, you often encounter duplicate fragments of SQL, for example a FROMclause or constraintstatement; iBATIS offers a simple yet powerful tag to reuse them. For the sake of simplicity, let's assume we want to get some items and we ...
How do I set the connection string per user in Web context
After having build the SqlMapper instance with the DomSqlMapBuilder Replace the SqlMapper DataSource with SqlMapper.DataSource = new PerUserDataSource( SqlMapper.DataSource ); where PerUserDataSource class is something like this public class PerUserDataSource : DataSource { IDataSource innerDataSource = null; public PerUserDataSource( IDataSource innerDataSource) public ...
How do I setup NPetshop
Download NPetshop A zip file containing the NPetshop VS.NET solution can be downloaded from the Files section of the iBATIS .NET !SourceForge project. Optionally, the latest NPetshop source code can be obtained from the iBATIS .NET Subversion repository...see ...
How do I use "where ... IN (...)" in my queries
src: Frequently Asked Questions > How do I use LIKE in my queries I would like to do a query like this : SELECT FROM emp WHERE emp.code IN ('EET', 'EEU', 'EEV') but the code list is dynamic ! That what you ...
How do I use a BLOB or CLOB
Here is an example of how to use the Custom Type Handler (CTH) feature of iBatis with large objects (LOB) such as BLOB's (Binary) and CLOB's (Character). As of release 2.0.9 the iBatis framework has the default CLOB and BLOB type handlers included. The example ...
How do I use a Custom Type Handler with complex property or Type Safe Enumeration
Here is an example of how to set up a custom type handler with a complex property. This example uses the enum features of Java 1.5 but could be used with a Type Safe Enumeration in anything below 1.5. Lets start by defining the database table ...
How do I use a Custom Type Handler? cs
you find yourself bumping into a type conversion issue when moving data between a class property and your database, a custom type handler may be just what you're looking for... A custom type handler allows you to extend the DataMapper's ...
How do I use a JNDI DataSource with iBATIS in Tomcat?
breaks down into two logical parts. First you have to declare the DataSource in JNDI in Tomcat. Then you have to tell iBATIS to use that object via its JNDI name. Putting a DataSource into JNDI in Tomcat depends on the version of Tomcat you ...
How do I use an embedded sqlMap.config file
easy way of using your sqlMap.config file with the DataMapper The really basic way to configure and use the DataMapper is to use the Mapper singleton provided by the framework. If you have the DataMapper source, the code for this singleton is found in the IBatisNet.DataMapper project directory and is named Mapper.cs. ...
How do I use an insert statement? cs
your database table uses an IDENTITY, AUTOINCREMENT, or SERIAL column or you have defined a SEQUENCE/GENERATOR, you can use the element in an statement to use or return that databasegenerated value. Examples: int key = (int ...
How do I use an Oracle Ref Cursor?
FAQ is based on iBATIS DataMapper (Java) 2.2.0.638 Release 2.2.0 of iBATIS DataMapper natively supports Oracle REF Cursors without the need to create a custom type handler. This FAQ shows a very small example on how to use it. We start ...
How do I use an Oracle Ref Cursor? cs
Note: This FAQ is based on .NET DataMapper code as of SVN Revision 169743 (DataMapper 1.2), a development revision of the .NET DataMapper. With the changes made to the .NET DataMapper's handling of parameterMaps, utilizing an Oracle ref cursor to return a list of objects is now ...
How do I use Enums with annotations
Here's how I do this. I have an interface that I use for my enums: public interface ValueEnum It looks like this to implement an enum that uses this: public enum EmploymentTermReason implements ValueEnum { Voluntary("V"), Fired("F ...
How do i use executeQueryForList java.lang.String, java.lang.Object, int, int
I have a table with more than 3000 records. If i use executeQueryForList(java.lang.String, java.lang.Object) to show a list of the contents it consumes a lot of time. This is the case when there are no search params(by default there are no search params) How can i improve the perfomance ...
How do I use LIKE in my queries
Because iBATIS uses PreparedStatement for mapped statements, you have to use the $value$ syntax, or make your parameter contain your % or characters. For example, let's say you want your database will end up with is this: select from foo where ...
How do I use POUND or DOLLAR symbols in my queries
Both # and $ can be escaped by doubling: ## or $$ respectively
How do I use the Java WSDP with iBATIS
Thanks to Colin Lamond for this tip: When using J2SE 1.4 with the Sun Web Service Development Kit (WSDK) 1.6 with iBATIS, you get a java.lang.NoSuchMethodError when you call SqlMapClientBuilder.buildSqlMapClient(reader) to create the sql map. The Sun WSDK 1.6 ...
How do you create InetAddress type handlers?
How does NPetshop connect to SqlSever2005?
I downloaded a NPetshop project, I start it on SqlSever2005, but it can't work. There is a exception. Error on page Exception : at NPetshop.Presentation.UserActions.CatalogAction..ctor(HttpContext context) at NPetshop.Web.UserControls.SideBar.LinkButtonCommand(Object sender, CommandEventArgs e) in c:\inetpub\wwwroot\npetshop.web\usercontrols\sbr.ascx.cs:line 30 ...
how to connect two databases
my project, i choice ibatis 2.0, but data stores in two databases, how should i do
How to set dynamic table name in complex object?
hey. help me, please.... single object,set dynamic table name is very easy,I can use $tableName$. if object is complex,how i can set dynamic table name in child object.like this: How to trace the log by using java.util.logging.Logger in iBATIS
Our project didn't use log4j. But I can't find any information about how to config the iBATIS by using java.util.logging.Logger.Please help me.Thanks

I

I have a problem using "top" keyword in my select queries
IBatisNet  question : My queries is like this :     SELECT TOP #par1#  FROM (       SELECT SEQ, TYPE, TITLE, CONTENT, REGID     ...
IBatis - Invoking Dynamic Procedure with Oracle Object
Hi, I have the following scenario. 1. I need to call a stored procedure, the name of stored procedure will be dynamic, which will be an one of the properties defined in the Object that I will be passing as an parameter. Following is the code snip for that iBATIS 3
iBATIS 3 is currently in development. Once iBATIS 3 is released the information from this page will be moved to the official documentation. Until iBATIS 3 is released feel free to download the sources directly from the source repository http://svn.apache.org/repos/asf ...
ibatis 3.0
ibatis 3.0 white boart
iBATIS 3.0 Whiteboard
iBATIS 3 has been released! See the iBATIS Homepage for more: http://ibatis.apache.org Opportunity for Change. January 11th, 2008 marks the 4th Anniversary of the iBATIS 2.0. It has served the community well for four years, but times change. The last ...
iBATIS 3.0 Whiteboard - Korean
이 문서는 원문의 v.23 버전 기준입니다. 생각을 정리한 문서이기 때문에 내용이 언제든지 바뀔수 있습니다. Opportunity for Change. January 11th, 2007 marks the 3rd Anniversary of the iBATIS 2.0. It has served the community well for three years ...
iBATIS DataMapper
iBATIS Release Process
First Things First #first Things to do first. # iBATIS Release Process #releaseprocess The details. # Beta Release #beta The details behind providing a BETA. # General Availability (GA) #ga The details behind releasing a GA. # Java Checklist #javachecklist ...
IDEA_PLUG_IN
Libing Chen (a 29 year old software developer from China) posted to one of the mailing lists about an iBATIS plugin for IDEA that he had started working on. Now that IDEA 7 is closer to release (I've been using ...
Improved Dynamic SQL Whiteboard
collaborative development space to discuss the future of dynamic SQL in iBATIS SQL Mapping files. This is a key feature of iBATIS that gives it great power. The current implementation has some limitations that we'd like to resolve by introducing a new and improved Dynamic SQL ...
Improved Stored Procedure Support Whiteboard
OBSOLETE This page is obsolete, as of iBATIS 2.2.0 we now support multiple result sets returned from queries and stored procedures so the need for this new function has reduced sharply. The Problem The traffic on the user's list regarding stored procedures ...
Index
inflatable boat rigid hull inflatable boat
Is there a simple way to use transactions in my service layer without having to use a seperate dao.config file
NPetshop and NPetshop2 sample applications use a service class to broker calls from the presentation layer to the persistance layer. An example UserService is below: public class UserService : BaseService { private static UserService instance = new UserService(); private IUserDao ...
Is working with multi data sources possible with iBatis ?

J

Jasmine IDE IBatis GUI
Jasmine IDE iBATIS plugin Well I've taken a crack at a point and click program for building maps/ value objects and a dao class (not ibatis dao just a java class to invoke an sqlclient's methods). It allows you to set up ...
JavaModelGenerator through Velocity
Java model object creation through Velocity's templates This implementation of JavaModelGenerator allows class creation through Velocity's templates. advantage: templates are externals to Java code easy to modify existing methods of created classes easy to add extra methods ...
JDBC logging issues
an issue with logging of JDBC objects such that means that you won't see any JDBC logging if {{java.sql.Connection}} logging isn't enabled. To quote Jeff Butler: This is related to a structural defect in the way iBATIS does logging. iBATIS does logging through ...
JPA
Hi all, I'm a newbie here, but I use ibatis always for my db applications from 2.1.x (I don't remember exactly and now 2.2.0. Now I want to change, because I'd like to use something that permits ...
JPetStore Driver Setup
I tried to setup the MySQL Driver for the JPetStore Sample Application, but after restarting Tomcat following error occurs: com.ibatis.dao.client.DaoException: Error starting SQL Map transaction. Cause: java.sql.SQLException: No suitable driver I've already installed the JPetStore Database to MySQL ...

K

L

Lazy loading issues
Enhanced lazy have different issues. 3 of them are discussed here. # When loading an object having a 1:1 relation. If the object on the other side of 1:1 relation is lazy loaded with tag, you will not be able to cast ...
like hibernate that iBatis can format_sql?
hibernate.formatsql=true iBatis can format a sql to log file
Logging Long Running Queries
When creating an application with many queries and a great deal of data, it is common practice to do development with a subset of the data. While this makes it faster to develop, it makes it harder to know what queries are slow or poorly optimized. It would be very helpful ...

M

maillists don't let me join-in
userjava@ibatis.apache.org SMTP error from remote mailer after end of data: host herse.apache.org 140.211.11.133: 552 spam score (10.3) exceeded threshold
Multiple inserts in table with same sequence id
Hi, I have to insert in 1 Parent table and 4 child tables . I have written sqlMap which inserts in the parent table as below. SELECT ...

N

Not Yet Documented
So much documentation to write, so little time... The following features have yet to be documented. Feel free to make a wiki page for any of them and document them here. Good documentation will be promoted to the official Developer Guide. Multiple result ...

O

Oracle REF CURSOR Solutions
whiteboard is for the collaborative documentation and design as a start toward improving or extending current support for Oracle REF CURSOR types. Current Working Solutions If you have a current solution that works, please put it here. Solution 1 This is sample mapping for a Stored ...

P

Pages for Deletion
View the children of this page. They are all questions which ought to have been asked in the forums. Admin rights are needed to delete them
Pass in a dynamic table name - or other uncommon parameters
quite easy to use a parameter as a table name or in any other portion of a SQL statement, e.g. IN ( ... ) syntax. Instead of using the ## denotation, use $$. For example: SELECT FROM $myValue$ WHERE AGE=#myAge# Be sure to indicate 'remapResults="true"' in your definition ...
Porting sqlMapConfig and sqlMap XML from 2.x to 3.0
meant to be a very rough first draft documenting common patterns in porting your iBatis configuration and mapping XML files from iBatis for Java 2 to iBatis for Java 3. I started working on porting and decided I needed to put ...

Q

Quick Start Guide
Quick Start Guide to iBATIS DataMapper Overview iBATIS DataMapper is a Java/.NET framework that will help you design and implement better persistence layers for your Java/.NET applications. iBATIS couples objects with stored procedures or SQL statements using ...

R

Random Question
Hello all, I have a situation where i have to make multiple inserts/updates to a table. Whats the solution while using ibatis? Does batch work here? The case is like adding many users to a group. So from ...
remapResults="true"
Proper Usage of remapResults="true" The remapResults attribute is available on ,

S

Spring integration with iBATIS 3
Spring integration with iBATIS 3 Creating SqlSessionFactory We want an SqlSessionFactory that can handle Spring's transactions. package ca.qc.ircm.mapper; import java.io.IOException; import java.io.InputStreamReader; import java.io.Reader; import java.sql.Connection; import java.sql.SQLException; import javax.annotation.PostConstruct; import javax.annotation.PreDestroy ...

T

This is a test with a ?
Just a test
Type Handler Callbacks
Implementations of {{com.ibatis.sqlmap.client.extensions.TypeHandlerCallback}} can be used to map between a Java object type and a database column. The following is a list of TypeHandlerCallback implementations that may be useful to iBATIS developers. Java Type Database Type sqlmapconfig Declaration Source Code java.net.URL VARCHAR

U

unix
First things first, you will need to have subversion installed on your local machine. You can get it from the Subversion site http://subversion.tigris.org/. Next step is to check out the latest code from the iBATIS respository http://svn.apache.org ...
Updating the Website
Every committer has access to update the website. ibatis.com/.net/.org simply forward to ibatis.apache.org. The ibatis.net and .org domains are actually parked at apache.org, but ibatis.com is a page forward because the DTDs are still hosted there. The DTDs are also at ibatis.apache.org, but it will be some time ...
UrlTypeHandlerCallback.java
package com.yourpackage; import java.net.MalformedURLException; import java.net.URL; import java.sql.SQLException; import java.sql.Types; / An iBATIS type handler callback for java.net.URLs that are mapped to Strings in the database. If a URL cannot be constructed based on the String, then the URL will be set to null.

Using Ibator to Generate Code for iBATIS

Troubleshooting Symptom: I'm getting a java.lang.InstantiationException when using iBATIS DAOs. Cause 1: Ensure that your ibator configuration file (e.g.abatorConfig.xml) defines the element with type="IBATIS". e.g.

V

W

What causes an Invalid column type error with Oracle
error is a bit misleading. What it is trying to tell you is that your jdbc driver does not know how to set one of your columns to null. In the following section I will show you what causes this error and how to correct it. First lets ...
What database-provider combinations have been tested with the .NET DataMapper
Feel free to add to this list! database name database version provider version notes DB2 DB2 iSeries IBM DB2 iSeries 10.0 not fully tested Firebird 1.5 Firebird SQL .NET provider 1.7 not fully tested MS ...
What is the difference between the iBATIS DAO framework and iBATIS SQL Maps
DAO framework and SQL Maps framework are different things. You can use both, or either one by itself. DAO is an abstraction layer that sits between your persistence solution and your service/domain layer. It serves to maintain a consistent ...
What should my properties.config file look like
Your properties file should contain key and value settings that iBATIS can use when parsing your sqlMap.config file, SqlMap.xml files, or dao.config file. Here's an example: Where can I get more information about Data Access Objects
Please see the products section of www.akcess.in akcess provides free tool to generate java code for data access object layer. http://www.akcess.in Here are just some of the many sources out there on Data Access Objects and patterns. Data Access ...
Where do I get the latest binaries, source, and documentation releases
While iBATIS completes its move to Apache, the latest .NET binaries, source, and documentation releases can be downloaded from: http://ibatis.apache.org
Which database-driver-combinations are known to work with iBATIS DAO and SqlMap
database name db version driver vendor/name driver version Oracle all all all, but recommend 10g DB2 all all all HSQLDB all n/a n/a MS SQL Server 2005 Sourceforge JTDS 1.1 ...
Who is using iBATIS?
Some public websites that utilize IBatis 1up.com Gaming community http://www.1up.com Abebooks.com Worlds largest online marketplace for books http://www.abebooks.com AccesStream.com Open Source Identity and Access Management Suite http://www.accesstream.com BullionVault.com Online gold ...
Why am I getting an exception about my provider not being found in providers.config?
you get this type of exception thrown... IBatisNet.Common.Exceptions.ConfigurationException : Error while configuring the Provider named "OleDb1.1". Cause : The provider is not in 'providers.config'. ...check to make sure that the provider is enabled in your providers.config file. Why am I having problems inserting dates into Oracle?
you don't want your SqlMap statements to look like this: INSERT INTO BOOKS ( BOOKID, TITLE, PUBDATE ) VALUES ( #Id#, #Title#, TODATE(#PubDate#, 'mm/dd/yyyy') ) There is hope! Here is one ...
Why can't I get selectKey and sequences to work properly with Oracle
seems there's an omition in the iBATIS SQL Maps Documentation. According to it the selectKey stanza would have the following syntax: SELECT SEQUENCENAME.NEXTVAL AS ID FROM DUAL But it won't work as it always inserts zero in your insert ...
Why can't I get selecyKey and sequences to work properly with Oracle
seems there's an omition in the iBATIS SQL Maps Documentation. According to it the selectKey stanza would have the following syntax: SELECT SEQUENCENAME.NEXTVAL AS ID FROM DUAL But it won't work as it always inserts zero in your insert ...
Why can't I use a property that begins with a single lower-case letter
Most likely, it's because your property is not defined correctly. property getter setter comment AString getAString setAString Surprise! This is not a property named aString as you expected.. aString getaString setaString Notice the lower case letter after get/set ...
Windows
First things first, you will need to have subversion installed on your local machine. You can get it from the Subversion site http://subversion.tigris.org/. Then create a directory in which to work. I've created the directory 'C:\iBatis' as an example ...

X

XMLType handler is working in somecases but not in some
hi, I have 2 columns defaultvalue & formula with XMLtype in Oracle . But while inserting in the table it gave me error saying invalid column type for formula. I tried using the XMLTytpehandler code but it there the exception XMLType mapping only supported ...
XMLTypeHandlerCallback.java
TypeHandlerCallback class was build and tested using iBATIS DataMapper (Java) 2.2.0.638 and requires the following Oracle specific libraries ojdbc14.jar xdb.jar xmlparserv2.jar package com.yourpackage; import java.io.StringReader; import java.sql.SQLException; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import org.w3c.dom.Document; import ...

Y

YNBooleanTypeHandler.java
package com.yourpackage; import java.sql.SQLException; import com.ibatis.sqlmap.client.extensions.ParameterSetter; import com.ibatis.sqlmap.client.extensions.ResultGetter; import com.ibatis.sqlmap.client.extensions.TypeHandlerCallback; / An iBATIS type handler callback for java.lang.Booleans that are mapped to either 'Y' or 'N' in the database. If a value is something other than 'Y' in the database, including null ...

Z

!@#$


Site running on a free Atlassian Confluence Open Source Project License granted to OSS. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.5 Build:#811 Jul 25, 2007) - Bug/feature request - Contact Administrators