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".
