This is a Live Software support issue.
--
Joe Shevland
Turnaround Solutions Pty. Ltd.
mailto:[EMAIL PROTECTED]
http://www.TurnAround.com.au
::-----Original Message-----
::From: A mailing list about Java Server Pages specification and reference
::[mailto:[EMAIL PROTECTED]]On Behalf Of steve Gale
::Sent: Saturday, March 20, 1999 3:12 PM
::To: [EMAIL PROTECTED]
::Subject: JRUN jspDB Bean usage for sql database via ODBC
::
::
::Hi
::I am new to JSP and am trying to use the jspDB bean to access an
::SQL database via ODBC. I cant
::find any doco about this bean but from the jrun provided examples
::I expect the code would look something like the following.....
::I have a servlet that uses the same query/ data source and this
::works ok, however the following code desnt even make a connection
::to the database
::(sql trace doesnt show one).
::I would appreciate some help and or some doco about the usage of
::this bean.
::thanks,
::Steve Gale
::[EMAIL PROTECTED]
::
::
:: <BEAN NAME="jspDb"
::TYPE="com.livesoftware.jrun.plugins.jsp.beans.JSPDBConnection"
::SCOPE="session">
:: </BEAN>
::
:: <%
:: jspDb.setDriver("sun.jdbc.odbc.JdbcOdbcDriver"); //
::supported ????
:: jspDb.setUrl("jdbc:odbc:testenrol;UID=sa;PWD=");
:://datasource="testenrol" userid = "sa" password= ""
:: jspDb.setPoolSize(1); // set Higher for MSsql database????
:: String sql = "use enrolment
::select * from Students";
:: jspDb.setSql(sql);
:: jspDb.open("enrolment"); //
::datbase name???
:: JSPDBResult[] rs = jspDb.execute();
:: %>
::
::==================================================================
::=========
::To unsubscribe, send email to [EMAIL PROTECTED] and include
::in the body
::of the message "signoff JSP-INTEREST". For general help, send email to
::[EMAIL PROTECTED] and include in the body of the message "help".
::
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff JSP-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
