Has anyone used this bean / does anyone use this bean in a production
environment to connect to MS SQL 7? What settings did you use?
Below are the settings I'm trying and they always return a JSPDBResult with
0 records. The getTotalConnections() method also always returns -1. (Leading
me to believe there is no connections built?)
<jsp:useBean id="jspDb"
class="com.livesoftware.jrun.plugins.jsp.beans.JSPDBConnection"
scope="request">
<jsp:setProperty name="jspDb" property="driver"
value="sun.jdbc.odbc.JdbcOdbcDriver" />
<jsp:setProperty name="jspDb" property="url"
value="jdbc:odbc:myDatasource" />
<jsp:setProperty name="jspDb" property="poolSize" value="5" />
<jsp:setProperty name="jspDb" property="sql" value="select * from users"
/>
<jsp:setProperty name="jspDb" property="user" value="TEST" />
<jsp:setProperty name="jspDb" property="pass" value="TESTPASS" />
</jsp:useBean>
Lots of questions after opening up J++ to peek into the bean:
What does the setDriverType() method do?
What is the MSSQL_DRIVER static int? Does this bean contain a MSSQL driver?
Or can it only use ODBC?
Any information is greatly appreciated, I'm at my wits end trying to work
out this bean.
Cheers,
Mike
__
| | The BookmarkBox
| | http://www.bookmarkbox.com
|/\| Manage and share your bookmarks online!
Have you seen our new forums? http://www.bookmarkbox.com/ubbcgi
Share your bookmarking with others and get helpful tips!
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
