And, where i mention PID below, I meant SID (which is going away according
to Oracle).
Brad
"Bradley G
Smith" To: "Struts Users Mailing List"
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
d.us> Subject: RE: db connection pool
question
21-01-03 09:34
Please respond
to "Struts Users
Mailing List"
My pleasure. Here is the relevant code in the struts-config.xml file:
<data-sources>
<data-source key="POLL_DATA_SOURCE"
type
="oracle.jdbc.pool.OracleConnectionPoolDataSource">
<set-property property="password"
value="password" />
<set-property property="user"
value="userid" />
<set-property property="description"
value="Oracle DataSource w/ Connection Pool" />
<set-property property="URL"
value="jdbc:oracle:thin:@ip_or_hostname:1521:ddb"
/>
</data-source>
</data-sources>
Be sure and set the port (1521) and pid (ddb) correctly.
Here is code from a plug-in that gets the reference to the datasource:
//initialize data cache
DataSource ds = (DataSource) servlet.getServletContext()
.getAttribute(DataKeys.DATABASE_KEY);
if (ds == null){
ServletException e = new ServletException(
"Datasource from servletcontext returned null");
log.error("Datasource is null.", e);
throw e;
}
DATABASE_KEY is the same value as the key on the DataSource in
struts.config.xml (ie POLL_DATA_SOURCE for our application). The DataSource
is the standard JDBC datasource interface.
We put the Oracle driver file (classes12.zip renamed to oracle.jar) into
Tomcat's commons/lib directory.
Brad
Thorsten Schäfer
<Newsletter@ThorstenS To: "'Struts Users
Mailing List'"
chaefer.de>
<[EMAIL PROTECTED]>
cc:
21-01-03 09:13 Subject: RE: db
connection pool question
Please respond to
"Struts Users Mailing
List"
Hi,
> I can supply and example struts configuration using Oracle's driver
> connection pool driver. Or check the archives for this mailing list,
as I
> have posted it here. Search using my name or Oracle.
Could you please post the example? I tried to search in the mailing
lists but I'm getting the error message "Text search not available for
this list".
--
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]>
