Thank you Larry,
I also found that at startup we get a connection from the pool that is
not closed. But as far as I understand "Pool.MaximumCheckoutTime" should
guarantee that a connection cannot be used longer that 20 seconds (in
our case).
Do I miss something?
Zsolt
Larry Mea
e executed and
if not successful a new connection created.
I use ibatis-2.3.4.726. Does anybody have an idea?
Zsolt
2009-06-14 14:31:19,167 ERROR dao.impl.ProjectDaoImpl - iBATIS
exception [TP-Processor489]
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while
Nathan,
we do that.
Zsolt
Nathan Maves schrieb:
Sounds like you need to use a validation query to ensure your
connections are not stale.
On Sun, Jan 25, 2009 at 10:06 AM, Zsolt Koppany
mailto:zkoppanyl...@intland.com>> wrote:
Hi,
after getting the Exception below I get
Hi,
after getting the Exception below I get lot of database related Exceptions.
What happens if ibatis finds an invalid connection? Will that be removed
from the pool?
What should the application do to prevent such problems?
We use ibatis 2.3.4.726 with mysql-5.0.67.
Zsolt
2009-01-25 15
Hi,
which database pool is recommended for production usage? The pool
shipped with ibatis or dbcp?
We use ibatis 2.3.4.726.
Zsolt
ot to support (also stupid
parts) derby.
Zsolt
Larry Meadors schrieb:
Here's my opinion on this, for what it's worth.
Neither derby nor ibatis are at fault here - both are doing what is
expected: Working within the constraints of a standard API from Sun
(JDBC).
The real issue h
with derby (we
use an old derby driver) and this results make derby more attractive
because you just don't have the huge overhead of oracle (including the
installation problems).
Zsolt
Here is the answer from the derby list:
Bernt M. Johnsen schrieb:
>>>>>>>>>&
tests testing all possible NULL values.
We use ibatis-2.3.4.726.
How can we fix the problem?
Zsolt
com.intland.codebeamer.persistence.util.PersistenceException:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the createUser
artDate#, #endDate#, #estimatedHours#, #spentHours#,
#noOfAttachments#, #closedAt#, #indexed#, #deleted#)
${SELECTKEY_BEFORE_TABLE_NAME_SQL_PART}task${SELECTKEY_AFTER_TABLE_NAME_SQL_
PART}
Zsolt
_
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent:
Neils,
as I described it in a previous email we know this option with properties,
but that would me that we should modify a lot of classes additionally where
we pass a class as property we cannot set properties.
Zsolt
_
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Friday
ld do that setting the property from Dao but in this
case the Dao would be database dependent what we don't like.
Zsolt
SELECT $queryParams.fileNameField$ as fileName,
LENGTH($queryParams.blobFieldName$)
Larry,
are there better options that will work long term?
What is the recommended way today?
Zsolt
> -Original Message-
> From: Larry Meadors [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2008 3:55 PM
> To: user-java@ibatis.apache.org
> Subject: Re
Kai ,
we tried to upgrade from 2.3.0.677 to 2.3.4.726.
http://ibatis.apache.org/javadownloads.cgi
http://apache.linux-mirror.org/ibatis/binaries/ibatis.java/ibatis-2.3.4.726.
zip
We have to pre-process the SQL statements thus this problem is a
show-stopper for us.
Zsolt
> -Origi
Hi,
XmlConverter doesn't seem to be available in 2.3.4.726.
We extend that class to pre-process xml files.
What should we use instead of XmlConverter?
Zsolt
Hi,
Is a hierarchical cache available? We find it difficult to assure that a
second cache will be cleared if another cache got cleared.
Zsolt
Hi,
how can I use caching with rowhandler?
Zsolt
Larry,
thank you but it means form me approx. 400 statements.
Zsolt
Zsolt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Larry Meadors
> Sent: Saturday, September 08, 2007 4:43 PM
> To: user-java@ibatis.apache.org
> Cc
get a derby-client that works
as before or we cannot use derby in the future?
Zsolt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 07, 2007 9:16 AM
> To: Derby Discussion
> Subject: Re: Derby 10.3.1.4 not working with i
ctivated' AND
unused2 IS NULL
ORDER BY lastlogin DESC
$LIMIT$
Zsolt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Larry
VARCHAR(255)
Zsolt
_
From: Brandon Goodin [mailto:[EMAIL PROTECTED]
Sent: Friday, August 31, 2007 4:39 PM
To: user-java@ibatis.apache.org
Subject: Re: Not working with derby 10.3.1.4
What is your column type in derby? Apparently the JDBC driver is reporting
it as a type of
Hi,
I tried to upgrade to derby 10.3.1.4 but I get strange error messages that I
didn't get with derby 10.2.2.0.
I use ibatis-2.3.0.677.
Any ideas?
Zsolt
com.intland.codebeamer.persistence.util.PersistenceException:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The
Nathan,
I mean an external file.
INSERT ..;
INSERT ..;
DELETE .;
Zsolt
_
From: Nathan Maves [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 31, 2007 11:31 PM
To: user-java@ibatis.apache.org
Subject: Re: executing batch file
Not quite sure what you are asking? Do you have
Hi,
what ist he best way to execute a batch file? Does ibatis support it? If
not, could spring help me?
Zsolt
Jeff,
thank you but we have problems with WebSphere connection pool and I would
like to use the same pool implementation under TC & WS.
Is the ibatis pool not recommended for production use?
Zsolt
_
From: Jeff Butler [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 14, 200
ool OK for production
usage?
Zsolt
I know what causes the problem.
trackerItemDto.modifiedAt is java.util.Date but the value stored into
trackerItemDto.modifiedAt is a sub-class of java.util.Date.
How can I fix the issue.
I use ibatis-2.1.7.597.
Zsolt
> -Original Message-
> From: Grigoras, Vasile [mailto:
Koka,
No, definitely not. If trackerItemDto were null, I would get an NPE earlier.
Zsolt
_
From: Koka Kiknadze [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 06, 2007 12:35 PM
To: user-java@ibatis.apache.org
Subject: Re: Strange NullPointerException
Maybe parameter
k.j
ava:49)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520
)
Caused by: java.lang.NullPointerException
Zsolt
Zsolt
Hi,
the documentation does say to much about the sqlmap-config
"enhancementEnabled" option. What does that do?
Zsolt
Thank you Jeff,
Why is that necessary if
I pass (java.lang.Integer)null?
Zsolt
From:
Jeff Butler [mailto:[EMAIL PROTECTED]
Sent: Monday, October
09, 2006 4:34 PM
To: user-java@ibatis.apache.org
Subject: Re: iBATIS with the
embedded Derby JDBC driver
If a
the sqlType argument being 0 instead
of the type of the parameter.
We are using iBATIS 2.1.7.597. We did not dive into the iBATIS source
code but instead thought to ask here. Is this a known issue?
Zsolt
cacheModelsEnabled="false"
should do that.
Zsolt
maxTransactions="8" maxRequests="128"
errorTracingEnabled="true" />
From: Tom Stroobants
[mailto:[EMAIL PROTECTED]
Sent: Fri
Try mysql-4.1.19, it won’t
crash.
Zsolt
From: Clinton Begin
[mailto:[EMAIL PROTECTED]
Sent: Sunday, September 10, 2006
4:52 PM
To: user-java@ibatis.apache.org
Subject: Re: Ibatis crashing MySQL
when I use DATE_FORMAT
I agree with Brandon on
this oneespecially
You probably need bulk insert.
insert into ... values(...),(...)
That is very fast.
Zsolt
>-Original Message-
>From: Ralf Assmann [mailto:[EMAIL PROTECTED]
>Sent: Friday, September 01, 2006 2:22 PM
>To: user-java@ibatis.apache.org
>Subject: Bad Performance Using Ibatis
)? This would lead to overall greater control on how
iBATIS initializes.
Zsolt
Brandon,
can you send me the code
for JNDI mock?
Zsolt
From: Brandon Goodin
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 16, 2006 4:14
PM
To: user-java@ibatis.apache.org
Subject: Re: How to setup
datasouce programmatically?
I setup a mock JNDI
context. It is
Hi,
In most cases we get the data-source from tomcat via JNDI. But we need to
make tests also without tomcat (thus without JNDI).
How can we do that programmatically? The ideal solution would be if I could
do something like below.
Hi,
I get an exception if a use "
Hi,
does the cache size mean the number of queries will be stored or the total
number of fetched records?
Zsolt
I don’t want to
convert all BLOBs to String only for one table.
Zsolt
From: Clinton Begin
[mailto:[EMAIL PROTECTED]
Sent: Thursday, March 30, 2006
5:51 AM
To: user-java@ibatis.apache.org;
Balaji
Subject: Re: How to convert
BLOB/CLOB to String.
iBATIS comes with a
Thank you Gustavo.
Is it possible to configure ibatis to put the BLOB directly into a string?
Zsolt
>-Original Message-
>From: Gustavo Henrique Sberze Ribas [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, March 14, 2006 12:11 PM
>To: user-java@ibatis.apache.org
>Subject: RE:
can I fix that?
I use ibatis-2.1.7.597.
zsolt
Hi,
which version is the official version: 2.1.6 or 2.1.5? I need it for
production.
Zsolt
I want to process the items once if they DO NOT come from the cache.
Zsolt
>-Original Message-
>From: Zarar Siddiqi [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, December 07, 2005 4:47 PM
>To: user-java@ibatis.apache.org
>Subject: Re: How to figure out whether the results
I have the problem also with ibatis-2.1.6.589 and that is pretty new.
Zsolt
>-Original Message-
>From: Voorhoeve, Niels {PBG} [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, December 07, 2005 4:26 PM
>To: user-java@ibatis.apache.org
>Subject: RE: Does Read/Write cache work
Hi,
How to figure out whether the results are coming from the cache or newly
fetched from the database?
Zsolt
t want to do that for all list manually.
...
Zsolt
Hi,
How can I use "groupBy" in resultMap more than once?
Zsolt
Hi,
Which is the current stable version: 2.15 or 2.1.6?
Zsolt
Is 2.1.6 the official and stable version?
Zsolt
>-Original Message-
>From: Aladin [mailto:[EMAIL PROTECTED]
>Sent: Friday, November 11, 2005 1:51 PM
>To: user-java@ibatis.apache.org
>Subject: iBatis-2.1.6 jars download
>
>Hello,
>
>Will the ibatis 2.1.6 jars
Hi,
can somebody provide me how to use nested "
I use mysql-connector-java-3.1.11-bin.jar but it does also work with
mysql-connector-java-3.0.14-production.
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Connection=DEBUG
Zsolt
>-Original Message-
>From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED]
>Sent: Friday, November
only a page. Are you sure that paginated list just skips records? In this
case we have to replace it because we work also on huge lists and cannot
load a couple of 100,000 records into memory to display for example 20.
Zsolt
>-Original Message-
>From: Niels Beekman [mailto:[EMAIL PRO
Paul,
How does it compare to batch processing?
Zsolt
>-Original Message-
>From: Paul Benedict [mailto:[EMAIL PROTECTED]
>Sent: Thursday, November 03, 2005 8:44 AM
>To: user-java@ibatis.apache.org
>Subject: Re: Bulk inserts
>
>Yes,
>
>SQL has a notation to INSE
Hi,
if I use the block below "
SELECT LAST_INSERT_ID()
Zsolt
Hi,
I see the SQL statements in log4j log file but not if I execute batch
commands using startBatch and executeBatch.
How can I see also those sql commands?
Zsolt
that by accident we used the
sqlMap.update() and not create() to invoke the SQL fragment, which was
actually an .
So it was our fault.
But is this the desired behaviour that .update() accepts also
fragments without any warning?
IMHO it might be a good idea to throw some kind a exception in this case.
Zsolt
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:14 AM
>To: user-java@ibatis.apache.org
>Subject: RE: How to use tomcat's naming-factory-dbcp
Thank you Niels, but I would like configure the database connection in
sqlmap-config.xml. Because we ship our application with tomcat it would be
easier if we could configure ibatis to use naming-factory-dbcp.jar that is
always there.
Zsolt
>-Original Message-
>From: Niels B
Hi,
I use tc-5.5.12 and that is shipped with naming-factory-dbcp.jar. It looks
like it has new class names such as:
org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory
How do I have to configure sqlmap-config.xml to use this library?
Zsolt
Hi,
as far as I understand, ibatis is shipped with a simple dataSource
implementation. Is that as good as DBCP for production?
Zsolt
Hi,
What is he preferred way to insert large blobs? I would like to do that via
InputStream.
Zsolt
simple example.
Zsolt
63 matches
Mail list logo
