I use Column prefix for this handler at home too.
BTW I faund ColumnPairHandler handler is a one usefull too:
SELECT ID,NAME FROM SOME_TABLE
Object handle(ResultSet rs)throws SQLException{
Map map = new HashMap();
while(rs.next()){
map.put(rs.getObject(1),rs.getObject(2));
}
return map;
}
David
+1
- Original Message -
From: Stephen Colebourne [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Friday, December 19, 2003 11:13 PM
Subject: [VOTE] Eric Pugh - new committer
Well extended rights committer, as he is already well known from the
sandbox
and
Hernan Silberman wrote:
--- Hernan Silberman [EMAIL PROTECTED] wrote:
Hello,
I'm working on an application that uses Named Queries much like the
DBUtils QueryLoader class reads in from a Java properties file. The
queries in
my application are stored in a relational database on the server
We can add handlers,converters, tools to contributed directory, feature
will be moved
to src if community will find it usefull, DbUtils can become a framework
this way, it is
not a major problem if community needs it, but new dependancies are.
I propose to discuss about repository in DbUtils
- Original Message -
From: David Graham [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 5:46 AM
Subject: Re: [DbUtils]Making the BeanHandler... Even Smarter
--- Corby Page [EMAIL PROTECTED] wrote:
Hmmm... I'm curious what the
You can do it with strings too:
private static String FIELD_LIST = column1 as beanProp1, column2 as
beanProp2,
column3 as beanProp3 ;
String sql1 = SELECT + FIELD_LIST + FROM ... ;
I use this way:
SELECT ${FIELD_LIST} FROM ... ;
I think it can be better to use this map for any dynamic
We have a patch to solve type mapping on application level.
I think your way is a good , I use CAST(xxx AS TYPE) for type mapping
too, but I see no problems to implement cast on client,
it can break types, but it must be not a problem for some use cases like
velocity templates.
José Fortunato
public Object getObject(int i,
Map map)
throws SQLException
Doe's somebody tried to use this method ? I am not sure, but looks like it
can be driver specific.
It is trivial to implement converters. It can be something like this:
//delegates convertion for
+1
- Original Message -
From: peter royal [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Saturday, November 15, 2003 10:46 PM
Subject: [VOTE] Elect Paul Libbrecht as a Jakarta Commons Committer
Paul Libbrecht [EMAIL PROTECTED] has been contributing to
Hi,
I do not think Commit flag is a good idea.
It must be better to remove transaction demarcation code form QueryRunner.
The best known way is to map connection to Thread (java.langThreadLocal),
JTA uses this way too.
ThreadLocal localConnections = new ThreadLocal();
public Connection
+1
- Original Message -
From: David Graham [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 09, 2003 10:25 PM
Subject: [VOTE] Release DbUtils 1.0
DbUtils is a stable, well tested package suitable for a 1.0 release. The
release candidate is available here:
as needed.
(4) Initial Committers
The initial committers on the DBUtils component shall be:
Henri Yandell
Steven Caswell
Juozas Baliuka
David Graham
__
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears
Try to run app without pool first to find broken component. Most of
Connection leak problems are in applications and it is not easy to trust
this test.
- Original Message -
From: Todd Carmichael [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 7:32 PM
Subject:
occurred.
ToddC
-Original Message-
From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 9:53 AM
To: Jakarta Commons Developers List
Subject: Re: [dbcp] Trying to track/find a connection leak in DBCP 1.1
Try to run app without pool first to find broken
the test of using JndiDataSourceFactory and that no leaks
occurred.
ToddC
-Original Message-
From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 9:53 AM
To: Jakarta Commons Developers List
Subject: Re: [dbcp] Trying to track/find a connection
Change it to public Object handle(ResultSet rs) throws SQLException.
Object params[], Object userObject was for ProcedureUtils.
- Original Message -
From: David Graham [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 7:10 PM
Subject: [dbutils]
remove it.
- Original Message -
From: David Graham [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 5:55 PM
Subject: [dbutils] ResultSetMetaDataHandler
I'm having trouble thinking of a use case that supports the need for the
ResultSetMetaDataHandler interface.
Remove it.
- Original Message -
From: David Graham [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 6:05 AM
Subject: [dbutils] Removing qdox references
QDox code is limited to the ProcedureUtils class. ProcedureUtils doesn't
seem to offer anything without
- Original Message -
From: Henri Yandell [EMAIL PROTECTED]
To: David Graham [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 6:31 PM
Subject: Re: [dbutils] Offer to help with DbUtils
Basic things that need to happen on
- Original Message -
From: Henri Yandell [EMAIL PROTECTED]
To: Juozas Baliuka [EMAIL PROTECTED]
Cc: Jakarta Commons Developers List [EMAIL PROTECTED];
David Graham [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 7:09 PM
Subject: Re: [dbutils] Offer
+1
I would like to nominate Fredrik Westermarck as an Apache Jakarta Commons
committer.
Fredrik has put tons of work into improving the Javadoc for [lang] in the
latest 2.0 release, in fact, looking at my archives he's offered 13
patches in the last year [that I saved], many of which
Just to note; I'll ensure that Steven Caswell and Juozas Baliuka have cvs
access to dbutils in db.apache.org.
I have forked experimental stuff from DBUtils to
http://voruta.sourceforge.net and I think we need to strip experiments and
to remove dependancies, we can do it before to move.
BTW
- Original Message -
From: Hope, Matthew [EMAIL PROTECTED]
To: 'Jakarta Commons Developers List' [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 10:26 AM
Subject: RE: [primitives] Open for business
perhaps less so from 1.5 onwards since for non critical performance the
ease
of
i'm also interested to see if this technology might be useful to speed up
other components which make extensive use of reflective (such as betwixt).
Code generation is useful for server applications, but it is always good to
have two implementations:
1 Reflection for testing and development
+1
- Original Message -
From: Stephen Colebourne [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:10 AM
Subject: [VOTE] New committer - Phil Steitz
I would like to nominate Phil Steitz as an Apache Jakarta Commons
committer.
It has meaning to duplicate or to fork code in some cases,
dependancies and integration can cause more problems than trivial code
maintainance.
- Original Message -
From: Henri Yandell [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003
-1
I do not think it is possible to detect connection leak in pool.
!ownerThread.isAlive() isOpen or weakReference is in referenceQueue is
100% connection leak, I have tested this workaround in my crappy
applications, I found it is a very dangerous feature and doe's not help to
fix application
Sorry, if somebody found something personal in my messages, I was not going
to personalize connection leak problem.
My suggestion is very clear, to remove workarounds from pool and to
implement resource management component.
Doe's somebody proposed the way to detect connection leak ? Is it bad
overhead in the most of my use cases (application and
DB on the same machine or LAN) if pool opens a new connection per thread
without autoreconnects and any kind of workarounds.
Juozas Baliuka wrote:
I like innovations, but try to implement and test it at home please.
I am sure
-
From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 13:16
To: Jakarta Commons Developers List
Subject: Re: [DBCP] AbandonedTrace - Connection Recovery
I do not think it is good idea to maintain any kind of public API for
abandoned connections, It is garbage,
If application
You misunderstand me. http://www.springframework.org/ I have never used this
framework, but I use the same ideas.
I did a lot of this kind of bugs myself too and it is very
trivial to fix.
1. Set maxConnections to 1 for testing
useful
2. Use lazy decorator for connection to throw
Message-
From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: 23 July 2003 09:19
To: Jakarta Commons Developers List
Subject: Re: [DBCP] AbandonedTrace - Connection Recovery
Connection Recovery can not help to solve resouce leak and
performance
problems, but It can produce more problems
resource use then or can handle the constraints
then by all means work within a framework - just remember that if you ever
change your situation to requiring optimal use or working outside the
constraints you have a problem.
Matt
-Original Message-
From: Juozas Baliuka [mailto:[EMAIL
What happens is that the broken app ends up sucking up resources for
each concurrent request being made to it which is waiting for the
db connection timeout. Usually this is set to 5-10 seconds.
This can suck up alot of resources. Memory, threads, etc.
Web server with limited
/**
* Get a db connection from the pool.
*
* If removeAbandoned=true, recovers db connections which
* have been idle removeAbandonedTimeout.
*
* @return Object jdbc Connection
*/
As I remember we have decided to log stack trace, but not to break pool.
Is
- Original Message -
From: John McNally [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 8:54 PM
Subject: Re: [DBCP] AbandonedTrace - Connection Recovery
I get the impression that some of you believe connection cleanup is
difficult. It really is trivial to
Yes, my applications have a lot of bugs too, but I am not ignoring it and I
am not going to break commons
code to hide my problems
.
- Original Message -
From: John McNally [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 10:54 PM
Please do not misunderstand me, it is not a recomendation,
it will not help too, but you can test this workaround at home:
1. before to return from getConnection pool sets currentThread for
connection.
2. if !connection.getOwner().isAlive(), it safe to reuse connection.
It must be safe to
Please do not misunderstand me, it is not a recomendation,
it will not help too, but you can test this workaround at home:
1. before to return from getConnection pool sets currentThread for
connection.
2. if !connection.getOwner().isAlive(), it safe to reuse connection.
It must be safe to
I do not think it is good idea to maintain any kind of public API for
abandoned connections, It is garbage,
If application or server is not broken, it doe's not need workarounds.
Workarounds can not help for broken applications any way, it is a useless
stuff and it infects code with Observers.
As
- Original Message -
From: Danny Angus [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 2:19 PM
Subject: RE: [DBCP] AbandonedTrace - Connection Recovery
Juozas,
I do not think it is good idea to maintain any kind of public API for
- Original Message -
From: Danny Angus [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 3:18 PM
Subject: RE: [DBCP] AbandonedTrace - Connection Recovery
Juozas,
I think I will leave commons and I will spend more my time on SF
PROTECTED]
Sent: Tuesday, July 22, 2003 5:38 PM
Subject: Re: [DBCP] AbandonedTrace - Connection Recovery
On Tue, 22 Jul 2003, Juozas Baliuka wrote:
Date: Tue, 22 Jul 2003 14:15:53 +0200
From: Juozas Baliuka [EMAIL PROTECTED]
Reply-To: Jakarta Commons Developers List
[EMAIL PROTECTED
I agree that this is an education/policy issue. But sometimes you need
a stop gap solution to keep something running while the customer fixes
the problem.
I would like to see this stop gap solution included with the DBCP release.
Along with quality docs on how to properly use a db
I like innovations, but try to implement and test it at home please.
I am sure there are not so many situations in the real world need this
feature.
It takes a few minutes to find connection leak and to fix it in any
applications, doe's not it ?
David Graham wrote:
This is absolutely not a
This attitude is not very helpful. I don't see how dbcp supplying the
ability to configure a connection pool to reclaim connections is that
big of an issue.
Have you tried to solve problems this way ? Is it tested solution and can be
used for high quality software ?
Try to implement and
Forget it please.
Try to solve it at home, fix it or remove crap from production . I do not
think commons commiters want or need to support crap.
All of us have a lot of work at home too and there are a lot of good code to
support.
- Original Message -
From: Glenn Nielsen [EMAIL
b) if this threshold is exceeded, you close the connection. The value
of trying to return it to the pool is minimal, while the downside of
returning a mid-transaction/statement connection to a pool is very bad
and nearly impossible to track down.
DBCP should not close connections that
It is nothing bad to add some logging to pool, but no workarounds.
Application must work with any pool implementation and not to depend on
workarounds in pool.
But I see nothing bad if application uses resource manager (It is not a
pool) and *never* closes connections,
connection returned from
ResultSet rs;
try {
con = magicGetConnection();
//stuff
} catch(...) {
} finally {
try {if (rs!=null){ rs.close(); rs=null; } } catch(Throwable ignore){}
try {if (ps!=null){ ps.close(); ps=null; } } catch(Throwable ignore){}
try {if (ps!=null){ con.close(); con=null; } }
It is possible to detect abandoned connection with Thread.isAlive() (if
thread pool is not used or maxConnections = maxThreads),
but it is not a good way for performance ( iterate owners and chech
isAlive )
- Original Message -
From: Danny Angus [EMAIL PROTECTED]
To: Jakarta Commons
Pool doe's not need locks on connection objects, synchronized can be used
for wait/notifyAll,
but it needs monitor of some global object. Pool must never return the
same connection
for different threads, but connection can be fail-fast itself,
it is not a very big overhead for connection
But, I've got a feeling that we're talking different languages here!
In fact I was discussing Ken Horn's idea that the pool could
* after a connection has been grabbed but not released,
for say 10 minutes
* forcibly close the underlying real connection
(thus freeing db server's
That is most likely why people want DBCP to recover connections but again
this is beyond the scope of DBCP. Fixing the applications to manage their
resources appropriately is the solution in this case.
+1
I prefer to remove all resource management workarounds from DBCP and use
fail-fast
Checked exeptions look very usefull for API designers and useless for API
users, doe's not it ?
You missed the correct solution in your logging
example. Obviously, various implementations will
throw different sets of exceptions so the right way to
handle it is to create a checked
I think this logging example was a good one:
void MyMethodUsesLogging()throws MyException{
try{
log.info(started);
}catch(LoggingException e){
log.error(e); // ??
throw new MyExeption(e);
}
}
- Original Message -
From: David Graham
appropriate here.
Logging was merely an example (probably a poor one). I don't want to
handle exceptions from my logging package but I wouldn't want it to throw
RuntimeExceptions either (unless I've misused the API).
David
Juozas Baliuka wrote:
I think this logging example was a good one
In many cases that a database operation fails the next layer just cares
that it gets notified of the failure and logs it (you could also have
subclasses of MyException that indicate more specific failure types).
MyException is allowing other layers to be independent of the persistence
A name in the Java Language, namely the name of a package, class,
interface, field, constructor or method. A name can be fully-qualified, such
as java.lang.String.equals(java.lang.Object), or partially-qualified, such
as equals(Object).
It must work:
@link #DefaultMapBag(java.util.Map)
-
+1
This project needs more developers, I can not help at this time and Phil
can do more as commiter.
I'm not sure if I have enough rights yet to nominate Phil Steitz for
commiter (I just became a commiter myself). Phil is the initial proposal
author on the math project. That in and of
read this:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/class-loader-howto.html
and
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/config/loader.html
- Original Message -
From: Wilson, Allen [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Wednesday, June
: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 3:14 PM
To: Jakarta Commons Developers List
Subject: Re: Commons Upload Problems...
read this:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/class-loader-howto.html
and
http://jakarta.apache.org/tomcat/tomcat-4.1-doc
|
---
-
---|
Howdy,
I understand it's just a wrapper, and that the
reading cannot be any faster. I'm curious why the
writing is so much faster, even in the default (not fast)
mode of FastHashMap.
Yoav Shapira
Millennium ChemInformatics
-Original Message-
From: Juozas Baliuka [mailto:[EMAIL
|
---
-
---|
Howdy,
I understand it's just a wrapper, and that the
reading cannot be any faster. I'm curious why the
writing is so much faster, even in the default (not fast)
mode of FastHashMap.
Yoav Shapira
Millennium ChemInformatics
-Original Message-
From: Juozas Baliuka [mailto:[EMAIL
Thanx,
It seems problems are solved and I will not forget this next time.
- Original Message -
From: Conor MacNeill [EMAIL PROTECTED]
To: Jakarta Project Management Committee List [EMAIL PROTECTED];
Juozas Baliuka [EMAIL PROTECTED]; Jakarta Commons Developers List
[EMAIL PROTECTED]; Mark R
+1
- Original Message -
From: Shapira, Yoav [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 3:42 PM
Subject: RE: [logging][VOTE] Proposal To Release Commons Logging 1.0.3
+1 for release and for Senor Donkin the release manager ;)
-scoped
classes which hide inside CollectionUtils].
org.apache.commons.collections.bag.BagUtils, and Bag interface, and Bag
implementations etc.
org.apache.commons.collections.map.MapUtils ...
and so on?
Hen
On Wed, 2 Apr 2003, Juozas Baliuka wrote:
+1, static public inner classes
see it as essential. If need be, all the collections can stay in
the org.apache.commons.collections package.
Yoav Shapira
Millennium ChemInformatics
-Original Message-
From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 1:57 PM
To: Jakarta Commons Developers
We have some experimental stuff like ProcedureUtils, I do not believe it can
find community in sandbox,
I think it is time to move it to SF, It will help to reduce dependancies
too.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
- Original Message -
From: Mario Ivankovits [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Monday, March 24, 2003 8:57 PM
Subject: Re: [DBCP] Please let us start to improve the connection pool
1) ThreadLocal
This might not help anything, or do i oversee
I will add some stuff to [dbutils], ThreadLocal/Proxy stuff doe's not
depends on pool implementation.
It is better to validate connectionout of pool too, in getConnection method
(validates once per transaction if needs to invoke some lazy connection
method)
- Original Message -
From:
It was interesting discussion :)
I see we have some stuff to depricate in dbcp, but not to improve
workaraunds.
We do not ignore patches, and possible it will be applied, but not by me.
- Original Message -
From: Mario Ivankovits [EMAIL PROTECTED]
To: Jakarta Commons Developers List
There are several circumstances where two different pieces of code can be
inadvertently sharing the same connection.
Connection pool user is responsable for this. User can store connection in
ThreadLocal or
implement something like this:
class MySafeConnection implements InvokationHandler{
BitSet.clear(), which is a JDK 1.4 method. It's the
only 1.4 only thing there, so I reckon it'd be good to try and fix it to
work differently. That possible?
Hen
On Tue, 11 Mar 2003, Juozas Baliuka wrote:
It is report about code I added last week and status:
1.Handler interface
It can go to commons-io, this stuff ( color escapes ) is not OS dependant,
it is standard, but not supported on some
console implementations.
This stuff is implemented in jfunc project:
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jfunc/jfunc/junit/extensions/
jfunc/util/ColorWriter.java
Some driver can decide to cache metadata and this will not work for
validation.
Validation query can break transactions in some situations (more side effect
than feature),
It works like roolback on erorr in transaction, you must have
getConnection per transaction if you use validation query,
but
Added more handlers:
1. ResultSet to Map
2. ResultSet to Bean
3. vector,map,bean and collections support in ProcedureUtils
Bean support:
It is assumed that field names are mapped to preperty names using alias:
SELECT MY_FIELD as myProperty ...
JAVA Beans API is used for introspection.
+1
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 14, 2003 4:07 PM
Subject: [VOTE] Nominate Gary Gregory as commons committer
I nominate Gary Gregory as a commons committer.
Gary has provided a number of useful patches to [lang], which also
-
From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 8:28 AM
To: Jakarta Commons Developers List
Subject: Re: [lang] ObjectUtils interner?
trivial test:
final int iterations = 10;
long time = System.currentTimeMillis();
for(int i =0; i
It will not increase performance, cache will create more grabage itself.
- Original Message -
From: grumpoxl [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 9:44 AM
Subject: [lang] Pooled and mutable numbers.
Is there any interest
+1
- Original Message -
From: Stephen Colebourne [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 1:31 AM
Subject: [VOTE] Nominate Alex Chaffee as Commons committer
I hereby nominate Alex Chaffee as a commons committer. He is a
I think it is ok.
- Original Message -
From: Steven Caswell [EMAIL PROTECTED]
To: 'Juozas Baliuka' [EMAIL PROTECTED]; 'Jakarta Commons Developers
List' [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 1:31 AM
Subject: RE: [dbutils] propose adding getResultSetMetaData
I am not sure it can help for performance, but it is possible to test it.
This method creates new WeakReferense object per operation, MapEntry per
object and
hols an array of size + 15%.
This produces more grabage than trivial objects like Integer.
snip
public Object intern(Object
Map performance depends on hash function implementation, one of ways to
optimize it is to find the best hash function at runtime (dependant on
known hash codes at runtime ) and rehash map using this function.
int findIndex(int hashCode){
//some hash function implementation generated at runtime
/gperf.html )
/Pranas
-Original Message-
From: Juozas Baliuka [mailto:[EMAIL PROTECTED]
Sent: 2003 m. kovo 10 d. 16:30
To: Jakarta Commons Developers List
Subject: Re: [collections] Faster than HashMap?
Map performance depends on hash function implementation, one of ways to
optimize
There are several circumstances where two different pieces of code can be
inadvertently sharing the same connection ... .
Is it possible in DBCP ? I believe it will not return the same connection
instance for different threads and will not return
connection to pool before close. Is it used store
I am not sure it will work on closed resultsetm, It is better to return
custom metadata object and value as result from
handler.
I have changed handle signature it will have params from prepared
statement.
- Original Message -
From: Steven Caswell [EMAIL PROTECTED]
To: Jakarta Commons
Yes, it can detect log4j and Jdk14Logger only, this kind of LogKitLogger
dettection is not supported at this time.
I do not like this kind of transparent autodetction(it is more side effect
than feature), but it is possible to add LogKitLogger too.
- Original Message -
From: Andreas
On Wed, 5 Mar 2003, Juozas Baliuka wrote:
I remember we decided not to implement religion in dbutils, but we can
try
this kind of experiment :
interface MyProcedure {
int executeSomeQuery( int p1, String p2 );
}
static final MyProcedure PROC1 = DbUtils.newInstance
No file is attached.
It will be faster on small maps, but method code size is limited, 65535
bytes or something like this and it needs some workaround.
- Original Message -
From: Stephen Colebourne [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Saturday,
Hi,
Is it possible to send some reminder once per month or week like SF doe's,
I have a few accounts and sometimes
use wrong from: line.
- Original Message -
From: [EMAIL PROTECTED]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Saturday, March 08, 2003 8:52 AM
Subject: Re:
do:
DbUtils dbutils = DbUtils.getInstance();
dbutils.setConnection(conn);
dbutils.doThing(); // etc
Though I'm not sure you didn't mean to do that anyway :)
Hen
On Wed, 5 Mar 2003, Juozas Baliuka wrote:
I remember we decided not to implement religion in dbutils, but we can
try
getMoreResults() precedes getResultSet().
Using this is slightly more efficient than an update followed by a query.
JDBC documentation says I must to call getMoreResults() after
getResultSet().
I have no way to test this stuff, doe's some opensource RDMS driver supports
getResultSet() after
public Object handle(ResultSet rs) throws SQLException
{
if(rs.next()){
return rtr.retrieve(rs);
}
throw new Exception
It is good idea, I wiil remove executeRowQuery and add this kind of adapter
and will move handler
I remember we decided not to implement religion in dbutils, but we can try
this kind of experiment :
interface MyProcedure {
int executeSomeQuery( int p1, String p2 );
}
static final MyProcedure PROC1 = DbUtils.newInstance( MyProcedure.class,
sql,
new ResultSetHandlerImpl()
Hi,
Hi folks,
Can we consider one of two solutions for this _single_ use of commons
logging
1) Removal of the commons-logging from attributes?
2) Backwards compatible rework that will allow the application to run
without commons logging in the classpath (or classloader tree for
complex
snip
Why does people get in to trouble when depending on ThreadContext
classloader which is
the correct way to load classes with (if one want to be container friendly
:)
Depending on ThreadContext classloader will work if the container follows
the spec - and if there
are no TCL, then use
]
To: Jakarta Commons Developers List [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 8:57 PM
Subject: Re: [dbutils] query with results
Juozas Baliuka [EMAIL PROTECTED] writes:
Do you know some use case for this ?
As I understand it must look like this:
ResultSet last = null
Hi,
this misunderstanding is not any kind of problem,
I yust do not know all convensions and have problems with my english.
I will try to fix this problem on weekend, it must trivial to solve for
some of situations,
proposed solution class loader priority will not wok 100%, but it will
work
Hi,
I was reported a few moths ago, but I see it is not fixed in current CVS
version,
can I add myself to logging comiters list and fix this problem ? It is not
possible to solve all problems
with current API. but it is possible to solve some of them like described in
this message posted to
1 - 100 of 254 matches
Mail list logo
