資源描述:
《java 與 pl_sql集成( 35 )》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、HowcanweintegratePL/SQLandJavatodevelopapplications?PresentedbyYun-HsiangWuIS8900AdvancedSQLwithOracleDecember18,2002IntroductionWhydoprogrammersusestoredprocedures?Storedproceduresareabletoprocessasetofoperationsinacallandtheyhavebetterperformanceofdata-i
2、ntensiveoperations.StartingwithOracle8i,Oraclesupportstwostoredprocedures,PL/SQLstoredproceduresandJavastoredproceduresPL/SQLStoredproceduresBeforeOracle8i,PL/SQListheonlylanguagethatcanbeusedinthedatabase.PL/SQListheprocedurallanguageextensiontoSQLanditen
3、capsulatesSQLstatementsinprocedurallogicandexecutealldatabaseobjecttypes.JavaStoredproceduresStartingwithOracle8i,OraclesupportsJavainthedatabase.JavastoredproceduresalsocanencapsulateSQLstatementsthatrunwithinthedatabaseviaprocedurallogicanditcanavoidover
4、headofnetworks.TerminologyofPL/SQLvs.JavaTerminologyofPL/SQLvs.JavaTerminologyofPL/SQLvs.JavaTerminologyofPL/SQLvs.JavaHowtodevelopJavaStoredproceduresStep1:TocreateanewJavaclassorreuseanexistingonethatmeetyourneed.OracleprovidesJDeveloperandsupportsmanyot
5、herJavaIDEssuchasSymantec'sVisualCafé,andBorland'sJbuilder.HowtodevelopJavaStoredproceduresStep2:ToloadJavaprogramintodatabasetobestoredasJavaschemeobjects.TheprogramcanloadJavainoneofthefollowingforms:Javasourcefilesandcompiledinthedatabase.compiledoutsid
6、ethedatabaseandbeloadedas.classor.jarfilesloadedasJavaresourcefilesHowtodevelopJavaStoredproceduresTwomethodtoloadJava:UsingCreateJavastatementstoloadJavasource,binaries,orresourcefilesintothedatabasefromabinaryfileontheoperatingsystemlevelorfromaLOBcolumn
7、inthedatabase.UsingloadjavautilitytoloadJavaprogramsintothedatabase.HowtodevelopJavaStoredproceduresStep3:PublishtheJavacodes.ThreeissuesshouldbeaddressedbeforepublishingJavaclasses(OracleTechnicalWhitePaper,1999):MappingSQLtypestoJavatypes.MappingSQLparam
8、etermodestoJavaparametermodes.PrivilegesunderwhichtheJavaprogramswillexecute.HowtodevelopJavaStoredproceduresOncefinishedaddressingthesethreeissues,theprogrammerscanwritecallspecificationstocontrolthemappingf