Very Computer

Is there available similar middleware driver, which uses EJB architecture?

Or is it possible to configure using RMI-to-JDBC driver with EJB servers
(for example Jonas server)?

Quote:>I've seen a link to RMI-to-JDBC driver, which actually used RMI as
>communication layer. Anyone used this one with JDBC 2 compliant drivers?

          <URL: http://www.objectweb.org/RmiJdbc/>

        I briefly tried it on PostgreSQL 7.0. With a direct JDBC
        connection, ResultSet.getRow() (which has only come at JDBC 2.0)
        it worked, but via RmiJDBC I got

                Exception in thread "main" java.lang.AbstractMethodError:
                RmiJdbc/RJResultSet.getRow

        So it seems that RmiJdbc doesn't implement JDBC 2.0.

        The JDBC 1 functionality seemed to work in my initial tests,
        and I think that RmiJdbc seems very promising. It would be great
        especially for managing Jdbc-Odbc-bridge connections, because
        the need of ODBC drivers and configuration on each client is a
        drag.

--

* <URL: http://www.euro.cauce.org/>

Quote:>>I've seen a link to RMI-to-JDBC driver, which actually used RMI as
>>communication layer. Anyone used this one with JDBC 2 compliant drivers?
> If you are referring to RmiJdbc,

>   <URL: http://www.objectweb.org/RmiJdbc/>

I wonder, if it's possible to configure Rmijdbc server driver to run as EJB
service. This would make it possible to use EJB communication methods from
applet client. And especially it would be a lot easier to maintain back-end
services as EJB session objects (startup, activation).

Quote:> I briefly tried it on PostgreSQL 7.0. With a direct JDBC
> connection, ResultSet.getRow() (which has only come at JDBC 2.0)
> it worked, but via RmiJDBC I got

> Exception in thread "main" java.lang.AbstractMethodError:
> RmiJdbc/RJResultSet.getRow

> So it seems that RmiJdbc doesn't implement JDBC 2.0.

Quote:>> So it seems that RmiJdbc doesn't implement JDBC 2.0.

Quote:>Hope someone clever java guru can implement a new version with jdbc2.0
>methods.

  public boolean next() throws RemoteException, SQLException {
    return jdbcResultSet_.next();
  }

        And here jdbcResultSet_ is an instance of java.sql.ResultSet.
        So I think that upgrading to JDBC 2.0 should be fairly trivial;
        just passing all the calls to the new methods over to the
        corresponding java.sql.* methods, e.g. in RJResultSetServer.java:

  public int getRow() throws RemoteException, SQLException {
    return jdbcResultSet_.getRow();
  }

        But I'm not sure. Even less sure I am that I'd be into doing all
        that :) Though if I'm correct, it shouldn't be any more than a
        mechanical job... I emailed to the developer and asked if it
        will really be that simple.

--

* <URL: http://www.euro.cauce.org/>

        I did some more testing on RmiJdbc and now we have an RmiJdbc
        server running on an NT server with the neccessary ODBC services
        configured, and I'm able to connect to the ODBC services with

                jdbcURL=jdbc:rmi://<SERVER>:1099/jdbc:odbc:<DSN>
                jdbcdriver=RmiJdbc.RJDriver

        Where <SERVER> is the mentioned NT server and <DSN> the ODBC
        Data Source Name.

        So now I can access ODBC data sources, via <SERVER>, from Linux
        or anywhere else where I have a functioning JRE and the RmiJdbc
        driver. Totally transparently. I find this very, very nice :)
        And the setup was incredibly simple.

        But let's see if problems show up on further testing...

--

* <URL: http://www.euro.cauce.org/>

I have a JDBC-RMI "Proxy" driver available for free at:
www.jetools.com

It only supports 1.2.x JDBC spec though, not 2.0.

Quote:> I've seen a link to RMI-to-JDBC driver, which actually used RMI as
> communication layer. Anyone used this one with JDBC 2 compliant
drivers?

> Is there available similar middleware driver, which uses EJB
architecture?

> Or is it possible to configure using RMI-to-JDBC driver with EJB
servers
> (for example Jonas server)?