Skip to Content
0
Former Member
May 15, 2007 at 06:45 AM

jdbc error in jspdynpage

27 Views

hi

all,

i am trying connect sql server in my jspdynpage application

i got error like this

Portal Runtime Error

An exception occurred while processing a request for :

iView : jdbc.jdbcjspdyn

Component Name : jdbc.jdbcjspdyn

The exception was logged. Inform your system administrator..

Exception id: 12:13_15/05/07_0001_11442750

See the details for the exception ID in the log file

here i past my code

package com.sap;

import java.sql.Connection;

import java.sql.*;

import com.sapportals.htmlb.page.*;

import com.sapportals.portal.htmlb.page.*;

import javax.servlet.*;

import javax.servlet.http.HttpServletRequest;

import com.sapportals.portal.prt.component.IPortalComponentRequest;

public class jdbcjspdyn extends PageProcessorComponent {

public DynPage getPage() {

return new jdbcjspdynDynPage();

}

public static class jdbcjspdynDynPage extends JSPDynPage {

public void doInitialization() throws PageException {

IPortalComponentRequest request1 =

(IPortalComponentRequest) this.getRequest();

HttpServletRequest req = (HttpServletRequest) this.getRequest();

try {

Class.forName(

"com.sap.portals.jdbc.sqlserver.SQLServerDriver");

String url =

"jdbc:sap:sqlserver://10.2.2.74;DatabaseName=TRAINING";

Connection con = null;

con =

DriverManager.getConnection(

url,

"SPADURI",

"netweaver");

Statement st = con.createStatement();

String sql =

"SELECT * FROM registration where fname='Pankaj'";

ResultSet rs = st.executeQuery(sql);

while (rs.next()) {

jdbcbean j = new jdbcbean();

j.setFname(rs.getString(1));

req.setAttribute("jdbcbean", j);

}

} catch (Exception e) {

System.out.println("Error" + e);

} finally {

}

}

public void doProcessAfterInput() throws PageException {

}

public void doProcessBeforeOutput() throws PageException {

this.setJspName("jdbcjsp.jsp");

}

}

}

my bean

package com.sap;

import java.sql.ResultSet;

import java.util.*;

import java.io.Serializable;

import com.sapportals.htmlb.table.DefaultTableViewModel;

//import com.sapportals.htmlb.table.TableView;

import com.sapportals.htmlb.table.TableViewModel;

public class jdbcbean implements Serializable

{ private String fname = "";

private String lname = "";

private String phoneNumber = "";

private String message = "";

public String getFname() {

return fname;

}

public String getLname() {

return lname;

}

public String getPhone() {

return phoneNumber;

}

public void setFname(String string) {

fname = string;

}

public void setLname(String string) {

lname = string;

}

public void setPhone(String string) {

phoneNumber = string;

}

}

my jsp

<%@ taglib uri= "tagLib" prefix="hbj" %>

<%@ page import="java.text.SimpleDateFormat" %>

<jsp:useBean id="jdbcbean" scope="session" class= "com.sap.jdbcbean" />

<hbj:content id="myContext" >

<hbj:page>

<hbj:form id="employeeInfoForm" >

<%jdbcbean=(com.sap.jdbcbean)request.getAttribute("jdbcbean");%>

<%jdbcbean.getLname();%>

<%jdbcbean.getFname();%>

<%jdbcbean.getPhone();%>

</hbj:form>

</hbj:page>

</hbj:content>