Start a new topic

Super slow to open

[This topic is migrated from our old forums. The original author name has been removed]

Hi. One of the users is having an issue of dbvis opening *extremely* slow. First thing that happens is the dbvis window frame with noting in it.. After about 2 minutes, the GUI is painted. Clicking on File-Open (for the first time) also takes another 30 seconds... Not sure if its a coincidence, but he has Java 1.7.0_70 .. Please help.. thanks. Product: DbVisualizer Pro 9.0.1 Build: #1907 (2012/12/17 12:05) Java VM: Java HotSpot(TM) Client VM Java Version: *1.7.0_07* Java Vendor: Oracle Corporation OS Name: Windows XP OS Arch: x86 OS Version: 5.1

[This reply is migrated from our old forums. The original author name has been removed]

Connection Error
I get an error while using DB viz ver 9.0.6 to connect to Vertica 6.1 ver database An error occurred while establishing the connection: The selected Driver cannot handle the specified Database URL. The most common reason for this error is that the database URL contains a syntax error preventing the driver from accepting it. The error also occurs when trying to connect to a database with the wrong driver. Correct this and try again. Could anyone help ? In the debugger window java exceptions are displayed : 16:33:26 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:26 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:26 [DEBUG ExecutorRunner-pool-3-thread-2 G.?] Connecting: analytics 16:33:26 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:26 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:26 [DEBUG pool-4-thread-2 D.?] RootConnection: Driver.acceptsURL("jdbc:vertica:/172.16.251.171:5433/analytics") 16:33:33 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:33 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:33 [DEBUG ExecutorRunner-pool-3-thread-2 G.?] Connecting: analytics 16:33:33 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:33 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.vertica.jdbc.Driver 16:33:33 [DEBUG pool-4-thread-2 D.?] RootConnection: Driver.acceptsURL("jdbc:vertica:/172.16.251.171:5433/analytics") Edited by: Gopu on May 16, 2013 1:04 PM
[This reply is migrated from our old forums.]

Re: Connection Error
Gopu, For future posts please open a new message rather than using non related ones. Your database URL must contain two slashes after jdbc:vertica:// jdbc:vertica://172.16.251.171:5433/analytics Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Connection Error
Thanks a lot. It worked.