Difference between DBCP and SIMPLE connection pools

2007-02-06 Thread Abdullah Kauchali
Hi folks, What's the difference between configuring connections as DBCP vs SIMPLE? When to use which? TIA, A

abator - namespace naming

2007-02-06 Thread Huy Do
Hi, Just starting to use abator and I was wondering if I could control the namespace naming in the generated sqlmal xml file. I am trying to reuse the appfuse UniversalDAO with the abator generated sqlmap files. Many Thanks Huy

Re: abator - namespace naming

2007-02-06 Thread Jeff Butler
There's no configuration option to do this. You could do it through code - by implementing the SqlMapGenerator interface. I'm not familiar with UniversalDAO - what kind of restrictions is it placing on the DAOs? Jeff Butler On 2/6/07, Huy Do [EMAIL PROTECTED] wrote: Hi, Just starting to

Re: abator - namespace naming

2007-02-06 Thread Huy Do
Hi Jeff, It's not so much a restriction, but the code currently uses the class name as the name space for finding the appropriate statement (eg. MyTable.insert() which in abator is my_table_SqlMap.abatorgenerated_insert). I guess I could always convert the class name into table names and use

issue with unknown host exception

2007-02-06 Thread Ashish Kulkarni
Hi I have a java program which uses ibatis to run SQL queries, this program runs on AS400, and on of the AS400 boxes i am getting following error Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Caused by: java.net.UnknownHostException: ibatis.apache.org The

Re: Difference between DBCP and SIMPLE connection pools

2007-02-06 Thread Clinton Begin
DBCP is a connection pool made by Apache. You need to download an additional JAR to use it. SIMPLE is built into iBATIS. SimpleDataSource has served us very well over the years, with very few changes. I'd like to redo the interface at some point (currently yucky property based config), but

RE: issue with unknown host exception

2007-02-06 Thread Yee, Richard K CTR DMDC
Your DOCTYPE is incorrect. You should be using this: !DOCTYPE sqlMapConfig PUBLIC -//ibatis.apache.org//DTD SQL Map Config 2.0//EN http://ibatis.apache.org/dtd/sql-map-config-2.dtd; Notice the difference in ibatis.apache.org and iBATIS.com This causes the parser to go to the Internet for the

Re: issue with unknown host exception

2007-02-06 Thread Larry Meadors
It should be resolved in the iBATIS jar file. Are you using an older version of iBATIS, or the current release? Also, it could be the XML parser on the 400..if that is the case, you could use a system DTD instead of the default. Larry On 2/6/07, Ashish Kulkarni [EMAIL PROTECTED] wrote: Hi I

RE: Difference between DBCP and SIMPLE connection pools

2007-02-06 Thread Abdullah Kauchali
Hi Clinton - thanks for responding. SimpleDataSource has served us very well over the years, with very few changes. I'd like to redo the interface at some point (currently yucky property based config), but the implementation seems to work well. It's a synchronous pool that doesn't spawn

Re: Stored Procedure with variable parameters

2007-02-06 Thread Brandon Goodin
Take a look at dynamic SQL. You may need to do something like use the iterate tag to iterate over a List of Strings. Brandon On 2/6/07, Brett Knights [EMAIL PROTECTED] wrote: Hello, I am using ibatis as my persistence layer in an application that I'm rewriting. I have some older code that

RE: Using a Type Handler for SELECT stmt

2007-02-06 Thread Dave Rodenbaugh
Hmmm...ok, found the source of my problem. You can't seem to do this with resultClass= You must explicitly define a resultMap, reference the resultMap instead of resultClass from the select, set the property on the resultMap to use the type handler, and then it works. FYI, -D

Re: Using a Type Handler for SELECT stmt

2007-02-06 Thread Jeff Butler
You could also define a global type handler if you wanted every instance of com.foo.UserTypeEnum to be handled with the same type handler. Jeff Butler On 2/6/07, Dave Rodenbaugh [EMAIL PROTECTED] wrote: Hmmm...ok, found the source of my problem. You can't seem to do this with

Typo in iBatis document

2007-02-06 Thread Abdullah Kauchali
Noticed an incorrect case for an XML close tag in iBatis Developer Guide page 13 (date 9 August 2006) (Maybe's it's been fixed.) /datasource should be /dataSource

Re: issue with unknown host exception

2007-02-06 Thread Ashish Kulkarni
Hi I tried changing it to !DOCTYPE sqlMap PUBLIC -//ibatis.apache.org//DTD SQL Map Config 2.0//EN http://ibatis.apache.org/dtd/sql-map-2.dtd; But still i get the same error, i have java 1.4.2 on this AS400, so the XML parser must be from java. Also i have these program running on 5 other AS400

cannot write to property without a setter

2007-02-06 Thread Reuben Firmin
Let's say I have a class structure as per below. Ibatis doesl not seem to let me address the path foo.bah.someProperty, because there is no setter (Foo#setBah). Specifically, I get com.ibatis.common.beans.ProbeException: There is no WRITEABLE property. Spring, on the other hand, is fine with

camel-cased column names

2007-02-06 Thread Mark Volkmann
I'm trying to use Abator with a table where the column names are camel-cased. In the generated Java code, for a column like AccountType, methods like getAccounttype get generated. Note the lowercase t at the beginning of type. Is there a way to get the generated method name to be

Re: camel-cased column names

2007-02-06 Thread Jeff Butler
If you just need to change it for one column, then you can do it with a columnOverride element to set the property name. If you want to do it for every column in the table, then tell abator to use the actual column name as the property like this: table tableName=foo property

JAR that contains com.ibatis.dao.client package

2007-02-06 Thread Mark Volkmann
I can't find the JAR that contains the .class files for the com.ibatis.dao.client. Some of the generated Java classes use the class DaoManager from that package. Currently I only have one JAR file for iBATIS and one for Abator and neither of them contain that class.

Re: JAR that contains com.ibatis.dao.client package

2007-02-06 Thread Jeff Butler
The DAO classes have been deprecated and removed from the latest iBATIS distribution. We recommend using the Spring framework for DAO support (Abator can generate DAOs for Spring). If you really want to use the iBATIS DAO framework, there is a seperate download for it on the Java dowloads page.

Re: JAR that contains com.ibatis.dao.client package

2007-02-06 Thread Mark Volkmann
On Feb 6, 2007, at 1:34 PM, Jeff Butler wrote: The DAO classes have been deprecated and removed from the latest iBATIS distribution. We recommend using the Spring framework for DAO support (Abator can generate DAOs for Spring). If you really want to use the iBATIS DAO framework, there is

Re: issue with unknown host exception

2007-02-06 Thread Ashish Kulkarni
Hi This is what i have in release.txt file ibatis-sqlmap-2.jar Build Date: 2005/05/16 01:33 Build Number: 565 -- 2.1.0 - May 16, 2004 _ Hope this helps, so what should be the doc type for this verion Ashish On 2/6/07, Yee, Richard K CTR DMDC [EMAIL

Re: issue with unknown host exception

2007-02-06 Thread Jeff Butler
Time for an upgrade. This was fully resolved in iBATIS version 2.1.5 in July 2005. Jeff Butler On 2/6/07, Ashish Kulkarni [EMAIL PROTECTED] wrote: Hi This is what i have in release.txt file ibatis-sqlmap-2.jar Build Date: 2005/05/16 01:33 Build Number: 565 --

RE: issue with unknown host exception

2007-02-06 Thread Yee, Richard K CTR DMDC
Ashish, You should take Jeff's advice and upgrade to 2.2 or 2.3. If you can't do that, try changing the doctype to this: !DOCTYPE sqlMap PUBLIC -//ibatis.com//DTD SQL Map 2.0//EN http://ibatis.com/dtd/sql-map-2.dtd http://ibatis.com/dtd/sql-map-2.dtd; -Richard -Original

Re: cannot write to property without a setter

2007-02-06 Thread Nathan Maves
I have never tried to do what you say in Spring. In fact I have never tried it at all :) My personal opinion is that you should never try and inject into private properties. Follow the bean specs and all will be well. Nathan On 2/6/07, Reuben Firmin [EMAIL PROTECTED] wrote: Let's say I

RE: cannot write to property without a setter

2007-02-06 Thread Daniel Pitts
Injection using blah.getFoo().setBar(bar); should be fine. There isn't any setFoo, but its not a private injection. From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 12:31 PM To: user-java@ibatis.apache.org Subject: Re: cannot write

Re: issue with unknown host exception

2007-02-06 Thread Ashish Kulkarni
Hi Is there any document where i can find what has changed, or how can i upgrade without breaking existing code? Ashish On 2/6/07, Jeff Butler [EMAIL PROTECTED] wrote: Time for an upgrade. This was fully resolved in iBATIS version 2.1.5 in July 2005. Jeff Butler On 2/6/07, Ashish

Re: issue with unknown host exception

2007-02-06 Thread Clinton Begin
You should be able to drop iBATIS 2.3 in place of your existing version. If you're using DAO I recommend downloading the standard dao package from the Java Downloads page. There's no incompatibilities that I know of within the 2.x versions. Cheers, Clinton On 2/6/07, Ashish Kulkarni [EMAIL

Bad UTF-8 data error

2007-02-06 Thread Christopher . Mathrusse
I'm getting a very odd error that states: The error occurred while applying a result map. Check the HomeCompany.HomeCompanyResult. The error happened while setting a property on the result object. Cause: org.omg.CORBA.MARSHAL: bad UTF-8 data vmcid: 0x0 minor code: 0 completed: No The