Sure I will
For time being I used DBCP.
Anjib
On 12/8/2010 12:54 PM, adam pinder wrote:
Anjib,
i'd certainly take a look at hibernate, i've been using it for a while now and
find it easy enough and functionally rich enough for most things.
adam
Date: Tue, 7 Dec 2010 14:36:01 -0500
From:
Anjib,
i'd certainly take a look at hibernate, i've been using it for a while now and
find it easy enough and functionally rich enough for most things.
adam
> Date: Tue, 7 Dec 2010 14:36:01 -0500
> From: anji...@hotmail.com
> To: user@struts.apache.org
> Subject: Connection Pooling with
ate: Tue, 7 Dec 2010 16:19:48 -0600
> Subject: Re: Connection Pooling with Struts
> From: stanl...@gmail.com
> To: user@struts.apache.org
>
> Dude, I can't sit quietly any longer! How you connect to a database has
> NOTHING WHATSOEVER to do with the Struts/2 Framework. I woul
Then you should be asking on the appropriate list.
http://www.catb.org/~esr/faqs/smart-questions.html#forum
On Tue, Dec 7, 2010 at 6:15 PM, Anjib wrote:
>
> Dude
> I am asking about ORM tool not Struts framework itself.
>
> Please see the reply from Johannes.
>
> Thanks
> Anjib
>
>
> On 12/7/2
On Tue, Dec 7, 2010 at 6:15 PM, Anjib wrote:
> I am asking about ORM tool not Struts framework itself.
>
I think the point was more along the lines of "why are you asking here,"
since you're not asking about the Struts framework.
Dave
Dude
I am asking about ORM tool not Struts framework itself.
Please see the reply from Johannes.
Thanks
Anjib
On 12/7/2010 5:19 PM, stanl...@gmail.com wrote:
Dude, I can't sit quietly any longer! How you connect to a database has
NOTHING WHATSOEVER to do with the Struts/2 Framework. I woul
Dude, I can't sit quietly any longer! How you connect to a database has
NOTHING WHATSOEVER to do with the Struts/2 Framework. I would advise you to
keep the two separated in your mind. Much like you wouldn't look to a
Database connection to serve a web page, neither should you look to Struts/2
a
So I can use this DBCP Componenet instead of framework?
Anjib
E.g -. http://commons.apache.org/dbcp/
On Tue, Dec 7, 2010 at 4:27 PM, Dave Newton wrote:
A connection pooling library?
On Tue, Dec 7, 2010 at 4:25 PM, Anjib Mulepati
wrote:
Ok now I get confuse. I was thinking simple JDBC can'
E.g -. http://commons.apache.org/dbcp/
On Tue, Dec 7, 2010 at 4:27 PM, Dave Newton wrote:
> A connection pooling library?
>
> On Tue, Dec 7, 2010 at 4:25 PM, Anjib Mulepati
> wrote:
>
> > Ok now I get confuse. I was thinking simple JDBC can't (or complex to )
> > handle connection pooling. So
A connection pooling library?
On Tue, Dec 7, 2010 at 4:25 PM, Anjib Mulepati wrote:
> Ok now I get confuse. I was thinking simple JDBC can't (or complex to )
> handle connection pooling. So framework make work easy. If framework is not
> used what are other alternatives to handle connection poo
Ok now I get confuse. I was thinking simple JDBC can't (or complex to )
handle connection pooling. So framework make work easy. If framework is
not used what are other alternatives to handle connection pooling beside
JDBC itself?
Anjib
On 12/7/2010 4:20 PM, Arthur Neves wrote:
Nop,
You don
Is the question about connection pooling, as the subject line indicates, or
is the question about generic DB handling and JDBC v. ORMs?
Dave
On Tue, Dec 7, 2010 at 4:20 PM, Arthur Neves wrote:
> Nop,
>
> You dont need using a framework... if you pick one just will make your life
> easier!
> If
Nop,
You dont need using a framework... if you pick one just will make your life
easier!
If you`re starting a new project I`d get one framework, however if the
project it`s already ready, just keep doing in the same way!
On Tue, Dec 7, 2010 at 3:36 PM, Anjib Mulepati wrote:
> I was thinking for
I was thinking for Hibernate.
So only way for struts is use one of these framework?
Anjib
On 12/7/2010 3:26 PM, Johannes Geppert wrote:
in java you have the choose which way is the best for your project to handle
databases.
there exists several frameworks for this job like hibernate, myBatis,
in java you have the choose which way is the best for your project to handle
databases.
there exists several frameworks for this job like hibernate, myBatis, spring
jdbc tempalate, ... .
google for it and look which framework is the best for your project.
Johannes
anjibman wrote:
>
> I have t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jasdeep,
jasdeep wrote:
> Yes this is peek load actually .. The requests are through SMS's which
> is forwarded by kannel server to my application . actually we are in
> development phase and we are testing it as per client specifications.
>
> So thi
Hi Christropher ..
Yes this is peek load actualy ..
The requests are through SMS's which is forwarded by kannel server to my
application .
actually we are in development phase and we are testing it as per client
specifications.
So this was the load client specified ...
i had s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jasdeep,
jasdeep wrote:
> 2. Configuring Jboss's Internal Container Level Connection pooling simply
> creating the datasources
This is the right way to do things.
> The application works OK with Second method but When it is being hit with
> 200 r
Hi,
Struts way (not good)
Connection pooling is not available in latest version of struts
1 and
struts 2. So if you upgrade your application to latest struts
then you
will be in trouble.
Server (JNDI) very good
All application servers provide it
Tomcat can provide a connection pool, you just have to configure the
pool and look up the resource in your application. The details can be
found here :
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
Tushar Agrawal wrote:
Hi Freinds,
I am using struts-config d
Hibernate (it has a Struts plugIn) can set those up automatically for you
and connect to both using the same API.
http://www.hibernate.org
Regards,
David
-Original Message-
From: Tushar Agrawal [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 11:08 PM
To: Struts Mailing List
Su
I have 4 excellent questions for you, of which #1 could be of EXTREME
importance to you...
1. Have you changed your password YET since you posted all of your JDBC
oracle details in the below message?
2. Have you logged into your Oracle database on the host chd4.sbc.com and
verified that the conne
> -Original Message-
> From: Jignesh Patel [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 17, 2004 7:18 AM
> To: Struts Users Mailing List
> Subject: RE: connection pooling
>
>
> Suppose I will put following code in my struts-config.xml instead of
> tomca
nal Message-
> > From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 16, 2004 3:16 PM
> > To: Struts Users Mailing List
> > Subject: RE: connection pooling
> >
> >
> > Jim,
> > I understand most part of it now. the only thing th
> -Original Message-
> From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 3:16 PM
> To: Struts Users Mailing List
> Subject: RE: connection pooling
>
>
> Jim,
> I understand most part of it now. the only thing that i dont
&
:45, Jim Barrows wrote:
> > -Original Message-
> > From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 16, 2004 2:42 PM
> > To: Struts Users Mailing List
> > Subject: RE: connection pooling
> >
> >
> > Jim,
> >I a
,
org.apache.struts.webapp.example.memory.MemoryDatabasePlugIn.java for
more details.
Regards,
Sridhar
-Original Message-
From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
Sent: Monday, August 16, 2004 2:24 PM
To: Struts Users Mailing List
Subject: Re: connection pooling
David,
But i want to make a business layer and call the DAO from there. I
yeah, I am planning to use OJB for persistence. Thankx for your advice.
regards
saurabh
On Mon, 2004-08-16 at 16:43, David Durham wrote:
> Jim Barrows wrote:
>
> > Ah, okay.. I also posted a link to the struts way to do the JNDI data
> > source stuff in that case.. you follow your web app s
> -Original Message-
> From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 2:42 PM
> To: Struts Users Mailing List
> Subject: RE: connection pooling
>
>
> Jim,
>I am sorry but I am confused now. Just correct me if I am
> w
Jim Barrows wrote:
Ah, okay.. I also posted a link to the struts way to do the JNDI data
source stuff in that case.. you follow your web app servers guide
on how to setup a data source, then you follow the destructions for a
normal jndi data source. Something like:
Additionally, Saurabh, hav
PM
> > To: Struts Users Mailing List
> > Subject: Re: connection pooling
> >
> >
> > David,
> > But i want to make a business layer and call the DAO from there. I
> > think that the links that you have sent me couple
> > presentation layer and
> -Original Message-
> From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 2:24 PM
> To: Struts Users Mailing List
> Subject: Re: connection pooling
>
>
> David,
> But i want to make a business layer and call the DAO from there
David,
But i want to make a business layer and call the DAO from there. I
think that the links that you have sent me couple presentation layer and
database tightly. I know i can use EJB for presentation layer but I dont
want that as it would be overkill for the small project I am working on.
I w
> -Original Message-
> From: David Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 2:01 PM
> To: Struts Users Mailing List
> Subject: Re: connection pooling
>
>
> Saurabh Bhatla wrote:
>
> > Now i want to
> > know how to initia
David Durham wrote:
I think you want to look at a piece of technology called JNDI.
Here's a link to Tomcat's JNDI Datasource How-To:
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Considering the list topic, I guess I should post this link instead:
http://st
Saurabh Bhatla wrote:
Now i want to
know how to initialize the connection pool object and how to pass that
object to all Action classes.
I think you want to look at a piece of technology called JNDI.
Here's a link to Tomcat's JNDI Datasource How-To:
http://jakarta.apache.org/tomcat/tomcat-5.0-do
Check
http://jakarta.apache.org/commons/dbcp/configuration.html
's abandanded something parameters.
I am not sure about how to apply this to Struts Datasource.
I've just replaced Struts Datasouce with tomcat JNDI datasource with DBCP.
to decouple Struts and DAOs.
Masashi
At 12:55 04/06/09 +0530,
Thanks for your attention.
"Abandand connection management" can you give more details on how to do this.
Masashi Nakane wrote:
> And if you have a chance to try DBCP , Abandand connection management
> function will tell you exactly where the unclosed connections are . You
> will love th
Thanks for the response.
I am using the "getConnection(request)" method to get the connection
and then "connection.close()" to close the connection.
"getConnection()" and "close()" both are in library files provided by struts
(DBCP).
Therefore it is difficult to put the counter in these methods.
And if you have a chance to try DBCP , Abandand connection management
function will tell you exactly where the unclosed connections are . You
will love this.
Masashi
At 23:33 04/06/08 -0700, you wrote:
"And Some other guy says the set the max number of connectons to 1."
Yes this is another
"And Some other guy says the set the max number of connectons to 1."
Yes this is another good way, thank you for bringing that up. I had a
fairly big app that was throwing away connections and when I set the
max connections to 1 it became almost immediately aparent where the
problem was.
Good sug
I'm using Oracle and when I meet that situation,
i check the DB session (v$session) and operate GUI .
When number of DB sessions increase, that is the timing .
And Some other guy says the set the max number of connectons to 1.
hope this help
At 22:49 04/06/08 -0700, you wrote:
This may seem to simp
This may seem to simplistic, but you could do a search for whichever
method you call to open a connection and then do a search for
connection.close() (or whatever you named the variable) and see if the
numbers add up... if they don't, this might help you narrow down which
file the two aren't syncro
If 5 users are simultaneously using
the database connections then you need to create more connections.
Brati Sankar Ghosh
Tata Consultancy Services
Mailto: [EMAIL PROTECTED]
Website: http://www.tcs.com
Lokanath <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/20/2004 10:11 AM
Please re
If your pool max is 4, then you will see 4 and your 5th user will wait
until someone returns their connection to the pool.
Lokanath wrote:
hi all
i have a doubt over connection pooling.When 5 users are using a project in
struts and if i have defined the maximumnumber of connection to 4 .Then how
Depends on your situation.
If the SQL Exceptions are expected (i.e., a trigger could fail) then
yes, you will want to catch that and send the message back to the user.
However, if you are thinking JDBC is the way to go, you really should
use something like iBATIS that hides this kind of stuff fr
ED]>
> Data: Wed, 07 Apr 2004 09:00:16 -0400
> Para: Struts Users Mailing List <[EMAIL PROTECTED]>
> Assunto: Re: Connection Pooling (How i use...)
>
> So, are there implied catches in there for SQLException (I assume there
> are)?
> In the innermost try block, does t
So, are there implied catches in there for SQLException (I assume there
are)?
In the innermost try block, does the catch rethrow the SQLException so that
it cascades to the outer blocks?
Just trying to understand the model.
Dean Hoover
Larry Meadors wrote:
Yes.
You really might want to consi
See this
Connection conn = null;
try{
conn = ds.getConnection();
...whatever you wish to do with conn..
catch(SQLException sqle)
{
action of exception
}
finally{
try{
if(nul != conn) conn.close();
}
catch(SQLException sqle){ action of except
Uhh, yeah, I never did that, no, I just heard about it...yeah, that's
it...
;-)
>>> [EMAIL PROTECTED] 04/06/04 11:45 AM >>>
*Quite* right: there was one time we had set the autoCommit on the
connection object to false, forgotten to change it back before releasing
it
to the pool andwell,all
gt;
> Data: Tue, 6 Apr 2004 10:54:06 -0700 (PDT)
> Para: Struts Users Mailing List <[EMAIL PROTECTED]>
> Assunto: Re: Connection Pooling - Monitor
>
> Marcelo,
> The # of connections is determined by the value you
> set when you defined your datasource. What is th
00
> > Para: "Struts Users Mailing List"
> <[EMAIL PROTECTED]>
> > Assunto: Re: Connection Pooling (How i use...)
> >
> > Now I am closing the connection in the finally
> block.
> > The exemple provided by:
> >
>
http://jakarta.
*Quite* right: there was one time we had set the autoCommit on the
connection object to false, forgotten to change it back before releasing it
to the pool andwell,all I can say is we spent some "interesting" hours
trying to debug that one!
Geeta
Larry Meadors wrote:
> Yes.
>
> So be careful
Oh yeah, that reminds me: Be careful not to double close your
connections - with some implementations, that closes the pool.
So do not close the connectionin the try *and* in the finally - do it
*only* in the finally!
Larry
>>> [EMAIL PROTECTED] 04/06/04 11:25 AM >>>
well, you are right...! Wh
Ah, well, you didn't read the fine print:
-->>Note: this code isn't anywhere near production ready - it's only supposed to be
used as a simple test :-)
Believe me, you should close connections/return them to the pool in a finally block if
you want to avoid major
problems.. As I said before, thi
I have yet to see a *good* example of how to do jdbc on the net.
Most are very simple one-off "throws SQLException" examples that don't
seem to take into consideration little things like stability and
releasing resources. :)
That is why I think tools like iBATIS are so powerful - you get all the
Yes.
So be careful if you tweak the connection (like changing transaction
isolation, etc) because that connection may be used elsewhere, and your
change will persist. :)
Larry
>>> [EMAIL PROTECTED] 04/06/04 11:17 AM >>>
What happens when i do conn.close()? does it go back to the pool?
---
To: Struts Users Mailing List
> Cc:
> Subject: Re: Connection Pooling (How i use...)
>
>
>
> This your problem: closing the connection in your try block. Move it to a
> finally block..
>
> Marcelo Epstein wrote:
>
>
g getFoo() { return foo; }
public int getBar() { return bar;}
}
On Tue, 06 Apr 2004 12:50:29 -0400, "Geeta Ramani"
<[EMAIL PROTECTED]> escreveu:
De: "Geeta Ramani" <[EMAIL PROTECTED]>
Data: Tue, 06 Apr 2004 12:50:29 -0400
Para: Struts Users Mailing List <[EMAIL PROTE
}
public String getFoo() { return foo; }
public int getBar() { return bar;}
}
On Tue, 06 Apr 2004 12:50:29 -0400, "Geeta Ramani" <[EMAIL PROTECTED]> escreveu:
> De: "Geeta Ramani" <[EMAIL PROTECTED]>
> Data: Tue, 06 Apr 2004 12:50:29 -0400
> Para:
]
Sent: Tue 4/6/2004 10:20 PM
To: Struts Users Mailing List
Cc:
Subject: Re: Connection Pooling (How i use...)
This your problem: closing the connection in your try block. Move it to a
finally block..
Marcelo Epstein wrote
System.out.println(ex.toString());
> }
>
> On Tue, 06 Apr 2004 10:19:15 -0600, "Larry Meadors" <[EMAIL PROTECTED]> escreveu:
>
> > De: "Larry Meadors" <[EMAIL PROTECTED]>
> > Data: Tue, 06 Apr 2004 10:19:15 -0600
> >
From: Marcelo Epstein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:31 AM
To: Struts Users Mailing List
Subject: Re: Connection Pooling (How i use...)
I use the pool like this: (IS IT WRONG??) I think the connection is being
closed..
try {
Context ctx = new InitialContext();
Yes.
You really might want to consider a tool like iBATIS, but if you want to
do it yourself, here is the pattern:
Connection c = null;
try{
//get connection
try{
// get statement
try{
// get result set
// process result set
}finally{
// close result set if not
) and always in a
finally block.
Brian McClung
Senior Programmer
Belo Interactive
-Original Message-
From: Marcelo Epstein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:31 AM
To: Struts Users Mailing List
Subject: Re: Connection Pooling (How i use...)
I use the pool like
ks...
On Tue, 6 Apr 2004 18:20:29 +0200, Mark Lowe <[EMAIL PROTECTED]>
escreveu:
De: Mark Lowe <[EMAIL PROTECTED]>
Data: Tue, 6 Apr 2004 18:20:29 +0200
Para: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Assunto: Re: Connection Pooling
If your using the version 3 m
http://proxool.sourceforge.net/
Avinash
-Original Message-
From: Marcelo Epstein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:31 AM
To: Struts Users Mailing List
Subject: Re: Connection Pooling (How i use...)
I use the pool like this: (IS IT WRONG??) I think the connection is being
closed..
s" <[EMAIL PROTECTED]> escreveu:
De: "Larry Meadors" <[EMAIL PROTECTED]>
Data: Tue, 06 Apr 2004 10:19:15 -0600
Para: <[EMAIL PROTECTED]>
Assunto: Re: Connection Pooling
My bet is on a connection leak - you open one in a try block and don't close it in the fina
ECTED]>
> Data: Tue, 6 Apr 2004 18:20:29 +0200
> Para: "Struts Users Mailing List" <[EMAIL PROTECTED]>
> Assunto: Re: Connection Pooling
>
> If your using the version 3 mysql driver don't.. Use version 2 and
> never look back.
>
> There also a ?aut
}
} catch (Exception ex) {
System.out.println(ex.toString());
}
On Tue, 06 Apr 2004 10:19:15 -0600, "Larry Meadors" <[EMAIL PROTECTED]> escreveu:
> De: "Larry Meadors" <[EMAIL PROTECTED]>
> Data: Tue, 06 Apr 2004 10:19:
If your using the version 3 mysql driver don't.. Use version 2 and
never look back.
There also a ?autoReconnect=true parameter to pass through with the
url, but i think thats bollocks or at least didn't work with version3
mysql drivers.
On 6 Apr 2004, at 18:08, Marcelo Epstein wrote:
Hi,
I h
My bet is on a connection leak - you open one in a try block and don't close it in the
finally block.
>>> [EMAIL PROTECTED] 04/06/04 10:08 AM >>>
Hi,
I have just started using Connection Pooling in my app (Tomcat, Struts, DBCP, Mysql) .
It woks for about 20 hours and stop working until tomcat r
These are the main 2 reasons that come to me:
(1) You are not "closing" the connection once you've finished using it.
This signals the pool's manager when to re-assign that connection (i.e.
you've finished, so it can be used by someone else).
(2) Your connection pool is not big enough.
HTH,
Fred
Marcelo;
You are probably exhausting all your connections in the pool. Make sure all your
connections
are returned back to the pool at the end of a "finally" block. That way the connection
is
returned to the pool regardless of whether your database work was a success or not.
Also, while
you ar
74 matches
Mail list logo
