JavaintheOracleDatabase@.PDFVIP

Java in the Oracle Database @ Work – Customer Case Studies An Oracle Sponsored White Paper Updated November 2007 Java in the Oracle Database @ Work – Customers Case Studies FOREWORD AND ACKNOWLEDGMENTS Almost a year ago, during my presentation at Oracle World San Francisco 2002, I asked the audience to share concrete, real life examples of running Java in the database. I am pleased to introduce this first issue of Customer Case Studies. This White Paper is a must read for all IT managers, DBAs, applications developers, and anyone who has ever questioned the usefulness of Java in the Oracle Database. You will learn how the combination of Java with the SQL engine turns the Oracle Database into an expansible data logic server, beyond a traditional relational database. The first case study describes Harris Corporation’s use of Java stored procedures for RMI call-out in their Weather And Radar Processor system. The second case study describes Appropriates Solution’s use of Java in the Oracle Database for secure credit card processing using JSSE call-outs. The third case study describes TECSIS’s use of Java in the Oracle Database for implementing a custom Enterprise Integration Framework. I know of more examples that could not be included in this paper because of lengthy authorization processes or corporate policies prohibiting the furnishing of case studies. If you would like to share your experience of using Java in the Oracle Database, please contact me at kuassi.mensah@. I am grateful to Lesley, John, Francisco, Raymond, and Esteban for sharing their experiences with the Oracle community. I would like to express my gratitude to Sahar Youssef in Oracle Support for testing and expanding Francisco’s paper, on her own time. Sahar has updated the JSSE use case as a Metalink Note # 256928.1 which is copy/pasted here. Finally, speci