install rmi server without installing JSDK

[elibb]

hi, im building an application with servlets and jsp.. i need to have access to a database that is on my client computer (on the computer that opens the browser), the only way i found to do it, is using rmi.. but then the client needs to have the RMI server running.. is there a way to install RMI as a server, without having to install all the JSDK??
to run rmi i use:

java RmiJdbc.RJJdbcServer sun.jdbc.odbc.JdbcOdbcDriver

in my command window..

i wouldnt like to install the JSDK in all my client computers, so ill be very thankfull if somebody knows a way to avoid it..

thank you very very much

Eli

 

[sedj]

The short answer is no. Why does your server need to access the client's Access db ? Wouldn't it be simpler for the server to host the db .... perhaps if you told us a little bit more about your "bigger picture", we could come up with a better design ...

 

[elibb]

its like this:

i have a server with a MySQL database, and im building a java application for it.
Now, the computers that log into my applications, are stand alone computers, that will connect via modem to the Internet and access my webpage, these computer have a database in Access. I want with my application to be able to extract some data from these access databases and put it on the MySQL big database that is on the server.

i have tried to do it putting an ODBC driver on the clinet computer, but then i cannt managae to access to it remotly from my servlet..

the one way we found to solve it was working with RMI... please, any solution will be accepted..

i hope i made myself clear

thank you very much

Eli

 

[hologram]

>>i have tried to do it putting an ODBC driver on the client computer, but then i cannot manage to access to it remotely from my servlet..

You should use a JDBC driver on your server to access the db on your client.

 

[elibb]

i have a JDBC driver on the server.. but how do i make it access the ODBC on the client??

i tried this:
jdbcdbc:200.171.10.1/myODBCName

but it didnt work.. please help!!!!

Eli

 

[sedj]

So what were your error messages ?

 

[elibb]

it said it didnt find the ODBC name.

thank you very much..

Eli

 

[JVZ]

You may want to check out a product called RmiJdbc (RmiJdbc is free software), check out the site below.

http://rmijdbc.objectweb.org/

I read the post, and I don't understand why the clients maintain there own database and why they don't use your DB... However another option is that you write some VBA code in Microsoft Access that exports the data that you want to a text file and then FTPs that file to a directory on your server. Then just create a simple class that listen for incoming files and then imports that data into mySQL...

or if you installed the ODBC drivers on the clients machine then create a link to a staging table on DB server and create a replication task in Access that inserts the data that you want when the client logs on to the network..

Just my 2 cents…