Re: update without set element

2010-01-20 Thread Larry Meadors
Do this in Java code. Doing it in xml is kinda silly. :) Larry On Wed, Jan 20, 2010 at 12:00 AM, masonka...@libero.it wrote: > Hi, > > I have a write a update statement with condition on every set element. > If > no condition are matched set part are empty, but where part is

update without set element

2010-01-19 Thread masonka...@libero.it
Hi, I have a write a update statement with condition on every set element. If no condition are matched set part are empty, but where part is already created and this cause a sql error (ex.: update where id=4). I show an example about it: update iord

problems with collection element

2009-09-08 Thread araoko
i have a problem with the collection element, i cant get it to populate ArraList properties on my POJO. i can instantiate the pojo using the constructor element but the collection element did not work. the mapper configuration xml is below, and folowing it is my POJO select a.name as

Re: iBATOR does not generate without optional an element

2009-08-20 Thread Jeff Butler
hout in any way it is impossible. > > Alexander > -- > View this message in context: > http://www.nabble.com/iBATOR-does-not-generate-without-optional-an-element-%3CdaoGenerator%3E-tp25057307p25057835.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >

Re: iBATOR does not generate without optional an element

2009-08-20 Thread bhaa
context: http://www.nabble.com/iBATOR-does-not-generate-without-optional-an-element-%3CdaoGenerator%3E-tp25057307p25057835.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. - To unsubsc

Re: iBATOR does not generate without optional an element

2009-08-20 Thread Alexis Pigeon
Hi Alexander 2009/8/20 bhaa > > Hi, > > In element, child element is optional. > Why if to do Generate iBATIS Artifacts without this element, there is an > exception: > [snip] When this child element is present in element > , generation is successful. > >

iBATOR does not generate without optional an element

2009-08-20 Thread bhaa
Hi, In element, child element is optional. Why if to do Generate iBATIS Artifacts without this element, there is an exception: Reason: Unexpected error while running iBator. java.lang.NullPointerExeption Here a file ibatorConfig.xml: http://ibatis.apache.org/dtd/ibator-config_1_0.dtd

Re: ibator - generate all tables for a schema w/out defining element for each table

2009-04-22 Thread javaguy44
've been a happy ibatis, abator, ibator user for a little while now, but >> there is one feature missing that I think would make my life a lot >> easier...and possibly others. Is there a way to generate all tables for >> a >> schema w/out specifying element in ibator conf

Re: iBator generatedKey Element usage with a stored procedure

2009-04-06 Thread Jeff Butler
't used it in a while.  I can > use iBator in my current project, but only if there is a way to use the > generatedKey element (a sub-element of Table) to invoke a stored procedure > that takes as input the tablename and the number of unique keys desired > (that would be always 1),

iBator generatedKey Element usage with a stored procedure

2009-04-06 Thread robertgloverjr
  Hi everybody.  I'm a big iBator fan but haven't used it in a while.  I can use iBator in my current project, but only if there is a way to use the generatedKey element (a sub-element of Table) to invoke a stored procedure that takes as input the tablename and the number of unique ke

Re: ibator - generate all tables for a schema w/out defining element for each table

2009-02-02 Thread Jeff Butler
a lot > easier...and possibly others. Is there a way to generate all tables for a > schema w/out specifying element in ibator config.xml? > > My current workflow when doing DDL changes is as follows: > 1. use GUI datamodeling tool to define / modify columns etc. > 2. actually c

ibator - generate all tables for a schema w/out defining element for each table

2009-02-02 Thread javaguy44
Hi, I've been a happy ibatis, abator, ibator user for a little while now, but there is one feature missing that I think would make my life a lot easier...and possibly others. Is there a way to generate all tables for a schema w/out specifying element in ibator config.xml? My current wor

Re: "resultMap" must be declared for element type "parameter".

2009-01-04 Thread Roger Voss
td/sql-map-2.dtd";> > > > If any solution on that will appreciate. > I gone threw so many places in google but it seems no one has solutions. > > Thanks > -- > View this message in context: > http://www.nabble.com/%22resultMap%22-must-be-declared-for-element-type-%22parameter%22.-tp21204286p21204286.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >

Re: "resultMap" must be declared for element type "parameter".

2009-01-04 Thread joson yu
hi,all. i have some other questions. i need to get the sql witch had executed to develop a log manager system.for ibatis,is there anyway to get it? 3ks!

"resultMap" must be declared for element type "parameter".

2008-12-29 Thread DH12
laces in google but it seems no one has solutions. Thanks -- View this message in context: http://www.nabble.com/%22resultMap%22-must-be-declared-for-element-type-%22parameter%22.-tp21204286p21204286.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

"resultMap" must be declared for element type "parameter".

2008-12-29 Thread DH12
laces in google but it seems no one has solutions. Thanks -- View this message in context: http://www.nabble.com/%22resultMap%22-must-be-declared-for-element-type-%22parameter%22.-tp21204262p21204262.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

RE: result element order matters?

2008-11-07 Thread I L
roblem. Are you interested at running this program when complete? Where should I send it? thx. Date: Fri, 7 Nov 2008 14:36:18 +0200 From: [EMAIL PROTECTED] To: user-java@ibatis.apache.org Subject: Re: result element order matters? I don't really know how you manage to get an IntegrityConst

Re: result element order matters?

2008-11-07 Thread Vadim
I don't really know how you manage to get an IntegrityConstraintsException when performing selects. Updates and inserts, on the other hand, are sensitive to parameter placement. You might be referring to the exception being thrown on update when you feed newly received object (using the faulty sele

result element order matters?

2008-11-05 Thread I L
This took several days to figure out and is not intuitive. We assume it is a bug. We have a resultMap that has about 40 mappings. When we added a new column to the result map, we started getting an error where a "select *" would not include another unrelated column in the result set. To fix t

Re: ibator question about element

2008-08-29 Thread Jeff Butler
lass file to the abator.jar file in > ./eclipse/plugins/org.apache.ibatis.abator.core_1.1.0. > > When I change the plugin.xml file in > ./eclipse/plugins/org.apache.ibatis.abator.core_1.1.0 to include an > additional element to refer to my class file, I ge

ibator question about element

2008-08-29 Thread Steven R. Baturin
se/plugins/org.apache.ibatis.abator.core_1.1.0. When I change the plugin.xml file in ./eclipse/plugins/org.apache.ibatis.abator.core_1.1.0 to include an additional element to refer to my class file, I get the following run-time error (in the Eclipse PDE Runtime Error Log). java.lang.RuntimeException: Cannot instantiate

Using element as group criteria

2008-07-22 Thread Barnes, Jim D
Anyone know of any way to use an element in result map as "groupBy" criteria. For example, Thanks!

RE: Attribute "type" must be declared for element type "selectKey".

2008-05-02 Thread Niels Beekman
user-java@ibatis.apache.org Subject: Attribute "type" must be declared for element type "selectKey". Hi to All i am getting this error Attribute "type" must be declared for element type "selectKey". my sqlMap .xml code is SELECT

Attribute "type" must be declared for element type "selectKey".

2008-05-01 Thread HelpMePlz
Hi to All i am getting this error Attribute "type" must be declared for element type "selectKey". my sqlMap .xml code is SELECT ADMINTEST.NEXTVAL AS bookid FROM DUAL insert into IBATISADMINTEST (BOOKID,BOOKNAME , AUTHORNAME , AVAILABLEBOOKS,PUBLISHER,CATEG

Re: element

2008-04-22 Thread Kenny Pearce
I have fixed the problem by not specifying jdbcType in the configuration. Why is this necessary? The type is CLOB. On Tue, 2008-04-22 at 11:38 -0400, Kenny Pearce wrote: > Hi, > I've been trying to configure TypeHandlerCallback implementations using > the element in for so

element

2008-04-22 Thread Kenny Pearce
Hi, I've been trying to configure TypeHandlerCallback implementations using the element in for some time, and I have never been able to get it to work. I have usually worked around it by specifying the type handler for the individual parameter or result, but I've come across a

RE: AW: Ibatis xml problem - Document root element "sqlmapconfig", must match DOCTYPE root "sqlMap".

2008-02-11 Thread Dominic Edwards
Thanks Axel, that seems to have corrected that issue at least ! Subject: AW: Ibatis xml problem - Document root element "sqlmapconfig", must match DOCTYPE root "sqlMap".Date: Fri, 1 Feb 2008 16:28:33 +0100From: [EMAIL PROTECTED]: user-java@ibatis.apache.org I'm in

AW: Ibatis xml problem - Document root element "sqlmapconfig", must match DOCTYPE root "sqlMap".

2008-02-01 Thread Leucht, Axel
I'm in a hurry, so I only had a quick look at your xml-file and found this to be in error. Keep in mind that xml-files are case sensitive so you must use names like sqlMapConfig,transactionManager,dataSource, sqlMap,... At least with this changes iBATIS parses the xml file correctly. /

FW: Ibatis xml problem - Document root element "sqlmapconfig", must match DOCTYPE root "sqlMap".

2008-02-01 Thread Dominic Edwards
: Document root element "sqlmapconfig", must match DOCTYPE root "sqlMap". at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source) at com.sun.org.apache.xerces.internal.util.ErrorHandl

Re: Can't get this selectKey element working

2007-11-20 Thread MrNobody
'/sqlMap/insert'. Cause: com.ibatis.common.beans.ProbeException: There >> is >> no READABLE property named 'id' in class 'com.mytest.MyTest' >> >> why does it keep trying to load id from the parameter class while >> ignoring >> the

Re: Can't get this selectKey element working

2007-11-20 Thread Larry Meadors
d 'id' in class 'com.mytest.MyTest' > > why does it keep trying to load id from the parameter class while ignoring > the selectKey ?? > -- > View this message in context: > http://www.nabble.com/Can%27t-get-this-selectKey-element-working-tf4846284.html#a13865417 > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >

Can't get this selectKey element working

2007-11-20 Thread MrNobody
hile ignoring the selectKey ?? -- View this message in context: http://www.nabble.com/Can%27t-get-this-selectKey-element-working-tf4846284.html#a13865417 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

The sqlMap element include another

2007-03-27 Thread erlend.bjorge
Hi there! In page 15 in the documentation: The Element The sqlMap element is used to explicitly include an SQL Map or another SQL Map Configuration file. What does the last part mean ? I try to do load one "sub" config file from the "master" config file, is

AW: Document root element is missing

2006-09-04 Thread Leucht, Axel
Problem solved.   When you copy text from Acrobat Reader into a file inside the Eclipse-IDE, the text is treated as Unicode! Thanks for your help. /Axel

Re: Document root element is missing

2006-09-04 Thread Jeff Butler
eter to match my environment, copied the Person.xml from the tutorial, created the person table in the database and then tried to start a simple query as in the tutorial.But iBatis throws a "org.xml.sax.SAXParseException: Document root element is missing" at startup time.. Does anybody know w

Document root element is missing

2006-09-04 Thread Leucht, Axel
y as in the tutorial. But iBatis throws a "org.xml.sax.SAXParseException: Document root element is missing" at startup time.. Does anybody know what's going wrong here? My environment is JDK 1.4.2_07. Here are both xml-Files. SqlMapConfig.xml: http://www.ib

Re: Where is element

2006-08-30 Thread Clinton Begin
Not sure what the subclass element does...never tried it.  But ... you can probably use discriminator tag.  It's dosclosed as undocumented on the wiki  :-)                                            Cheers,ClintonOn 8/30/06, Jan Vissers <[EMAIL PROTECTED]> wrote: I

Where is element

2006-08-30 Thread Jan Vissers
I'm reading JIRA for ResultObjectFactory and came across this: Factories are not the way to solve inheritance as described (yet another contradiction in this request --first a complaint, and then an intended use). We're going to support the element, as in the .NET vers

RE: [ERROR] Attribute paramaterClass is not declared for element insert

2005-11-28 Thread Hendry
Wow.. I didn't notice that. Sorry.. And thanx ^^ Regards, Hendry -Original Message- From: Ron Grabowski parameterClass

Re: [ERROR] Attribute paramaterClass is not declared for element insert

2005-11-28 Thread Ron Grabowski
ing XPath '/sqlMapConfig/sqlMap'. Cause: > com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: > org.xml.sax.SAXParseException: Attribute "paramaterClass" is not > declared > for element "insert". > Caused by: org.xml.sax.SAXParseExceptio

[ERROR] Attribute paramaterClass is not declared for element insert

2005-11-28 Thread Hendry
ion: Error parsing XML. Cause: org.xml.sax.SAXParseException: Attribute "paramaterClass" is not declared for element "insert". Caused by: org.xml.sax.SAXParseException: Attribute "paramaterClass" is not declared for element "insert". Could somebody help me with

Re: Element Naming Question

2005-11-17 Thread Larry Meadors
lem is as follows > though. > > In the EmployeeSQL.xml mapping, I am seeing elements like this: > > and > > > But as I am using the DevGuide.pdf from the IBatis site download, they refer > to the elements like so: > > > > > > > > > Basically th

Element Naming Question

2005-11-17 Thread Scott Purcell
refer to the elements like so: Basically the DevGuide.pdf uses a different element naming than the example I am working with. Does anyone know the difference? The DTDs look the same?

Re: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread neilhenry
The delete needs a close node. Quoting David Moss <[EMAIL PROTECTED]>: > I'm getting this exception when trying to start my web app in Tomcat5. > > my sql-map-config.xml file contains: > > > 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd";> > > > >

RE: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread Niels Beekman
:26 To: user-java@ibatis.apache.org Subject: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete". I'm getting this exception when trying to start my web app in Tomcat5. my sql-map-config.xml file contains:

Re: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread David Moss
Sorry, I've found it. Hadn't closed a tag correctly. What a stupid mistake, and I'd spent ages looking for it too. David Moss wrote: I'm getting this exception when trying to start my web app in Tomcat5. my sql-map-config.xml file contains: http://www.ibatis.com/dtd/sql-map-config-2

org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread David Moss
I'm getting this exception when trying to start my web app in Tomcat5. my sql-map-config.xml file contains: http://www.ibatis.com/dtd/sql-map-config-2.dtd";> and Map.xml contains... http://www.ibatis.com/dtd/sql-map-2.dtd";>

Re: More than one parameter class/map for the element ?

2005-09-01 Thread Larry Meadors
By creating a composite class, or using a Map. public class Foo{ private YourClassA yourClassA; private YourClassB yourClassB; // getters and setters below... } Larry On 9/1/05, Mathew Samuel <[EMAIL PROTECTED]> wrote: > > Is it possible to pass a 2nd custom/standard class > through a qu

More than one parameter class/map for the element ?

2005-09-01 Thread Mathew Samuel
Is it possible to pass a 2nd custom/standard class through a queryForObject() or queryForList() ? Or do I have to combine both objects under a Collection before sending it in ? I would want to use certain properties from the 2nd class to aid the 1st in a join, like shown below: ...