I've been playing with InterSystems Cache and using its jdbc driver. I see the DB name in the structure display but no tables. A jdbc log didn't seem to show a request for tables. Does this come only with a DB specific plugin?
tnx,
/steveA
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It should work fine without a custom plugin - internally it uses JDBC meta data to inspect the database, and database-specific plugins are used to provide additional, non-standard data only.
Please can you try with the 3.5.0RC5 - although it is still pre-production you should find it pretty stable. In case that doesn't work, I've signed up for the eval of Cache and I'll try it as soon as I can (although work commitments mean probably not for a couple of days, sorry :(
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I did try to put 3.5.0RC5 on my box and saw duplicate items in popup menus (eg, AutoCommit). Additionally, the perspective didn't have a similar layout at all. I'll try again!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I see nothing in the database structure panel. I'm using Cache's driver
com.intersys.jdbc.CacheDriver. Their log file is:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Started At: Nov 15, 2007 1:49:54 PM
Driver Name: com.intersys.jdbc.CacheDriver
Jar File Name: CacheDB.jar
Client Version: 2007.1.0.369
Compiled At: Fri 06/15/2007 12:41:57.24
JDBC Version: 3.0
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I think that the reason that you see duplicates is because you effectively have 3.0 _and_ 3.5.0RC5 running at the same time; in your eclipse/features and eclipse/plugins folders, delete any folders or .jars that begin "net.sourceforge.sqlexplorer", reinstall the 3.5.0RC5, and when you start eclipse for the first time after this, add "-clean" on the command line (this only needs to be done once).
Hopefully, that will solve your problem (i.e. the theory goes that when you restarted eclipse you were accidentally using 3.0.0 database structure view, not the 3.5.0 one). In case that doesn't work I've already downloaded Cache and a license key, and I'll try to get a patch out "real soon now"
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
John:
When I installed 3.5.0.RC5, I went through exactly the steps you suggested - deleting stuff under features and plugins.. right-click on a connection shows "Auto Commit" checked TWICE
steve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When I click on connect, I get an eclipse error. Here is the bottom of the stack (that I can see). btw - I'm using java 1.6.0_03:
at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:251)
at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1606)
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addSession(DatabaseStructureView.java:261)
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addUser(DatabaseStructureView.java:119)
at net.sourceforge.sqlexplorer.plugin.actions.OpenPasswordConnectDialogAction$1$1.run(OpenPasswordConnectDialogAction.java:70)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:123)
... 22 more
When I look at the log now, I see a table request but it looks like it comes back empty.
==============
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Started At: Nov 19, 2007 11:51:32 AM
Driver Name: com.intersys.jdbc.CacheDriver
Jar File Name: CacheDB.jar
Client Version: 2008.1.0.382
Compiled At: Tue 11/13/2007 23:00:53.06
JDBC Version: 3.0
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Things have gotten worse. I am using InterSystems newest version with jdk 1.6 drivers (I have only jdk 1.6 on my box). During a connect, I get an error - the bottom of the stack is:
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addSession(DatabaseStructureView.java:261)
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addUser(DatabaseStructureView.java:119)
at net.sourceforge.sqlexplorer.plugin.actions.OpenPasswordConnectDialogAction$1$1.run(OpenPasswordConnectDialogAction.java:70)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:123)
... 22 more
The database doesn't appear in the view and I can't execute a query! GAG!
DEAD IN THE WATER!
Sent: [Job number = -1]
2 0 0 0 1 0 0 0 0 0 0 0 72 83 ............HS
44 0 ,.
I've been playing with InterSystems Cache and using its jdbc driver. I see the DB name in the structure display but no tables. A jdbc log didn't seem to show a request for tables. Does this come only with a DB specific plugin?
tnx,
/steveA
It should work fine without a custom plugin - internally it uses JDBC meta data to inspect the database, and database-specific plugins are used to provide additional, non-standard data only.
Please can you try with the 3.5.0RC5 - although it is still pre-production you should find it pretty stable. In case that doesn't work, I've signed up for the eval of Cache and I'll try it as soon as I can (although work commitments mean probably not for a couple of days, sorry :(
John
I did try to put 3.5.0RC5 on my box and saw duplicate items in popup menus (eg, AutoCommit). Additionally, the perspective didn't have a similar layout at all. I'll try again!
I see nothing in the database structure panel. I'm using Cache's driver
com.intersys.jdbc.CacheDriver. Their log file is:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Started At: Nov 15, 2007 1:49:54 PM
Driver Name: com.intersys.jdbc.CacheDriver
Jar File Name: CacheDB.jar
Client Version: 2007.1.0.369
Compiled At: Fri 06/15/2007 12:41:57.24
JDBC Version: 3.0
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Sent: [Job number = -1]
2 0 0 0 1 0 0 0 0 0 0 0 72 83 ............HS
42 0 *.
Received: [Job number = -1]
12 0 0 0 1 0 0 0 0 0 0 0 0 0 ..............
42 0 0 0 8 1 76 97 116 105 110 49 *.....Latin1
Sent: [Job number = -1]
113 0 0 0 2 0 0 0 0 0 0 0 67 78 q...........CN
6 1 85 83 69 82 9 1 122 218 152 91 249 121 ..USER..z..[.y
91 10 1 250 120 222 114 115 184 25 153 11 1 50 [...x.rs.....2
49 50 48 51 57 48 51 54 9 1 83 65 76 80 12039036..SALP
69 82 84 35 1 111 114 103 46 101 99 108 105 112 ERT#.org.eclip
115 101 46 101 113 117 105 110 111 120 46 108 97 117 se.equinox.lau
110 99 104 101 114 46 77 97 105 110 14 1 5 0 ncher.Main....
1 0 0 0 0 0 2 0 0 0 11 1 49 50 ............12
55 46 48 46 48 46 49 3 1 0 3 4 1 2 7.0.0.1.......
4 .
Received: [Job number = -1]
75 0 0 0 2 0 0 0 0 0 0 0 0 0 K.............
59 1 67 97 99 104 101 32 79 98 106 101 99 116 ;.Cache.Object
115 32 86 101 114 115 105 111 110 32 50 48 48 55 s.Version.2007
46 49 46 48 46 51 54 57 32 67 97 99 104 101 .1.0.369.Cache
32 120 68 66 67 32 83 101 114 118 101 114 32 54 .xDBC.Server.6
46 49 48 2 4 3 4 1 3 4 3 6 1 52 .10..........4
56 49 54 2 4
I think that the reason that you see duplicates is because you effectively have 3.0 _and_ 3.5.0RC5 running at the same time; in your eclipse/features and eclipse/plugins folders, delete any folders or .jars that begin "net.sourceforge.sqlexplorer", reinstall the 3.5.0RC5, and when you start eclipse for the first time after this, add "-clean" on the command line (this only needs to be done once).
Hopefully, that will solve your problem (i.e. the theory goes that when you restarted eclipse you were accidentally using 3.0.0 database structure view, not the 3.5.0 one). In case that doesn't work I've already downloaded Cache and a license key, and I'll try to get a patch out "real soon now"
John
John:
When I installed 3.5.0.RC5, I went through exactly the steps you suggested - deleting stuff under features and plugins.. right-click on a connection shows "Auto Commit" checked TWICE
steve
I must be going blind! Sorry Steve, I've just looked again and it's staring me in the face.
John
When I click on connect, I get an eclipse error. Here is the bottom of the stack (that I can see). btw - I'm using java 1.6.0_03:
at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:251)
at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1606)
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addSession(DatabaseStructureView.java:261)
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addUser(DatabaseStructureView.java:119)
at net.sourceforge.sqlexplorer.plugin.actions.OpenPasswordConnectDialogAction$1$1.run(OpenPasswordConnectDialogAction.java:70)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:123)
... 22 more
When I look at the log now, I see a table request but it looks like it comes back empty.
==============
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Started At: Nov 19, 2007 11:51:32 AM
Driver Name: com.intersys.jdbc.CacheDriver
Jar File Name: CacheDB.jar
Client Version: 2008.1.0.382
Compiled At: Tue 11/13/2007 23:00:53.06
JDBC Version: 3.0
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Sent: [Job number = -1]
2 0 0 0 1 0 0 0 0 0 0 0 72 83 ............HS
44 0 ,.
Received: [Job number = -1]
12 0 0 0 1 0 0 0 0 0 0 0 0 0 ..............
42 0 0 0 8 1 76 97 116 105 110 49 *.....Latin1
Sent: [Job number = -1]
117 0 0 0 2 0 0 0 0 0 0 0 67 78 u...........CN
6 1 85 83 69 82 9 1 122 218 152 91 249 121 ..USER..z..[.y
91 10 1 250 120 222 114 115 184 25 153 11 1 50 [...x.rs.....2
49 50 48 51 57 48 51 54 9 1 83 65 76 80 12039036..SALP
69 82 84 39 1 111 114 103 46 101 99 108 105 112 ERT'.org.eclip
115 101 46 99 111 114 101 46 105 110 116 101 114 110 se.core.intern
97 108 46 106 111 98 115 46 87 111 114 107 101 114 al.jobs.Worker
14 1 5 0 1 0 0 0 0 0 2 0 0 0 ..............
11 1 49 50 55 46 48 46 48 46 49 3 1 0 ..127.0.0.1...
3 4 1 2 4 .....
Received: [Job number = -1]
75 0 0 0 2 0 0 0 0 0 0 0 0 0 K.............
59 1 67 97 99 104 101 32 79 98 106 101 99 116 ;.Cache.Object
115 32 86 101 114 115 105 111 110 32 50 48 48 56 s.Version.2008
46 49 46 48 46 51 56 50 32 67 97 99 104 101 .1.0.382.Cache
32 120 68 66 67 32 83 101 114 118 101 114 32 54 .xDBC.Server.6
46 49 48 2 4 3 4 1 3 4 3 6 1 52 .10..........4
54 55 50 2 4 672..
Sent: [Job number = 4672]
5 0 0 0 3 0 0 0 1 0 0 0 67 65 ............CA
3 4 1 2 4 .....
Received: [Job number = 4672]
79 0 0 0 3 0 0 0 1 0 0 0 0 0 O.............
3 4 1 3 4 1 11 1 84 65 66 76 69 95 ........TABLE_
67 65 84 3 4 12 3 4 128 2 4 3 4 2 CAT...........
11 1 84 65 66 76 69 95 67 65 84 13 1 74 ..TABLE_CAT..J
68 66 67 67 97 116 97 108 111 103 10 1 37 76 DBCCatalog..%L
105 98 114 97 114 121 2 1 13 1 0 0 0 0 ibrary........
0 0 0 0 0 0 0 2 4 .........
Received: [Job number = 4672]
0 0 0 0 3 0 0 0 1 0 0 0 100 0 ............d.
Sent: [Job number = 4672]
5 0 0 0 4 0 0 0 2 0 0 0 67 65 ............CA
3 4 1 2 4 .....
Received: [Job number = 4672]
79 0 0 0 4 0 0 0 2 0 0 0 0 0 O.............
3 4 1 3 4 1 11 1 84 65 66 76 69 95 ........TABLE_
67 65 84 3 4 12 3 4 128 2 4 3 4 2 CAT...........
11 1 84 65 66 76 69 95 67 65 84 13 1 74 ..TABLE_CAT..J
68 66 67 67 97 116 97 108 111 103 10 1 37 76 DBCCatalog..%L
105 98 114 97 114 121 2 1 13 1 0 0 0 0 ibrary........
0 0 0 0 0 0 0 2 4 .........
Received: [Job number = 4672]
0 0 0 0 4 0 0 0 2 0 0 0 100 0 ............d.
one more datapoint. The ExecuteQuery tool (http://executequery.org/) seems to work fine.
Things have gotten worse. I am using InterSystems newest version with jdk 1.6 drivers (I have only jdk 1.6 on my box). During a connect, I get an error - the bottom of the stack is:
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addSession(DatabaseStructureView.java:261)
at net.sourceforge.sqlexplorer.plugin.views.DatabaseStructureView.addUser(DatabaseStructureView.java:119)
at net.sourceforge.sqlexplorer.plugin.actions.OpenPasswordConnectDialogAction$1$1.run(OpenPasswordConnectDialogAction.java:70)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:123)
... 22 more
The database doesn't appear in the view and I can't execute a query! GAG!
DEAD IN THE WATER!
Sent: [Job number = -1]
2 0 0 0 1 0 0 0 0 0 0 0 72 83 ............HS
44 0 ,.
Received: [Job number = -1]
12 0 0 0 1 0 0 0 0 0 0 0 0 0 ..............
42 0 0 0 8 1 76 97 116 105 110 49 *.....Latin1
Sent: [Job number = -1]
117 0 0 0 2 0 0 0 0 0 0 0 67 78 u...........CN
6 1 85 83 69 82 9 1 122 218 152 91 249 121 ..USER..z..[.y
91 10 1 250 120 222 114 115 184 25 153 11 1 50 [...x.rs.....2
49 50 48 51 57 48 51 54 9 1 83 65 76 80 12039036..SALP
69 82 84 39 1 111 114 103 46 101 99 108 105 112 ERT'.org.eclip
115 101 46 99 111 114 101 46 105 110 116 101 114 110 se.core.intern
97 108 46 106 111 98 115 46 87 111 114 107 101 114 al.jobs.Worker
14 1 5 0 1 0 0 0 0 0 2 0 0 0 ..............
11 1 49 50 55 46 48 46 48 46 49 3 1 0 ..127.0.0.1...
3 4 1 2 4 .....
Received: [Job number = -1]
75 0 0 0 2 0 0 0 0 0 0 0 0 0 K.............
59 1 67 97 99 104 101 32 79 98 106 101 99 116 ;.Cache.Object
115 32 86 101 114 115 105 111 110 32 50 48 48 56 s.Version.2008
46 49 46 48 46 51 56 50 32 67 97 99 104 101 .1.0.382.Cache
32 120 68 66 67 32 83 101 114 118 101 114 32 54 .xDBC.Server.6
46 49 48 2 4 3 4 1 3 4 3 6 1 54 .10..........6
48 49 50 2 4 012..
Sent: [Job number = 6012]
5 0 0 0 3 0 0 0 1 0 0 0 67 65 ............CA
3 4 1 2 4 .....
Received: [Job number = 6012]
79 0 0 0 3 0 0 0 1 0 0 0 0 0 O.............
3 4 1 3 4 1 11 1 84 65 66 76 69 95 ........TABLE_
67 65 84 3 4 12 3 4 128 2 4 3 4 2 CAT...........
11 1 84 65 66 76 69 95 67 65 84 13 1 74 ..TABLE_CAT..J
68 66 67 67 97 116 97 108 111 103 10 1 37 76 DBCCatalog..%L
105 98 114 97 114 121 2 1 13 1 0 0 0 0 ibrary........
0 0 0 0 0 0 0 2 4 .........