iBatis SQL Maps

Laurent MANNS | 5 Jul 10:58

Picon

Ibatis 3 and null values

Hello,

I'm facing a weird problem when resultType is a Map : 

<select id="test" resultType="java.util.LinkedHashMap">
  select 
    getDate() "Timestamp", 
    null      "Test"
</select>

List<LinkedHashMap<Object, Object>> lignes = session.selectList("test");

for (Iterator it = ((LinkedHashMap<Object, Object>)    
lignes.get(0)).keySet().iterator(); it.hasNext();) 
                  System.out.println(it.next());

                  		
The result is : 

   TIMESTAMP
   Timestamp
   1

Why is first column duplicated when the alias is in lowercase ? And why can't i
get the second column header when it contains null values ? 

Any help would be appreciated. 

Thx.

(Continue reading)

Poitras Christian | 5 Jul 14:23

Picon

RE: Ibatis 3 and null values

Ibatis project moved to Google. If I am not mistaking, the developers of iBATIS are not registered to this
list anymore.
Please, post your questions to the new list at mybatis-user <at> googlegroups.com

Christian

-----Original Message-----
From: Laurent MANNS [mailto:laurent.manns <at> gmail.com] 
Sent: Monday, July 05, 2010 4:58 AM
To: user-java <at> ibatis.apache.org
Subject: Ibatis 3 and null values

Hello,

I'm facing a weird problem when resultType is a Map : 

<select id="test" resultType="java.util.LinkedHashMap">
  select 
    getDate() "Timestamp", 
    null      "Test"
</select>

List<LinkedHashMap<Object, Object>> lignes = session.selectList("test");

for (Iterator it = ((LinkedHashMap<Object, Object>)    
lignes.get(0)).keySet().iterator(); it.hasNext();) 
                  System.out.println(it.next());

                  		
The result is :

(Continue reading)

Panciz | 10 Jul 08:24

Picon

Ibator 1.2.2

Hi,

I built ibator 1.2.2 from sources downloaded from 
http://svn.apache.org/repos/asf/ibatis/java/ibator/trunk/core/
and create the JAR file.
The problem is that when I run the tool on a configuration file,
which worked with the previous version, I get  

$ java -jar ibator-1.2.2.jar -configfile ../conf/ibatorConfig.xml 
java.net.MalformedURLException
at java.net.URL.<init>(URL.java:601)
at java.net.URL.<init>(URL.java:464)
at java.net.URL.<init>(URL.java:413)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager
  .setupCurrentEntity(XMLEntityManager.java:650)
at com.sun.org.apache.xerces.internal.impl
  .XMLEntityManager.startEntity(XMLEntityManager.java:1315)
at com.sun.org.apache.xerces.internal.impl
.XMLEntityManager.startDTDEntity(XMLEntityManager.java:1282)
at com.sun.org.apache.xerces.internal.impl
  .XMLDTDScannerImpl.setInputSource(XMLDTDScannerImpl.java:283)
at com.sun.org.apache.xerces.internal.impl
  .XMLDocumentScannerImpl$DTDDriver.dispatch(XMLDocumentScannerImpl.java:1193)
at com.sun.org.apache.xerces.internal.impl
  .XMLDocumentScannerImpl$DTDDriver.next(XMLDocumentScannerImpl.java:1090)
at com.sun.org.apache.xerces.internal.impl
  .XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:1003)
at com.sun.org.apache.xerces.internal.impl
  .XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:648)
at com.sun.org.apache.xerces.internal.impl

(Continue reading)

Poitras Christian | 12 Jul 14:23

Picon

RE: Ibator 1.2.2

Ibatis project moved to Google. If I am not mistaking, the developers of iBATIS are not registered to this
list anymore.
Please, post your questions to the new list at mybatis-user <at> googlegroups.com

Christian

-----Original Message-----
From: Panciz [mailto:dav.poletti <at> gmail.com] 
Sent: Saturday, July 10, 2010 2:25 AM
To: user-java <at> ibatis.apache.org
Subject: Ibator 1.2.2

Hi,

I built ibator 1.2.2 from sources downloaded from http://svn.apache.org/repos/asf/ibatis/java/ibator/trunk/core/
and create the JAR file.
The problem is that when I run the tool on a configuration file, which worked with the previous version, I get  

$ java -jar ibator-1.2.2.jar -configfile ../conf/ibatorConfig.xml java.net.MalformedURLException
at java.net.URL.<init>(URL.java:601) at java.net.URL.<init>(URL.java:464) at
java.net.URL.<init>(URL.java:413) at com.sun.org.apache.xerces.internal.impl.XMLEntityManager
  .setupCurrentEntity(XMLEntityManager.java:650)
at com.sun.org.apache.xerces.internal.impl
  .XMLEntityManager.startEntity(XMLEntityManager.java:1315)
at com.sun.org.apache.xerces.internal.impl
.XMLEntityManager.startDTDEntity(XMLEntityManager.java:1282)
at com.sun.org.apache.xerces.internal.impl
  .XMLDTDScannerImpl.setInputSource(XMLDTDScannerImpl.java:283)
at com.sun.org.apache.xerces.internal.impl
  .XMLDocumentScannerImpl$DTDDriver.dispatch(XMLDocumentScannerImpl.java:1193)

(Continue reading)

droidin.net | 19 Jul 05:06

Dynamic table names in DELETE


iBatis 3 has wonderful ability in SELECT statements to provide dynamic
substitution before statement is prepared. For example this will work

<select id="foo">SELECT * FROM $db$.MY_TABLE</select>

However I can't make it work when trying to empty table

XML code:

<delete id="del" parameterType="String">DELETE FROM $db$.MY_TABLE</delete>
<!-- and I also tried -->
<delete id="del" parameterType="String">DELETE FROM $0$.MY_TABLE</delete>

Java code:

// method defined as
del(String db);
// and executed as
mapper.del("MY_DB");

I get message complaining that Database '$db$' does not exist

Anyone can suggest the solution? I'm on Teradata db and it is setup in the
way that I need provide db names in query or else I get Object not found

--

-- 
View this message in context: http://old.nabble.com/Dynamic-table-names-in-DELETE-tp29201077p29201077.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

(Continue reading)

Poitras Christian | 19 Jul 14:33

Picon

RE: Dynamic table names in DELETE

Ibatis project moved to Google. If I am not mistaking, the developers of iBATIS are not registered to this
list anymore.
Please, post your questions to the new list at mybatis-user <at> googlegroups.com

Christian 

-----Original Message-----
From: droidin.net [mailto:droid <at> droidin.net] 
Sent: Sunday, July 18, 2010 11:07 PM
To: user-java <at> ibatis.apache.org
Subject: Dynamic table names in DELETE

iBatis 3 has wonderful ability in SELECT statements to provide dynamic substitution before statement is
prepared. For example this will work

<select id="foo">SELECT * FROM $db$.MY_TABLE</select>

However I can't make it work when trying to empty table

XML code:

<delete id="del" parameterType="String">DELETE FROM $db$.MY_TABLE</delete>
<!-- and I also tried -->
<delete id="del" parameterType="String">DELETE FROM $0$.MY_TABLE</delete>

Java code:

// method defined as
del(String db);
// and executed as

(Continue reading)

Bruno Issenmann | 21 Jul 18:19

Picon

Re: Transaction Rollback not working with iBatis + Spring

Hi,

I'm facing the same problem. Did you solved it ?
Thanks

Larry Meadors | 21 Jul 18:43

Picon

Re: Transaction Rollback not working with iBatis + Spring

You don't need the batch, and I'm pretty sure it won't ever work with
the batch because the inserts don't happen when you call them (they
happen when you call executeBatch()) so your ids don't get set when
you expect them to.

Remove the lines related to the batch, and I think it'll work.

Larry

On Wed, Jul 21, 2010 at 10:19 AM, Bruno Issenmann
<b.issenmann <at> labsoft.fr> wrote:
> Hi,
>
> I'm facing the same problem. Did you solved it ?
> Thanks
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
> For additional commands, e-mail: user-java-help <at> ibatis.apache.org
>
>

Bruno Issenmann | 21 Jul 19:07

Picon

Re: Transaction Rollback not working with iBatis + Spring

Thanks for ansering.

I do not use the batch.
I'm just doing two inserts then i commit. I still have an integrity contraint
violation.

Vinaya Tirikkovalluru | 21 Jul 19:24

RE: Transaction Rollback not working with iBatis + Spring

Sorry!! I missed the thread.
Does it give you a runtime exception? Only if the code throws a runtime
exception the transaction will be rolled back

Vinaya

-----Original Message-----
From: Bruno Issenmann [mailto:b.issenmann <at> labsoft.fr] 
Sent: Wednesday, July 21, 2010 1:07 PM
To: user-java <at> ibatis.apache.org
Subject: Re: Transaction Rollback not working with iBatis + Spring

Thanks for ansering.

I do not use the batch.
I'm just doing two inserts then i commit. I still have an integrity
contraint
violation.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe <at> ibatis.apache.org
For additional commands, e-mail: user-java-help <at> ibatis.apache.org

This electronic message is intended only for the use of the individual(s) or entity(ies) named above and
may contain information which is privileged and/or confidential.  If you are not the intended recipient,
be aware that any disclosure, copying, distribution, dissemination or use of the contents of this
message is prohibited.  If you received this message in error, please notify the sender immediately.

Group

gmane.comp.java.ibatisdb.user.

Project Web Page

iBatis SQL Maps

Search Archive

Page

1 | 2

Articles in period: 15

July 2010

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

Dynamic table names in DELETE (19 Jul 05:06)
Ibator 1.2.2 (10 Jul 08:24)
Ibatis 3 and null values (5 Jul 10:58)
ibatis 3 and calling stored procedure (28 Jun 18:03)
Inheritanc (24 Jun 21:05)
Passing Oracle Table Types (Is it possible?) (18 Jun 12:11)
Lazy Loading per ResultMap (17 Jun 18:51)
SQLMap Question - Select Statement (15 Jun 16:43)
Getting RunTime Exception (14 Jun 17:15)
SQLExecutor.addBatch() modified (14 Jun 07:10)
Select from View (as opposed to table) using iBatis (9 Jun 23:11)
iBATIS 3 dynamic sql 'foreach' list got problem. (8 Jun 10:09)
Cause: java.sql.SQLException: Closed Connection (7 Jun 00:21)
committing stored procedure (4 Jun 11:23)
Possible to get ibatis to throw an exception if not all params are fil (3 Jun 23:23)
JPetstore5.0+mysql error:XXXX in field list is ambiguous (3 Jun 15:53)
Mapping an Array of String (1 Jun 16:14)
iBatis 3: dynamic sql and numeric property type problem (31 May 16:55)
FileNotFoundException: http://www.mybatis.org/dtd/sql-map-config-2.dtd (27 May 18:20)
Procedure returining Array (25 May 15:21)
Need support for Dynamic procedure invocation (25 May 07:03)

Archives

15	July 2010
36	June 2010
177	May 2010
236	April 2010
184	March 2010
232	February 2010
220	January 2010
180	December 2009
168	November 2009
220	October 2009
157	September 2009
361	August 2009
204	July 2009
171	June 2009
137	May 2009
174	April 2009
214	March 2009
233	February 2009
293	January 2009
165	December 2008
166	November 2008
164	October 2008
154	September 2008
287	August 2008
264	July 2008
152	June 2008
215	May 2008
179	April 2008
260	March 2008
219	February 2008
287	January 2008
189	December 2007
234	November 2007
206	October 2007
247	September 2007
211	August 2007
247	July 2007
204	June 2007
226	May 2007
275	April 2007
388	March 2007
386	February 2007
323	January 2007
177	December 2006
354	November 2006
333	October 2006
417	September 2006
631	August 2006
489	July 2006
455	June 2006
371	May 2006
296	April 2006
452	March 2006
351	February 2006
381	January 2006
242	December 2005
403	November 2005
356	October 2005
338	September 2005
544	August 2005
410	July 2005
395	June 2005
526	May 2005
424	April 2005
389	March 2005
459	February 2005
418	January 2005
301	December 2004
57	November 2004

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template