Problem with xml config files

2005-02-10 Thread Jason Hall
Title: Problem with xml config files Hi, I'm testing ibatis for the first time using ibatis 2.0. I created the sqlMapConfig.xml, network.xml (custom), Network.java (bean), and a servlet to invoke a the bean. I get as far as the sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); AT THI

Getting error with Bean Object property not writtable at sqlmap config initial load

2005-02-17 Thread Jason Hall
Title: Getting error with Bean Object property not writtable at sqlmap config initial load I'm get this error below. What's the problem. Cause: com.ibatis.common.beans.ProbeException: There is no WRITEABLE property named 'netPrefixID2' in class 'Network' Network.java: import java.io.

RE: Getting error with Bean Object property not writtable at sqlmap config initial load

2005-02-17 Thread Jason Hall
ry Meadors [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 1:03 PM To: ibatis-user-java@incubator.apache.org Subject: Re: Getting error with Bean Object property not writtable at sqlmap config initial load setNetPrefixID == netPrefixID, not netPrefixID2 On Thu, 17 Feb 2005 12:59:14

RE: Getting error with Bean Object property not writtable at sqlmap config initial load

2005-02-17 Thread Jason Hall
with Bean Object property not writtable at sqlmap config initial load Yep, there is still no netPrefixID2 property in the bean: Larry On Thu, 17 Feb 2005 13:08:27 -0500, Jason Hall <[EMAIL PROTECTED]> wrote: > Sorry here is the correct to xml file. The original xml file had

RE: Getting error with Bean Object property not writtable at sqlmap config initial load

2005-02-17 Thread Jason Hall
still no netPrefixID2 property in the bean: Larry On Thu, 17 Feb 2005 13:08:27 -0500, Jason Hall <[EMAIL PROTECTED]> wrote: > Sorry here is the correct to xml file. The original xml file had the wrong > database field of "O1" it should have been NetPrefixID. >

Does Ibatis support "Unit of Work" like Hibernate

2005-03-17 Thread Jason Hall
Title: Does Ibatis support "Unit of Work" like Hibernate Hi, I just want to know if Ibatis supports "unit of work" instead of requerying the database each time.

Ibatis vs Jaxor

2005-03-17 Thread Jason Hall
Title: Ibatis vs Jaxor Hi, I was just reading up on Jaxor, similar to ibatis using a xml mapping technique and traditional SQL queries. But it provides more, like "unit of work", identity, etc.  It seems intrieging.  What's significantly  better in ibatis than Jaxor? T

RE: Ibatis vs Jaxor

2005-03-17 Thread Jason Hall
Title: Ibatis vs Jaxor here's the link http://jaxor.sourceforge.net -Original Message-From: Jason Hall [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 1:19 PMTo: ibatis-user-java@incubator.apache.orgSubject: Ibatis vs Jaxor Hi, I was just reading up on

RE: Ibatis vs Jaxor

2005-03-17 Thread Jason Hall
may be wrong. Also, jaxor does not abstract it's sql from the java class. It only abstracts the mapping to entity objects from the java class. That's just a quick overview of what i saw. I'd be interested to hear what others have to say. Brandon On Thu, 17 Mar 2005 13:19:

Selectkey Tag Question

2005-04-06 Thread Jason Hall
Title: Selectkey Tag Question Hi, I'm using Oracle sequences.  I just wanted to know when using the tag, if there is a way to fetch that key in java after it has been inserted.  I need this key for other tables. Thanks, Jason Hall

RE: Selectkey Tag Question

2005-04-06 Thread Jason Hall
("myInsertStatement",someObject); } --- sql map --- ... ... Hope that helps, Brandon On Apr 6, 2005 9:46 AM, Jason Hall <[EMAIL PROTECTED]> wrote: > > > Hi, > > I'm using Oracle sequences. I just wanted to know when using the > tag, if there is a way to fe

RE: Using a stored proc in selectKey?

2005-04-06 Thread Jason Hall
Why don't you call your stored procedure through the select statement. ex. select sp_get_next_id('CATEGORY_ID',???) as id from dual; . . Jason Hall -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 12:47 PM

RE: Using a stored proc in selectKey?

2005-04-06 Thread Jason Hall
hm ... can you pass parameters in the tag? -Original Message- From: Jason Hall [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 1:26 PM To: ibatis-user-java@incubator.apache.org; Brandon Goodin Subject: RE: Using a stored proc in selectKey? Why don't you call your s

SQL Map Configuration with Many tables and Domain classes

2005-04-13 Thread Jason Hall
on can the namespace be Personer(just want to know if this is possible)? please help. Thanks! Jason Hall

RE: SQL Map Configuration with Many tables and Domain classes

2005-04-13 Thread Jason Hall
is used when you call your sqlmap queryForObject("MyNameSpace.myMappedStatement",myObject). So, the namespace is arbitrary. You can name it whatever you like. Brandon On 4/13/05, Jason Hall <[EMAIL PROTECTED]> wrote: > > > Hi, > > I have about 200 tables and

RE: composite keys and procedures

2005-04-18 Thread Jason Hall
on this note. Does ibatis support composite keys not using store procedures but say using tag and .   Jason. -Original Message-From: Clinton Begin [mailto:[EMAIL PROTECTED]Sent: Sunday, April 17, 2005 3:01 AMTo: ibatis-user-java@incubator.apache.orgSubject: Re: composite k

SqlMap namespace - reserved words ?

2005-04-21 Thread Jason Hall
Title: SqlMap namespace - reserved words ? Hi, I tried using and I get this error com.ibatis.sqlmap.client.SqlMapException: There is no statement named Lookup.getAdlDTO-AllRows in this SqlMap.  com.ibatis.sqlmap.engine.mapping.statement.MappedStatement com.ibatis.sqlmap.engine.impl.SqlMa

Implicit Mapping and Dynamic SQL

2005-05-02 Thread Jason Hall
Title: Implicit Mapping and Dynamic SQL Hi, I use the following sqlMap statement. select * from $table$ In my java code this works List l = queryForList("selectTable","TABLE_A"); but when i do this with same statement id (selectTable) ... List l = queryForList("selectTable","TABLE_A

RE: Implicit Mapping and Dynamic SQL

2005-05-03 Thread Jason Hall
licit Mapping and Dynamic SQL The remapResults attribute is used if you have a need to dynamically change the result map when the statement is called. While this makes the returned data more flexible, the cost is pretty high, so use it with caution. Larry On 5/3/05, Jason Hall &l

RE: Implicit Mapping and Dynamic SQL

2005-05-03 Thread Jason Hall
I figured it out remapResults="true"   I test it and it works!!!   Thanks Larry.   JH. -Original Message-From: Jason Hall [mailto:[EMAIL PROTECTED]Sent: Tuesday, May 03, 2005 1:29 PMTo: ibatis-user-java@incubator.apache.org; [EMAIL PROTECTED]Subject: RE: Implic

RE: transactions

2005-05-24 Thread Jason Hall
if a an error occurs in any of these 3 updates below > > update("insertAccount", account); > > update("insertProfile", account); > > update("insertSignon", account); a rollback will occur before the daoManager.commitTransaction(). So isn't it safe to say that these updates a wrapped in the transact

RE: transactions

2005-05-24 Thread Jason Hall
void insertAccount(Account account) { update("insertAccount", account); } Would this startTransaction() call still be necessary? >From: "Jason Hall" <[EMAIL PROTECTED]> >Reply-To: ibatis-user-java@incubator.apache.org >To: >,<[EMAIL PROTECTED]>,<[EMAIL PROTE

RE: transactions

2005-05-24 Thread Jason Hall
PROTECTED] Sent: Tuesday, May 24, 2005 4:22 PM To: Jason Hall Cc: ibatis-user-java@incubator.apache.org; [EMAIL PROTECTED] Subject: Re: transactions If you do not call start transaction then each update call in the dao class will be in it's own transaction. This means that you would have incom

Error processing Null during Insert statement - Help

2005-05-26 Thread Jason Hall
Title: Error processing Null during Insert statement - Help Hi, I'm trying to force a null in a nullable column and i get an error. Java code: Dummy d = new Dummy(); d.setId(-999); sqlMap.insert("Dummy.insertDummy",d); Sql Map: http://www.ibatis.com/dtd/sql-map-2.dtd">  

RE: Error processing Null during Insert statement - Help

2005-05-26 Thread Jason Hall
Jason, Looking at the stack trace you posted, it's clear that the error you're getting comes from your DB. Look at your table Dummy structure. Does it allow the column id to be null? Also, what is your DB? Hope that helped. Cheers, Daniel Silva. On 5/26/05, Jason Hall <[EMAIL PROT

RE: Error processing Null during Insert statement - Help

2005-05-26 Thread Jason Hall
Yes I'm using JDBC-ODBC driver. I'm using Oracle 9i. Will Oracle 10g driver work with Oracle 9i? -Original Message- From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED] Sent: Thursday, May 26, 2005 1:34 PM To: Jason Hall Subject: Re: Error processing Null dur

RE: Error processing Null during Insert statement - Help

2005-05-26 Thread Jason Hall
Error processing Null during Insert statement - Help Change NUMBER to varchar will take care the business. -Henry Jason Hall wrote: >All the columns in table dummy are nullable in Oracle > >-Original Message- >From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL

Handling Null value In Oracle - Everything fine but 1 problem

2005-05-26 Thread Jason Hall
Title: Handling Null value In Oracle - Everything fine but 1 problem Hi, I've tried every scenario from previous mailing-list, wike etc. I'm using Oracle 9i (tried Oracle 9i & 10g jdbc thin driver) Everything works, i'm able to insert null data for varchar and ALSO able to insert NUMBER

RE: Handling Null value In Oracle - Everything fine but 1 problem

2005-05-26 Thread Jason Hall
fine but 1 problem Is id an Integer or an int? Also, the syntax in your example has: #id:NUMERIC:# It should be: #id:NUMERIC# Not sure if that is causing a problem. On 5/26/05, Jason Hall <[EMAIL PROTECTED]> wrote: > > > Hi, > > I've tried every scenario

Is there a way to Debug SQL statements

2005-06-06 Thread Jason Hall
Title: Is there a way to Debug SQL statements Hi, I just wanted to know is there a way in Java to debug sql statments being passed to the database? J.H.

RE: Is there a way to Debug SQL statements

2005-06-06 Thread Jason Hall
, Carbonell Soler, Jorge <[EMAIL PROTECTED]> wrote: > > > > Just use log4j or any other logging framework. This way you'll get, for > example, the querys or the resultsets those querys return. > > > > -----Mensaje original- > De: Jason Hall [mailto:[E

RE: Is there a way to Debug SQL statements

2005-06-06 Thread Jason Hall
amework. This way you'll get, for >> example, the querys or the resultsets those querys return. >> >> >> >> -Mensaje original- >> De: Jason Hall [mailto:[EMAIL PROTECTED] >> Enviado el: lunes, 06 de junio de 2005 19:04 >> Para: ibatis-use