Hi,
Seems to me that you are using two config-files or something like that,
you say you are including com/*ashish*/data/SqlMapConfig.properties, but
the debug-output displays
com/*pfizer/maps*/data/SqlMapConfig.properties...
Niels
-Original Message-
From: Ashish Kulkarni [mailto:[EMAIL
You should escape the $, when using $$ iBATIS should skip it.
-Original Message-
From: German Gonzalez [mailto:[EMAIL PROTECTED]
Sent: maandag 11 juli 2005 16:25
To: user-java@ibatis.apache.org
Subject: Re: Auto-generated keys using Sybase
I have a similar problem, but with firebird db.
Title: Getting UncategorizedSQLException
True, but the UncategorizedSQLException is
not thrown by iBATIS, I believe it is from Spring or something like that, so it
should be related to the SQL itself. Could you please dump the complete
stacktrace instead of just saying some kind of
Did you try to escape the # using ##?
Niels
-Original Message-
From: Bing Qiao [mailto:[EMAIL PROTECTED]
Sent: dinsdag 2 augustus 2005 11:26
To: user-java@ibatis.apache.org
Subject: Temporary table causing problems?
This problem seems to only exist after 2.0.9b.550
I use queryForList
IFAIK this depencency is removed in 2.1.5. From the docs:
* If you want to use advanced logging you'll need one or both of the
following:
Commons Logging(http://jakarta.apache.org/commons/)
Log4J 1.2.8(http://logging.apache.org/log4j/docs/)
iBATIS selects the
Wat version are you using? Your error looks much like
http://issues.apache.org/jira/browse/IBATIS-148 which was fixed in 2.1.5
Niels
-Original Message-
From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED]
Sent: woensdag 3 augustus 2005 14:21
To: user-java@ibatis.apache.org
Subject: Re:
: woensdag 3 augustus 2005 14:40
To: user-java@ibatis.apache.org
Subject: Re: iterate over 2 collections
On Wed, Aug 03, 2005 at 02:23:34PM +0200, Niels Beekman wrote:
Wat version are you using? Your error looks much like
http://issues.apache.org/jira/browse/IBATIS-148 which was fixed in
2.1.5
Hi,
Are you using CGLIB? If not, iBATIS uses the Java
Proxy/Invocationhandler, which only handles interfaces. Somebody please
correct me if I'm wrong. If you look into EnhancedLazyResultLoader
you'll see that it does not only wrap instances of Collection.
Hope this clarifies something,
Niels
I would say:
select id=studentStatement resultClass=Student
SELECT id, fname, lname
FROM students
/select
queryForMap(studentStatement, null, id);
this would result in for example:
1 - Student1
2 - Student2
Or is this too simpleminded?
Niels
-Original Message-
From: Nathan Maves
it with your below example would
queryForMap(studentStatement, null, id, fname);
return a Map of
1 - Niels
2 - Nathan
On Aug 4, 2005, at 12:29 PM, Niels Beekman wrote:
I would say:
select id=studentStatement resultClass=Student
SELECT id, fname, lname
FROM students
/select
queryForMap
You may want to try jTDS (http://jtds.sf.net), it performs much better
than the MS-driver and contains less bugs, didn't try the new
SP4-version of the MS-driver though and I do not have experience with
stored procedures.
Niels
-Original Message-
From: Priyesh Mashelkar [mailto:[EMAIL
@ibatis.apache.org
Subject: Re: iterate
On Mon, Aug 08, 2005 at 04:29:42PM +0200, Niels Beekman wrote:
Something like this:
class MyBean {
public List getList() {
return mylinkedList;
}
}
iterate property=list open=( close=)
#[]#
/iterate
When passing the list directly as argument
@ibatis.apache.org
Subject: Re: iterate
#[]# is not valid ibatis token, there can't be property of empty name
and
when you address bean in a global manner (whole bean) you write value
Michal Malecki
On Tue, Aug 09, 2005 at 02:27:38PM +0200, Niels Beekman wrote:
You defined a parameter-class list
@ibatis.apache.org
Subject: Re: Logging?
On Wed, Aug 10, 2005 at 11:23:43AM +0200, Niels Beekman wrote:
Almost, in 2.1.5 the dependency on commons-logging has been removed,
so
just addding the log4j-libraries should do the trick.
It is just a wish.
Right now it won't work w/o the commons-logging
iBATIS has a legacy implementation for
DBCP, this is the implementation described in the docs, prefixed with Pool,
it also has a new implementation, you just specify the properties as mentioned
in the documentation you found on apache.org.
Legacy:
dataSource type=DBCP
property
Adam,
Can you simulate what happens when
t.execute(this.sqlMapClient)
throws an exception, so before you
explicitly close the session?
Niels
From: Clinton Begin
[mailto:[EMAIL PROTECTED]
Sent: maandag 15 augustus 2005
19:19
To: user-java@ibatis.apache.org
Subject:
Could you paste the JDBC-code, otherwise we are not getting any further
:)
Niels
-Original Message-
From: Rao, Satish [mailto:[EMAIL PROTECTED]
Sent: dinsdag 16 augustus 2005 16:47
To: user-java@ibatis.apache.org
Subject: RE: ArrayDescriptor issue
I tried it again. It works with
Hi,
I'm facing this exact same problem however in a somewhat different
context, see the following archived thread:
http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg025
80.html
http://www.mail-archive.com/user-java@ibatis.apache.org/msg00036.html
I recently restarted my
with this approach.
Thanks,
Brian Barnett
-Original Message-
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 17, 2005 3:00 PM
To: user-java@ibatis.apache.org
Subject: RE: Transaction question
Hi,
I'm facing this exact same problem however in a somewhat
You need to choose between compareProperty or compareValue...
What you are trying to do requires the following:
IsNotEqual prepend= OR property=test compareValue=-1/
The attribute compareProperty would be used to compare against another
property...
Niels
-Original Message-
From:
Hi,
The java.sql.*-outputs are from iBATIS too,
java.sql does not do any debugging on its own What logging did
you expect?
Niels
From: Paul Glezen
[mailto:[EMAIL PROTECTED]
Sent: woensdag 31 augustus 2005
18:16
To: user-java@ibatis.apache.org
Subject: iBatis logging
Hi,
You should definitely try things out, you'll be surprised how many
constructs are supported in iBATIS :)
iterate prepend=AND property=userList
open=( close=) conjunction=OR
telephonenumber = #userList[].number# AND
name = #userList[].name#
/iterate
Or maybe even:
Title: Mapping across namespaces
Are you including CategoryValue.xml before
User.xml? iBATIS currently has a loading-order dependency, so all statements
referenced should already be loaded
Niels
From: Patrick
Lightbody [mailto:[EMAIL PROTECTED]
Sent: woensdag 7 september
]
www.jivesoftware.com
317 SW Alder, Ste 500
Portland, OR
97204
ph (503) 295-6552
fx (503) 961-1047
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 07,
2005 10:23 AM
To: user-java@ibatis.apache.org
Subject: RE: Mapping across
namespaces
Are you including
I do not know PostgreSql very well, but could
it be that you have to explicitly specify the JDBC-type, as in Oracle?
Niels
From: Zarar Siddiqi
[mailto:[EMAIL PROTECTED]
Sent: dinsdag 13 september 2005
15:15
To: user-java@ibatis.apache.org
Subject: Postgres - inserting null
Any new information about this? Would be
nice if we can redirect users to the FAQ again J
From: Clinton Begin
[mailto:[EMAIL PROTECTED]
Sent: woensdag 31 augustus 2005
19:00
To: user-java@ibatis.apache.org;
user-cs@ibatis.apache.org; dev@ibatis.apache.org
Cc: Confluence Support
Does the query work with plain JDBC? In MS SQL TABLE is a reserved
keyword and should be escaped using [TABLE].
Niels
-Original Message-
From: Joachim Hoffmann [mailto:[EMAIL PROTECTED]
Sent: woensdag 14 september 2005 19:10
To: user-java@ibatis.apache.org
Subject: example for mapping
Hi,
I looked at the source code, and I believe you are right, iBATIS
performs null-checking, but only when invoking methods; i.e.
entity.getFoo().getX(), when the proxied (lazily loaded) result is null,
null is returned as method-result. The proxy, however, is created
immediately.
The reason for
Hi,
It is definitely there:
!ELEMENT context (transactionManager,
dao*)+
!ATTLIST context
id
CDATA #IMPLIED
Niels
BTW You should use the DTD located at
apache, http://ibatis.apache.org/dtd/dao-2.dtd
From: Agilan Palani
[mailto:[EMAIL PROTECTED]
Sent: woensdag 5
No, but there is already a JIRA-issue, you
could vote for it:
http://issues.apache.org/jira/browse/IBATIS-22
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: woensdag 5 oktober 2005
20:53
To: user-java@ibatis.apache.org
Subject: setQueryTimeout
Is there a way to
Hi,
You could use the TypeHandlerCallback-interface.
sqlmap:
resultMap id=myResultMap class=myClass
result column=myColumn property=myProperty
typeHandler=MyHandlerCallback/
/resultMap
MyHandlerCallback.java:
class MyHandlerCallback implements TypeHandlerCallback {
...
public Object
Title: Inserting null into SQLServer DATETIME field
Hi,
java.sql.Types.DATETIME does not exist in
Java 1.4, we use TIMESTAMP, see the API of your Java-version
Niels
From: Matthew Hegarty
[mailto:[EMAIL PROTECTED]
Sent: woensdag 19 oktober 2005
11:01
To:
configure ibatis to use naming-factory-dbcp.jar that
is
always there.
Zsolt
-Original Message-
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 9:16 AM
To: user-java@ibatis.apache.org
Subject: RE: How to use tomcat's naming-factory-dbcp.jar
You should
You only defined the typehandler for resultmaps (reads), to make it also work
with updates and inserts, you need to:
- define a parameterMap with the typehandler
- declare typehandler globally in the config using the typehandler-tag
When you choose the latter option, you can remove the
: vrijdag 21 oktober 2005 12:48
To: user-java@ibatis.apache.org
Subject: RE: How to use tomcat's naming-factory-dbcp.jar
Does it mean that I cannot use directly the tomcat dbcp library?
zsolt
-Original Message-
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Friday, October 21, 2005 10
http://opensource2.atlassian.com/confluence/oss/display/IBATIS/What+caus
es+an+Invalid+column+type+error+with+Oracle
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: maandag 31 oktober 2005 17:17
To: user-java@ibatis.apache.org
Subject: error inserting null
Just a guess, can you try to remove the CDATA-tags? There have been a
number of people that reported similar issues.
Niels
-Original Message-
From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 november 2005 2:01
To: user-java@ibatis.apache.org
Subject:
This feature has been available as of JDBC 3.0 (so actually JDK1.4), but
is not available in iBATIS. There is already an issue in JIRA for it, so
you could vote for it to increase the chance it gets implemented (I
believe):
http://issues.apache.org/jira/browse/IBATIS-142
Niels
decided to stick to what works ok: inline parameters.
After finishing this project i'll try to look into this issue and
maybe write a Wiki entry about it with my findings.
Cheers,
Daniel Silva
On 11/2/05, Niels Beekman [EMAIL PROTECTED] wrote:
Just a guess, can you try to remove the CDATA-tags
Could you post your complete resultMap?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: maandag 31 oktober 2005 20:41
To: user-java@ibatis.apache.org
Subject: error while using a CTH
Here is the error.
com.ibatis.dao.client.DaoException: Error executing
No, that doesn't work, I tried that too.
You could create a JIRA-issue for it...
Niels
From: 张鑫宇 [mailto:[EMAIL PROTECTED]
Sent: donderdag 3 november 2005 14:52
To: user-java@ibatis.apache.org
Subject: Does iterate tag conjunction property support
It doesn't, it just skips results in the ResultSet I believe. If you
want to get optimal performance, roll your own implementation of paging
and use the LIMIT/OFFSET statements, however, it won't be
database-independent.
Niels
-Original Message-
From: Eugeny N Dzhurinsky [mailto:[EMAIL
I think you can leave out the property-attribute.
Niels
-Original Message-
From: Steven Pannell [mailto:[EMAIL PROTECTED]
Sent: vrijdag 4 november 2005 17:05
To: user-java@ibatis.apache.org
Subject: Use isNull (in sqlMap) with a Long value?
Hi,
I want to make use of the isNull option
I checked the postgres driver (I did not find a useful map on the
website), the methods getBytes() and setBytes() are ported directly to
the native bytea-datatype.
I think it works out-of-the-box :)
Niels
-Original Message-
From: Alan Chandler [mailto:[EMAIL PROTECTED]
Sent: maandag 7
If sequenceName is a property available to iBATIS at runtime, you can
use:
SELECT $sequenceName$.nextval FROM dual
iBATIS replaces the $'s with the value of the property, the #'s are for
setting parameters in a prepared statement.
Hope this helps,
Niels
-Original Message-
From: Tom
Hi,
Type aliases in iBATIS can be specified in two places: the main config
and in SQLMaps. I looked at the source of iBATIS and saw that the types
aliases are just put in one big Map.
I would like to see the behaviour of type aliases:
- aliases defined in the main config are global (just as
You should use removeFirstPrepend=true on the dynamic-tag, this causes iBATIS
to skip the first prepend encountered.
Hope this helps,
Niels
From: John Chien [mailto:[EMAIL PROTECTED]
Sent: maandag 14 november 2005 18:30
To: user-java@ibatis.apache.org
You should use the DTD (http://ibatis.apache.org/dtd/sql-map-2.dtd).
The property is actually nullValue, in your example:
When iBATIS finds -999 in the Dummy.id-property
it will insert null into the database, when null is found in the database,
iBATIS will put -999 in the
I don't want to insert null in the
database, i want to insert -1 because the database column is set to not null.
Maybe Ibatis does not support this.
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Monday, November 14, 2005
2:28 PM
To: user-java@ibatis.apache.org
Subject: RE
2005 14:34
To: user-java@ibatis.apache.org
Subject: Re: New doctype won't work
Thanks you for the quick answer. Does this mean that I will have to
change it again with a future revision of iBatis ? Or will the
//iBatis.com be recognize too in future releases ?
Niels Beekman a écrit :
iBATIS uses
You cannot use the attribute id on the sqlMap-tag (hence the parser
complains that you are using an attribute that is not defined in the DTD
for that tag):
sqlMap id=LabelValueSQL
should just be:
sqlMap
Be sure to use a DTD-validating XML-editor, these errors are much harder
to debug without
Nope, that's why database servers got invented :) Of course you can
cache the objects, but that was probably not your question.
The MS SQLServer documentation contains lots of information about how it
uses memory for caching, maybe you should take a look at it.
Niels
Larry means iterating your list, that would still result in one query,
but one that works and still protects against SQL injection.
Niels
-Original Message-
From: Michael Laccetti [c] [mailto:[EMAIL PROTECTED]
Sent: donderdag 8 december 2005 23:12
To: user-java@ibatis.apache.org
$-s are for SQL injection werent
they J
!-s can be used as operators (SELECT *
FROM bla WHERE foo != bar)
-s can be used to delimit strings,
so this would require old uses of to be escaped (am I right?)
|-s can be used as string concatenator
So the only viable option left is @ I
Hi,
You should change the resultmap, you have to specify the columnName of
the value you would like to pass to findPermissionByUserId:
resultMap id=UserResultMap class=User
result property=userId column=UserId/
result property=permissions column=UserId
Try setting resultClass to String,
you told iBATIS already that you want a List by using queryForList().
From: radha rukmani
[mailto:[EMAIL PROTECTED]
Sent: maandag 9 januari 2006 16:35
To: user-java@ibatis.apache.org
Subject: parameter map
Hi
I am trying to
You could use a typehandler to do that:
http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+
use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe+Enumeration
Niels
-Original Message-
From: Olivier Antoine [mailto:[EMAIL PROTECTED]
Sent: donderdag 19 januari
IBatis indeed works very well with itself :)
I think you are wrong on the interpretation of the exception, namespace is
not declared for element sqlMap actually means you have used the attribute
namespace, but it is not declared in (allowed by) the DTD.
Niels
-Original Message-
From:
This is currently not possible, you can vote for it at:
http://issues.apache.org/jira/browse/IBATIS-94
Niels
From: Eric Blue [mailto:[EMAIL PROTECTED]
Sent: zaterdag 28 januari 2006 3:12
To: user-java@ibatis.apache.org
Subject: Getting object access to
You must either use the iterate-tag (recommended, see previous posts about
this) or use $-syntax: IN ($provinces$).
Related Wiki for $-syntax (linewrap):
http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+pass+in+a+dynamic+table+name+-+or+other+uncommon+parameters
Niels
Hi,
The usage of ? is AFAIK not related to the procedure-tag, but just
general iBATIS syntax, you can use two ways of passing parameters to
queries:
- use the parameterMap-attribute and ?'s, the order in the parametermap
is the order iBATIS uses to populate the ?'s
- use the
Just in case: did you use the selectKey-element within your insert statement?
Niels
From: Zhongmin Chen [mailto:[EMAIL PROTECTED]
Sent: woensdag 1 februari 2006 22:03
To: user-java@ibatis.apache.org
Subject: Insert returned object is NULL
Hi,
I am using
Hi,
I'm not sure I understand your question, but the iterate-tag supports
(amongst others) all Collection implementations (so ArrayList is supported) and
arrays. You do not have to change anything in your first query to make it work.
The []-syntax is there to let iBATIS know it should retrieve
Hi,
This has been discussed several times now on this mailing list, the
short answer is no, the longer answer: it is already in JIRA, find the
issue and vote for it, or even better, contribute it yourself.
Grtz,
Niels
-Original Message-
From: Richard Lin [mailto:[EMAIL PROTECTED]
You need to tell the iterate-tag which property to iterate:
iterate property=accountIdList open=ACCOUNTS.ID IN ( close=)
conjunction=,
#accountIdList[]#
/iterate
Niels
From: Amad Fida [mailto:[EMAIL PROTECTED]
Sent: woensdag 8 maart 2006 12:35
Hi,
You provided the following properties in a previous mail:
property name=SetAutoCommitAllowed value=false/
property name=DefaultAutoCommit value=false/
Change SetAutoCommitAllowed to true and it will work.
Niels
-Original Message-
From: Cesar Villar [mailto:[EMAIL PROTECTED]
Which version are you using? The latest iBATIS version resolve all DTD's
from the jar, so you do not have to access the internet.
Niels
-Original Message-
From: Gordon Shankman [mailto:[EMAIL PROTECTED]
Sent: woensdag 15 maart 2006 12:25
To: user-java@ibatis.apache.org
Subject: DTD URL
...
FROM dbo.PURCHASE_HEADER t where order_no = #value#
/select
-Original Message-
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Monday, March 20, 2006 2:02 PM
To: user-java@ibatis.apache.org
Subject: RE: Complex property question
Hi Niels,
Can we see the definition
-class,
introduce a new select.
Niels
BTW 'single column could be the source
for several properties' should work just fine...
-Original Message-
From: Voorhoeve, Niels {PBG} [mailto:[EMAIL PROTECTED]
Sent: dinsdag 21 maart 2006 17:56
To: Niels Beekman
Subject: RE: Complex property question
You cannot use an iterated property in the decision tags. I believe
there is a JIRA issue for this.
isNotNull property=contentBeanTrees[].detailsTable -- not allowed
Niels
-Original Message-
From: Daniel Pitts [mailto:[EMAIL PROTECTED]
Sent: woensdag 22 maart 2006 2:44
To:
And how would that error look like? Seems like this should work just
fine.
Niels
-Original Message-
From: Sol [mailto:[EMAIL PROTECTED]
Sent: woensdag 22 maart 2006 18:04
To: user-java@ibatis.apache.org
Subject: Sql Map self call
I all, i'm totally new to IBatis so i need some piece of
Yes, you cannot parameterize clauses in SQL.
Use the $-syntax: AND $shows$
Niels
-Original Message-
From: Bob [mailto:[EMAIL PROTECTED]
Sent: donderdag 23 maart 2006 9:38
To: user-java@ibatis.apache.org; [EMAIL PROTECTED]
Subject: Re: sql server 2k parameterized queries
On 23/03/06,
You should really take a look at the docs,
its all there
Niels
From: Zsolt
[mailto:[EMAIL PROTECTED]
Sent: donderdag 30 maart 2006 8:14
To: user-java@ibatis.apache.org
Subject: RE: How to convert
BLOB/CLOB to String.
I dont want to
convert all BLOBs to String only for
Title: Need Help with JNDI Connection
Should be:
name=cams should be: name=DataSource
Niels
From: Ali, Mohammed
(Liquidity Risk Technology) [mailto:[EMAIL PROTECTED]
Sent: maandag 17 april 2006 18:07
To: user-java@ibatis.apache.org
Subject: Need Help with JNDI
Connection
You are probably using getDao(abc.dao.sqlmap.SqlMapDao.class) while you
should use getDao(com.abc.dao.ContentOrderDao)...
Niels
-Original Message-
From: Hendry [mailto:[EMAIL PROTECTED]
Sent: maandag 1 mei 2006 11:24
To: user-java@ibatis.apache.org
Subject: about dao implementation
Hi
PM 5/3/2006, Niels Beekman
wrote:
Hi,
Could you post the actual typehandler code and the piece of SQLMap where
you use it?
-Original Message-
From: Paul Allen [
mailto:[EMAIL PROTECTED]]
Sent: woensdag 3 mei 2006 18:32
To: user-java@ibatis.apache.org
Subject: boolean type handler
Thats very strange, since
queryForMap() uses queryForList() internally. Is there a proper getter in class
com.mycompany.ecommerce.ProductCategory for the productCategoryId
property?
Niels
From: Firas A.
[mailto:[EMAIL PROTECTED]
Sent: dinsdag 9 mei 2006 20:05
To:
productCategoryId) in ProductCategory class.
Butwhy queryForMap returns only the last row from the
resultset?
Thanks again!
/Firas
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: den 9 maj 2006 20:28
To: user-java@ibatis.apache.org
Subject: RE: queryForMap
Are you using the DTD for your sqlmap configfile? There is no such
element typeHandlers...
Niels
-Original Message-
From: Tracey Annison [mailto:[EMAIL PROTECTED]
Sent: maandag 15 mei 2006 9:20
To: user-java@ibatis.apache.org
Subject: RE: Problem with using generic and specific custom
Of course, you do nothing with the newAdministrator variable. You are
just restoring the data that already exists. You should update using
something like this:
Administrator administrator = new Administrator();
Administrator.setId(2);
administrator.setJmeno(Ivan);
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+u
se+LIKE+in+my+queries
-Original Message-
From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED]
Sent: woensdag 17 mei 2006 11:52
To: user-java@ibatis.apache.org
Subject: like and '%'
Is it possible to pass some
Hi,
I dont know if the article is written by one of the
list regulars, but I just added a link to the Wiki. Didnt read it yet,
but at first glance, it looked ok.
http://www.devx.com/Java/Article/31481
Niels
Hi,
Maybe http://forum.java.sun.com/thread.jspa?threadID=567285tstart=180?
I think it definitely has to do with the config, as the stacktrace lists
SqlMapConfigParser.parse().
Did you put the config files in the right place?
Niels
-Original Message-
From: Eric Bauld [mailto:[EMAIL
I think your typehandler.valueOf() implementation is incorrect. The
string passed to it is the string you specified in the attribute
nullValue. You should do something like:
public Object valueOf(String s) {
return Y.equals(s);
}
Niels
-Original Message-
From: Rick Reumann
I think you can use resultmap extension,
first define a resultmap for the 3 properties, then create a new one that
extends it with the other 17 fields.
HTH,
Niels
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: donderdag 18 mei 2006 14:26
To:
You specified SetAutoCommitAllowed=false, that instructs iBATIS to leave the
default autocommit setting (true) in place, which causes automatic commits,
unless an SQLException occurs when executing a statement. Changing it to true
will cause iBATIS to use the DefaultAutoCommit setting.
Niels
It would indeed be nice if iBATIS told you the file to look in, but this
is just an XML validation error and should be easy to spot if you use a
decent editor with DTD-validation.
Niels
-Original Message-
From: rs [mailto:[EMAIL PROTECTED]
Sent: woensdag 24 mei 2006 19:21
To:
Your constructor is package-level accessible, change it to public:
public class OrderIbatisDao extends SqlMapDaoTemplate implements
IOrderDao{
_public_ OrderIbatisDao(DaoManager daoManager){
super(daoManager);
}
}
-Original Message-
From: levan Dvalishvili
Maybe you can fiddle with the order of the
properties, see http://support.microsoft.com/kb/824106.
Niels
From: RZG
[mailto:[EMAIL PROTECTED]
Sent: woensdag 14 juni 2006 16:15
To: user-java@ibatis.apache.org
Subject: about sqlserver2000 text
and ntext field
hi all,
I believe the connection refused
is actually the result of the wrong DOCTYPE declaration, the DTD cannot be
resolved.
Niels
From: Jeff Butler
[mailto:[EMAIL PROTECTED]
Sent: maandag 19 juni 2006 16:25
To: user-java@ibatis.apache.org
Subject: Re: Ibatis DAO XML
problem
This information is closer to the one I
get from google about this problem. How can I solve this? Also, I've already
fixed the other observations from Jeff.
Thanks,
CMS
-Mensagem original-
De: Niels
Beekman [mailto:[EMAIL PROTECTED]
Enviada em: segunda-feira, 19 de
junho de 2006
That should work, yes. Do you get any exceptions? I believe
resultClass=java.util.Map should be changed to a concrete
Map-implementation, for example resultClass=java.util.HashMap.
Niels
-Original Message-
From: jaybytez [mailto:[EMAIL PROTECTED]
Sent: woensdag 21 juni 2006 17:12
To:
Do you get any results if you just print the results of queryForList()?
I just tried something like your example and it worked perfectly well,
however, I did find that when you specify an incorrect property, iBATIS
does _not_ complain and just returns null, that sounds like a bug.
Niels
That should really work out, namespaces are not automatically preprended to the
statement names (they should be IMHO). Can you give us a stacktrace?
Niels
-Original Message-
From: Serafín Orillán Chaparro [mailto:[EMAIL PROTECTED]
Sent: dinsdag 27 juni 2006 11:25
To:
Does the modificacion exist somewhere in your sqlmap-file? You excluded some
parts by replacing it with ..., so I cannot verify that.
Second, the commented select uses a resultClass while the uncommented select
uses a resultMap, but I don't think that matters in this case.
Niels
-Original
So when you use:
cacheModel id=cacheConsulta type=LRU
flushInterval minutes=30/
flushOnExecute statement=operadores.alta/
flushOnExecute statement=operadores.baja/
flushOnExecute statement=operadores.modificacion/
property name=size value=100 /
/cacheModel
it fails in exactly
Yes, that should work out just fine. See the Developer Guide for some
examples...
-Original Message-
From: Vadim Grinshpun [mailto:[EMAIL PROTECTED]
Sent: woensdag 28 juni 2006 20:58
To: user-java@ibatis.apache.org
Subject: flexible queries?
Hi everyone,
Suppose I have a query where I
you take another look at it, please, or explain in more detail?
Thanks!
-Vadim
Niels Beekman wrote:
Yes, that should work out just fine. See the Developer Guide for some
examples...
-Original Message-
From: Vadim Grinshpun [mailto:[EMAIL PROTECTED]
Sent: woensdag 28 juni 2006 20:58
Look more closely to the example Jeff posted, the DAO manager links a
DAO-interface to a concrete implementation (see interface and
implementation attributes in the DAO config). Something like:
OdmLinkDAO linkDao = (OdmLinkDAO)daoManager.getDao(OdmLinkDAO.class);
Niels
-Original
As for the first problem:
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+POUND+or+DOLLAR+symbols+in+my+queries
Second one I don't know.
Niels
From: vishakha sawant [mailto:[EMAIL PROTECTED]
Sent: woensdag 5 juli 2006 10:43
1 - 100 of 237 matches
Mail list logo
