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 ú»�E²�E܁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 ̂eXú»Œí³ƒg 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 ̐ځEú»�E²�EWebLogic 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 ڑ́Eú»�E¿’ᑬŁ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 `ú»�E²�AgUNV 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 ̃IuWFNgNú»Œí³‰X^ANX^ŃzXg AvP[V̉—pú»´ú΂߂邱Ƃł܁ENX^pɃRtBO[Ve JDBC 銃IuWFNǵANX^ ǗΏۃT[oƂɑ݂ĂȁEȁEB AJDBC IuWFNgRú»Œí³“tBO[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 ú»�E²ƒf[^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 pú»�E³ƒ[^w û´ˆí²©A܂͎w肹Ɂj s邽߂Ɏgp B

CallableStatement

Statement p猁EBf[^x[X XgAh vV[Wւ̌Ăяo sú»¸úν߂Ɏgp BOUT p[^ú»£úсEbh ú»�E²�E

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[uú»�Eµ�sɃJlƂĊi[ z锗vf񗑂ւ̃ANZX B

Clob

Character Large Object 𒁂Jú»Œí³‰lƂăf[^x[X e[u̍sɊi[g鑂ݍ݃^CvB

Blob

Binary Large Object Jú»Œí³‰lƂă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