iBatis and ORM's

2005-11-04 Thread Abdullah Kauchali
So, iBatis is /not/ an ORM. What makes Hibernate an ORM and iBatis not? or a corollary: What makes iBatis a DAO implementation and Hiberate not? (Is this a valid question, to begin with?) What are the /decisive/ qualities of each (viz. DAO vs ORM) that classify them appropriately? I am

RE: paginated list

2005-11-04 Thread Zsolt
I use mysql-connector-java-3.1.11-bin.jar but it does also work with mysql-connector-java-3.0.14-production. log4j.logger.java.sql=DEBUG log4j.logger.java.sql.Connection=DEBUG Zsolt -Original Message- From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005

Re: iBatis and ORM's

2005-11-04 Thread Larry Meadors
Man, this is a big one, and i am late already..i'll get it started. The question is not DAO vs ORM, it is ORM vs Data Mapping. ORM = mapping database objects to java objects (or c#, whatever). Data mapping = mapping sql *statements* to java objects (c#, blah, whatever). DAO can be used with

Re: iBatis and ORM's

2005-11-04 Thread Clinton Begin
Quick comparison... ORM 1) Maps classes to tables, and columns to fields. 2) Must support Object Identity 3) Generates SQL SQL Mapping 1) Maps objects (not necessarily a custom type, or even the same type) to statements 2) Generally does not support object identity (would be hard to

Use isNull (in sqlMap) with a Long value?

2005-11-04 Thread Steven Pannell
Hi, I want to make use of the isNull option in the sqlMap using a Long as the parameter class like this: update id=update parameterClass=java.lang.Long UPDATE log SET new = isNotNull property=value 10 /isNotNull isNull

RE: Use isNull (in sqlMap) with a Long value?

2005-11-04 Thread Niels Beekman
I think you can leave out the property-attribute. Niels -Original Message- From: Steven Pannell [mailto:[EMAIL PROTECTED] Sent: vrijdag 4 november 2005 17:05 To: user-java@ibatis.apache.org Subject: Use isNull (in sqlMap) with a Long value? Hi, I want to make use of the isNull option

[OT ANN] Roomity v 1.5 w/ video, social networking and html editor + JDNC article

2005-11-04 Thread netsql
Roomity.com v 1.5 is a web 2.01/RiA poster child community webapp. This new version ads broadcast video, social networking such as favorite authors and html editor.It likely already has groups and content you are already using but aggregated and safer, including technology, Java, etc., but it only

Property starting with 'i' character in Turkish Locale

2005-11-04 Thread Bahri Gencsoy
Think about the most simple database table, just containing ID column as an integer: CREATE TABLE SAMPLE(ID INTEGER NOT NULL PRIMARY KEY) And very simple mapping configuration, as stated in the tutorial: ?xml version=1.0 encoding=UTF-8 ?!DOCTYPE sqlMapPUBLIC -//iBATIS.com//DTD SQL Map

Same table, multiple sources

2005-11-04 Thread Voorhoeve, Niels {PBG}
Hi, I have a situation where I need to read the same table from a couple of different servers. I'm using the ibatis dao framework on top of ibatis sqlmaps. I've thought of a couple of solutions and was wondering what the best practice is? 1. a. Copy the sqlmap config file for the

Re: Same table, multiple sources

2005-11-04 Thread Larry Meadors
Uhm, that is already available. ;-) public Dao getDao(Class iface, String contextId); context id=foo.../context context id=bar.../context Larry On 11/4/05, Voorhoeve, Niels {PBG} [EMAIL PROTECTED] wrote: Hi, I have a situation where I need to read the same table from a couple of different

Property starting with 'i' character in Turkish Locale

2005-11-04 Thread Bahri Gencsoy
Think about the most simple database table, just containing ID column as an integer: CREATE TABLE SAMPLE(ID INTEGER NOT NULL PRIMARY KEY) And very simple mapping configuration, as stated in the tutorial: ?xml version=1.0 encoding=UTF-8 ? !DOCTYPE

Re: iBatis and ORM's

2005-11-04 Thread Abdullah Kauchali
Fantastic. Some more questions in-line. g Clinton Begin wrote: ORM 1) Maps classes to tables, and columns to fields. Don't we do that with iBatis too? Are we saying that mapping classes to tables, and columns to fields is generally a bad idea? 2) Must support Object Identity Yes,

Re: iBatis and ORM's

2005-11-04 Thread Abdullah Kauchali
Larry Meadors wrote: Man, this is a big one, and i am late already..i'll get it started. Sorry. :) I know Friday's almost over, but I need some ammo for something I am preparing for next week. The question is not DAO vs ORM, it is ORM vs Data Mapping. Got it! ORM = mapping

iBATIS transactional behaviour

2005-11-04 Thread Konda, Sreenivasulu \(Consultant\)
Hi All, I would like to know expected behaviour of iBATIS JDBC transactions. Please see below code snippets and details for the same. daoManager.startTransaction(); insert("insertToTable1", Object1); insert("insertToTable2", Object2); update("updateTable3", Object3);

Re: iBatis and ORM's

2005-11-04 Thread Clinton Begin
Try this with Hibernate: int i = (Integer) client.queryForObject (countUsersInGroup, MyGroup); select id=countUsersInGroup resultClass=int parameterClass=string SELECT Count(1) FROM Users WHERE GroupName = #groupName# /select In asking yourself why this isn't possible in Hibernate, you'll

Re: iBatis and ORM's

2005-11-04 Thread Larry Meadors
Preamble/disclaimer: It is late on friday afternoon. On 11/4/05, Kim Goings [EMAIL PROTECTED] wrote: Clinton - This discussion is probably far too old for you since you've been around it for so long. :) I think it's still valid. I've Clinton, Kim just called you OLD, I think. ;-) started

Re: iBatis and ORM's

2005-11-04 Thread Clinton Begin
Sorry everyone. I didn't mean to sound like I don't care about such comparisons. I think it is old for me, and I'm able to look at situation objectively and decide whether Hibernate or iBATIS (or neither) is the best choice. To me, it seems obvious. Perhaps this is a VERY long overdue FAQ that

Re: iBatis and ORM's

2005-11-04 Thread Clinton Begin
Clinton, Kim just called you OLD, I think. ;-) Yeah, but in dog years, I'm only 4. ClintonOn 11/4/05, Larry Meadors [EMAIL PROTECTED] wrote: Preamble/disclaimer: It is late on friday afternoon.On 11/4/05, Kim Goings [EMAIL PROTECTED] wrote: Clinton - This discussion is probably far too old

Re: iBatis and ORM's

2005-11-04 Thread Kim Goings
I will try. I've only been able to convert 2 people so far and would love to reach more. :) Kim On Nov 4, 2005, at 5:49 PM, Clinton Begin wrote: Sorry everyone.  I didn't mean to sound like I don't care about such comparisons.  I think it is old for me, and I'm able to look at situation

Re:iBATIS transactional behaviour

2005-11-04 Thread ooper
I suspect it depends on the rdbms being used and how it is configured; row level locks, page level locks, table level locks. I'm notsure this is affected by iBATIS.Scenario 1: Thread2 will be able to start a tx, but may have to wait for Thread1 to commit/rollback before it can commit/rollback.

Re: iBatis and ORM's

2005-11-04 Thread Clinton Begin
But if those two people convert two people each.exponential growth!On 11/4/05, Kim Goings [EMAIL PROTECTED] wrote:I will try.I've only been able to convert 2 people so far and would love to reach more.:)KimOn Nov 4, 2005, at 5:49 PM, Clinton Begin wrote:Sorry everyone. I didn't mean to sound

parameterMap for Oracle's select * from Table(f(x))

2005-11-04 Thread Balayn, Anna
Title: parameterMap for Oracle's select * from Table(f(x)) Can someone help? I am having a problem executing the following statement with queryWithRowHandler(): statement id=getCaseData resultMap=rmap parameterMap=pmap select * from TABLE (func(?)) /statement This

Re: iBatis and ORM's

2005-11-04 Thread Abdullah Kauchali
netsql wrote: Let me try another approach of how I answer this: Thanks, I appreciate it greatly! :) SQL is a set processing langage. You select a set, update a set where, etc., SQL engines are optimised for this for many decades. (See set theory, unions, intersections, SQL PT, etc.) In