ORACLE JAPAN Server Release 6.1

 

  |  

  WebLogic Server ꏃz[   |     JDBC vO~O KCh   |   O   |   ցE/a>   |   ֖ځE/a>   |     |   PDF

WebLogic JDBC ̊Tv

 

ȉ̐߂ł́AJDBC R|[lg JDBC API Ƃɂ‚ĊTµ܁E

 


JDBC ̊Tv

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 hCo̊Tv

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

JDBC hCõ^Cv

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

hCöꗗ\

̕\ɁAWebLogic Server Ŏgph郃Cöꗗ҂܁E

\1-1 JDBC hCo

hCow

hCõ^CvƖO

f[^x[XځE/strong>

hLg \[X

2 w
i XAj

Type 2 i񁁃lCeBu .dllj

  • WebLogic jDriver for Oracle

  • T[hp[eB hCo

Type 4 iI[ Javaj

  • WebLogic jDriver for Informix WebLogic jDriver for Microsoft SQL Server

  • ȉ́E փT[hp[eB hCo
    Oracle Thin
    Sybase jConnect DB2
    Informix JDBC

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

wWebLogic jDriver for Microsoft SQL Server CXg[Ǝgx

2 w

iXA၁j

Type 2 ilCeBu .dllj

  • WebLogic jDriver for Oracle XA

UgUNVŁEWebLogic Server ́EDBMS ƁE

ԁwWebLogic JTA vO}[Y KChx

wǗ҃KChx́uJDBC ڑ̊ǁE/a>v

w

Type 3

  • RMI hCo

  • Pool hCo

  • JTS

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


 

 


JDBC hCo̐־

ȉ̐߂ł́A\ 1-1 uJDBC hCovɁEJDBC hCoɂ‚ďڂ־܁E

WebLogic Server 2 w JDBC hCo

ȉ̐߂ł́Ax_ŗL DBMS ̂ɐڑ邽߁EWebLogic Server ɂŎgp Type 2 Type 4 BEA 2 ̑whCoɂ‚Đ־܁E

WebLogic jDriver for Oracle

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 jDriver for Informix

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

WebLogic Server JDBC whCo

ȉ̐߂ł́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 hCo

WebLogic Pool hCogpӁEAHTTP T[ubg EJB ǂ̃T[oTCh AvP[V v[Epł܁E

WebLogic RMI hCo

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

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

T[hp[eB hCo

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

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

Sybase jConnect hCo

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

Oracle Thin hCo

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

 


ڑv[̊Tv

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

\1-2 ڑv[gpӂ郁bg

ڑv[̃bg

@\

Ԃ̐ߖAI񁃁[o[wbh̍팸

DBMS ڑ́EEᑬŁE遐ڑv[gpӁEAڑm [UpŁEɂȁE遁E i蒂́AAvP[V R[hKvɉēƁEJDBC ̐ڑsΤƂŁEDBMS 遂́A sɃ[U ڑsԁE pꗐڑgΤꍂɓ삷B

DBMS 遃[ŮǁE/p>

VXe ́E DBMS EŁE遁EADBMS ڑɃCZX 邩A܂̓\[Xɕs ɏdvƂȁE

遃AvP[V DBMS ̓[UApX[hA DBMS ̏ꏊm 𒂂K镗vAS`K镗v B

DBMS iIvVgpӂŁE/p>

DBMS i鉑IvV EJB Ƃ̂悤 API ȂgΤꍇAWebLogic Server JDBC ځE ΃v[K{ƂȁE遁E AEJB gUNVmŠSɃR~bg܂̓[ obN B


 

T[oTCh AvP[Vł̐ڑv[̎g

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

NCAgTCh AvP[Vł̐ڑv[̎g

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

 


}`v[̊Tv

JDBC }`v[ł́Af[^x[X̐ځEγ邽߂ɁA—p܂̓[h oVO ASYI 𑑂܁E}`v[́uv[̃v[vŁAځE𒂽߂̃v[XgI瑑ퟋӂ邽߂̃RtBO[V”\ȃASY E܁Eڍׂɂ‚ẮA }`v[̎g QƂāE

}`v[ ASY̑I

}`v[́Aȉ̂ꂩ̕@ ݁E܁E

 


NX^ꂽ JDBC ̊Tv

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 ̊Tv

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 API

JDBC AvP[V ΁Ajava.sql API gpӂ܁E API ̂gpӁEAf[^ \[Xւ̐ڑmӧANG𑗐MǍʂ퟼ԁEɕKvȃNX IuWFNg ق܁E

WebLogic JDBC C^tF[X̒`

苎̕\ɁAWebLogic Server ł悭gp JDBC C^tF[X҂܁EׂāEJDBC ̃C^tF[X̏ڍׂɂ‚ẮAjava.sql Javadoc ܁Eweblogic.jdbc Javadoc ͂Q ہE

JDBC C^tF[X

־

Driver

hCoƃf[^x[XԂ̐ځE𐂵AhCoɊցE Ef[^x[Xւ̐ڑɊցE 񋟂B遊ehCo NXȁEȁEC^tF[XB

DataSource

R DBMS ܂͑̃f[^ \[X\𕂷Bf[^ \[Xւ̐ڑmӧ邽߂Ɏgp B

Statement

P SQL ȕp[^ȂŃf[^\[XɑMB

PreparedStatement

Statement 遂p猁EBRpCς݁ESQL ̕iIN pE[^w A܂͎w肹Ɂj s邽߂Ɏgp B

CallableStatement

Statement p猁EBf[^x[X XgAh vV[Wւ̌Ăяo sν߂Ɏgp BOUT p[^сEbh EE

ResultSet

SQL 遃NǴEsʂi[ BNG̏ퟰۂ𖞂񂪊i[ B

ResultSetMetaData

ResultSet IuWFNg J̃^CvƃvpeBɊցE 񋟂B

DataBaseMetaData

遃f[^x[XSʂɊցE 񋟂B遒P l܂͌ʃZbg B

Array

f[^x[X e[uEsɃJlƂĊi[ z锗vf񗑂ւ̃ANZX B

Clob

Character Large Object 𒁂JlƂăf[^x[X e[u̍sɊi[g鑂ݍ݃^CvB

Blob

Binary Large Object JlƂăf[^x[X e[u̍sɊi[g鑂ݍ݃^CvB

WebLogic jDriver for Oracle gpӁÉẼC^tF[X̏ڍׂɂ‚ẮAwWebLogic jDriver for Oracle ̃CXg[Ǝgx QƂāE

 


JDBC 2.0

WebLogic Server ́AJDBC 2.0 T|[gāEJDK 1.3 gp܁E

́EɒӂāE

 


v񁃃bgtH[

T|[g vbgtH[́Ax_ŗL DBMS ̂ƃhCoɁEĈقȁEB_ł́Eɂ‚ẮAuBEA WebLogic Server vbgtH[ T|[gvQ ہE

 

back to top previous page next page