I have used it with mySQL and it works fine. javaexchange.com may have more
than one version on their site. Be sure to get the latest one.
There is a class called HttpServletJXGB, which extends HttpServlet. That
class has the following field:
protected static DbConnectionBroker myBroker; // a singleton
In its init() method HttpServletJXGB has
try {
myBroker = new DbConnectionBroker(
driver, jdbcURL,username, password,
minConnections, maxConnections,
logFileLocation, maxConnectTimeInDays);
}
catch (etc. ...
You must declare your servlets to be subclasses of HttpServletJXGB (at
least those that want to instantiate Connection objects). Proceeding this
way you create a single broker for all servlets, that is, your broker is a
"Global" one.
Then in any one of these servlets (subclasses) you do
Connection conn = myBroker.getConnection();
and you are all set.
Hope this helps.
Fernando
At 07:11 PM 12/20/99 -0800, you wrote:
>Has anyone on this list used DbConnectionBroker from www.javaexchange.com? I
>am trying to use it with mySQL and any attempts to get connections from the
>pull returns a null connection...
>
>I have tried to contact the author to get the sources (it's under GPL) but
>he's not returning my email...
>
>Can anyone help?
>
>Hunter
>
>___________________________________________________________________________
>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
___________________________________________________________________________
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
