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>