InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: Fw: Question about instantDB


 
----- Original Message -----
Sent: Friday, September 22, 2000 10:47 PM
Subject: Re: Question about instantDB

Take a look at my batch file used to run the rmi registry peace.
 
@echo off
 
set ProjectPath=c:\Temp
set JarPath=c:\java\jar
set JarFiles=%JarPath%\RmiJdbc.jar;%JarPath%\idb.jar;%JarPath%\jta-spec1_0_1.jar;
 
@echo on
rem java -classpath .;%JarFiles% RmiJdbc.RJJdbcServer jdbc.idbDriver
 
java -classpath .;%JarFiles% -Ddb.root=c:\\devproto\\rmijdbc -Djava.security.policy=db.policy RmiJdbc.RJJdbcServer org.enhydra.instantdb.jdbc.idbDriver
 
@echo off
pause
 
Also i noticed you dont have a security policy which could do it also.
 
I use to get this error and found that you have to run it with all the properties configured correctly or it will not run.
 
Also:
 
set CLASSPATH=c:\IBMjava12\lib\classes.zip;C:\instantDB\Classes\Rmi
Jdbc.jar

I think your looking for idb.jar for instant db.
 
java.class.path=C:\IBMDebug\lib\dertrjrt.jar;.;C:\SQLLIB\java\db2java.zip;C:\SQLLIB\java\runtime.zip;C:\instantDB\Classes\idb.jar;C:\instantDB\Classes\idbexmpl.jar;C:\instantDB\Classes\RmiJdbc.jar

your idb.jar file is located in c:\instantdb\classes directory but when you set your class path it does not indicate that.
 
I've included a small sample you should compress it to the following directory:
 
c:\devproto\rmijdbc
 
run the server first then the client
 
give it a try check my batch  files to make sure its set up to your configuration.  I've tried to make it easy .
 
Let me know how it works out or if I can give you any further assitance.
 
good luck
 
later
 
 
 
----- Original Message -----
Sent: Friday, September 22, 2000 8:48 PM
Subject: Question about instantDB

Eric,

In looking over past posting I noticed that you are very knowledgable about instantDB. Being new to this database, I need a little help setting it up for remote access. Could you figure out what I have done wrong. Both of the computers are on a simple peer network and both run Windoze 2000. I have the same properties set to include rmi.

I ran the browser on the machine with instantDB and was able to connect and work the sample.prp. To use remote access I also installed RmiJdbc. After installation I started the rmi server. This resulted in:

C:\instantDB>set CLASSPATH=c:\IBMjava12\lib\classes.zip;C:\instantDB\Classes\Rmi
Jdbc.jar

C:\instantDB>java RmiJdbc.RJJdbcServer org.enhydra.instantdb.jdbc.idbDriver
*** Can't register jdbc Driver for org.enhydra.instantdb.jdbc.idbDriver
Error message is: org.enhydra.instantdb.jdbc.idbDriver
Binding RmiJdbcServer...
RmiJdbcServer bound in rmi registry
^C
C:\instantDB>set CLASSPATH=c:\IBMjava12\lib\classes.zip;C:\instantDB\Classes\Rmi
Jdbc.jar;C:\instantDB\Classes\idb.ja

C:\instantDB>java RmiJdbc.RJJdbcServer org.enhydra.instantdb.jdbc.idbDriver
*** Can't register jdbc Driver for org.enhydra.instantdb.jdbc.idbDriver
Error message is: org.enhydra.instantdb.jdbc.idbDriver
Binding RmiJdbcServer...
RmiJdbcServer bound in rmi registry

I assume that it is not running properly, but I tried the client sample and recieved this:

C:\instantDB\Examples>java TestClient
java.sql.SQLException: No suitable driver
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Stream
RemoteCall.java:248)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:
223)
at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:358)
at RmiJdbc.RJDriverServer_Stub.connect(RJDriverServer_Stub.java:77)
at RmiJdbc.RJConnection.<init>(RJConnection.java:85)
at RmiJdbc.RJDriver.connect(RJDriver.java:131)
at java.sql.DriverManager.getConnection(DriverManager.java:459)
at java.sql.DriverManager.getConnection(DriverManager.java:161)
at TestClient.main(TestClient.java:31)
java.sql.SQLException: No suitable driver
at java.lang.Throwable.<init>(Throwable.java:96)
at java.lang.Exception.<init>(Exception.java:44)
at java.sql.SQLException.<init>(SQLException.java:84)
at RmiJdbc.RJDriver.connect(RJDriver.java:137)
at java.sql.DriverManager.getConnection(DriverManager.java:459)
at java.sql.DriverManager.getConnection(DriverManager.java:161)
at TestClient.main(TestClient.java:31)

The CLASSPATH includes the jars; here is the listing from the instantDB browser:

java.class.path=C:\IBMDebug\lib\dertrjrt.jar;.;C:\SQLLIB\java\db2java.zip;C:\SQLLIB\java\runtime.zip;C:\instantDB\Classes\idb.jar;C:\instantDB\Classes\idbexmpl.jar;C:\instantDB\Classes\RmiJdbc.jar


Any suggestions?


Pat

RMIJDBC.zip