JSP在EBS中的开发-V1.0.doc

JSP在EBS中的开发Author:彭美Creation Date:2014-07-01Last Updated:2014-07-02Document Ref: Version:1.0 Copy Number_Document ControlChange Record9DateAuthorVersionChange Reference2014-07-01PM2164071.0No Previous DocumentReviewersNamePositionDistributionCopy No.NameLocation1234Note To Holders:If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.ContentsDocument Control2JSP注册教程4预览JSP页面7Open and Closed Issues for this Deliverable9Open Issues9Closed Issues9JSP注册教程第一步：编辑好JSP文件，并在eclipse中试运行看是否可以通过1.编辑 Test.jsp文件 ORALCE-EBSEBS开发JSP页面! This is a test page!%Statement stmt = null;ResultSet rs =null;tryif (conn != null)stmt = conn.createStatement();stmt.execute(insert into hek_test_a values(1,sysdate,测试数据QQ11);rs = stmt.executeQuery(select col1,col2,col3 from hek_test_a for update);out.println();while(rs.next()out.println();out.println(输出：+rs.getString(1);out.println();out.println();mit();catch(Exception ex)ex.printStackTrace();finallytryrs.close();stmt.close();conn.close();catch(Exception exsql)exsql.printStackTrace(); %-注意此处不能写成UAT9，不然会报 Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 第二步： 上传JSP页面(1) 将Test.jsp页面上传到服务器的$OA_HTML下的ebs_java目录下：(/data/uat/apps/apps_st/comn/webapps/oacore/html/ebs_java/)cd $OA_HTML mkdir ebs_java 如果没有ebs_java文件夹，则创建(2) 使JSP文件在EBS中能自动编译当你在EBS中为此jsp文件注册功能，然后到相对应的职责下运行此功能时，可能会报java类如下错误：javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException这时你需要修改 $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml这个配置文件中，修DEVELOPER_MODE和Main_Mode节点的值修改为如下所示：1developer_mode2true34main_mode5recompile之后重新启动服务器就可以了。代码参照下面第三步：上传到服务器，注册1. 将对应的jar包上传至服务器目录:$FND_TOP/java/3rdparty/stdalone，此处jsp页面中有用到 ojdbc14-.0.jar（/data/uat/apps/apps_st/appl/fnd/12.0.0/java/3rdparty/stdalone/） 2. 修改OC4J配置路径：$ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/ orion-application.xml修改 orion-application.xml 文件，添加如下内容:3. 注册功能功能名称用户功能名称类型HTML调用JSP_EBS_TESTJSP TESTJSP 可与 OA 共同使用ebs_java/test.jsp4. -重启OC4J包cd $ADMIN_SCRIPTS_HOME-关闭sh adapcctl.sh stopsh adoacorectl.sh stop-重启sh adapcctl.sh startsh adoacorectl.sh start返回