|
|
REPLY
InstantDB
jacobmarble |
Posted: 07/16/2009 19:30
|
Hello, I'm unsuccessfully trying to use your fine DataBrowser application with InstantDB.
Platform: Ubuntu (Linux) 9.04
JRE: sun 1.6.0_14
I run the command: java -jar databrowser.jar
The application loads.
Edit->Edit Preferences->Driver Manager
I set the Driver Dir to the directory that contains idb.jar.
I also add a specific driver, idb.jar.
This satisfies the first and second options in the help in "Why Is My Connector Disabled?" I suspect two possible problems:
1) InstantDB is old and no longer around. I'm lucky to even have idb.jar.
2) User error. I'm not very experienced with Java.
Any suggestions? Can anyone confirm that DataBrowser 3.5.1 still works with InstantDB? |
|
|
|
Re: InstantDB
bemowski |
Posted: 07/16/2009 20:39
|
All good info - thanks for the detailed background. But what is the problem? What happens?
Are you curious about how to connect to the DB? If the connector is still disabled, then you should:
1) confirm that the .jar file is valid. Can you unjar it?
2) Does the jar file contain the following class:
org.enhydra.instantdb.jdbc.idbDriver
3) If the driver does not contain that class, or there is a different class, try manually connecting using the Generic Connector - and enter the driver name, connection URL and credentials manually.
If it is some other error, go to View->System Console, and post the error that you see.
Paul
|
|
Re: InstantDB
bemowski |
Posted: 07/16/2009 20:41
|
Looking at the .jar file, looks like a very old driver. You'd need to use the GenericConnector. The driver class would be:
jdbc.idbDriver
You'd need some docs to find the format of the connection URL. |
|
Re: InstantDB
jacobmarble |
Posted: 07/17/2009 13:13
|
Thank you, you've already been helpful.
You're right, I failed to mention the problem. When I try to create a new connection, InstantDB is greyed out.
I understand what you said about the driver being old. I have tried to create a generic connection. These links helped me with the variables:
http://instantdb.tripod.com/old-site/jdbc-1.html
http://publib.boulder.ibm.com/infocenter/wsadhelp/v5r1m2/index.jsp?topic=/com.ibm.etools.rsc.doc/topics/tdbconn_instantdb.html
Using the following values, I got the following output in the system console; the same thing happens when I use any random path in the url.
driver class: jdbc.idbDriver
url: jdbc:idb:/home/jake/Desktop/HarmonyIDB/harmony.prp
10:08:29.826 [AWT-EventQueue-0] D3: Connector menu event action=GenericConnector (your driver)
10:13:49.028 [AWT-EventQueue-0] D1: Connect!!!: ConnectionInfo (dba on jdbc:idb:/home/jake/Desktop/HarmonyIDB/harmony.prp):
driver = jdbc.idbDriver
url = jdbc:idb:/home/jake/Desktop/HarmonyIDB/harmony.prp
props:
user=dba
password=sql
10:13:49.066 [ConnectThread-0] D3: Attempting to connect to ConnectionInfo (dba on jdbc:idb:/home/jake/Desktop/HarmonyIDB/harmony.prp):
driver = jdbc.idbDriver
url = jdbc:idb:/home/jake/Desktop/HarmonyIDB/harmony.prp
props:
user=dba
password=sql
10:13:49.093 [ConnectThread-0] D3: Removing 0 table models
10:13:49.093 [ConnectThread-0] D4: SQLBookmarks.addBookmark()
10:13:49.101 [ConnectThread-0] D4: Bookmark update modified 0 rows. inserting.
10:13:49.110 [ConnectThread-0] D3: TreePanelModel.disconnect()
10:13:49.112 [ConnectThread-0] D3: About to revalidate.
10:13:49.113 [ConnectThread-0] D3: Done revalidating.
10:13:49.114 [ConnectThread-0] D3: Class not found with standard CLASSLOADER, checking the DriverLoader.
10:13:49.114 [ConnectThread-0] D3: DCL: Attempting to load jdbc.idbDriver with DCL
10:13:49.131 [ConnectThread-0] D3: DCL: found class: jdbc.idbDriver
10:13:49.132 [ConnectThread-0] D3: Using jdbc.idbDriver@eaf40c to connect to jdbc:idb:/home/jake/Desktop/HarmonyIDB/harmony.prp
10:13:49.176 [ConnectThread-0] E1: Unknown throwable connecting.
10:13:49.177 [ConnectThread-0] E1: java.lang.ClassFormatError: Illegal field name "?" in class db/fb
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:621)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)
at java.net.URLClassLoader.access$000(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at com.jet.utils.loader.URLDriverLoader.findClass(URLDriverLoader.java:115)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at jdbc.idbConnection.<init>(Unknown Source)
at jdbc.idbDriver.connect(Unknown Source)
at com.jet.apps.databrowser.database.ConnectionFactory.loadWithDCL(ConnectionFactory.java:154)
at com.jet.apps.databrowser.database.ConnectionFactory.getConnection(ConnectionFactory.java:84)
at com.jet.apps.databrowser.database.ConnectThread.run(ConnectThread.java:97) |
|
Re: InstantDB
bemowski |
Posted: 07/17/2009 13:57
|
Looks to me like that code is just too old to function in a modern JVM.
I assume you are trying to recover some old data stored in InstantDB format, right? You should not be using this driver for any new work. There are other pure java databases - like Hypersonic SQL.
I did find another, more modern version of the Instant DB driver. You might try using this more recent driver to access the data in your IDB database. I've attached the new driver jar here. Let me know if this works.
Paul |
|
|
|
Re: InstantDB
jacobmarble |
Posted: 07/17/2009 14:18
|
> I assume you are trying to recover some old data stored in InstantDB format, right?
Yes.
> I did find another, more modern version of the Instant DB driver. You might try using this more recent driver to access the data in your IDB database. I've attached the new driver jar here. Let me know if this works.
And that worked. Thank you so much, Paul.
For my reference, can you tell me what version of the driver you just gave me? In fact, do you know what version of the driver I am using? Thanks again. |
|
Re: InstantDB
jacobmarble |
Posted: 07/17/2009 14:21
|
> > I did find another, more modern version of the Instant DB driver. You might try using this more recent driver to access the data in your IDB database. I've attached the new driver jar here. Let me know if this works.
> And that worked. Thank you so much, Paul.
>
> For my reference, can you tell me what version of the driver you just gave me? In fact, do you know what version of the driver I am using? Thanks again.
Found it; yours is 3.21. |
|
Re: InstantDB
shaiss |
Posted: 09/22/2009 18:11
|
| I had a similar issue. This thread helped out. I have the .db open and DataBrowser shows the sys tables but nothing else. If I open that same .db file in a text editor I can see valid customer info there. Am I doing something worng? |
|
Re: InstantDB
donaldjeo |
Posted: 03/05/2010 00:49
|
Can you send me the screen shot of your problem.. i ill give you solution.. because i am know well about DB :)
====================
The [url=http://www.ccnasecuritytest.com]ccna security questions[/url] has been designed for knowledgeable security professionals in the field of security which is one of the fastest growing fields in IT. |
REPLY
|
|
|
