RE: Resources

2006-01-20 Thread Priyesh Mashelkar
Sorry, I meant, Where is the xml file placed in the jar file?   Priyesh   From: Priyesh Mashelkar Sent: Saturday, January 21, 2006 11:12 AM To: user-java@ibatis.apache.org Subject: RE: Resources   What is the xml file placed in the jar

RE: Resources

2006-01-20 Thread Priyesh Mashelkar
What is the xml file placed in the jar file?   Priyesh   From: Tony Qian [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 10:07 PM To: user-java@ibatis.apache.org Subject: Resources   Can someone tell why Resources.getResourceAsR

Re: WE LOVE IBATIS!

2006-01-20 Thread Larry Meadors
Just now, yeah. Larry On 1/20/06, Clinton Begin <[EMAIL PROTECTED]> wrote: > Did someone move this to the wiki yet? :-) > > Thanks Craig! > > > > > > On 1/20/06, Larry Meadors <[EMAIL PROTECTED]> wrote: > > Wow, that is awesome. :-D > > > > Larry > > > > > > On 1/20/06, Craig A. Vanderborgh <[E

Re: WE LOVE IBATIS!

2006-01-20 Thread Clinton Begin
Did someone move this to the wiki yet?  :-) Thanks Craig! On 1/20/06, Larry Meadors <[EMAIL PROTECTED]> wrote: Wow, that is awesome. :-DLarryOn 1/20/06, Craig A. Vanderborgh <[EMAIL PROTECTED]> wrote:> Hello Ibatis-Land:>> We tried them all.  First OJB, then Hibernate, and we wound up finding >

Re: n+1 relation table

2006-01-20 Thread Gregg D Bolinger
Thanks for the help. I really don't think this can be performed with a single query.  Let me see if I can explain better and with a simpler example...Type.javapublic class Type{   private Long type_id;    private String type;   //getters and setters}Item.java{   private Long item_id;   private Stri

Re: WE LOVE IBATIS!

2006-01-20 Thread Larry Meadors
Wow, that is awesome. :-D Larry On 1/20/06, Craig A. Vanderborgh <[EMAIL PROTECTED]> wrote: > Hello Ibatis-Land: > > We tried them all. First OJB, then Hibernate, and we wound up finding > out the best option last - IBATIS. > > A year ago, we were naive Pojo-persistence beginners, and fell into

WE LOVE IBATIS!

2006-01-20 Thread Craig A. Vanderborgh
Hello Ibatis-Land: We tried them all. First OJB, then Hibernate, and we wound up finding out the best option last - IBATIS. A year ago, we were naive Pojo-persistence beginners, and fell into usual the Hibernate trap pretty quickly. Complex code configuration with Middlegen, a gratuitously

Re: iBatis usage pattern

2006-01-20 Thread Jeff Butler
Hi Yusuf,   This is a big question!   Clinton is right that a JavaBean will be faster, but I've always thought that the performance gain will be negligible and not noticed by any user.  For me, this is not enough of an argument one way or the other.   I have been on both sides of the issue with M

Passing a NULL value to a parameter of an Oracle stored procedure

2006-01-20 Thread Vu, Thai
Hello, I have an Oracle stored procedure `myproc' which has 2 parameters which can be null. {call myproc(?, ?)} In Java: Map map = new HashMap(); map.put("p1", new Integer(5)); map.put("p2", null); // throws exception at sqlMapClient.queryForObject // map.put("p2", "hi"); // g

Re: encrypted password in the properties file

2006-01-20 Thread radha rukmani
Thanks Larry.Larry Meadors <[EMAIL PROTECTED]> wrote: You could create a SqlMapClientBuilder that does that, but honestly,it would be a waste of time.If someone can access that file, they can access the bytecode todecrypt it (because your jdbc driver won't use it encrypted) thus theyown you anyway

Re: encrypted password in the properties file

2006-01-20 Thread Larry Meadors
You could create a SqlMapClientBuilder that does that, but honestly, it would be a waste of time. If someone can access that file, they can access the bytecode to decrypt it (because your jdbc driver won't use it encrypted) thus they own you anyway. Good file system security is your best bet. La

Re: how to create two connection pools

2006-01-20 Thread Jeff Butler
Two SqlMapConfig.xml files.   Two DAO contexts if you are using iBATIS DAO.   Jeff Butler   On 1/20/06, radha rukmani <[EMAIL PROTECTED]> wrote: Hi,   How to create two connection pools, for two different databases.   Thanks     Yahoo! PhotosRing in the New Year with Photo Calendars. Add photos

Re: how to create two connection pools

2006-01-20 Thread Larry Meadors
Create two SqlMapClient instances and pass in the properties to the builder. Larry On 1/20/06, radha rukmani <[EMAIL PROTECTED]> wrote: > Hi, > > How to create two connection pools, for two different databases. > > Thanks

how to create two connection pools

2006-01-20 Thread radha rukmani
Hi,   How to create two connection pools, for two different databases.   Thanks     Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

encrypted password in the properties file

2006-01-20 Thread radha rukmani
Hi   I am new to ibatis, I want to save only an encrypted password inside the .properties file,   say for now, my sqlMapConfig.properties file has,  driver=oracle.jdbc.driver.OracleDriver url="">jdbc:oracle:thin:@xxx username=username password=password   i want to save an encrypted p

Re: how to set rolename

2006-01-20 Thread Larry Meadors
I have never heard of anything like this...can you provide some more information? Larry On 1/20/06, radha rukmani <[EMAIL PROTECTED]> wrote: > Hi, > > I want to set the rolename and rolepassword. I need this, because some of > the tables are available for querying , only if we have a certain rol

Re: Resources

2006-01-20 Thread Larry Meadors
I have also seen cases where you have to use a leading / with different classloaders, I know, it sounds retarded (and IMO, it is), but it has worked for me in the past. Larry On 1/20/06, Clinton Begin <[EMAIL PROTECTED]> wrote: > Because JAR files mess up the resource path. You'd probably have t

Re: Resources

2006-01-20 Thread Reuben Firmin
If you use this Spring class, you can get resources from jars... * @param resource e.g. "classpath:your/package/here/Blah.xml"     public static Resource getClasspathResource(String resource) {     PathMatchingResourcePatternResolver res = new PathMatchingResourcePatternResolver();

Re: Resources

2006-01-20 Thread Clinton Begin
Because JAR files mess up the resource path.  You'd probably have to use something goofy like "jar!/sqlMapConfig.xml"but I wouldn't depend upon that.  I suggest just putting them in WEB-INF/classes. ClintonOn 1/20/06, Tony Qian <[EMAIL PROTECTED]> wrote: Can someone tell why Resources.

Re: Ref Cursor Support in iBatis

2006-01-20 Thread Mike Fagan
Yusuf, The SQL package is bundled with the testsrc.zp in the attachments. Regards, Mike Fagan Yusuf wrote: 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

Re: NPE with iBATIS - queryForObject

2006-01-20 Thread Jeff Butler
You are not accessing the DAO correctly (see the DAO manual, page 8).  This is the proper way to gain access to a DAO implementation with iBATIS DAO:   UsersDAO usersdao = daoManager.getDao(UsersDAO.class); If you still have a problem after making this fix, then please send more specifics about the

Resources

2006-01-20 Thread Tony Qian
Can someone tell why Resources.getResourceAsReader(sqlMapConfig.xml) can not find the sqlMapConfig.xml and sql mapping xml files if I package them inside jar file? When I put them under WEB-INF/classes/ (i'm using tomcat), everything works okay. Thanks, Tony

RE: cascading insert of complex properties?

2006-01-20 Thread Fullam, Jonathan, ALABS
You are barking up the wrong tree.  I actually saw this asked over a year ago but I can't remember the exact response.  Basically, this is no supported and there is a good reason why not.  Sorry to be so vague. -Original Message-From: bob robertson [mailto:[EMAIL PROTECTED]Sent

NPE with iBATIS - queryForObject

2006-01-20 Thread Rashmi Dave
We have used ABATOR to generate DAO classes for tables in Oracle. The SQLMap.xml generated by abator is unchanged. I have the following daoconfig Code to call this // TODO Auto-generated method stub Reader reader= Resources.getResourceAsReader("daoConfig.

how to set rolename

2006-01-20 Thread radha rukmani
Hi,   I want to set the rolename and rolepassword. I need this, because some of the tables are available for querying , only if we have a certain role set for the account.  So if we want to access these tables using our application, the application itself sets that user the particular role for th

cascading insert of complex properties?

2006-01-20 Thread bob robertson
Couldn't find this in the archives.   I have a bean class, so:   class Bean {     private Nested nested; }   (naturally with more properties, getters setters etc).   Bean maps to one table in the DB, Nested to another ,the two are linked with a FK from Bean to Nested.   To save this w

Re: boolean JavaType and mapping

2006-01-20 Thread olivier antoine
I have found qhat I want to doIt works very well I discover that it already exists a class named BooleanTypeHandler which make the staff (only for 0 and 1 value).So we can extends that class to make it works with "yes", "no" values ... Thanks a lot2006/1/20, Gareth Moorst <[EMAIL PROTECTED]>: Here

RE: boolean JavaType and mapping

2006-01-20 Thread Gareth Moorst
Here's one I wrote to do just that. Feel free to use it (just don't tell my boss)package com.phones4u.datamanagement.datamodel.ibatis.typehandler;import java.sql.SQLException;import java.sql.Types;import com.ibatis.sqlmap.client.extensions.ParameterSetter;import com.ibatis.sqlmap.client.extensions.

RE: boolean JavaType and mapping

2006-01-20 Thread Niels Beekman
You could use a typehandler to do that: http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+ use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe+Enumeration Niels -Original Message- From: Olivier Antoine [mailto:[EMAIL PROTECTED] Sent: donderdag 19 januari 20