Re: Dynamic table replacement possible in iBatis3 ?

2010-04-07 Thread Niels Beekman
In iBATIS 2, you would use ${value}. Maybe this still holds for version 3? Niels On 7 April 2010 16:46, Joram Barrez wrote: > Hi All, > > I was wondering if this is possible with iBatis 3: > > >select count(*) from ${tableName} > > > The problem is that the string ${tableName} is not repl

RE: what to put in nullValue when date value is null

2010-02-11 Thread Niels Beekman
Use a type handler. Better even, do not use nullValue at all and handle this case in your domain logic. 1900 sounds like a magic value to me. Niels From: Bhaarat Sharma [mailto:bhaara...@gmail.com] Sent: Thursday, February 11, 2010 9:24 PM To: user-java@ibati

RE: java.util.UUID to postgres uuid column

2010-02-10 Thread Niels Beekman
Try #value#, this will use your parameter object directly. Using #id# tries to obtain the id property from it. From: Vikram Subbarao [mailto:vikra...@directi.com] Sent: Thursday, February 11, 2010 7:50 AM To: user-java@ibatis.apache.org Subject: Re: java.util.

RE: insert going wrong after going from Sybase to MySQL

2010-01-22 Thread Niels Beekman
Your XML is simply invalid, use an editor that supports DTD validation. The selectKey element can only be used inside select elements. I also think that resultClass="java.lang.Long" is obsolete, and should be removed. Niels -Original Message- From: StevenF [mailto:ste...@web2.filipowicz.

RE: Serious Problem with Select resultClass=HashMap on different tables

2010-01-07 Thread Niels Beekman
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+p ass+in+a+dynamic+table+name+-+or+other+uncommon+parameters -Original Message- From: starfish0r [mailto:starfis...@gmail.com] Sent: Thursday, January 07, 2010 12:19 PM To: user-java@ibatis.apache.org Subject: Serious

RE: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread Niels Beekman
egards, JR Ed Stafford-3 wrote: > > You could also wrap it in CDATA block if you don't want to deal with > escaping everything (http://www.w3schools.com/xmL/xml_cdata.asp). > > -Ed > > 2009/10/14 Niels Beekman > > -- View this message in context: http://www.nab

RE: can IBATIS handle mysql "DATE" keyword?

2009-10-14 Thread Niels Beekman
You should escape your < and >. Niels -Original Message- From: jrhitokiri [mailto:jrhitok...@gmail.com] Sent: Wednesday, October 14, 2009 10:21 AM To: user-java@ibatis.apache.org Subject: can IBATIS handle mysql "DATE" keyword? I have this query I tested in mysql. it works when I type

RE: odd behaviour with select, resultset and header

2009-01-27 Thread Niels Beekman
When injecting SQL (using $) that affects column names, you should use remapResults="true" on your select-statement. Niels -Original Message- From: loctorp [mailto:boris.kartasch...@logica.com] Sent: Tuesday, January 27, 2009 10:33 AM To: user-java@ibatis.apache.org Subject: odd behaviou

RE: Multiple Queries in a single prepared statement in DB2

2009-01-06 Thread Niels Beekman
This looks like a sequence/increment-value to me, doesn't DB2 have something like this? That would probably be a lot safer as well in a concurrent environment. Niels From: Michael Schall [mailto:mike.sch...@gmail.com] Sent: Tuesday, January 06, 2009 5:39 PM T

RE: about log sql

2009-01-05 Thread Niels Beekman
If you write a custom appender for log4j, you should be able to access this information. This would require some parsing on your end. Another possibility is to write your own proxies for Connection/Statement/PreparedStatement and provide custom factories for this. Hope this helps, Niels __

RE: about log sql

2009-01-05 Thread Niels Beekman
Duplicate posts, hijacking posts: a great way to start the New Year. You might want to check out http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+g et+SqlMapClient+to+log+SQL+statements. I believe the manual also includes some info on logging. Niels __

RE: 2.3.4.726 and XmlConverter

2008-10-20 Thread Niels Beekman
escription#, #descriptionFormat#, #startDate#, #endDate#, #estimatedHours#, #spentHours#, #noOfAttachments#, #closedAt#, #indexed#, #deleted#) ${SELECTKEY_BEFORE_TABLE_NAME_SQL_PART}task${SELECTKEY_AFTER_TABLE_NAME_ SQL_PART} Zsolt __

RE: 2.3.4.726 and XmlConverter

2008-10-18 Thread Niels Beekman
asses additionally where we pass a class as property we cannot set properties. Zsolt From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 8:57 AM To: user-java@ibatis.apache.org Subject: RE: 2.3.4.726 and XmlConverter You could easi

RE: 2.3.4.726 and XmlConverter

2008-10-16 Thread Niels Beekman
You could easily do this with properties, unless you are connecting to databases on the fly. Search the archives for some examples of this. We use this for purposes similar like yours. Niels From: Zsolt Koppany [mailto:[EMAIL PROTECTED] Sent: Friday, October

RE: linked server with list parameter

2008-10-06 Thread Niels Beekman
NKED_SERVER, 'remote query') ? I was trying to mimic the openquery syntax in ibatis. Is there another way to do this with ibatis? Thank you, Alin -----Original Message- From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2008 4:47 PM To: user-java@ibatis.apache.

RE: linked server with list parameter

2008-10-06 Thread Niels Beekman
Why are you using quotes for the inner SELECT? You now have a query without any parameters, hence the error. Niels -Original Message- From: Tomoiaga, Alin [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2008 11:42 PM To: user-java@ibatis.apache.org Subject: RE: linked server with lis

RE: java.lang.InstantiationException using Ibatis DAO

2008-09-15 Thread Niels Beekman
At least I got that part right. I'm glad you resolved the issue. You might want to document this on the wiki, it could be of help to others Niels From: Paul Ski [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 3:07 PM To: user-java@ibatis.apache.org

RE: java.lang.InstantiationException using Ibatis DAO

2008-09-09 Thread Niels Beekman
I don't understand. If this code is generated by Ibator, I would say that somehow you have a version mismatch. Maybe Jeff can comment on this? Niels From: Paul Ski [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 10:20 AM To: user-java@ibatis.apach

RE: java.lang.InstantiationException using Ibatis DAO

2008-09-08 Thread Niels Beekman
Please include the contents of com.intient.smash.ibatis.impl.AliasesDAOImpl, this has definitely something to do with class/member visibility. From: Paul Ski [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2008 11:31 AM To: user-java@ibatis.apache.org Subje

RE: java.lang.InstantiationException using Ibatis DAO

2008-09-08 Thread Niels Beekman
Can you post the complete stacktrace? From: Paul Ski [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2008 9:14 AM To: user-java@ibatis.apache.org Subject: RE: java.lang.InstantiationException using Ibatis DAO My DAO and DAOImlp classes were generated

RE: java.lang.InstantiationException using Ibatis DAO

2008-09-07 Thread Niels Beekman
Your AliasesDaoImpl should have a public constructor that takes a DaoManager as its single argument. Can you check that this is the case? Hth, Niels From: Paul Ski [mailto:[EMAIL PROTECTED] Sent: Sunday, September 07, 2008 3:47 AM To: user-java@ibatis.apa

RE: passing in java date

2008-08-22 Thread Niels Beekman
Hi, Before doing AOP or hardcoded proxy stuff, if there's just a few queries that need the date passed in you could get away with just a utility method. It takes the original parameter object, creates a map and stores the parameter object under a fixed key "parameter" and the current date under ke

RE: sealectKey database abstraction

2008-08-12 Thread Niels Beekman
Use a properties file to specify the statements, and then include them from within the selectKey statement. There was a post about this a while back, but I can't find it. You could look in the documentation to see if there's any information about including properties. Niels ___

RE: Result HashMap elemnt order

2008-07-04 Thread Niels Beekman
Use java.util.LinkedHashMap From: Nicholoz Koka Kiknadze [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2008 2:19 PM To: user-java@ibatis.apache.org Subject: Result HashMap elemnt order Hi, I get results using resultClass="java.util.HashMap" and I expec

RE: setting table prefix in sql statement

2008-05-20 Thread Niels Beekman
See http://www.mail-archive.com/user-java@ibatis.apache.org/msg09859.html Niels -Original Message- From: Artin Petrossian [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 9:39 PM To: user-java@ibatis.apache.org Subject: setting table prefix in sql statement Hi, Is there a way to d

RE: sqp maps, namespaces a queries' IDs

2008-05-08 Thread Niels Beekman
No, if you enable namespaces, you must specify them when you're executing queries. Of course you can create utility classes that do this. Niels From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Filipe David Manana Sent: Thursday, May 08, 2008 10:5

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

2008-05-02 Thread Niels Beekman
The attribute 'type' has recently been introduced. You are probably using an older version of iBATIS or the DTD is not correct. What DTD are you using in your sqlmaps? Niels -Original Message- From: HelpMePlz [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 8:09 AM To: user-java@ibat

RE: Using Ibats with Group By and sums, etc

2008-04-28 Thread Niels Beekman
Hi, First, you're using both the resultClass and resultMap attributes; use only one of those, not both. Second, in your resultmap you have the following: This means, map resultset column 'BCMP' to property 'companyCode'. In your SQL you have: select '$library$' as library,

RE: how can send hashmap values to the

2008-04-25 Thread Niels Beekman
Your SQL SELECT-clause is not valid; you're missing some commas. Niels -Original Message- From: HelpMePlz [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 4:18 PM To: user-java@ibatis.apache.org Subject: how can send hashmap values to the public IbatisBooksForm retriveBookDetail

RE: iBATIS insert does not execute

2008-04-19 Thread Niels Beekman
I don't understand what you're trying to do: a) Do you want to get rid of the separate selectKey definition, if so, why? b) What do you mean by the DTD is correct? c) Integer id = (Integer) sqlMap.insert("statementId"); should just plain work, if not, try debugging an insert by setting breakpoints

RE: iBATIS insert does not execute

2008-04-19 Thread Niels Beekman
That should work with the Java version. You are using unsupported attributes, relevant DTD-piece: I don't know if that helps, try enabling debug to see if the selectKey-query gets executed, and if so, what results are returned. HTH, Niels -Original Message- From: Chris Marshall [mail

RE: Support for private properties

2008-03-27 Thread Niels Beekman
This has been added quite some time ago, but I can't find it either. I've checked the release notes and issue tracker, but no luck. Niels -Original Message- From: André B. [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2008 9:04 AM To: user-java@ibatis.apache.org Subject: Re: Suppo

RE: Problem Timestamp insert and retriev

2008-03-18 Thread Niels Beekman
Sorry for the noise, but you might want to change 'dateOfBird' to 'dateOfBirth', I doubt that most users have two wings ;) No offense, just a friendly pointer... Niels -Original Message- From: dimitriBarzagli [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 3:39 PM To: user-java@

RE: Re : Dynamic request with null values and AND

2008-03-04 Thread Niels Beekman
Move your join constraints before the dynamic statements, the dynamic statements can then always use AND. -Original Message- From: Gilles Schlienger [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 11:13 AM To: user-java@ibatis.apache.org Subject: Re : Dynamic request with null va

RE: Undefined Column Name Exception in Implicit Map

2008-02-27 Thread Niels Beekman
I think that this affects the aliasing of columns, which would be bad IMHO. But the javadoc of getColumnLabel says: "Gets the designated column's suggested title for use in printouts and displays." This would mean that it's perfectly valid to call getColumnName, maybe someone with more JDBC

RE: discriminator and submap

2008-02-13 Thread Niels Beekman
onstraints out. Niels From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 6:37 PM To: user-java@ibatis.apache.org Subject: RE: discriminator and submap "Niels Beekman" <[EMAIL PROTECTED]> scritti il 12/02/2008 22:3

RE: discriminator and submap

2008-02-12 Thread Niels Beekman
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 7:07 PM To: user-java@ibatis.apache.org Subject: Re: discriminator and submap > Niels Beekman > Sat, 04 Nov 2006 03:35:52 -0800 > If only if/else behaviour is required, why not create an additio

RE: iBATIS QUERRY TAKE LONG TIME AS COMAPARED TO NORMAL JDBC

2008-01-29 Thread Niels Beekman
Maybe you're typing your queries with CAPS-LOCK while your database is case-sensitive? From: Yuvraj Shinde [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 29, 2008 10:46 AM To: user-java@ibatis.apache.org Subject: iBATIS QUERRY TAKE LONG TIME AS COMAPARED TO

RE: Strange Behavior

2008-01-14 Thread Niels Beekman
You might want to use $filterBy$ instead of #filterBy#. Niels From: Carlos de Luna Saenz [mailto:[EMAIL PROTECTED] Sent: Monday, January 14, 2008 4:56 PM To: user-java@ibatis.apache.org Subject: Strange Behavior i have a weird behavior with this select:

RE: nullValue for Boolean wrapper class property

2008-01-10 Thread Niels Beekman
entsById.", > sqlException); > } > > logger.debug("END - > selectMemberWithDependentsById"); > > return members; > } > > --- Niels Beekman <[EMAIL PROTECTED]> wrote: &g

RE: nullValue for Boolean wrapper class property

2008-01-10 Thread Niels Beekman
DependentsById"); return members; } --- Niels Beekman <[EMAIL PROTECTED]> wrote: > The code you posted is from a result map, the > exception you're getting > is probably coming from an insert or update, can you > post the Java co

RE: nullValue for Boolean wrapper class property

2008-01-10 Thread Niels Beekman
The code you posted is from a result map, the exception you're getting is probably coming from an insert or update, can you post the Java code involved and all relevant SQL? Niels -Original Message- From: top de castro [mailto:[EMAIL PROTECTED] Sent: Thursday, January 10, 2008 4:40 PM To

RE: Error setting a property: IllegalArgumentException

2008-01-07 Thread Niels Beekman
This usually occurs when you are trying to stuff a DB null-value into a primitive Java field. You can either: - change DB data - change primitive type into wrapper, i.e. int -> Integer - use the magic nullValue attribute, personally I don't like this one Niels ___

RE: QueryforList and Generics

2007-12-13 Thread Niels Beekman
One thing you could do is introduce a utility method that accepts an extra 'resultClass' argument, something like this: @SuppressWarnings("unchecked") public List queryForList(Class resultClass, String id, Object parameterObject) { return queryForList(id, parameterObject); } Invocat

RE: sql server paging

2007-11-20 Thread Niels Beekman
TOP arguments can't be parameterized, use $quantity$ and $offset$ instead. From: Sergey Livanov [mailto:[EMAIL PROTECTED] Sent: dinsdag 20 november 2007 18:56 To: user-java Subject: sql server paging I want to make paging for mssql server. I use a desig

RE: Using # in a schema name?

2007-11-15 Thread Niels Beekman
That's weird, I would assume iBATIS to just inject the schemaname, not reprocess it. Try escaping the # with ##. Niels -Original Message- From: Ralf Assmann [mailto:[EMAIL PROTECTED] Sent: donderdag 15 november 2007 14:55 To: user-java@ibatis.apache.org Subject: Using # in a schema name?

RE: iBatis gives no error but no results!

2007-11-14 Thread Niels Beekman
Try replacing parameters with hardcoded values for the individual pieces, maybe BETWEEN does not like to be used in combination with parameters. Which dbms are you using? Niels -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: woensdag 14 november 2007 15:38 To:

RE: Setting schema name

2007-11-13 Thread Niels Beekman
I think the schema in question is a DB-schema which afaik, is only injectable using the configuration file solution, because iBATIS does not modify the SQL statements you write in any way. Niels From: Carlos de Luna Saenz [mailto:[EMAIL PROTECTED] Sent: din

RE: Re: problem with flushInterval in cacheModel

2007-11-07 Thread Niels Beekman
This is a bug. The problem is that the flush interval is computed in milliseconds, which can easily overflow integer boundaries. The code used in parsing the flush interval: long t = 0; String hours = childAttributes.getProperty("hours"); if (hours != null) t += Integer.parseInt(hours) * 60 * 60 *

RE: JAVA 1.5 enum > typehandler woes

2007-11-05 Thread Niels Beekman
post back any new information. I don't know how I would be more explicit for the INSERT. Do I have to decompose the definition of the parameter class? Given that I know from the debugger that the typehandler is definitely called on the INSERT, what benefit would that bring? On 05/

RE: JAVA 1.5 enum > typehandler woes

2007-11-05 Thread Niels Beekman
have to > decompose the definition of the parameter class? Given that I know from the > debugger that the typehandler is definitely called on the INSERT, what > benefit would that bring? > > > > On 05/11/2007, Niels Beekman <[EMAIL PROTECTED]> wrote: > > >

RE: JAVA 1.5 enum > typehandler woes

2007-11-05 Thread Niels Beekman
nto iBATIS, the value goes null. That is why I wondered if there is something that I needed to do with the enum itself? Thanks for the continued support. Ray On 05/11/2007, Niels Beekman <[EMAIL PROTECTED]> wrote: Hi, Are you sure this is the complete stacktrace? Did you try

RE: JAVA 1.5 enum > typehandler woes

2007-11-05 Thread Niels Beekman
Hi, Are you sure this is the complete stacktrace? Did you try debugging? This error can be caused by numerous things, for example the property frequency can be null in your bean, ensure that you are handling the null-case in your typehandler, for a comprehensive explanation, see: http://opens

RE: Caching problem using IBATIS

2007-11-01 Thread Niels Beekman
Did you enable caching globally in the config file? Niels -Original Message- From: Odelya Glick [mailto:[EMAIL PROTECTED] Sent: vrijdag 2 november 2007 1:33 To: user-java@ibatis.apache.org Subject: Caching problem using IBATIS Hi, I am trying to implement cache in IBATIS. I declared t

RE: infinite loop in the method 'moveToNextResultsIfPresent'

2007-10-31 Thread Niels Beekman
esent' I *always* reply faster with an active support agreement - please feel free to email me off-list to negotiate the rate. ;-) ...and I've never had this issue with Oracle stored procedures, sorry. Larry On 10/31/07, Niels Beekman <[EMAIL PROTECTED]> wrote: > > I thin

RE: infinite loop in the method 'moveToNextResultsIfPresent'

2007-10-30 Thread Niels Beekman
I think you will be rewarded when you forward this message at least 10 times to the same list. Please be patient, this is open-source remember? Niels From: Hemant.Kamatgi [mailto:[EMAIL PROTECTED] Sent: woensdag 31 oktober 2007 4:59 To: user-java@ibatis.apach

RE: retrieve a list of strings, how?

2007-10-11 Thread Niels Beekman
Looks good to me, can you enable debugging and see if the statement actually executes? Also, post the select statement that uses the ClueEntry result map and the corresponding Java-code. Niels -Original Message- From: lihh [mailto:[EMAIL PROTECTED] Sent: donderdag 11 oktober 2007 21:14 T

RE: Unknown Column Name problem

2007-10-09 Thread Niels Beekman
You are testing the other way around. The 'problem' is that when you specify a column in a resultmap that's not actually delivered by the query, you get a driver-specific 'Column name xxx was not found in this ResultSet', which is to be expected imho. The TS could either fix the problem by issu

RE: Lazy loading -- IllegalArgumentException: argument type mismatch

2007-10-02 Thread Niels Beekman
batis.apache.org Subject: Re: Lazy loading -- IllegalArgumentException: argument type mismatch I will interpret this as "You don't need interfaces for the proxying in lazy loading to work" and send some more info. Attached are a lot of files... :) On 10/2/

RE: Lazy loading -- IllegalArgumentException: argument type mismatch

2007-10-02 Thread Niels Beekman
Please post relevant SQLMap and net.bioclipse.structuredb.domain.Library code. It's difficult to see what's going on without them. Niels From: Jonathan Alvarsson [mailto:[EMAIL PROTECTED] Sent: dinsdag 2 oktober 2007 11:02 To: user-java@ibatis.apache.org Subj

RE: How to setup JNDI connection in ibatis

2007-09-27 Thread Niels Beekman
On a side note: ensure that 'select * from PODATA' doesn't return a huge resultset, preferably just one row, one column. From: Ashish Kulkarni [mailto:[EMAIL PROTECTED] Sent: donderdag 27 september 2007 15:59 To: user-java@ibatis.apache.org Subject: Re: How to

RE: TypehandlerCallback

2007-09-14 Thread Niels Beekman
You're probably not posting the full exception stacktrace. Does iBATIS query your type handler? You should handle the null case yourself... Niels -Original Message- From: Härtel, Eric [mailto:[EMAIL PROTECTED] Sent: vrijdag 14 september 2007 16:22 To: user-java@ibatis.apache.org Subject

RE: abstract property

2007-09-13 Thread Niels Beekman
te.queryForObject(SqlM apExecutorDelegate.java:561) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlM apExecutorDelegate.java:536) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSes sionImpl.java:93) at com.

RE: abstract property

2007-09-13 Thread Niels Beekman
You shouldn't specify both resultMap and resultClass, you can only have one: should be: Hth, Niels -Original Message- From: Kenny Pearce [mailto:[EMAIL PROTECTED] Sent: donderdag 13 september 2007 15:44 To: user-java@ibatis.apache.org Subject: Re: abstract property

RE: abstract property

2007-09-12 Thread Niels Beekman
How could iBATIS throw an InstantiationException when you're not even telling it the name of your abstract class? Please post the full exception stacktrace and your result maps. Niels -Original Message- From: Kenny Pearce [mailto:[EMAIL PROTECTED] Sent: woensdag 12 september 2007 20:46 T

RE: how to execute a complete dynamic querry in ibatis(urgent)

2007-09-12 Thread Niels Beekman
Since it's so urgent, I decided to drop all my work and help you first. Hooray for the offshoring! Now, onto the question, imho you're way too dynamic here, but you need to use remapResults=true, see http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+p ass+in+a+dynamic+table+na

RE: How to map a list of double?

2007-09-11 Thread Niels Beekman
-java@ibatis.apache.org Subject: Re: How to map a list of double? On 9/11/07, Niels Beekman <[EMAIL PROTECTED]> wrote: I don't understand how iBATIS thinks you're trying to map to an array, do you have overloads for the values-property? Try setting some debug breakpoints in

RE: How to map a list of double?

2007-09-11 Thread Niels Beekman
ssCastException. (It reads the file correctly though because ouble rendered a class not found exception) Isn't this supposed to be possible to do? On 9/11/07, Niels Beekman <[EMAIL PROTECTED]> wrote: Hm, your result class of MoleculeDescriptor.getValueList is wrong,

RE: How to map a list of double?

2007-09-11 Thread Niels Beekman
? Well that's what I thought I was doing. My field in my bean is private List values; with setter: public void setValues(List values) { this.values = values; } Does my mapping somehow not match this? On 9/11/07, Niels Beekman <[EMAIL PROTECTED]> wrote: This seems to be a

RE: How to map a list of double?

2007-09-11 Thread Niels Beekman
This seems to be a bug, iBATIS tries to cast a double array to an Object array. A workaround would probably be to change the double array to a Double list. Niels From: Jonathan Alvarsson [mailto:[EMAIL PROTECTED] Sent: dinsdag 11 september 2007 11:36 To: user

RE: JavaBean and Map parameters

2007-09-03 Thread Niels Beekman
This only holds when the bean-class is explicitly specified, i.e. it must not be an anonymous class. If it's anonymous, iBATIS has no way to inspect the bean class, since it's unknown at load-time. Niels -Original Message- From: Ilya Boyandin [mailto:[EMAIL PROTECTED] Sent: maandag 3 s

RE: Get return value and return result set

2007-08-28 Thread Niels Beekman
osting but it didn´t work either. I´ve seen that i should use xmlCollection type to do what i want. Is it rigth? There´s no documentation related to retrieve nested xml elements so i´ll take a look at the source code and see what i can see. Thanks. On 8/28/07, Niels Beekman <[EMAIL PROTECTE

RE: Get return value and return result set

2007-08-28 Thread Niels Beekman
Change to , the configured namespace includes all statements in the same SQLMap. Niels From: Fábio Pisaruk [mailto:[EMAIL PROTECTED] Sent: maandag 27 augustus 2007 23:45 To: user-java@ibatis.apache.org Subject: Re: Get return value and return result set

RE: appending to collection properties

2007-08-22 Thread Niels Beekman
properties Niels Beekman wrote: > You would have to create a select that joins all children and returns > them in one shot. Thanks for your answer. Is it possible to concatenate all three subselects since they each need their own resultMap mapping? Cheers. Ole.

RE: appending to collection properties

2007-08-22 Thread Niels Beekman
You would have to create a select that joins all children and returns them in one shot. Niels -Original Message- From: Ole Trenner [mailto:[EMAIL PROTECTED] Sent: woensdag 22 augustus 2007 10:10 To: user-java@ibatis.apache.org Subject: appending to collection properties Hello, I unders

RE: Ibatis access denied with tomcat

2007-08-16 Thread Niels Beekman
Hi, This has nothing to do with file permissions, this is because iBATIS tries to get all declared class methods (not only public ones), this requires special priviliges which the codebase apparently does not have. Do some searching to find out how to grant these privileges. Niels -Original

RE: specifying offset/top parameter

2007-08-07 Thread Niels Beekman
SQL Server does not allow top to be specified as a parameter, you need to inject in the query: select top $max_users$ * from NP_USER HTH, Niels From: Alec Lebedev [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 augustus 2007 20:10 To: user-java@ibatis.apach

RE: Problem with nullpoiterException.

2007-07-25 Thread Niels Beekman
Hi, Why did you comment the initalization of rowBeheer[i]? That blows stuff up... Also, why are you performing beanfield copying between Beheer and RowBeheer, why not directly return the Beheer class? No offense, but these are all basic Java programming questions/problems, try following some tuto

RE: Issue in dynamic select

2007-07-18 Thread Niels Beekman
epends and it is right. Then, what I want is obtain and set this value when it is not null and avoid it when it is null. Is there any way to do it? Is it possible? >From: "Niels Beekman" <[EMAIL PROTECTED]> >Reply-To: user-java@ibatis.apache.org >To: >Subject: RE:

RE: Issue in dynamic select

2007-07-18 Thread Niels Beekman
Either you are throwing the exception yourselves from the setter, or you are trying to map a null value into a primitive field... Hope this helps, Niels -Original Message- From: Francisco Exposito Aguilera [mailto:[EMAIL PROTECTED] Sent: woensdag 18 juli 2007 17:42 To: user-java@ibatis

RE: IBATIS map and Cache

2007-07-04 Thread Niels Beekman
Did you enable the cache globally in your SqlMap config? From: Gabriel Macerot [mailto:[EMAIL PROTECTED] Sent: woensdag 4 juli 2007 10:17 To: user-java@ibatis.apache.org Subject: IBATIS map and Cache I build a web application. Then I store data in a mys

RE: How to pass more than one query parameter?

2007-06-27 Thread Niels Beekman
You can use a Map, see the manual for more information. Niels From: Sreenivasulu N (HCL Financial Services) [mailto:[EMAIL PROTECTED] Sent: woensdag 27 juni 2007 10:29 To: user-java@ibatis.apache.org Subject: How to pass more than one query parameter?

RE: R: maxTransactions DefaultValue

2007-06-06 Thread Niels Beekman
irm my guessing. Thank you in advance Giuseppe ________ Da: Niels Beekman [mailto:[EMAIL PROTECTED] Inviato: venerdì 1 giugno 2007 19.41 A: user-java@ibatis.apache.org Oggetto: RE: maxTransactions DefaultValue maxSessions != maxTransactions, try setMaxTra

RE: maxTransactions DefaultValue

2007-06-01 Thread Niels Beekman
maxSessions != maxTransactions, try setMaxTransactions(). But anyway, I don't know if settings these values after construction is even supported. You'd better put them in your 'newprops' variable, and then referencing them in the sqlmap-config. Niels From:

RE: MySQLSyntaxErrorException

2007-05-24 Thread Niels Beekman
Loose the extraneous comma after candidate_surname. -Original Message- From: Okan Çetin [mailto:[EMAIL PROTECTED] Sent: vrijdag 25 mei 2007 1:41 To: user-java@ibatis.apache.org Subject: MySQLSyntaxErrorException Hello, Candidate.xml: insert into candidate ( candidate_name,

FW: Iterate problem

2007-05-18 Thread Niels Beekman
s all there. HTH, Niels From: Hemalatha Reddy (HCL Financial Services) [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 mei 2007 13:29 To: Niels Beekman Subject: Iterate problem Hi, I am new to Ibatis . I have to do multiple inserts into database at a

RE: auto-generated keys in Oracle

2007-05-16 Thread Niels Beekman
Use the keyProperty attribute of selectkey... From: Jiming Liu [mailto:[EMAIL PROTECTED] Sent: woensdag 16 mei 2007 12:28 To: user-java@ibatis.apache.org Subject: auto-generated keys in Oracle hi guys, I was trying to use auto-generated key in oracle by i

RE: How to map getBytes in iBATIS?

2007-05-09 Thread Niels Beekman
Hi, I don't believe there is a way to map directly to byte[]. IMHO, byte arrays should not be used as properties. Maybe you could create a custom typehandler that maps the byte[] to String. If I may do another suggestion: avoid doing rs.getBytes() multiple times for the same column, you'd better

RE: How2: debug errors on SQL XML queries

2007-05-07 Thread Niels Beekman
It seems that you've got a JVM that does not have the indicated RuntimeException constructor, JVM version 1.4 should work fine. I couldn't find a minimum required JVM version on the website, so I don't know if this should be considered a bug. Niels From:

RE: How to support read-only fields/paramters

2007-05-07 Thread Niels Beekman
Java Reflection allows to bypass this using Member.setAccessible(true)... Niels -Original Message- From: Gordon Ross [mailto:[EMAIL PROTECTED] Sent: maandag 7 mei 2007 11:10 To: user-java@ibatis.apache.org Subject: RE: How to support read-only fields/paramters Yes it does help : It work

RE: Taking care of different databases

2007-05-06 Thread Niels Beekman
As for selectKey statements, see http://issues.apache.org/jira/browse/IBATIS-142 for a hint on this. Otherwise, I think you need to include different sqlmaps for different databases, search the archives for some examples. Niels From: Ashok Madhavan [mailto:

RE: Caching problems

2007-04-02 Thread Niels Beekman
Did you enable caching globally in the config file? Niels -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: maandag 2 april 2007 17:54 To: user-java@ibatis.apache.org Subject: Caching problems Hi all, I'm having a bit of a problem with caching. I have

RE: SQL Server JDBC drivers

2007-03-27 Thread Niels Beekman
-----Original Message- From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 10:19 PM To: user-java@ibatis.apache.org Subject: FW: SQL Server JDBC drivers And for the archives... -----Origi

RE: Polymorphism question

2007-03-25 Thread Niels Beekman
Hi, I've been experiencing this 'problem' too. I currently use the left joins solution when there are <=3 tables, otherwise I just query the type and perform a single join, that seems to be faster than paying the overhead associated with the left joins. Niels ___

RE: SQL Server JDBC drivers

2007-03-21 Thread Niels Beekman
SDN for details. Regards, A > -Original Message----- > From: Niels Beekman [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 21, 2007 10:19 PM > To: user-java@ibatis.apache.org > Subject: FW: SQL Server JDBC drivers > > And for the archives... > > -Original

FW: SQL Server JDBC drivers

2007-03-21 Thread Niels Beekman
And for the archives... -Original Message- From: Niels Beekman Sent: woensdag 21 maart 2007 20:33 To: 'Mark Volkmann' Subject: RE: SQL Server JDBC drivers Sure: INSERT INTO example (example_column) VALUES (#exampleColumn#) SELECT @@IDENTITY AS ID iBATIS

RE: SQL Server JDBC drivers

2007-03-21 Thread Niels Beekman
Hi, We use jTDS (http://jtds.sf.net) for several years now, it has excellent performance and any bugs (which are very rare) are dealt with promptly. Niels -Original Message- From: Mark Volkmann [mailto:[EMAIL PROTECTED] Sent: woensdag 21 maart 2007 17:28 To: user-java@ibatis.apache.org

RE: Interview at Inventum (was: Retrieving wrong result out of the Cache.)

2007-03-16 Thread Niels Beekman
Please take your spam elsewhere... From: Padam J Singh [mailto:[EMAIL PROTECTED] Sent: vrijdag 16 maart 2007 12:23 To: user-java@ibatis.apache.org Subject: Interview at Inventum (was: Retrieving wrong result out of the Cache.) Hello, Your resume has been

RE: How do I apply individual properties from a resultMap to another resultMap

2007-03-14 Thread Niels Beekman
Don't know of a pretty solution, but you can do the following: 1. use queryForObject() to create an object with either values (stored proc or regular query) 2. use the constructed object and pass it to queryForObject() as 'resultObject' parameter (stored proc or regular query, depending on first

RE: iBatis and JBoss

2007-03-14 Thread Niels Beekman
Did you try it using com.apioutsourcing.commcardimaging.domain.DocumentRequest.RequestParamet ers? Niels -Original Message- From: holodok [mailto:[EMAIL PROTECTED] Sent: woensdag 14 maart 2007 12:53 To: user-java@ibatis.apache.org Subject: iBatis and JBoss I use iBatis in my web servic

  1   2   3   >