DB connection Config in SqlMapConfig

2009-03-30 Thread ramang
Hi All, I am working on implementing Ibatis framework in Java for vignette portal. Typically, my portal application uses the DB connection attributes and connection pool attributes from Vignette portal properties. How can I use the DB connection properties and connection pool from

com.ibatis.common.xml.NodeletException: Error parsing XML.Cause: java.net.ProtocolException: Server redirected too many times (20)

2009-03-30 Thread Ashish Kulkarni
HiI am having issue with ibatis, the error i am getting is Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.net.ProtocolException: Server redirected too many times (20) java.net.ProtocolException: Server redirected too many times (20) How can i

Re: com.ibatis.common.xml.NodeletException: Error parsing XML.Cause: java.net.ProtocolException: Server redirected too many times (20)

2009-03-30 Thread Brandon Goodin
What specific version of iBATIS are you using. This should not be an issue. I do development all the time offline and do not have this issue. Try the following DOCTYPE declaration. !DOCTYPE sqlMap PUBLIC -//ibatis.apache.org//DTD SQL Map 2.0//EN http://ibatis.apache.org/dtd/sql-map-2.dtd;

dynamic prepend problem

2009-03-30 Thread esemba
Hi, I have this sql map: ... dynamic prepend=union isNotNull property=queryFulltext removeFirstPrepend=false select theses.id as id, ... ... where theses_documents.index @@ to_tsquery('cs', #queryFulltext#) isNotNull property=categoryId prepend=and

Re: dynamic prepend problem

2009-03-30 Thread Larry Meadors
Why not just say this: isNotNull property=categoryId and theses_categories.id = #categoryId# /isNotNull Larry

Re: dynamic prepend problem

2009-03-30 Thread esemba
Thanks, I guess I'm kind of overworked today :) Do you know why my example doesn't work? Larry Meadors wrote: Why not just say this: isNotNull property=categoryId and theses_categories.id = #categoryId# /isNotNull Larry -- View this message in context:

Re: dynamic prepend problem

2009-03-30 Thread Bhaarat Sharma
your question is already answered but could you tell me how can you see the sql code that ibatis generates? On Mon, Mar 30, 2009 at 2:56 PM, esemba ese...@gmail.com wrote: Thanks, I guess I'm kind of overworked today :) Do you know why my example doesn't work? Larry Meadors wrote: Why

Re: DB connection Config in SqlMapConfig

2009-03-30 Thread ramang
Hi all, Not sure if anyone have been able to understand the query below. let me put it again. I have an existing portal application with DB connection properties and connection pool that are defined in vignette portal (//vignette/portal/config/properties file. The properties are similar to the

Re: DB connection Config in SqlMapConfig

2009-03-30 Thread Nathan Maves
The only way to get access to the pool that Vignette creates would be if they expose it as JNDI. I guess you could also extend ibatis to get a connection for the Vignette pool if you were in the same JVM. On Mon, Mar 30, 2009 at 1:17 PM, ramang raman.gudime...@sdgc.com wrote: Hi all, Not sure

Re: dynamic prepend problem

2009-03-30 Thread esemba
Hi, ibatis uses commons logging and I use log4j in my application. So you only need set DEBUG level for ibatis and check the log for generated statements. Lukas omnipresent wrote: your question is already answered but could you tell me how can you see the sql code that ibatis generates?

Re: iBatis+xStream

2009-03-30 Thread AlexElba
Thanks Eric T. Blue wrote: I ran into this problem a couple years ago. It had something to do with the way XStream serialized the properties (not using getters/setters, but accessing the properties directly). I personally like XStream a lot, but because of this limitation we ended

Please help with mapping Ibatis

2009-03-30 Thread AlexElba
Hello, I have a class public class Part{ private Integer id; private String name; private Bar bar; getters/setters } I have a mapping for part and for there part I am adding aliases for column names after join. I am sure it is not correct way to do it. Please advice how to do correct