![]() |
![]() |
|
|
| |
WebLogic JDBC ̊Tv
ȉ̐߂ł́AJDBC R|[lg JDBC API ƂɂĊTµ܁E
JDBC ́ASQL sν߁EJava API ̂ŁE API ̂́AJava vO~O LqꂽAꘂ̃NXƃC^tF[X\獁EBJDBC ̓c[/f[^x[XJҁEW API ŁEpure-Java API 聂gpӂf[^x[X AvP[V̍쐬 \Ղ܁E
JDBC ͒x C^tF[XŁESQL 聃R}hڋNi遌Ăяoj߂Ɏgp B܁EJDBC JMS ́EEJB ǂ̍x̃C^tF[Xƃc[\z邽߂́Eł B
JDBC hCóAJDBC API ̃C^tF[XƃNX ځEBEA ́AJDBC API dlg ܂ȃf[^x[X ANZXpIvV E܁E ̃IvVɂ́AOracleAMicrosoft SQL ServerA Informix f[^x[XǗVXeiDBMSjp WebLogic jDriver ȂǁE2 ̑w JDBC hCoƁANCAg AvP[V DBMS ƂƂ́EƁEWebLogic Server ĂŎgp whCo B
WebLogic Server ́Aȉ̃^Cv JDBC ̃hCogpӂ܁E ̃hCo݂ɘAg邱ƂɁEāAf[^x[X ANZX B
ԑwA[LeN` p Af[^x[X \[X WebLogic Server WΗł܁Ex_ɈˑȂw JDBC hCogpӁEAw⽃R|[lgՎЁEDBMS ̊ɁEȒPɓKA ڐA̍R[hLqۂł܁E
̕\ɁAWebLogic Server Ŏgph郃Cöꗗ҂܁E
hCow |
hCõ^CvƖO |
f[^x[XځE/strong> |
hLg \[X |
---|---|---|---|
2 w |
Type 2 ilCeBu Type 4 iI[ Javaj |
WebLogic Server DBMS ƁE/p> |
ԁwWebLogic JDBC vO~O KChxĩ}jAj wǗ҃KChx́uJDBC ڑ̊ǁE/a>v wWebLogic jDriver for Oracle ̃CXg[Ǝgx wWebLogic jDriver for Informix CXg[Ǝgx |
2 w iXA၁j |
Type 2 ilCeBu |
UgUNVŁEWebLogic Server ́EDBMS ƁE |
wǗ҃KChx́uJDBC ڑ̊ǁE/a>v |
w |
Type 3 |
NCAg WebLogic Server ƊԁBRMI hCo͔Et3 ̃hCóE gp BJTS hCo͕UgUNVŎgp BPool JTS hCo̓T[oTCĥ݁B |
wWebLogic JDBC vO~O KChxĩ}jAj |
ȉ̐߂ł́A\ 1-1 uJDBC hCovɁEJDBC hCoɂďڂ־܁E
ȉ̐߂ł́Ax_ŗL DBMS ̂ɐڑ邽߁EWebLogic Server ɂŎgp Type 2 Type 4 BEA 2 ̑whCoɂĐ־܁E
BEA Oracle ̗p Type 2 JDBC hCoŁEWebLogic jDriver for Oracle AWebLogic Server zzLbgɁE܁ẼhCogpӁÉAOracle NCAgCXg[ K镗v BWebLogic jDriver for Oracle XA hCóAWebLogic jDriver for Oracle UgUNVpɊg܁EڍׂɂẮAwWebLogic jDriver for Oracle ̃CXg[Ǝgx QƂāE
WebLogic jDriver for Microsoft SQL Server
WebLogic Server 6.1 zzLbgɁEBEA WebLogic jDriver for Microsoft SQL Server ̂́AMicrosoft SQL Server ւ̐ځE pure-JavaAType 4 JDBC 𒁃hCoŁEڍׂɂẮAwWebLogic jDriver for Microsoft SQL Server ̃CXg[Ǝgx QƂāE
WebLogic Server 6.1 zzLbgɁEBEA WebLogic jDriver for Informix ̂́AInformix DBMS ւ̐ځE pure-JavaAType 4 JDBC 𒁃hCoŁEڍׂɂẮAwWebLogic jDriver for Informix ̃CXg[Ǝgx QƂāE
ȉ̐߂ł́ANCAgւ̃f[^x[X ANZX WebLogic w JDBC hCoɂĐ־܁E ̃hCȍڍׂɂẮAwWebLogic JDBC vO~O KChx́uWebLogic w JDBC hCo̎gv QƂāE
WebLogic Pool hCogpӁEAHTTP T[ubg EJB ǂ̃T[oTCh AvP[V v[Epł܁E
WebLogic RMI hCóAw Type 3 JDBCiJava Data Base ConnectivityjhCoŁẼhCo WebLogic Server ͂ŁEsAꁔCӁE2 ̑w JDBC hCoƈꏏɎgp邱ƂŃf[^x[X ANZX EE܁EWebLogic Server NX^ RtBO[V ́ANX^ JDBC pɎgpł܁E AJDBC NCAg WebLogic ̓NX^̃[h oVO@\ƃt@CI[o@\ԗpł܁E
WebLogic JTS hCo ͑w Type 3 JDBC hCoŁA1 ̃f[^x[X CX^Xgpӂ镡̃T[oԂł̕UgUNVɎgp BJTS hCo 2 ̓tF[Y R~bg 邽߁AP f[^x[X CX^XgpӁEɁE WebLogic jDriver for Oracle XA h胃Co I擂ɓ삵܁E
WebLogic Server ́Aȉ̋@\ T𒃁[hp[eB JDBC hCoƘAgċ@\܁E
܁EWebLogic Server whCo JDBC APÍA W JDBC ĂяozΦ@鋔\ T𒃁[hp[eB hCoT|[g܁E
Cloudscape pure-Java DBMS ̂́AWebLogic Server zzLbgɕtĂ܁ECloudscape DBMS ɃANZX邽߁EJDBC ̃hCotՑĂ܁E DBMS ̂́AzzLbgɕt̃R[h TvŕpɂɎgp B DBMS ̂gpӂłȂꍇA DBMS ̂eXg JpɎgpł܁EA̕]łg Ίi[łf郁[^̗ʂɂ́E B
ڍׂɂẮAuWebLogic Server Cloudscape Database łgpӂv遂Q ہE
2 w Sybase jConnect Type 4 hCóAWebLogic Server zzLbgɕtĂ܁ẼhCóAŒE܁EWebLogic Server ł̂̃hCo̎g ڍׂɂẮA WebLogic Server ł̃T[hp[eB hCo̎g QƂāE
2 w Oracle Thin Type 4 hCóAWebLogic Server Oracle DBMS ̐ځEEEWebLogic Server ł̂̃hCo̎g ڍׂɂẮA WebLogic Server ł̃T[hp[eB hCo̎g QƂāE
whCo WebLogic Server ͂gpӂāADBMS ւ̐vȐځE\ՁEv[ɃANZX܁Eڑv[NϮƂɂ̓f[^x[Xڑ́Em ŁAf[^x[XڑmӧI郁[o[wbh Bڑv[́AWebLogic Pool hCog T[oTCh AvP[ViHTTP T[ubg EJB ǁjg玗p邩AWebLogic RMI hCog X^hA Java NCAgg玗p܁E̐߂ł́Aڑv[̊TvɂĐ־܁EڍׂɂẮA ڑv[̎g QƂāE
ڑv[g WebLogic Server EDBMS ځÉA2 w JDBC hCoKvƂȁEB 2 ̑w hCóAWebLogic jDriver 1 ̂E܂̓T[hp[eB JDBC hCoiSybase jConnect hCoȂǁjŁE ̃hCóAWebLogic zzLbgɁE܁E̕\ɁAڑv[gpӂ郁bg҂܁E
HTTP T[uჃbg EJB ǂ̃T[oTCh AvP[Vf烁[^x[XɃANZX ́AWebLogic Pool hCogpӂ܁E2 tF[Y R~bg gUNV̏ꍇ́AWebLogic Server JDBC/XA hCo WebLogic jDriver for Oracle/XA ̂gpӂ܁E1 ̃f[^x[X CX^XgΤ̃T[oԂł̕UgUNV̏ꍇ́AJTS hCogpӂ܁E܁EJava Naming and Directory Interface iJNDIj DataSource ƃIuWFNggpӂĐڑv[ɃANZX邱ƁE܁E
BEA ANCAgTCh̑w JDBC p RMI ɃhCo E܁ERMI hCoɂ́AJava 2 Enterprise Edition iJ2EEjdlg ΕWx[X̃Av[` bg BVfvCgÈ́ARMI hCogΤƂԊ߂܁Et3 NCAg T[rX́Ã[Xł͔ɂȁEĂ܁E
WebLogic RMI hCo Type 3́Aw JDBC hCoŁARMI DataSource ƃIuWFNgg f[^x[XځEفẼhCo̓NX^ꂽ JDBC ɁEAWebLogic NX^̃[h oVO tFCI[o@\ԗp܁EDataSource IuWFNg `EAgUNV T|[gL 𗌂́Eł܁E
JDBC }`v[ł́Af[^x[X̐ځEγ邽߂ɁAp܂̓[h oVO ASYI 𑑂܁E}`v[́uv[̃v[vŁAځE𒂽߂̃v[XgI瑑ퟋӂ邽߂̃RtBO[V\ȃASY E܁EڍׂɂẮA }`v[̎g QƂāE
}`v[́Aȉ̂ꂩ̕@ ݁E܁E
WebLogic Server ł́Af[^ \[XAڑv[A}`v[ȂǁEJDBC ̃IuWFNgNX^ANX^ŃzXg AvP[V̉p߂邱Ƃł܁ENX^pɃRtBO[Ve JDBC 銃IuWFNǵANX^ ǗΏۃT[oƂɑ݂ĂȁEȁEB AJDBC IuWFNgRtBO[V ́ANX^ Eɂčs܁E
NX^ɁEJDBC I郃uWFNg̏ڍׂɂẮAwWebLogic Server NX^ [U[Y KChx́uJDBC ځE/a>vQ ہE
DataSource IuWFNggpӁEAJDBC NCAg DBMS ͐ځEځEɂȁEBDataSource ́ANCAg vOƐڑv[̊Ԃ̃C^tF[XŁEef[^ \[Xɂ́AƁEDataSource ̃IuWFNgKvŁEDataSource IuWFNǵAڑv[܂͕UgUNVT|[g DataSource N郃XƂāEł܁EڍׂɂẮA DataSource ̃RtBO[VƎgp@ QƂāE
JDBC AvP[V Ajava.sql API gpӂ܁E API ̂gpӁEAf[^ \[Xւ̐ڑmӧANG𑗐MǍʂԁEɕKvȃNX IuWFNg ق܁E
苎̕\ɁAWebLogic Server ł悭gp JDBC C^tF[X҂܁EׂāEJDBC ̃C^tF[X̏ڍׂɂẮAjava.sql Javadoc ܁Eweblogic.jdbc Javadoc ͂Q ہE
WebLogic jDriver for Oracle gpӁÉẼC^tF[X̏ڍׂɂẮAwWebLogic jDriver for Oracle ̃CXg[Ǝgx QƂāE
WebLogic Server ́AJDBC 2.0 T|[gāEJDK 1.3 gp܁E
́EɒӂāE
callableStatement ܁EpreparedStatement
SQL ͕ł̓ob`XViaddBatch()
j͎gpł܁E
T|[g vbgtH[́Ax_ŗL DBMS ̂ƃhCoɁEĈقȁEB_ł́EɂẮAuBEA WebLogic Server vbgtH[ T|[gvQ ہE
![]() |
![]() |
![]() |