
                     Remote JDBC-JDBC Bridge ver.1.0

-------------------------------------------------------------------------

== Tv ==

JDBC hCoɂ͂Sނ̃^Cv܂B

  ^CvP JDBC-ODBC ubW
  ^CvQ lCeBuubW
  ^CvR lbghCo
  ^CvS _CNghCo

Remote JDBC-JDBC Bridge ́A^CvRɕނ JDBC hCoŁAAv
P[VAvbggp Remote JDBC-JDBC Driver (Ȍ RJJ-Driver
ƕ\L) ƁAhCo̗v𒆌pAۂ DBMS ւ̃ANZXs
Remote JDBC-JDBC Server (Ȍ RJJ-Server ƕ\L) ɂ\܂B

[UvO璼ڎgp RJJ-Driver ɂ̓lCeBuR[h܂
ĂȂ߁AuEUɂ HTTP T[oAvbgƋɃ[h
邱Ƃ\łB܂ RJJ-Drive ̗v𒆌p RJJ-Server ́AT[
oɃ[hꂽ JDBC hCogăf[^x[Xւ̃ANZXs
܂Bsun.jdbc.odbc.JdbcOdbcDriver ̂悤ȃlCeBuR[h܂
JDBC hCoARemote JDBC-JDBC Bridge ʂăAvbg痘p邱
Ƃ\łB


== ӎ ==

1. ݂̃o[Wł́ARJJ-Driver  RJJ-Server ̎ RMI p
  Ă邽߁ARMI T|[gȂvbgtH[ł͗pł܂B
  ܂AM␫\ RMI Ɉˑ܂B

2. ݂̃o[Wł́ARJJ-Driver ł̃f[^LbVOSsĂ
  Ȃ߁ARJJ-Server ւ̃ANZX񐔂ȂAɎԂ܂B
  ʂ̃f[^ɂ͌܂B

3. ҂ JDK 1.1.7B  Java 2 SDK v 1.2 gĂ̓eXgsĂ
  ܂BeXg͂ɕt JDBC-ODBC ubWpAAvbg
  ̎sƂ Appletviewer AAvP[V̎sƂ JRE
  gāAWindows NT 4.0  Windows 95 ōs܂B܂AHotjava
  1.1.5  Internet Explorer 4.0 + Java Plug-in 1.2 ł̓mFĂ
  ܂B

4. InputStream ɂf[^݂̏́AޑSf[^U
  u܂B

5. vO̗\zOȓɂAQ̔\ꍇ́Agp
  ȂłB


== s ==

RMI pł Java 1.1A܂ Java 2 vbgtH[BRJJ-Server 
sɂ́AړI DBMS ɃANZXł JDBC hCoKv (JDK 1.1.X 
Java 2 SDK Ɋ܂܂ JDBC-ODBC ubWł)B

  =======================================================================
  * Java 2 ŗpꍇA񋟂@\ JDBC 1.1 ƂȂ܂B
  =======================================================================


== CXg[ ==

1. rjj10.zip WJ܂B

  ȉ̃t@C܂B

    rjjsrv.jar     T[o[pvO
    rjjdrv.jar     NCAgpvO
    rjj.jar        T[o[pvO + NCAgpvO
    ReadMe.txt     hLg(̃t@C)
    src.zip        \[XvO

2. rjjsrv.jar t@CT[ozXgɈړ܂B

  Cӂ̃fBNg rjjsrv.jar ړACLASSPATH ϐݒ肵
  B

  (: Windows 95  rjjsrv.jar  C:\rjj Ɉړ)

    EJDK 1.1.X ̏ꍇ

        set CLASSPATH=.;C:\jdk1.1.7B\lib\classes.zip;C:\rjj\rjjsrv.jar

        // C:\jdk1.1.7B  JDK CXg[ĂtH_

    EJava 2 (JDK 1.2) ̏ꍇ

        set CLASSPATH=.;C:\rjj\rjjsrv.jar

  =======================================================================
  * CLASSPATH ̎ẃAϐ̂ java R}h javac R}h
   -classpath IvVg@܂B
  =======================================================================

3. AvP[V RJJ-Driver gpꍇ́Arjjdrv.jar t@C
  NCAgzXgɈړ܂B

  Cӂ̃fBNg rjjdrv.jar ړACLASSPATH ϐݒ肵
  Bݒ@ rjjsrv.jar t@Cł̗QlɂĂB


4. Avbggpꍇ́AAvbg̃NXt@CuĂ
  fBNgȉ rjjdrv.jar t@Cړ܂B


== RJJ-Driver ̎g ==

1. org.iwatsuki.rjj.RemoteJdbcJdbcDriver [h܂B

  ()
        Class.forName("org.iwatsuki.rjj.RemoteJdbcJdbcDriver");

  =======================================================================
  * ȑÕo[WƂ̌݊̂߂ rjj.RemoteJdbcJdbcDriver g
  悤ɂȂĂ܂Ão[Wł͍폜邩܂B
  =======================================================================

2. Connection IuWFNg擾 URL ɂ́Aȉ̕\Lgp܂B

    jdbc:rjj:<rjjurl>;<suburl>

  <rjjurl> ͎̌`Ŏw肵܂B

    //<host>:<port>/<name>

  <host> ɂ RJJ-Server ݂̑zXgA<port> ɂ̓WXg̃|[
  gԍA<name> ɂ RJJ-Server ̖Ow肵܂B͏ȗ邱
  Ƃ\ŁA<host> ȗꍇɂ̓Jg̃zXgA<port> ȗ
  ꍇɂ 1099 A<name> ȗꍇɂ "RemoteDriver" Ƃ
  OꂼftHglƂė^܂Bȉ̂悤ɏȗł܂B

    //<host>:<port>
    //<host>/<name>
    //<host>
    //:<port>/<name>
    //:<port>
    /<name>
    <name>
    (Sďȗ)

  <suburl> ɂ́A<rjjurl> ŎꂽT[oŗp\ JDBC hCo
  URL w肵܂B

  ()
        Connection con = DriverManager.getConnection
              ("jdbc:rjj://host;jdbc:odbc:dsn", "user", "password");

  =======================================================================
  * Kvɉă|[gԍ RJJ-Server ̖Ow肵܂B

  (: |[gԍw)
        Connection con = DriverManager.getConnection
              ("jdbc:rjj://host:2001;jdbc:odbc:dsn", "user", "password");
  =======================================================================

3. RJJ-Driver ́ARJJ-Server gpĂ JDBC hCoƓ
  SQLException  throw ܂B܂lbg[N֘ÃG[
  ɂ́ARJJ-Driver  SQLState="08001" SQLException 𐶐܂B

4. Avbg RJJ-Driver gpꍇ́AuEU_E[hł
  悤ɁAHTML t@C APPLET ^OŁAARCHIVE p[^w肵܂B

  (: AvbgƓfBNg rjjdrv.jar uĂꍇ)

        <applet code="MyApplet.class"
          archive="rjjdrv.jar"
          width=320 height=240>
        </applet>


== RJJ-Server ̎s ==

1. RMI u[gXgbvWXg̃X^[gBR}hCȉ̃R}
  hs܂B

  (: Windows 95AWindows NT)
        start rmiregistry

  (: Solaris)
        rmiregistry &

  =======================================================================
  * RMI WXg̓ftHgł̓|[g 1099 Ŏs܂BقȂ|[
  gŎsɂ̓R}ḧŃ|[gԍw肵܂B

  (: Windows 95AWindows NT)
        start rmiregistry 2001
  =======================================================================

2. RJJ-Server ̃X^[gB̃R}hs܂B

        java org.iwatsuki.rjj.RemoteJdbcJdbcServer [ -rjj:<rjjurl> ]
                        [ -security=<security manager> ] jdbc-driver ...

  =======================================================================
  * ȑÕo[WƂ̌݊̂߂ rjj.RemoteJdbcJdbcServer g
  悤ɂȂĂ܂Ão[Wł͍폜邩܂B
  =======================================================================

  ŁA[h JDBC hCow肵܂B

  (: Windows 95AWindows NT)
        start java org.iwatsuki.rjj.RemoteJdbcJdbcServer
                                        sun.jdbc.odbc.JdbcOdbcDriver

  (: Solaris)
        java org.iwatsuki.rjj.RemoteJdbcJdbcServer
                                        sun.jdbc.odbc.JdbcOdbcDriver &

   JDBC hCow肷ɂ̓Xy[Xŋ؂ĕׂ܂B

  -rjj: IvVgA|[gԍ RJJ-Server ɃoCh閼Ow
  肷邱Ƃł܂BzXg̎w\łAZLeB̗R
  Jg̃zXĝ݂ƂȂĂ܂B<rjjurl> ̒ĺAAvP[V
  Avbg Connection IuWFNg擾Ɏg <rjjurl> ARMI 
  WXg̋NɎw肳ꂽ|[gԍȂǂƈvĂKv܂B
  <rjjurl> ̏ȗ̒lȂǂ == RJJ-Driver ̎g == ̐Q
  ƂĂB

  (: Windows 95AWindows NT)
        start java org.iwatsuki.rjj.RemoteJdbcJdbcServer
                            -rjj://:2001 sun.jdbc.odbc.JdbcOdbcDriver

  ̃o[Wł́AftHgł RMISecurityManager CXg[
  ܂BZLeB}l[W𗘗pɂ -security IvV
  g܂B

  (: Windows95AWindowsNT)
        start java org.iwatsuki.rjj.RemoteJdbcJdbcServer
            -security=java.rmi.RMISecurityManager sun.jdbc.odbc.Jdbc ...

  =======================================================================
  * Java 2  RMISecurityManager gɂ́A|V[t@CpӂK
  v܂B
  =======================================================================

3. RJJ-Server ̃X^[ǵARJJ-Driver gpAvP[VAv
  bg DBMS ւ̃ANZX\ɂȂ܂B


== 쌠 ==

Remote JDBC-JDBC Bridge ̎gpA]ځAzzɊւ鐧͂܂B
ւ̘AsvłB

Remote JDBC-JDBC Bridge ́u⌎v̒앨łBÃvO
gpɂ萶Ȃ鑹Qɑ΂ĂA҂͕ۏ؂`𕉂܂B


== 藚 ==

1. TuZbg      1997/06/10

  DriverAConnectionAStatementAResultSet ̂ݎB

2. ver.0.01 alpha  1997/11/07

  tZbg̎B

  Remote JDBC-JDBC Bridge JB

3. ver.1.0 beta    1998/03/06

  gp|[goCh閼O̎wǉB

4. ver.1.0         1998/12/12

  ftHg RMISecurityManager gݍ܂Ȃ悤ɕύXB

  RemoteJdbcJdbcServer  -security IvVǉB

  jar t@CAT[opƃNCAgpɕB

  package Kɏ]O (org.iwatsuki.rjj.*) ɕύXB

  hCoNX̃[h DriverManager.registerDriver \bh
  SQLException  throw ꍇ ExceptionInInitializerError  throw
  悤ɕύXB


-------------------------------------------------------------------------

  ⌎                  E-mail:         mitsumasa@iwatsuki.org
                            NIFTY SERVE:    MXK02034
                            T|[gy[W: http://www.iwatsuki.org/java/
