"boby on nestinfotech.com" wrote:
>
> Hi,
> Sorry this mail does not come with an answer, but an addon question ie how
> do you create the properties file(cantaining the URL, uid, password etc.) in
> Hans bergsten's method of connection pooling?
I believe this is described in the article, but here it goes.
The db.properties file is a regular text file, with name=value pairs. An
example is:
drivers=sun.jdbc.odbc.JdbcOdbcDriver jdbc.idbDriver
logfile=D:\\user\\src\\java\\DBConnectionManager\\log.txt
idb.url=jdbc:idb:c:\\local\\javawebserver1.1\\db\\db.prp
idb.maxconn=2
access.url=jdbc:odbc:demo
access.user=demo
access.password=demopw
With one pool configuration ("idb") for an InstantDB database and another ("access")
for a database accessed through the JDBC-ODBC Bridge driver (such as MS Access).
The pool described in the article uses java.lang.Class.getResourceAsStream() to
locate and read this file. This means the file must be located in the classpath
for the server.
If I missed something, and you have a more specific question, please email me
directly.
Hans
--
Hans Bergsten [EMAIL PROTECTED]
Gefion Software http://www.gefionsoftware.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
