hi there, thanks for the reminder, yet there is no results return as output. I tried to replace the line:
return output; with return "" + interString; and it return my input value... ----- Original Message ----- From: "Karthikeyan .K.V" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Saturday, March 09, 2002 12:34 PM Subject: RE: Help in JSP > Think use the "output=" statement before u use the close function > statement. > > Karthik > > -----Original Message----- > From: Neo Gigs [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 08, 2002 9:53 PM > To: Tomcat Users List > Subject: Help in JSP > > > Hi there all, > > I had a JSP page that talks to a JBeans, but the problem is my Bean is > actually doing DB connectivity to a Oracle db, as no result returned from > the Bean. > > As I had tested with the application of the same codes. > > Could anyone help me to scan thru, whats wrong with this? > > package com.mbf.beans; > > import java.sql.*; > import java.math.*; > import java.io.*; > import oracle.jdbc.driver.*; > > public class SpTest > { > private int interString; > private String output; > > public String getInput() > { > // First detect class existance > try{ > Class.forName("oracle.jdbc.driver.OracleDriver"); > } catch (java.lang.ClassNotFoundException e){ > System.err.print("Class Not Found error!" + e.getMessage()); > } > > // Now try to open db connection and do the fetching > try{ > // DriverManager.registerDriver(new > oracle.jdbc.driver.OracleDriver()); > String url = "jdbc:oracle:thin:@10.97.2.50:1521:REL4"; > String scall = "begin sp_GetClatTypeIE(?, ?); end;"; > Connection conn = DriverManager.getConnection(url, "tux", > "tux"); > CallableStatement cs = conn.prepareCall(scall); > cs.registerOutParameter(2, Types.VARCHAR); > cs.setInt(1, interString); > cs.execute(); > cs.close(); > conn.close(); > output = cs.getString(2); > } catch (SQLException e) { > System.err.println("Error: " + e.getMessage()); > } > return output; > } > > public void setInput(String s) > { > // Here to assign input parameters > interString = Integer.parseInt(s); > } > } > > Thanks > > Regards, > > Neo Gigs > ======== > VB? > http://communities.msn.com.my/VisualBasicwithNeo > http://www.vbcity.com/forum > http://www.vbweb.co.uk > Get paid cash receive email? > http://www.MintMail.com/?m=1414418 > Reading SMS got paid? > http://www.dynamicsms.com.au/intro.asp?ref=0123502385&refc=348 > Malaysianshop.com http://www.malaysianshop.com > More Traffic? > http://www.exitblaze.com/cgi-bin/intro_track.pl?b=25924&c=xbad1 > ================================================ > Note:This is intended to addressees only, if you wanna be removed, let me > know. > > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>