From josephsmith@example.net Tue Apr 03 09:33:55 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 92660 invoked from network); 3 Apr 2007 09:33:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Apr 2007 09:33:55 -0000 Received: (qmail 28577 invoked by uid 500); 3 Apr 2007 09:34:02 -0000 Delivered-To: josephsmith@example.net Received: (qmail 28568 invoked by uid 500); 3 Apr 2007 09:34:01 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 28551 invoked by uid 99); 3 Apr 2007 09:34:01 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2007 02:34:01 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2007 02:33:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id B46DB71406D for <josephsmith@example.net>; Tue, 3 Apr 2007 02:33:32 -0700 (PDT) Message-ID: <27878879.1175592812735.JavaMail.jira@brutus> Date: Tue, 3 Apr 2007 02:33:32 -0700 (PDT) From: "M.H. Avegaart (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Created: (IBATIS-412) Allow parameters as values in composite keys MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Allow parameters as values in composite keys -------------------------------------------- Key: IBATIS-412 URL: https://issues.apache.org/jira/browse/IBATIS-412 Project: iBatis for Java Issue Type: New Feature Components: SQL Maps Affects Versions: 2.3.0 Reporter: M.H. Avegaart Assume a master table TABLE1 with fields KEY1 and FIELD1 (primary key KEY1) and a detail table TABLE2 with fields KEY, KEY2 and FIELD2 (composite primary key KEY1, KEY2). TABLE1 is mapped on a class Table1, TABLE2 is mapped on a class Table2 and Table1 has a list property that contains a List of Table2 objects. I would like to query for all Table1 objects with a specific field1 value together with the corresponding Table2 objects with a specific key2 value, but this is currently not possible without joining TABLE1 and TABLE2 in a single query (which I can't use because I really need to use lazy loading !). Would it be possible to change SQL Maps to allow the following syntax: <parameterMap id="params1" class="test.MyParams1"> <parameter property="field1" /> <parameter property="key2" /> </parameterMap> <resultMap id="result1" class="test.Table1"> <result property="key1" column="KEY1" /> <result property="field1" column="FIELD1" /> <result property="list" column="{key1=KEY1,key2=#key2#}" select="select2" /> </resultMap> <select id="select1" parameterMap="params1" resultMap="result1"> <![CDATA[select KEY1, FIELD1 from TABLE1 where FIELD1 = ?]]> </select> <parameterMap id="params2" class="test.MyParams2"> <parameter property="key1" /> <parameter property="key2" /> </parameterMap> <resultMap id="result2" class="test.Table2"> <result property="key1" column="KEY1" /> <result property="key2" column="KEY2" /> <result property="field2" column="FIELD2" /> </resultMap> <select id="select2" parameterMap="params2" resultClass="test.MyResult2"> <![CDATA[select KEY1, KEY2, FIELD2 from TABLE2 where KEY1 = ? and KEY2 = ?]]> </select> Here, the column attribute for the list field specifies the KEY1 column and the key2 parameter as parameters for the select2 query. ps. I tried to add the field2 parameter as a field to the select statement of the select1 query, but most databases (DB2 in my case) don't allow this. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Tue Apr 03 12:12:05 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 46024 invoked from network); 3 Apr 2007 12:12:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Apr 2007 12:12:02 -0000 Received: (qmail 64879 invoked by uid 500); 3 Apr 2007 12:12:05 -0000 Delivered-To: josephsmith@example.net Received: (qmail 64752 invoked by uid 500); 3 Apr 2007 12:12:05 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 64680 invoked by uid 99); 3 Apr 2007 12:12:04 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2007 05:12:04 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2007 05:11:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id A5CED714065 for <josephsmith@example.net>; Tue, 3 Apr 2007 05:11:32 -0700 (PDT) Message-ID: <25378839.1175602292673.JavaMail.jira@brutus> Date: Tue, 3 Apr 2007 05:11:32 -0700 (PDT) From: "val lee (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Created: (IBATIS-413) Error parsing XML(SQL Maps) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Error parsing XML(SQL Maps) --------------------------- Key: IBATIS-413 URL: https://issues.apache.org/jira/browse/IBATIS-413 Project: iBatis for Java Issue Type: Bug Components: SQL Maps Affects Versions: 2.3.0, 2.2.0 Environment: windows xp sp2, tomcat 5.0.28,springframework 2.0.3 Reporter: val lee if my domain bean have propertis for single letter start .etc xYYYY, tomcat will error. Domain Bean: public class SscIssue extends BaseModel { private static final long serialVersionUID = -8485826237084876775L; private String lSaleMoney ; public long getSaleMoney() { return saleMoney; } public void setSaleMoney(long saleMoney) { this.saleMoney = saleMoney; } } sql map: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd"> <sqlMap namespace="sscIssue"> <typeAlias type="com.ucinfo.WebLottery.ssc.domain.SscIssue" alias="sscIssue" /> <resultMap class="sscIssue" id="sscIssueResult"> <result property="lSaleMoney" column="lSaleMoney" /> </resultMap> <insert id="insertSscIssue"> INSERT INTO tabtab (lSaleMoney) values (saleMoney) </insert> </sqlMap> error info: 2007-04-02 21:13:38,500 ERROR [org.springframework.web.context.ContextLoader] - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in ServletContext resource [/WEB-INF/dataAccessContext-local.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/insert'. Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'lSaleMoney' in class 'com.ucinfo.WebLottery.ssc.domain.SscIssue' java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/insert'. Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'lSaleMoney' in class 'josephsmith@example.net(SqlMapConfigParser.java:84) at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:62) at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:258) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:269) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4343) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) at org.apache.catalina.core.StandardService.start(StandardService.java:480) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) at org.apache.catalina.startup.Catalina.start(Catalina.java:556) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/insert'. Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'lSaleMoney' in class 'josephsmith@example.net(NodeletParser.java:52) at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:81) ... 27 more Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/insert'. Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'lSaleMoney' in class 'josephsmith@example.net(NodeletParser.java:113) at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:74) at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:92) at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62) at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:50) ... 28 more Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/insert'. Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'lSaleMoney' in class 'josephsmith@example.net(NodeletParser.java:52) at com.ibatis.sqlmap.engine.builder.xml.SqlMapParser.parse(SqlMapParser.java:50) at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:364) at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:111) ... 32 more Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMap/insert'. Cause: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'lSaleMoney' in class 'josephsmith@example.net(NodeletParser.java:113) at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:74) at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:92) at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62) at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:50) ... 35 more Caused by: com.ibatis.common.beans.ProbeException: There is no READABLE property named 'lSaleMoney' in class 'josephsmith@example.net(ClassInfo.java:240) at com.ibatis.common.beans.GenericProbe.getClassPropertyTypeForGetter(GenericProbe.java:224) at com.ibatis.common.beans.GenericProbe.getPropertyTypeForGetter(GenericProbe.java:153) at com.ibatis.sqlmap.engine.mapping.parameter.InlineParameterMapParser.resolveTypeHandler(InlineParameterMapParser.java:229) at com.ibatis.sqlmap.engine.mapping.parameter.InlineParameterMapParser.newParseMapping(InlineParameterMapParser.java:138) at com.ibatis.sqlmap.engine.mapping.parameter.InlineParameterMapParser.parseInlineParameterMap(InlineParameterMapParser.java:50) at com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.applyInlineParameterMap(SqlStatementParser.java:428) at com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.processSqlStatement(SqlStatementParser.java:216) at com.ibatis.sqlmap.engine.builder.xml.SqlStatementParser.parseGeneralStatement(SqlStatementParser.java:121) at com.ibatis.sqlmap.engine.builder.xml.SqlMapParser$19.process(SqlMapParser.java:553) at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:111) ... 39 more when i change lSaleMoney to saleMoney, tomcat runs ok. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Tue Apr 03 15:37:56 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 42795 invoked from network); 3 Apr 2007 15:37:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 3 Apr 2007 15:37:55 -0000 Received: (qmail 86585 invoked by uid 500); 3 Apr 2007 15:38:02 -0000 Delivered-To: josephsmith@example.net Received: (qmail 86317 invoked by uid 500); 3 Apr 2007 15:38:01 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 86255 invoked by uid 99); 3 Apr 2007 15:38:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2007 08:38:00 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2007 08:37:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id ACA70714065 for <josephsmith@example.net>; Tue, 3 Apr 2007 08:37:32 -0700 (PDT) Message-ID: <17830326.1175614652703.JavaMail.jira@brutus> Date: Tue, 3 Apr 2007 08:37:32 -0700 (PDT) From: "James Burton (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Created: (IBATIS-414) Allow extending the Example classes or allow hand written criteria MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Allow extending the Example classes or allow hand written criteria ------------------------------------------------------------------ Key: IBATIS-414 URL: https://issues.apache.org/jira/browse/IBATIS-414 Project: iBatis for Java Issue Type: Improvement Components: Tools Affects Versions: 2.3.0 Environment: Java 1.5, Maven 2, ANT 1.6.5, Ibatis 2.3.0, abator 1.0.0 Reporter: James Burton I currently have database searches implemented very nicely with abator generated code. I use the Example classes with the 'and..Like' criteria to do this. It works great. However, I now have a requirement to make these searches case-insensitive. After a bit of thinking I decided to try and extend the generated Example classes and override the 'and..Like' methods to add in the required upper() functions that Sybase requires to get true case insensitivity. I need to get a criteria added something like this... addCriterion("upper(code) like", value, "upper(code)"); The problem is, I cannot extend the Example classes because there is no public constructor on the 'Criteria' inner class. Nor does the Example class allow a 'hand written' criteria to be added. This too, would be very useful. Do you think you could add a public constructor or make the existing one public? Either that or add methods to allow adding a hand-written criteria? ..or is there a better way to do this that I have completely missed? If not, Thanks, James -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Wed Apr 04 16:50:03 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 61352 invoked from network); 4 Apr 2007 16:50:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Apr 2007 16:50:03 -0000 Received: (qmail 28576 invoked by uid 500); 4 Apr 2007 16:50:01 -0000 Delivered-To: josephsmith@example.net Received: (qmail 28495 invoked by uid 500); 4 Apr 2007 16:50:00 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 28422 invoked by uid 99); 4 Apr 2007 16:50:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 09:50:00 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 09:49:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 6F1B4714066 for <josephsmith@example.net>; Wed, 4 Apr 2007 09:49:32 -0700 (PDT) Message-ID: <16800431.1175705372433.JavaMail.jira@brutus> Date: Wed, 4 Apr 2007 09:49:32 -0700 (PDT) From: "Gabor Willner (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Commented: (IBATIS-332) Exposing javaType (resultMap/parameterMap) attribute in TypeHandler methods for Superclass/Subclass handlers. In-Reply-To: <18019517.1155232816087.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATIS-332?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486695 ]=20 Gabor Willner commented on IBATIS-332: -------------------------------------- ditto. I would like to have that feature too... > Exposing javaType (resultMap/parameterMap) attribute in TypeHandler metho= ds for Superclass/Subclass handlers. > -------------------------------------------------------------------------= ------------------------------------ > > Key: IBATIS-332 > URL: https://issues.apache.org/jira/browse/IBATIS-332 > Project: iBatis for Java > Issue Type: Improvement > Components: SQL Maps > Affects Versions: 2.1.7 > Environment: WebLogic 8.1.5, Oracle 9i, Solaris > Reporter: Jay Blanton > > This improvement is inregards to TypeHandler and its usage with Superclas= ses/Subclasses. Currently we have an Abstract object (TypeSafeEnumeration)= that users will extend to create their own specific implementations of our= TypeSafeEnumeration. When they want to map this data type in iBatis, they= have to create a specific handler for each implementation of the TypeSafeE= numeration. What we would like to accomplish is to create a single handler= for the superclass. But in order to do this...methods like the getResult = in the TypeHandler interface would need to know how to take a VARCHAR from = the database and create the specific implementation of that superclass. Th= is information is not available to getResult (but not needed in the setPara= meter), so therefore a handler must be created specific to each implementat= ion. I would like to register a superclass with a global typeHandler in my= sqlMapConfig that can handle the conversion for each specific implementati= on of that superclass, by utilizing the javaType (for example). > So a superclass could be registered as the the global javaType with a sup= erclass based TypeHandler. Then each resultMap/parameterMap could defined = the specific implementation in the javaType and the TypeHandler could use t= hat resultMap/parameterMap javaType to instantiate the specific version of = that superclass. > I have included below the TO that is getting mapped, and the Superclass (= Abstract) that needs the TypeHandler, and two specific implementations of t= hat TypeHandler: > TO: > public class ContactTO { > =20 > private GenderType gender; > private ContactMethodType contactMethod; > public ContactMethodType getContactMethod() { > return this.contactMethod; > } > public void setContactMethod(ContactMethodType contactMethod) { > this.contactMethod =3D contactMethod; > } > public GenderType getGender() { > return this.gender; > } > public void setGender(GenderType gender) { > this.gender =3D gender; > } > =20 > } > Superclass (Enum) > import java.io.Serializable; > import java.util.Hashtable; > import java.util.Iterator; > /** > * Base class for type-safe Enumeration to provide a consistent interface = and > * common methods, and to make Castor-ation easier. > */ > public abstract class AbstractTypeSafeEnumeration implements Serializable= { > private static Hashtable _types =3D new Hashtable(); > private String _value; > private String _displayValue; > public static final AbstractTypeSafeEnumeration getTypeByValue(String= value, Class clazz ) { > Hashtable classType =3D (Hashtable)_types.get(clazz.getName()); > AbstractTypeSafeEnumeration out =3D (AbstractTypeSafeEnumeration)= classType.get(value); > return out; > } > public static final AbstractTypeSafeEnumeration getTypeByDisplayValue= (String displayValue, Class clazz) > { > Hashtable classType =3D (Hashtable)_types.get(clazz.getName()); > Iterator values =3D classType.values().iterator(); > AbstractTypeSafeEnumeration value =3D null; > while (values.hasNext() && value =3D=3D null) > { > AbstractTypeSafeEnumeration tempValue =3D (AbstractTypeSafeEn= umeration) values.next(); > if (value.getDisplayValue().equals(displayValue)) { > value =3D tempValue; > } > } > return value; > } > protected AbstractTypeSafeEnumeration( String value, String displayVa= lue ) { > this._value =3D value; > this._displayValue =3D displayValue; > synchronized( _types ) { > String className =3D this.getClass().getName(); > Hashtable classType =3D ( Hashtable )_types.get( className ); > if( classType =3D=3D null ) { > classType =3D new Hashtable(); > _types.put( className, classType ); > } > classType.put( value, this ); > } > } > public final String getValue() { > return this._value; > } > public final String getDisplayValue() { > return this._displayValue; > } > } > Implementations of Enum (located in ContactTO) > import com.foo.to.AbstractTypeSafeEnumeration; > /** > * This class is a type-safe Enumeration of ContactMethodTypes. > * > * @author Jay Blanton > */ > public class ContactMethodType extends AbstractTypeSafeEnumeration { > public static final ContactMethodType PHONE =3D new ContactMethodType= ("P", "Phone"); > public static final ContactMethodType MAIL =3D new ContactMethodType(= "M", "Mail"); > public static final ContactMethodType UNKNOWN =3D new ContactMethodTy= pe("U", "Unknown"); > /** > * Creates a new ContactMethodType object. > * > * @param intValue param > * @param displayString param > */ > private ContactMethodType(String value, String displayString) { > super(value, displayString); > } > } > import com.foo.to.AbstractTypeSafeEnumeration > public class GenderType extends AbstractTypeSafeEnumeration { > public static final GenderType FEMALE =3D new GenderType("F", "Female= "); > public static final GenderType MALE =3D new GenderType("M", "Male"); > public static final GenderType UNKNOWN =3D new GenderType("U", "Unkno= wn"); > /** > * Creates a new GenderType object. > * > * @param intValue param > * @param displayString param > */ > private GenderType(String value, String displayString) { > super(value, displayString); > } > } > This is what we would like to see: > Global Type Handler: > <typeHandler javaType=3D"com.foo.to.AbstractTypeSafeEnumeration" callback= =3D"com.foo.dao.datahandler.AbstractTypeSafeEnumerationTypeHandler"/> > Specific Result Map for ContactTO: > <resultMap id=3D"loadContact" class=3D"com.foo.to.ContactTO"> > <result property=3D"gender" column=3D"GENDER" jdbcType=3D"VARCHAR" ja= vaType=3D"com.foo.to.GenderType"/> > <result property=3D"contactMethod" column=3D"METHOD" jdbcType=3D"VARC= HAR" javaType=3D"com.foo.to.ContactMethodType"/> =20 > </resultMap> > Sample of a pseudo NewTypeHandler that has access to javaType: > public class AbstractTypeSafeEnumerationTypeHandler implements NewTypeHan= dler { > /** > * This method overrides the default setParameter method in TypeHandl= er. > *=20 > * @param ps param > * @param i param > * @param parameter param > * @param jdbcType param > * > * @throws SQLException can be thrown > */ > public void setParameter(PreparedStatement ps, int i, Object paramete= r, String jdbcType) > throws SQLException { =20 > if(parameter =3D=3D null) { > JdbcType type =3D (JdbcType)JdbcType.getTypeByDisplayValue(jd= bcType, JdbcType.class); > int sqlType =3D Integer.parseInt(type.getValue()); > ps.setNull(i, sqlType); > } > else { > AbstractTypeSafeEnumeration enum =3D (AbstractTypeSafeEnumera= tion)parameter; > ps.setString(i, enum.getValue()); > } > } > private AbstractTypeSafeEnumeration getEnum(String value, String java= Type) { > Class clazz =3D null; > try { > clazz =3D Class.forName(javaType); > } > catch (ClassNotFoundException e) { > throw new RuntimeException("Invalid javaType - This class doe= s not exist: -> " + javaType, e);=20 > } > return AbstractTypeSafeEnumeration.getTypeByValue(value, clazz); > } > =20 > /** > * This method overrides the default getResult method in TypeHandler. > *=20 > * @param rs param > * @param columnName param > * > * @return returned > * > * @throws SQLException can be thrown > */ > public Object getResult(ResultSet rs, String columnName, String javaT= ype) > throws SQLException { > String result =3D rs.getString(columnName); > return this.getEnum(result, javaType); > } > /** > * This method overrides the default getResult method in TypeHandler. > *=20 > * @param rs param > * @param columnIndex param > * > * @return returned > * > * @throws SQLException can be thrown > */ > public Object getResult(ResultSet rs, int columnIndex, String javaTyp= e) > throws SQLException { > String result =3D rs.getString(columnIndex); > return this.getEnum(result, javaType); > } > /** > * This method overrides the default getResult method in TypeHandler. > *=20 > * @param cs param > * @param columnIndex param > * > * @return returned > * > * @throws SQLException can be thrown > */ > public Object getResult(CallableStatement cs, int columnIndex, String= javaType) > throws SQLException { > String result =3D cs.getString(columnIndex); > return this.getEnum(result, javaType); > } > /** > * This method overrides the default equals method in TypeHandler. > *=20 > * @param object param > * @param dbVal param > * > * @return returned > */ > public boolean equals(Object object, String dbVal) { > return StringHelper.equals(((AbstractTypeSafeEnumeration)object).= getValue(), dbVal); > } > /** > * This method overrides the default valueOf method in TypeHandler. > *=20 > * @param dbVal param > * > * @return returned > */ > public Object valueOf(String dbVal) { > return dbVal; > } > } > =20 --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Wed Apr 04 18:45:53 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 14522 invoked from network); 4 Apr 2007 18:45:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 4 Apr 2007 18:45:53 -0000 Received: (qmail 64816 invoked by uid 500); 4 Apr 2007 18:46:00 -0000 Delivered-To: josephsmith@example.net Received: (qmail 64802 invoked by uid 500); 4 Apr 2007 18:46:00 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 64769 invoked by uid 99); 4 Apr 2007 18:46:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 11:46:00 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 11:45:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 61505714068 for <josephsmith@example.net>; Wed, 4 Apr 2007 11:45:32 -0700 (PDT) Message-ID: <3861325.1175712332394.JavaMail.jira@brutus> Date: Wed, 4 Apr 2007 11:45:32 -0700 (PDT) From: "Tony Ugando (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Created: (IBATIS-415) Obey column order in resultMap MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Obey column order in resultMap ------------------------------ Key: IBATIS-415 URL: https://issues.apache.org/jira/browse/IBATIS-415 Project: iBatis for Java Issue Type: New Feature Components: SQL Maps Affects Versions: 2.3.1 Reporter: Tony Ugando It will be extremely beneficial if iBatis could lookup column names in a resultSet, in the exact same order they are found in the resultMap. This would allow users to maintain joins much easier, specifically for tables with a lot of columns. Maybe an attribute can be added to the resultMap tag, named obeyColumnOrder="true/false". When setting this attribute to true, then the columns will be read in the exact same order that they are found in the resultMap, and any nested or inherited result maps as well. Currently, it is truly a nightmare when dealing with joined tables that have conflicting column names. You either need to define an alias for each column name, in each table, which is extremely tedious, or you need to use the columnIndex attribute in the result tag. The columnIndex solution is also very tedious to maintain, and it requires you to create multiple resultMaps for each table that you are modeling. eq. select TBL_1.*, TBL_2.* from TBL_1 left outer join TBL_2 on TBL_1.SEQ = TBL_2.FK_SEQ is much easier to maintain than... select TBL_1.SEQ, TBL_1.COL,..., TBL_2.SEQ, TBL_2.COL,... from TBL_1 left outer join TBL_2 on TBL_1.SEQ = TBL_2.FK_SEQ -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Thu Apr 05 01:03:54 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 64420 invoked from network); 5 Apr 2007 01:03:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2007 01:03:54 -0000 Received: (qmail 55516 invoked by uid 500); 5 Apr 2007 01:04:01 -0000 Delivered-To: josephsmith@example.net Received: (qmail 55357 invoked by uid 500); 5 Apr 2007 01:04:00 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 55346 invoked by uid 99); 5 Apr 2007 01:04:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 18:04:00 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Apr 2007 18:03:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 5C77B714068 for <josephsmith@example.net>; Wed, 4 Apr 2007 18:03:32 -0700 (PDT) Message-ID: <12725465.1175735012372.JavaMail.jira@brutus> Date: Wed, 4 Apr 2007 18:03:32 -0700 (PDT) From: "Jeff Butler (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Closed: (IBATIS-415) Obey column order in resultMap In-Reply-To: <3861325.1175712332394.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATIS-415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeff Butler closed IBATIS-415. ------------------------------ Resolution: Invalid iBATIS already retrieves columns in the order they are specified in a result map. As for the issue you raise, there is nothing iBATIS can do. The JDBC specification explicitly states that if multiple columns have the same name in a result set, then only the first one will be returned when getting by column name. The only way to ensure that you'll get the proper columns is to use a column index or to rename the columns so that they are unique. Sorry for the hassle, but blame JDBC - not us :) > Obey column order in resultMap > ------------------------------ > > Key: IBATIS-415 > URL: https://issues.apache.org/jira/browse/IBATIS-415 > Project: iBatis for Java > Issue Type: New Feature > Components: SQL Maps > Affects Versions: 2.3.1 > Reporter: Tony Ugando > > It will be extremely beneficial if iBatis could lookup column names in a resultSet, in the exact same order they are found in the resultMap. This would allow users to maintain joins much easier, specifically for tables with a lot of columns. Maybe an attribute can be added to the resultMap tag, named obeyColumnOrder="true/false". When setting this attribute to true, then the columns will be read in the exact same order that they are found in the resultMap, and any nested or inherited result maps as well. > Currently, it is truly a nightmare when dealing with joined tables that have conflicting column names. You either need to define an alias for each column name, in each table, which is extremely tedious, or you need to use the columnIndex attribute in the result tag. The columnIndex solution is also very tedious to maintain, and it requires you to create multiple resultMaps for each table that you are modeling. > eq. > select > TBL_1.*, TBL_2.* > from TBL_1 > left outer join TBL_2 > on TBL_1.SEQ = TBL_2.FK_SEQ > is much easier to maintain than... > select > TBL_1.SEQ, TBL_1.COL,..., > TBL_2.SEQ, TBL_2.COL,... > from TBL_1 > left outer join TBL_2 > on TBL_1.SEQ = TBL_2.FK_SEQ -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Thu Apr 05 14:14:04 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 23397 invoked from network); 5 Apr 2007 14:14:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2007 14:14:01 -0000 Received: (qmail 48210 invoked by uid 500); 5 Apr 2007 14:14:02 -0000 Delivered-To: josephsmith@example.net Received: (qmail 48124 invoked by uid 500); 5 Apr 2007 14:14:02 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 48072 invoked by uid 99); 5 Apr 2007 14:14:01 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 07:14:01 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 07:13:53 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 7CAE6714065 for <josephsmith@example.net>; Thu, 5 Apr 2007 07:13:32 -0700 (PDT) Message-ID: <26684549.1175782412504.JavaMail.jira@brutus> Date: Thu, 5 Apr 2007 07:13:32 -0700 (PDT) From: "David Smiley (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Created: (IBATIS-416) Ability to build SqlMapClient programmatically without SqlMapConfig.xml file MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Ability to build SqlMapClient programmatically without SqlMapConfig.xml file ---------------------------------------------------------------------------- Key: IBATIS-416 URL: https://issues.apache.org/jira/browse/IBATIS-416 Project: iBatis for Java Issue Type: Improvement Affects Versions: 2.3.0 Reporter: David Smiley Priority: Minor I've looked over Spring's support for iBatis and I observed that I am required to have the SqlMapConfig.xml file. It'd be nice if SqlMapClientImpl and/or SqlMapExecutorDelegate had javabean get/set properties so that this could be programatically constructed (particularly via Spring), thus not requiring the SqlMapConfig.xml file. At first inspection, it would seem that the delegate class is already good for this purpose because it has quite a few get/sets, but then I look at your SqlMapConfigParser class and see the special way that, for example, defaultStatementTimeout is handled, is not workable for external programatic configuration. That's just one example. In order to enhance Spring to not need this xml file, it'll need to dynamically generate it in-memory to hand it to the builder. Clearly a hack. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Thu Apr 05 15:18:01 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 61796 invoked from network); 5 Apr 2007 15:17:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 5 Apr 2007 15:17:59 -0000 Received: (qmail 6451 invoked by uid 500); 5 Apr 2007 15:18:00 -0000 Delivered-To: josephsmith@example.net Received: (qmail 6426 invoked by uid 500); 5 Apr 2007 15:18:00 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 6390 invoked by uid 99); 5 Apr 2007 15:18:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 08:18:00 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 08:17:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 64F0D714048 for <josephsmith@example.net>; Thu, 5 Apr 2007 08:17:32 -0700 (PDT) Message-ID: <12665069.1175786252366.JavaMail.jira@brutus> Date: Thu, 5 Apr 2007 08:17:32 -0700 (PDT) From: "David Smiley (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Commented: (IBATIS-416) Ability to build SqlMapClient programmatically without SqlMapConfig.xml file In-Reply-To: <26684549.1175782412504.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATIS-416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487003 ] David Smiley commented on IBATIS-416: ------------------------------------- FYI: a conversation with the Spring - iBatis integration developer on their mailing list about this: http://www.nabble.com/iBatis%2C-inline-SqlMapConfig-configuration--tf3529186.html#a9856796 > Ability to build SqlMapClient programmatically without SqlMapConfig.xml file > ---------------------------------------------------------------------------- > > Key: IBATIS-416 > URL: https://issues.apache.org/jira/browse/IBATIS-416 > Project: iBatis for Java > Issue Type: Improvement > Affects Versions: 2.3.0 > Reporter: David Smiley > Priority: Minor > > I've looked over Spring's support for iBatis and I observed that I am required to have the SqlMapConfig.xml file. It'd be nice if SqlMapClientImpl and/or SqlMapExecutorDelegate had javabean get/set properties so that this could be programatically constructed (particularly via Spring), thus not requiring the SqlMapConfig.xml file. At first inspection, it would seem that the delegate class is already good for this purpose because it has quite a few get/sets, but then I look at your SqlMapConfigParser class and see the special way that, for example, defaultStatementTimeout is handled, is not workable for external programatic configuration. That's just one example. In order to enhance Spring to not need this xml file, it'll need to dynamically generate it in-memory to hand it to the builder. Clearly a hack. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Fri Apr 06 00:49:57 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 1846 invoked from network); 6 Apr 2007 00:49:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Apr 2007 00:49:55 -0000 Received: (qmail 25376 invoked by uid 500); 6 Apr 2007 00:50:00 -0000 Delivered-To: josephsmith@example.net Received: (qmail 25256 invoked by uid 500); 6 Apr 2007 00:50:00 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 25242 invoked by uid 99); 6 Apr 2007 00:50:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 17:50:00 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 17:49:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 6911A714065 for <josephsmith@example.net>; Thu, 5 Apr 2007 17:49:32 -0700 (PDT) Message-ID: <30191519.1175820572427.JavaMail.jira@brutus> Date: Thu, 5 Apr 2007 17:49:32 -0700 (PDT) From: "Frank Wang (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Created: (IBATIS-417) Abator (or any other plug-in): ability to search for Java references in sqlMap XML files MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Abator (or any other plug-in): ability to search for Java references in sqlMap XML files ----------------------------------------------------------------------------------------- Key: IBATIS-417 URL: https://issues.apache.org/jira/browse/IBATIS-417 Project: iBatis for Java Issue Type: New Feature Components: Tools Environment: all Reporter: Frank Wang Priority: Minor For Abator (or any other Eclipse plug-in for iBATIS), it would be nice to be able to search for class and method references in the iBATIS sqlMap XML files. For example, in the Java editor, when I right-click on a class or method name and select "Search > References", any and all configurations within the sqlMap's that instantiates objects of that class or calls a method on a bean of that class would be included/shown in the "Search" View. This would make development so much faster! -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Fri Apr 06 03:31:46 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 47614 invoked from network); 6 Apr 2007 03:31:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Apr 2007 03:31:46 -0000 Received: (qmail 6108 invoked by uid 500); 6 Apr 2007 03:31:53 -0000 Delivered-To: josephsmith@example.net Received: (qmail 5956 invoked by uid 500); 6 Apr 2007 03:31:52 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 5945 invoked by uid 99); 6 Apr 2007 03:31:52 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 20:31:52 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of josephsmith@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO ug-out-1314.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2007 20:31:43 -0700 Received: by ug-out-1314.google.com with SMTP id m2so1146648ugc for <josephsmith@example.net>; Thu, 05 Apr 2007 20:31:22 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=Ut5cLEnADBz5JaFVyAFCCbednV/umASA34yvFzL4YUYcjBw2jBVbubJkcVQ4zGzDm9WOvR63Zm/rVS4ro29OBzie9bwv/k+ws6Rnzua6Dsj1nbbuO4XmGvdBr7UxBCjVYMqW6dRB8zeJ0mAWbk50n2M1R6/PVnbhlyZlH7az5pk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=PeY8wNP4KopwFOfoGvDWZGsIFdvOVFN/6gt2Gyl3rMHU9QAqUDtwaDSst+x9ht9G53gpbrkWN9m7P9uhbk78U53xdSxXyLW6aJB07O0V9BwddqfUzz0n0e3qDCWt3ehVTWYe0DLQ4MdAQ3kNPQwiMHxe8NXqYGT1l1jhcGgTZpI= Received: by 83.161.120.155 with SMTP id w15mr461416hud.1175830282605; Thu, 05 Apr 2007 20:31:22 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Thu, 5 Apr 2007 20:31:22 -0700 (PDT) Message-ID: <josephsmith@example.net> Date: Fri, 6 Apr 2007 05:31:22 +0200 From: "Gilles Bayon" <josephsmith@example.net> To: josephsmith@example.net, josephsmith@example.net, josephsmith@example.net Subject: [VOTE SUCCEEDED] Promote iBATIS.NET DataMapper 1.6.1 and DataAccess 1.9.1 to General Availability MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1705_3312920.1175830282559" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_1705_3312920.1175830282559 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline iBATIS.NET DataMapper 1.6.1 and DataAccess 1.9.1 has been successfully promoted to General Availability Binding Gilles +1 Ted +1 Ron +1 The site will be updated to reflect this vote. --- Cheers, Gilles ------=_Part_1705_3312920.1175830282559 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <p><a href="http://iBATIS.NET">iBATIS.NET</a> DataMapper 1.6.1 and DataAccess 1.9.1 has been successfully promoted to General Availability</p> <p>Binding<br>Gilles +1<br>Ted +1<br>Ron +1</p> <div>The site will be updated to reflect this vote.</div> <div>&nbsp;</div> <div>---<br>Cheers,<br>Gilles</div> ------=_Part_1705_3312920.1175830282559-- From josephsmith@example.net Fri Apr 06 13:24:11 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 84611 invoked from network); 6 Apr 2007 13:23:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 6 Apr 2007 13:23:54 -0000 Received: (qmail 95647 invoked by uid 500); 6 Apr 2007 13:24:00 -0000 Delivered-To: josephsmith@example.net Received: (qmail 95625 invoked by uid 500); 6 Apr 2007 13:24:00 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 95603 invoked by uid 99); 6 Apr 2007 13:24:00 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Apr 2007 06:24:00 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Apr 2007 06:23:52 -0700 Received: from brutus (localhost [83.161.120.155]) by brutus.apache.org (Postfix) with ESMTP id 88332714066 for <josephsmith@example.net>; Fri, 6 Apr 2007 06:23:32 -0700 (PDT) Message-ID: <3739570.1175865812554.JavaMail.jira@brutus> Date: Fri, 6 Apr 2007 06:23:32 -0700 (PDT) From: "Jeff Butler (JIRA)" <josephsmith@example.net> To: josephsmith@example.net Subject: [jira] Closed: (IBATIS-417) Abator (or any other plug-in): ability to search for Java references in sqlMap XML files In-Reply-To: <30191519.1175820572427.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/IBATIS-417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeff Butler closed IBATIS-417. ------------------------------ Resolution: Won't Fix I agree this would be a nice feature but it is far outside the scope of what we are trying to accomplish with Abator. This would be a good exercise for a budding Eclipse plug-in writer ... (hint, hint) > Abator (or any other plug-in): ability to search for Java references in sqlMap XML files > ----------------------------------------------------------------------------------------- > > Key: IBATIS-417 > URL: https://issues.apache.org/jira/browse/IBATIS-417 > Project: iBatis for Java > Issue Type: New Feature > Components: Tools > Environment: all > Reporter: Frank Wang > Priority: Minor > > For Abator (or any other Eclipse plug-in for iBATIS), it would be nice to be able to search for class and method references in the iBATIS sqlMap XML files. > For example, in the Java editor, when I right-click on a class or method name and select "Search > References", any and all configurations within the sqlMap's that instantiates objects of that class or calls a method on a bean of that class would be included/shown in the "Search" View. > This would make development so much faster! -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. From josephsmith@example.net Mon Apr 09 07:03:38 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 90677 invoked from network); 9 Apr 2007 07:03:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 9 Apr 2007 07:03:38 -0000 Received: (qmail 49856 invoked by uid 500); 9 Apr 2007 07:03:44 -0000 Delivered-To: josephsmith@example.net Received: (qmail 49834 invoked by uid 500); 9 Apr 2007 07:03:44 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 49823 invoked by uid 99); 9 Apr 2007 07:03:44 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Apr 2007 00:03:44 -0700 X-ASF-Spam-Status: No, hits=4.1 required=10.0 tests=DATE_IN_FUTURE_24_48,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy includes SPF josephsmith@example.net) Received: from [83.161.120.155] (HELO smtp102.biz.mail.re2.yahoo.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 09 Apr 2007 00:03:36 -0700 Received: (qmail 37377 invoked from network); 9 Apr 2007 07:03:14 -0000 Received: from unknown (HELO kavya) (josephsmith@example.net@83.161.120.155 with login) by smtp102.biz.mail.re2.yahoo.com with SMTP; 9 Apr 2007 07:03:14 -0000 X-YMail-OSG: GjPlqH8VM1kyqVpxpz9YBWkhuxqy1y.vNTmSFrDXp2PysE3zASrlSqRc_T5M6hwU_grn5UHhAF1Qy4JtHzU.yka5RnQZu3IPBvzCek43ouqAE9GYj8cZOfznR7y_JYWD07tRA8Sd_e3x3A-- Message-ID: <001201c77b3f$3a490ad0$150aa8c0@kavya> Reply-To: "prakash" <josephsmith@example.net> From: "prakash" <josephsmith@example.net> To: <josephsmith@example.net> Subject: Dynamic Group by cluase in ibatic Date: Tue, 10 Apr 2007 12:39:45 +0530 Organization: Enventure Technologies MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000F_01C77B6D.51CC3E60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C77B6D.51CC3E60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable i have problem, please help, i need to give dynamic group by clauses in my query. If i specify = <dynamic prepend=3D"Group by"> in my xml file, i am not getting the = correct output, What should i do for specifiying dynamic group by = clauses in select query. Please reply with example. thanks and regards prakash ------=_NextPart_000_000F_01C77B6D.51CC3E60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>i have problem, please = help,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>i need to give dynamic group by clauses = in my=20 query. If i specify &lt;dynamic prepend=3D"Group by"&gt; in my xml file, = i am not=20 getting the correct output, What should i do for specifiying dynamic = group by=20 clauses in select query. Please reply with example.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>thanks and regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>prakash</FONT></DIV></BODY></HTML> ------=_NextPart_000_000F_01C77B6D.51CC3E60-- From josephsmith@example.net Mon Apr 09 19:13:14 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 6420 invoked from network); 9 Apr 2007 19:13:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 9 Apr 2007 19:13:14 -0000 Received: (qmail 31595 invoked by uid 500); 9 Apr 2007 19:13:20 -0000 Delivered-To: josephsmith@example.net Received: (qmail 31443 invoked by uid 500); 9 Apr 2007 19:13:20 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 31432 invoked by uid 99); 9 Apr 2007 19:13:19 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Apr 2007 12:13:19 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of josephsmith@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO nz-out-0506.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Apr 2007 12:13:13 -0700 Received: by nz-out-0506.google.com with SMTP id q3so1213438nzb for <josephsmith@example.net>; Mon, 09 Apr 2007 12:12:52 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=h3tF73tcd1BTOrg1fDo6+AenNbzo71E0iH2/NjGM8U54UMLXvEO1FprxXxl2t4JWNu/rd6yQR5myTL9IwXRhEv3pVh5lhTN238GzYTYaGcJt/mHcbNFSsrnYsrDoETWKWGB+CNtocYhoNlw1g88EkRuIbtMGnQiqWiZ3ZXapcbM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=unH9IXeUG/cdTa9mrBXi/7i4Ycmp+JoomuAjLDffxNA3/z9GJqdQg+gHe+Yc7ZbFE6OAlY+HnnEudHwK5nV2VzdbwjKxGHhtzxm7SyR8EtI8PdXP0X8zDoblTbtk01IwQycdWPqNthU2LDWz8G25VUecjhlOc4ah/4/qVd7rVwQ= Received: by 83.161.120.155 with SMTP id z15mr2472331waf.1176145971861; Mon, 09 Apr 2007 12:12:51 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Mon, 9 Apr 2007 12:12:51 -0700 (PDT) Message-ID: <josephsmith@example.net> Date: Mon, 9 Apr 2007 14:12:51 -0500 From: "Jeff Butler" <josephsmith@example.net> To: josephsmith@example.net, prakash <josephsmith@example.net> Subject: Re: Dynamic Group by cluase in ibatic In-Reply-To: <001201c77b3f$3a490ad0$150aa8c0@kavya> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9450_10961565.1176145971700" References: <001201c77b3f$3a490ad0$150aa8c0@kavya> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_9450_10961565.1176145971700 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Please post these types of questions to the user list. The dev list is for questions related to the development of iBATIS itself. Also, you'll get more help of you post an example of what you're trying to do. Then someone will be able to help you debug. Jeff Butler On 4/10/07, prakash <josephsmith@example.net> wrote: > > i have problem, please help, > > i need to give dynamic group by clauses in my query. If i specify <dynamic > prepend="Group by"> in my xml file, i am not getting the correct output, > What should i do for specifiying dynamic group by clauses in select query. > Please reply with example. > > thanks and regards > prakash > ------=_Part_9450_10961565.1176145971700 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline <div>Please post these types of questions to the user list.&nbsp; The dev list is for questions related to the development of iBATIS itself.</div> <div>&nbsp;</div> <div>Also, you&#39;ll get more help of you post an example of what you&#39;re trying to do.&nbsp; Then someone will be able to help you debug.</div> <div>&nbsp;</div> <div>Jeff Butler<br><br>&nbsp;</div> <div><span class="gmail_quote">On 4/10/07, <b class="gmail_sendername">prakash</b> &lt;<a href="mailto:josephsmith@example.net">josephsmith@example.net</a>&gt; wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"> <div bgcolor="#ffffff"> <div><font face="Arial" size="2">i have problem, please help,</font></div> <div><font face="Arial" size="2"></font>&nbsp;</div> <div><font face="Arial" size="2">i need to give dynamic group by clauses in my query. If i specify &lt;dynamic prepend=&quot;Group by&quot;&gt; in my xml file, i am not getting the correct output, What should i do for specifiying dynamic group by clauses in select query. Please reply with example. </font></div> <div><font face="Arial" size="2"></font>&nbsp;</div> <div><font face="Arial" size="2">thanks and regards</font></div> <div><font face="Arial" size="2">prakash</font></div></div></blockquote></div><br> ------=_Part_9450_10961565.1176145971700-- From josephsmith@example.net Tue Apr 10 14:27:10 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 78228 invoked from network); 10 Apr 2007 14:27:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 10 Apr 2007 14:27:07 -0000 Received: (qmail 32570 invoked by uid 500); 10 Apr 2007 14:27:13 -0000 Delivered-To: josephsmith@example.net Received: (qmail 32551 invoked by uid 500); 10 Apr 2007 14:27:13 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 32540 invoked by uid 99); 10 Apr 2007 14:27:12 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2007 07:27:12 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of josephsmith@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO pandore.ircm.qc.ca) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2007 07:27:03 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C77B7C.431D42DB" Subject: Confluence problem Date: Tue, 10 Apr 2007 10:26:43 -0400 Message-ID: <josephsmith@example.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Confluence problem Thread-Index: Acd7fEMbTfs5l42DRnKnQvwUXx4NkQ== From: "Poitras Christian" <josephsmith@example.net> To: "Developpement" <josephsmith@example.net> X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C77B7C.431D42DB Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When it tried to edit my page for lazy loading problems, I had to face = this message. =20 This Confluence installation is not licensed for additional users You have exceeded the maximum number of users for your license. You will = still be able to view content, but in order to create or edit content, = you must reduce the number of active users in the installation.=20 There are three ways to reduce the number of active users:=20 * Delete users * Remove the "can use" permission from users To delete users, visit the Manage Users = <http://opensource.atlassian.com/confluence/oss/admin/users/browseusers.a= ction> page.=20 To modify the global permissions, visit the Global Permissions = <http://opensource.atlassian.com/confluence/oss/admin/permissions/globalp= ermissions.action> page.=20 =20 =20 Is it possible to correct this problem? I can't update the page with the code sniplet... =20 http://opensource.atlassian.com/confluence/oss/display/IBATIS/Lazy+loadin= g+issues =20 Christian Poitras Institut de recherches cliniques de Montr=E9al (IRCM) josephsmith@example.net =20 ------_=_NextPart_001_01C77B7C.431D42DB Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR></HEAD> <BODY> <DIV><FONT face=3DArial size=3D2><SPAN class=3D366572414-10042007>When = it tried=20 to&nbsp;edit my page for lazy loading problems, I had to face this=20 message.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D366572414-10042007></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D366572414-10042007> <CENTER> <DIV class=3Dgreybox=20 style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; BACKGROUND: = rgb(240,240,240) 0% 50%; PADDING-BOTTOM: 10px; WIDTH: 60%; PADDING-TOP: = 10px; TEXT-ALIGN: left; -moz-background-clip: -moz-initial; = -moz-background-origin: -moz-initial; -moz-background-inline-policy: = -moz-initial"> <H4 style=3D"MARGIN: 3px 0pt">This Confluence installation is not = licensed for=20 additional users</H4>You have exceeded the maximum number of users for = your=20 license. You will still be able to view content, but in order to create = or edit=20 content, you must reduce the number of active users in the installation. = <P>There are three ways to reduce the number of active users: </P> <P></P> <UL> <LI>Delete users</LI> <LI>Remove the "can use" permission from users</LI></UL> <P>To delete users, visit the <A title=3D"Manage Users"=20 href=3D"http://opensource.atlassian.com/confluence/oss/admin/users/browse= users.action">Manage=20 Users</A> page. </P> <P>To modify the global permissions, visit the <A title=3D"Global = Permissions"=20 href=3D"http://opensource.atlassian.com/confluence/oss/admin/permissions/= globalpermissions.action">Global=20 Permissions</A> page. </P></DIV></CENTER></SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D366572414-10042007>Is it = possible to=20 correct this problem?</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D366572414-10042007>I = can't update the=20 page with the code sniplet...</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2><A=20 href=3D"http://opensource.atlassian.com/confluence/oss/display/IBATIS/Laz= y+loading+issues">http://opensource.atlassian.com/confluence/oss/display/= IBATIS/Lazy+loading+issues</A></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV align=3Dleft><FONT face=3DArial size=3D2>Christian = Poitras</FONT></DIV> <DIV align=3Dleft><SPAN class=3Dtexte><SPAN class=3Dsous-titre>Institut = de recherches=20 cliniques de Montr=E9al (IRCM)</SPAN></SPAN></DIV> <DIV align=3Dleft><SPAN class=3Dtexte><SPAN=20 class=3Dsous-titre>josephsmith@example.net</SPAN></SPAN></DIV> <DIV>&nbsp;</DIV></BODY></HTML> ------_=_NextPart_001_01C77B7C.431D42DB-- From josephsmith@example.net Tue Apr 10 14:55:02 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 6991 invoked from network); 10 Apr 2007 14:54:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 10 Apr 2007 14:54:57 -0000 Received: (qmail 99723 invoked by uid 500); 10 Apr 2007 14:55:01 -0000 Delivered-To: josephsmith@example.net Received: (qmail 99693 invoked by uid 500); 10 Apr 2007 14:55:01 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 99650 invoked by uid 99); 10 Apr 2007 14:55:01 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2007 07:55:01 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of josephsmith@example.net designates 83.161.120.155 as permitted sender) Received: from [83.161.120.155] (HELO wx-out-0506.google.com) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2007 07:54:53 -0700 Received: by wx-out-0506.google.com with SMTP id t14so1730656wxc for <josephsmith@example.net>; Tue, 10 Apr 2007 07:54:32 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=L95LfYdI5nzyTkswYQKLgnRT15bk+7jk65o0K16VSzaol0p3OlVHRdsu92sYmTVpTnWjCS3d7OpEhImC9m3LZLoHtNCeTDMcbE++E/C7iJ+lExAgmuBqW2mtdNK3DmsIdh9CBdpRZU5op53xYaACOUNy08YnAYl97P8K5YDyQ1M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=CZgRmMpIhs+0yaPECPk/GK9KHyygtwkvgCE6GX6eC5fZBP42k+CrGLCQ1aDpQTdEwHd4pZ5ILMGonlLPo4pA2u8x/xlvLLDhaVr6OmlXRpz25as0v01ZlNS6X9lal87P5eWhltLiLH5IzduRjY9cDIApSmnlHnYnA3iF0GlYM/g= Received: by 83.161.120.155 with SMTP id l6mr1094321hud.1176216871324; Tue, 10 Apr 2007 07:54:31 -0700 (PDT) Received: by 83.161.120.155 with HTTP; Tue, 10 Apr 2007 07:54:31 -0700 (PDT) Message-ID: <josephsmith@example.net> Date: Tue, 10 Apr 2007 08:54:31 -0600 From: "Larry Meadors" <josephsmith@example.net> Reply-To: josephsmith@example.net Sender: josephsmith@example.net To: josephsmith@example.net Subject: Re: Confluence problem In-Reply-To: <josephsmith@example.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <josephsmith@example.net> X-Google-Sender-Auth: 91a4b2130f446f33 X-Virus-Checked: Checked by ClamAV on apache.org :-/ That happened a few weeks ago, too..i thought it was fixed, but apparently = not. I'll look into it. Larry On 4/10/07, Poitras Christian <josephsmith@example.net> wrote: > > > When it tried to edit my page for lazy loading problems, I had to face th= is > message. > > > > This Confluence installation is not licensed for additional usersYou have > exceeded the maximum number of users for your license. You will still be > able to view content, but in order to create or edit content, you must > reduce the number of active users in the installation. > > There are three ways to reduce the number of active users: > > > > Delete users > Remove the "can use" permission from users > > To delete users, visit the Manage Users page. > > To modify the global permissions, visit the Global Permissions page. > > > Is it possible to correct this problem? > I can't update the page with the code sniplet... > > http://opensource.atlassian.com/confluence/oss/display/IBATIS/Lazy+loadin= g+issues > > Christian Poitras > Institut de recherches cliniques de Montr=E9al (IRCM) > josephsmith@example.net > From josephsmith@example.net Tue Apr 10 22:25:48 2007 Return-Path: <josephsmith@example.net> Delivered-To: josephsmith@example.net Received: (qmail 54556 invoked from network); 10 Apr 2007 22:25:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155) by minotaur.apache.org with SMTP; 10 Apr 2007 22:25:48 -0000 Received: (qmail 52674 invoked by uid 500); 10 Apr 2007 22:25:54 -0000 Delivered-To: josephsmith@example.net Received: (qmail 52656 invoked by uid 500); 10 Apr 2007 22:25:54 -0000 Mailing-List: contact josephsmith@example.net; run by ezmlm Precedence: bulk List-Help: <mailto:josephsmith@example.net> List-Unsubscribe: <mailto:josephsmith@example.net> List-Post: <mailto:josephsmith@example.net> List-Id: <dev.ibatis.apache.org> Reply-To: josephsmith@example.net Delivered-To: mailing list josephsmith@example.net Received: (qmail 52645 invoked by uid 99); 10 Apr 2007 22:25:54 -0000 Received: from herse.apache.org (HELO herse.apache.org) (83.161.120.155) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Apr 2007 15:25:54 -0700 X-ASF-Spam-Status: No,
{'source': 'Apache Software Foundation Public Mail Archives'}