I want to create simple tableView in. Can anybody please give me some code for doing the same. I have tried making tableView from the examples posted on SDN by prakash and other.
Thanks for the reply. But dear I have already gone through this link. If you have created a simple table then can you post that code to me, here in this post.
Actually I want to create a table and then fill the table enteries with the result from a BAPI.
package com.ust.jcatotable;
import javax.naming.Context;
import javax.resource.cci.MappedRecord;
import javax.resource.cci.RecordFactory;
import com.sapportals.connector.ConnectorException;
import com.sapportals.connector.connection.IConnection;
import com.sapportals.connector.connection.IConnectionFactory;
import com.sapportals.connector.execution.functions.IInteraction;
import com.sapportals.connector.execution.functions.IInteractionSpec;
import com.sapportals.connector.execution.structures.IRecord;
import com.sapportals.connector.execution.structures.IRecordSet;
import com.sapportals.connector.metadata.functions.IFunction;
import com.sapportals.connector.metadata.functions.IFunctionsMetaData;
import com.sapportals.htmlb.page.DynPage;
import com.sapportals.htmlb.page.PageException;
import com.sapportals.portal.htmlb.page.JSPDynPage;
import com.sapportals.portal.htmlb.page.PageProcessorComponent;
import com.sapportals.portal.ivs.cg.ConnectionProperties;
import com.sapportals.portal.ivs.cg.IConnectorGatewayService;
import com.sapportals.portal.ivs.cg.IConnectorService;
import com.sapportals.portal.prt.component.IPortalComponentProfile;
import com.sapportals.portal.prt.component.IPortalComponentRequest;
import com.sapportals.portal.prt.runtime.PortalRuntime;
public class Display extends PageProcessorComponent {
public DynPage getPage(){
return new DisplayDynPage();
}
public static class DisplayDynPage extends JSPDynPage{
private TableBean myBean = null;
public void doInitialization(){
IPortalComponentProfile profile = ((IPortalComponentRequest)getRequest()).getComponentContext().getProfile();
Object o = profile.getValue("myBean");
if(o==null || !(o instanceof TableBean)){
myBean = new TableBean();
profile.putValue("myBean",myBean);
} else {
myBean = (TableBean) o;
}
// fill your bean with data here...
IPortalComponentRequest request = (IPortalComponentRequest) this.getRequest();
doJca(request);
}
public void doProcessAfterInput() throws PageException {
}
public void doProcessBeforeOutput() throws PageException {
this.setJspName("display.jsp");
}
private IConnection getConnection(
IPortalComponentRequest request,
String alias)
throws Exception {
IConnectorGatewayService cgService =
(IConnectorGatewayService) PortalRuntime
.getRuntimeResources()
.getService(
IConnectorService.KEY);
ConnectionProperties prop =
new ConnectionProperties(
request.getLocale(),
request.getUser());
return cgService.getConnection(alias, prop);
}
public void doJca(IPortalComponentRequest request) {
IConnectionFactory connectionFactory = null;
IConnection client = null;
String rfm_name = "BAPI_COMPANYCODE_GETLIST";
try {
try {
//pass the request & system alias
//Change the alias to whatever the alias is for your R/3 system
client = getConnection(request, "R3IDES");
} catch (Exception e) {
System.out.println(
"Couldn't establish a connection with a target system.");
return;
}
/*
* Start Interaction
* */
IInteraction interaction = client.createInteractionEx();
IInteractionSpec interactionSpec = interaction.getInteractionSpec();
interactionSpec.setPropertyValue("Name", rfm_name);
/*
* CCI api only has one datatype: Record
* */
RecordFactory recordFactory = interaction.getRecordFactory();
MappedRecord importParams = recordFactory.createMappedRecord("CONTAINER_OF_IMPORT_PARAMS");
IFunctionsMetaData functionsMetaData = client.getFunctionsMetaData();
IFunction function = functionsMetaData.getFunction(rfm_name);
if (function == null) {
System.out.println(
"Couldn't find " + rfm_name + " in a target system.");
return;
}
/*
* How to invoke Function modules
* */
System.out.println("Invoking... " + function.getName());
MappedRecord exportParams = (MappedRecord) interaction.execute(interactionSpec, importParams);
/*
* How to get structure values
* */
IRecord exportStructure = (IRecord) exportParams.get("RETURN");
String columnOne = exportStructure.getString("TYPE");
String columnTwo = exportStructure.getString("CODE");
String columnThree = exportStructure.getString("MESSAGE");
System.out.println(" RETURN-TYPE = " + columnOne);
System.out.println(" RETURN-CODE = " + columnTwo);
System.out.println(" RETURN-MESSAGE =" + columnThree);
/*
* How to get table values
* */
IRecordSet exportTable = (IRecordSet) exportParams.get("COMPANYCODE_LIST");
exportTable.beforeFirst(); // Moves the cursor before the first row.
while (exportTable.next()) {
String column_1 = exportTable.getString("COMP_CODE");
String column_2 = exportTable.getString("COMP_NAME");
System.out.println(" COMPANYCODE_LIST-COMP_CODE = " + column_1);
System.out.println(" COMPANYCODE_LIST-COMP_NAME = " + column_2);
}
//create the tableview mode in the bean
myBean.createData(exportTable);
/*
* Closing the connection
* */
client.close();
} catch (ConnectorException e) {
//app.putValue("error", e);
System.out.println("Caught an exception: n" + e);
} catch (Exception e) {
System.out.println("Caught an exception: n" + e);
}
}
}
}
<b>Bean</b>
package com.ust.jcatotable;
import java.io.Serializable;
import java.util.Vector;
import com.sapportals.connector.execution.structures.IRecordSet;
import com.sapportals.htmlb.table.DefaultTableViewModel;
import com.sapportals.htmlb.table.TableViewModel;
public class TableBean implements Serializable {
public DefaultTableViewModel model;
public TableViewModel getModel() {
return this.model;
}
public void setModel(DefaultTableViewModel model) {
this.model = model;
}
public void createData(IRecordSet table) {
//this is your column names
Vector column = new Vector();
column.addElement("Company Code");
column.addElement("Company Name");
//all this logic is for the data part.
Vector rVector = new Vector();
try {
table.beforeFirst();
while (table.next()) {
Vector data = new Vector();
data.addElement(table.getString("COMP_CODE"));
data.addElement(table.getString("COMP_NAME"));
rVector.addElement(data);
}
} catch (Exception e) {
e.printStackTrace();
}
//this is where you create the model
this.setModel(new DefaultTableViewModel(rVector, column));
}
}
Can you post the Stack Trace? Is your system defined for SAPLogonTicket or Usermapping? If it is defined saplogonticket then does you userid in portal matches with userid in R/3? If it defined for Usermapping then have you mapped your userid and password properly?
#1.5#000EA6C6016B00630000002F000006640003F485C791CE5F#1113280346171#com.sap.portal.connectors.R3#sap.com/irj#com.sap.portal.connectors.R3#praveshv#280#####SAPEngine_Application_Thread[impl:3]_31##0#0#Error#1#/System/Server#Plain###Failed to get connection. Please contact your admin. #
#1.5#000EA6C6016B006300000030000006640003F485C791CF58#1113280346171#System.err#sap.com/irj#System.err#praveshv#280#####SAPEngine_Application_Thread[impl:3]_31##0#0#Error##Plain###<b>Couldn't establish a connection with a target system</b> : Connection Failed: Nested Exception. Failed to get connection. Please contact your admin. #
#1.5#000EA6C6016B006300000031000006640003F485C792E830#1113280346234#com.sap.portal.portal#sap.com/irj#com.sap.portal.portal#praveshv#280#####SAPEngine_Application_Thread[impl:3]_31##0#0#Info##Plain###------PRT AbstractPortalComponent: calling doContent for portal component: CallingBAPI.Display#
Please notice the bold lines. This clearly means that its going into the catch block hence the connection to the system is not created. Should I create a new system? Can you please give me some links to create a system.
I am also excuting the same program. I am facing the same problem here - 'Tag tableView attribute model: Cannot access bean property myBean.model in page context.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.