Hi All,
I am using Rod West document for linking e-business to Apex and our Apex and EBS are in different domain. I did all the steps that the document provides but I have problem changing the jsp. I changed the jsp but it fails in compile. Here is the jsp:
<%@ page contentType="text/html;charset=UTF-8" %>
<%--
/* LaunchApex.jsp */
--%>
<%@ page
import="java.io.*"
import="java.net.*"
import="java.sql.*"
import="javax.servlet.http.*"
import="java.util.Enumeration"
import="java.util.Properties"
import="java.lang.Math"
import="oracle.apps.fnd.common.VersionInfo"
import="oracle.apps.fnd.functionSecurity.Function"
import="oracle.apps.fnd.functionSecurity.RunFunction"
import="oracle.apps.fnd.common.WebAppsContext"
import="oracle.apps.fnd.common.AppsEnvironmentStore"
import="oracle.apps.fnd.common.WebRequestUtil"
import="oracle.apps.fnd.common.ResourceStore"
import="oracle.apps.fnd.security.CSS"
import="oracle.apps.fnd.common.Message"
import="oracle.jdbc.OracleConnection"
import="oracle.jdbc.OraclePreparedStatement"
import="oracle.jdbc.OracleResultSet"
%>
<%
// Session has to be validated first
WebAppsContext ctx = WebRequestUtil.validateContext(request, response);
if (ctx==null) {
return; }
String cookieName = ctx.getSessionCookieName();
boolean validSession = ctx.validateSession(cookieName);
WebRequestUtil.setClientEncoding(response, ctx);
%>
<html>
<head>
<title>Launch Apex</title>
<!-- LaunchApex.jsp -->
</head>
<body>
<%
String p_application = request.getParameter("application");
p_application = ( p_application==null ? "NONE" : p_application);
String p_page = request.getParameter("page");
p_page = ( p_page==null ? "1" : p_page);
String p_item_names = request.getParameter("item_names");
p_item_names = ( p_item_names==null ? "" : p_item_names);
String p_item_values = request.getParameter("item_values");
p_item_values = ( p_item_values==null ? "" : p_item_values);
AppsEnvironmentStore m_env = (AppsEnvironmentStore) ctx.getEnvStore();
String query = "SELECT apps_applmgr.get_apex_url FROM DUAL";
Connection conn = ctx.getJDBCConnection();
if(conn!= null){
try {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next())
{
String l_launcher=rs.getString(1);
} //while
rs.close();
stmt.close();
response.sendRedirect(l_launcher);
} //try
catch (Exception e) {
out.println("Exception found : ");
} //catch
}
%>
</body>
</html>
and here is the error:
!!COMPILATION ERROR(0) LaunchApex.jsp:
_LaunchApex.java:227: error: reference to Statement is ambiguous, both interface java.sql.Statement in java.sql and class java.beans.Statement in java.beans match
Statement stmt = conn.createStatement();
^
_LaunchApex.java:237: error: cannot find symbol
response.sendRedirect(l_launcher);
^
symbol: variable l_launcher
location: class _LaunchApex
Appreciate your help.