I am trying to work with JRUN...
My machine is a Win 95 m/c over which JRUN is installed
I tried connecting to localhost:8000 which gave me the sample jSP page.
Now when i click over any link that points to a JSP page then i dont get any
page... instead errors
However i can see the HTML pages well..
Is it that JRUN doesnot support Win 95 coz its running well over Win NT
machine..
Or some setting needs to be done...
Just to clarify i have done 2-3 uninstall and installs.
Thanks in advance,
Pawan\
-----Original Message-----
From: Rajneesh Garg [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, May 06, 2000 10:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Calling Stored Procedures in Oracle
Hi List,
In the example code provided, one of the statement is
int returnCode = rs.getInt("ReturnCode");
This "ReturnCode" inside the getInt() call has to be the name of the
field
in the resultset. However, I wish to return values which are not in
resultset. e.g. I wish to return value 1 if block 1 executes, 2 if
block 2
executes, and so on. So, how should I make changes?
BTW, I am using SQL Server 7.
Regards,
Rajneesh
----- Original Message -----
From: Franck Rageade <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 05, 2000 6:53 PM
Subject: Re: Calling Stored Procedures in Oracle
Jose,
it looks like this
<%!
public boolean testCookie(HttpServletRequest request) {
String cookieCode = getCookieValue(request, "MGR2SECURITY");
Connection DB;
CallableStatement cstmt;
boolean retour = false;
if (cookieCode!=null) {
try {
String DSN = "DB_VO_DEV";
// Acces a l'interface JDBC
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// Connection a la base ("jdbc:odbc:" + DSN, login, password)
if ((request.getServerName()).equals("localhost")) DSN =
"DB_VO_DEV" ;
DB = DriverManager.getConnection("jdbc:odbc:" + DSN,
"VO_InternetUser",
"VO_InternetPassword") ;
// Creation et execution de la requete
cstmt = DB.prepareCall("{?= call sp_Cookie_Check(?)}");
// Parametres de sortie
cstmt.registerOutParameter(1,java.sql.Types.INTEGER);
// Parametres d'entree
cstmt.setString(2, cookieCode);
boolean hasResultSet = cstmt.execute();
if (hasResultSet) {
ResultSet rs = cstmt.getResultSet();
rs.next();
int returnCode = rs.getInt("ReturnCode");
if (returnCode == 1) retour = true;
rs.close();
}
cstmt.close();
DB.close();
}
catch (java.lang.Exception ex) {
}
}
return retour;
}
%>
Regards,
Franck
----- Message d'origine -----
De : "Jose Castro" <[EMAIL PROTECTED]>
� : <[EMAIL PROTECTED]>
Envoy� : vendredi 5 mai 2000 14:45
Objet : Calling Stored Procedures in Oracle
> Does anyone knows if it is possible to call Stored Procedures with
JSP's.
>
> I'm using Stored Procedures in Oracle, and some of them return
values, but
> another ones don't.
>
> Thanks in advance,
> Jos� Castro
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
