Thanks for your help.
I set up data source at startup in with the following lines:
public DataSourceComponent scoringDataSource = null;
ComponentSelector dbSelector =
(ComponentSelector)_excalibur.lookup("com.banqueagf.business.server.DataSour
ceComponentSelector");
scoringDataSource = (DataSourceComponent)dbSelector.select("scoring");
Sorry, I forgot the datasource config at office. I connect to an Oracle
database.
I use the connection in a servlet service routine:
Connection con;
con = Server.getServer().scoringDataSource.getConnection();
PreparedStatement stmt = con.prepareStatement("SELECT agf, sofinco,
inconnu, habit FROM transc WHERE agf = ?");
stmt.setString(1, matricule.toUpperCase());
ResultSet rs = stmt.executeQuery();
if (rs.next()) {
if (rs.getString("habit").compareTo("O") == 0) {
allowed = true;
} else {
allowed = false;
}
result = new LoanHabilitationData(rs.getString("agf"),
rs.getString("sofinco"), allowed);
} else {
result = null;
}
rs.close();
con.close();
When I make multiple calls, I get 5 times better response time with Turbine.
So I guess this is because the connection is opened/closes at each call.
Regards
Ronan-Yann Lorin t�l: +33 610 927 199
3, All�e des Hirondelles t�l: +33 134 506 034
95220 Herblay mailto:[EMAIL PROTECTED]
France http://lorin.nom.fr
----- Message d'origine -----
De : "Berin Loritsch" <[EMAIL PROTECTED]>
� : "Avalon Developers List" <[EMAIL PROTECTED]>
Envoy� : lundi 31 d�cembre 2001 14:40
Objet : Re: JdbcDataSource pool
> Ronan-Yann Lorin wrote:
>
> > Hi,
> >
> > I'm new to Avalon/Exvalibur and manage to use it in a new project. It
will
> > be a Java server side application running in a servlet container. My
first
> > need is to have a connection pooling package (and a server framework).
> > Avalon looks interesting for this duty.
> >
> > I tried the datasource package (which I like for it's xml configuration
> > file). It gives me very poor performances with my JSP test page. I
suspect
> > it's because of the datasource component opening/closing JDBC
connections
> > and not working as a classical connection pool (get/release).
> >
> > What would be the right solution?
>
>
> There can be a number of reasons for this. I was in the midst of making
fixes,
> but am officially out of time (my boss read me the riot act).
>
> Can you tell me exactly what your issues are?
>
> How are you setting up the Connection Pool?
>
> Are you instantiating a new pool on every request? If so, no wonder!
> Please post some more specifics regarding how you are using it in your
system.
> You can hide the actual queries and change the connection info when you
post.
> I am concerned with methodology--it could be something you are not doing
right.
>
>
> >
> > Thanks in advance for your help.
> >
> > Ronan-Yann Lorin t�l: +33 610 927 199
> > 3, All�e des Hirondelles t�l: +33 134 506 034
> > 95220 Herblay mailto:[EMAIL PROTECTED]
> > France http://lorin.nom.fr
> >
> >
> > --
> > To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
> >
> > .
> >
> >
>
>
>
> --
>
> "They that give up essential liberty to obtain a little temporary safety
> deserve neither liberty nor safety."
> - Benjamin Franklin
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
