iBatis usage pattern

2006-01-19 Thread Yusuf
Hello, I've been using ibatis for quite some time now, and I like to ask some questions to all ibatis gurus out there... - For queries with joins from many table, i usually map results to a Map (no need to make custom beans), for example: SELECT * FROM dept, emp, bonus

Ref Cursor Support in iBatis

2006-01-19 Thread Yusuf
Hello, I was wondering about the support for ref cursors in ibatis, and i stumbled upon this in the ibatis wiki page (http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+R EF+CURSOR+Solutions):

Re: boolean JavaType and mapping

2006-01-19 Thread Albert L. Sapp
Olivier Antoine wrote: Hello everyone, I have to re-write a website with an existant MySQL database with an important number of data ...so i could not change database structure (column type and so on) I m'a sking if it's possible and so ...How to? make a mapping between a boolean from my ja

boolean JavaType and mapping

2006-01-19 Thread Olivier Antoine
Hello everyone, I have to re-write a website with an existant MySQL database with an important number of data ...so i could not change database structure (column type and so on) I m'a sking if it's possible and so ...How to? make a mapping between a boolean from my java bean class and an inte

Re: [OT] Utility to create DDL from a database

2006-01-19 Thread Zarar Siddiqi
I think most DB Clients like MySQL Front, PostGres Manager etc have an option to "Export as DDL" which does what you're asking for. The export feature is really built into the database (eg: mysqldump). Try looking at Aquafold (http://www.aquafold.com/) and see what it can do for you. What yo

Re: [OT] Utility to create DDL from a database

2006-01-19 Thread Nathan Maves
Try http://www.minq.se/products/dbvis/ On Jan 19, 2006, at 12:57 PM, Ashish Kulkarni wrote: Hi Is there any open source utility which i can use to create DDL from an existing database, so i can use it to run to create tables on other database. This utility should be smart enough to create DDL

[OT] Utility to create DDL from a database

2006-01-19 Thread Ashish Kulkarni
Hi Is there any open source utility which i can use to create DDL from an existing database, so i can use it to run to create tables on other database. This utility should be smart enough to create DDL statements for tables with primary key, before tables with foreign key. That way when i run the D

Special Characters Encoding

2006-01-19 Thread Rafiq, Adnan
We have a requirement where we want to encode special characters in string fields right before saving to the database. And, vice versa, decode special characters after returning them from the DB. What classes do I need to extend/implement in iBatis to provide our own encoding/decoding hook in th

dynabean as resultClass

2006-01-19 Thread Alden S
I want to use org.apache.commons.beanutils.LazyDynaBean for the resultClass but Ibatis does not allow me to. resultClass="org.apache.commons.beanutils.LazyDynaBean"> I know i can use HashMap and then do org.apache.commons.beanutils.BeanUtils.copyProperties(bean, map); which would be accep

Re: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread Jeff Butler
That question is far beyond the scope of Abator - so it should probably be it's own discussion thread.  But in general, the answer is "yes" - you should be able to do that.  You'll need to implement a custom transactionManager and dataSource in iBATIS that does what you want with Oracle.   Jeff Bu

RE: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread seyhan.basmaci
ok , thanks .. we are planning to use Ibatis, I think Ibatis more convenient if you know SQL and integrate with existing system. Also seems easy to learn, and simpler than others.     We need to call an Oracle api  to set db side settings just after getting connection from pool and b

Re: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread Jeff Butler
You cannot run Abator by itself - it is not an executable JAR file.  You need to write a Java program to call the functions in Abator, or use Ant.  See the README for details.   Jeff Butler   On 1/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote: Wen I want to run abataor.jar file directly fro

RE: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread seyhan.basmaci
Wen I want to run abataor.jar file directly from java I get the following error   "Failed to load Main-class manifest attribute from abator0.6.0.jar "         -Original Message-From: Jeff Butler [mailto:[EMAIL PROTECTED]Sent: Thursday, January 19, 2006 5:29 PMTo: user-java@

Re: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread Jeff Butler
If there is a syntax error in the config file, then an exception will be thrown.   Other warnings (like unknown tables, etc.) should be logged in the Ant output.  Or, if you are calling this directly from Java, the warnings are added to the list supplied in the Abator  object's constructor.   Sorry

Re: SQL 'IN' clause

2006-01-19 Thread Jorge DeCastro
Right you are, thanks! j.

RE: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread Meindert
Hi Jeff,   I thought there was a getting started guide with more information about the config file, I can see now that this isn’t necessary because it is all in the DTD. Does anybody know how to make this visible in netbeans (it does the code completion for the tag’s but not the document

Re: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread Jeff Butler
Hi Meindert,   Maybe your browser had the page cached, or the Apache update didn't happen fast enough?  Everything looks OK to me this morning.   I restructured SVN somewhat too, so I removed the SVN links from the page.  If you use Eclipse, then documentation is in the Eclipse help system.  If you

Re: [ABATOR] Version 0.6.0 - Independence from Eclipse

2006-01-19 Thread Larry Meadors
http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper2/tools/abator/eclipse/org.apache.ibatis.abator.doc/html/gettingstarted/intro.html But you may need to check that out instead - when i click on it, I get the HTML source. Larry On 1/19/06, Meindert <[EMAIL PROTECTED]> wrote: > > > > H

Re: SQL 'IN' clause

2006-01-19 Thread Larry Meadors
Look at the iterate tags. Larry On 1/19/06, Jorge DeCastro <[EMAIL PROTECTED]> wrote: > Hi all, > > I am using iBatis 2.1.6 with SQLServer and I can't make dynamic queries > work with SQL's 'IN' clause. > I have the string 'airlineFilter'. > If I pass a string containing one value (airlineFilter

SQL 'IN' clause

2006-01-19 Thread Jorge DeCastro
Hi all, I am using iBatis 2.1.6 with SQLServer and I can't make dynamic queries work with SQL's 'IN' clause. I have the string 'airlineFilter'. If I pass a string containing one value (airlineFilter = "BA"), it works fine. If I pass a comma-separated string of values (airlineFilter = "BA,QF") to t