On Thu, Sep 21, 2006 at 10:31:02AM -0600, [EMAIL PROTECTED] wrote:
You're only going to want to create temporary tables when the connection is
created, not at the beginning of every transaction.
Depending on what kind of connection pool you're using, you may be able to
use their connection
On Wed, Sep 20, 2006 at 09:59:12AM -0600, [EMAIL PROTECTED] wrote:
This sounds like it could be solved by a connection lifecycle event handler
that Clinton mentioned on Sept. 16th:
http://www.mail-archive.com/user-java@ibatis.apache.org/msg06174.html
Strangely, I've actually needed this
On Tue, Sep 19, 2006 at 03:40:43PM +0300, Eugeny N Dzhurinsky wrote:
Hello!
I have a problem - my application creates temporary views for set of talbes
and then I would like to execute some queries on this view using iBATIS. For
postgresql the temporary view is alife unless the connection
Hello!
I have a problem - my application creates temporary views for set of talbes
and then I would like to execute some queries on this view using iBATIS. For
postgresql the temporary view is alife unless the connection is closed, so my
workflow might looks like this:
1) get the connection from
I'm trying to do this:
statement id=prepareView parameterClass=list
create temporary view task_url_view as
dynamic
iterate conjunction= union all
select * from task_url_$values[]$
/iterate
/dynamic
/statement
but this seems
On Tue, Sep 19, 2006 at 04:01:38PM +0300, Eugeny N Dzhurinsky wrote:
I'm trying to do this:
statement id=prepareView parameterClass=list
create temporary view task_url_view as
dynamic
iterate conjunction= union all
select * from task_url_
On Tue, Sep 19, 2006 at 03:56:43PM +0200, Niels Beekman wrote:
Try using $value[]$ or maybe $[]$.
Using #'s is probably not going to work, since most databases do not
support dynamic tablenames.
The $[]$ solved problem, but $value[]$ doesn't work for some reason.
--
Eugene N Dzhurinsky
On Mon, Aug 14, 2006 at 10:43:15AM -0600, Nathan Maves wrote:
Eugeny that is why I asked what jdk you are using. If you can run
java 1.5 you will not have these issues.
java -version
java version 1.5.0-p3
Java(TM) 2 Runtime Environment, Standard Edition (build
On Wed, Aug 16, 2006 at 07:22:22AM -0600, Larry Meadors wrote:
So does this make the error go away?
Yep.
If the database allows null values, you really don't want to use an
int - and you are discovering why.
Even with JDK5 and auto-boxing, if you try to assign a null to an int,
On Mon, Aug 14, 2006 at 09:38:02AM -0600, Larry Meadors wrote:
The simplest solution is for you to make the setters for the
properties on com.project.Entity.Task not throw NPEs. ;-)
The thing is I don't have methods whch are throwing MPEs. I found such thing
happens when setProperty(int
Hello!
Is it possible somehow to use several databases for single SqlMapClient
instance?
For example, I would like to use queries in namespace spider to be executed
on MySQL, and queries in the reset namepaces to be executed on PostgreSQL, w/o
creating 2 instances of SQL map clients.
--
Eugene
Hello!
When passing null as parameter value for postgresql, the exception is being
thrown: org.postgresql.util.PSQLException: Unknown Types value
I tried to alter my query for like this: insert into table (field)
(#value#::varchar) but that didn't solve issue. Could somebody please help?
--
When using gnujaxp.jar java.lang.StackOverflowError occurs when iBATIS tries
to parse XML file.
JDK 1.4.2-p8 on FreeBSD 5.5
--
Eugene N Dzhurinsky
Is it possible to pass some parameter and wrap it with %%?
Something like this:
select * from table where name=%#param%
to ensure parameters will be escaped as well?
--
Eugene N Dzhurinsky
Could somebody please tell me, is it possible to use nested loops or
conditions inside loops in current version of iBATIS?
--
Eugene N Dzhurinsky
I seem to miss something - I configured JNDI resource in context like this
Context path=/myapp
Realm className=org.apache.catalina.realm.JAASRealm appName=PortalRealm
userClassNames=com.liferay.portal.jaas.PortalPrincipal
roleClassNames=com.liferay.portal.jaas.PortalRole debug=99
exception is
ERROR 22/07/06 02:07:51 [http-8280-Processor24] (DevCasePortlet:75) -
java.lang.RuntimeException: Error initializing class. Cause:
com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause:
com.ibatis.common.xml.NodeletException: Error parsing XML. Cause:
On Wed, Feb 22, 2006 at 08:26:22AM -0600, Jeff Butler wrote:
Try this:
property name=DataSource value=java:comp/env/jdbc/DBConn /
that seem to work... Strange, so I should add prefix /comp/env ? May be there
are some other common prefixes for iBATIS not described in documentation? =)
--
On Wed, Feb 22, 2006 at 03:37:26PM +0100, Cimballi wrote:
This a Tomcat specific prefix, not iBatis.
Cimballi
Well, I'm not sure about that, because I'm using OSWorkflow and it uses
another JNDI resource, specified like this:
propertysets
propertyset name=jdbc
Can somebody please explain how this work? I need to show results from some
table, i'm using limit/offset statements in SQL query, but I saw iBATIS can
handle pages in result set somehow, so I might not be forced to add
limit/offset statements in the SQL clauses. But I'm wandering how does iBATIS
On Thu, Nov 03, 2005 at 04:07:11PM +0100, Niels Beekman wrote:
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.
Okay,
On Fri, Nov 04, 2005 at 08:22:29AM +0100, Zsolt wrote:
The MySql driver loads everything into the memory (unless you use LIMIT),
thus if paginated list just skips records it seems to be use less. Its
functionality can be replaced with List.subList(int fromIndex, int toIndex).
My log just
On Tue, Oct 25, 2005 at 10:23:54AM -0500, Jeff Butler wrote:
Hmmm...another undocumented feature :(
From browsing through the source code, it looks like you can do this:
dataSource type=JNDI
property name=DataSource value=somevalue/
property name=context.java.naming.provider.url
Hello! Just a question - I have DataSource, registered in JNDI on some
another server. How should I specify the name and location of that DataSource
in db.properties/connection tag?
--
Eugene N Dzhurinsky
On Tue, Oct 25, 2005 at 10:00:31AM -0500, Jeff Butler wrote:
I would say it's not *exactly* singleton, but close enough. And it certainly
works. As to the question why not this?, I have these thoughts:
jokingIt's not cool as cool as the other ways, and we're all about
cool/joking
On a more
On Tue, Sep 13, 2005 at 11:47:14AM +0200, Joachim Hoffmann wrote:
Are there any plans for the integration of iBatis into Ecplise 3.1?
... e.g in order to use an XML editor from within the IDE and be able to
benefit from Refactoring, e.g class rename, and package rearrangement
I'm a bit weary
Is there simple way to load/store HashMap in the database using the BLOB column
and iBATIS? I can think about getting BLOB as byte array and then create
HashMap from this byte array.
--
Eugene N Dzhurinsky
Is there any way to specify the path where to search for the mapping files?
I simply don't want to store the iBATIS files in the WEB-INF/classes for my
WEB application
--
Eugene N Dzhurinsky
On Wed, Aug 10, 2005 at 11:19:42AM +0200, [EMAIL PROTECTED] wrote:
Hi, I think a very simple question: how to log in Log4J with iBatis 2.1.5?
I'm using IBM Rational Software Development Platform Version: 6.0.0.1 and
iBatis 2.1.5 and I've configured log4j.properties file this way:
you need to
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 libraries.
--
Eugene N Dzhurinsky
On Wed, Aug 10, 2005 at 07:36:19AM -0500, Mitchell, Steven C wrote:
That is a question for IBM. If you have a JUnit test you can run from the
command line logging works fine and you can see all the detail you need. It
just doesn't work from inside of RAD. Let me know if you find the answer
On Wed, Aug 10, 2005 at 05:57:05PM +0200, [EMAIL PROTECTED] wrote:
Hi,
I had commons-logging.jar and log4j-1.2.8.jar in my project classPath
and didn't see logs from iBatis.
I tried to add even commons-logging-api.jar to the classPath but nothing
changed...
I'm starting thinking it is
On Mon, Aug 08, 2005 at 07:46:51PM +0200, Niels Beekman wrote:
Read carefully, my second sample uses the list directly:
When passing the list directly as argument use:
iterate open=( close=)
#[]#
/iterate
what's wrong here:
select id=getRules parameterClass=list
On Tue, Aug 09, 2005 at 02:27:38PM +0200, Niels Beekman wrote:
You defined a parameter-class list, this is java.util.List, then you
iterate over 'something' which does not exist. If you pass a single
parameter (like you do now) do not use the attribute 'property' of the
iterate-tag:
select
On Tue, Aug 09, 2005 at 07:37:56AM -0500, Mitchell, Steven C wrote:
We cheat. In our insert method we manually get the next id from the
sequence, assign that value to a property of the object being inserted,
and then do the insert.
Seems i will be forced to use last_insert_id...
Ok.
--
On Tue, Aug 09, 2005 at 02:47:04PM +0200, Niels Beekman wrote:
That's weird, the iBATIS JUnit-tests use this construction numerous
times and yet do not fail. That's why I assumed it should work, I do not
use it myself...
Very nice =)))
Unit tests are testing something which is not legal, and
On Tue, Aug 09, 2005 at 04:57:01PM +0300, Koka wrote:
Have a look at selectKey in
http://prdownloads.sourceforge.net/ibatisnet/DevGuide.pdf?download
Cool!
thanks!
--
Eugene N Dzhurinsky
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 use:
iterate open=( close=)
On Mon, Aug 08, 2005 at 07:46:51PM +0200, Niels Beekman wrote:
Read carefully, my second sample uses the list directly:
When passing the list directly as argument use:
iterate open=( close=)
#[]#
/iterate
Niels
Ahh, i missed it
Thanks a lot =)
--
Eugene N Dzhurinsky
On Wed, Aug 03, 2005 at 09:25:24PM -, sreenivas wrote:
Hi,
I would like to know whether or not below approach is possible with iBATIS.
select id =getEmpDetails parameterClass = com.abc.Input resultClass =
com.abc.Output select emp_name as eName, emp_sal as eSal from emp where
emp_id =
On Wed, Aug 03, 2005 at 04:20:57PM -0600, Nathan Maves wrote:
I think a union is only a good solution when the data from both
queries can be combined into one column.
Not really, the columns should be ordered to have the same types
in the order, so there is an ability to query for several
I'm running the application at Jakarta tomcat 5.0, may be that's the clue?
An log statements from my application are logged w/o any problems.
and log4j-1.2.9.jar is located under WEB-INF/lib in my application, and
is working fine, just the iBATIS don't see it for some reason :(
--
Eugene N
I have a query like this:
statement id=dynamicGetRule
resultClass=com.greenvalley.TMS.MML.Entity.Rule
select distinct r.rule_id,r.name,r.description from rule r left join
rule_field rf
on r.rule_id = rf.rule_id
dynamic prepend= WHERE
isNotNull prepend= AND property=name
Or may be it is possible to use the iterator on the complex types somehow?
--
Eugene N Dzhurinsky
On Wed, Aug 03, 2005 at 10:40:46AM +0100, James, Steven wrote:
did you try it and what were the errors..
for now I'm trying to play with this query.
statement id=dynamicGetRule
resultClass=com.greenvalley.TMS.MML.Entity.Rule
select distinct r.rule_id,r.name,r.description from rule r
On Wed, Aug 03, 2005 at 01:25:47PM +0300, Eugeny N Dzhurinsky wrote:
On Wed, Aug 03, 2005 at 10:40:46AM +0100, James, Steven wrote:
did you try it and what were the errors..
for now I'm trying to play with this query.
And finally that's it:
d=dynamicGetRule resultClass
On Wed, Aug 03, 2005 at 01:07:25PM +0100, James, Steven wrote:
Can we see the parameter class?
the rule(parameter) class
import java.util.ArrayList;
import java.util.List;
public class Rule extends iBATISSearchable {
private static final String RULE_SEARCH_COUNT_SQL =
On Wed, Aug 03, 2005 at 01:47:45PM +0100, James, Steven wrote:
if this is just an issue with isnotnull could you not just add a geter
int getFieldsize(){
return fields.size();
}
then in the xml map
isGreaterThan property=fieldSize compareValue=0
/isGreaterThan
or is this an issue with
Sorry to all, I've found it in the developers guide. Really nice, iBATIS rocks
=)
--
Eugene N Dzhurinsky
49 matches
Mail list logo