Start a new topic

DbVisualizer 5.1.1.8 now available

Roger Bjärevall

started a topic over 17 years ago

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

Hi, 

DbVisualizer 5.1.1.8 (early access) is now available: 

http://www.minq.se/products/dbvis/eap

Best Regards 

Roger

26 Comments

Roger Bjärevall

said over 17 years ago

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available

Benny,

Just browsed through a couple of hundred package/bodies and cannot get any error...

Running this DB server on Ubuntu/Linux:

Oracle
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Oracle JDBC driver
10.2.0.2.0

It is very difficult to say exactly what the problem is or why it happen. Does it work with 5.1.1?

Regards

Roger

anonymous

said over 17 years ago

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

Re: DbVisualizer 5.1.1.8 now available

Hi Roger,

It looks like I have this problem on only one client. I have tried another one and asked a colleague of mine to do so as well and there this does not appear.

Regards,

Benny

anonymous

said over 17 years ago

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

Re: DbVisualizer 5.1.1.8 now available

I just wanted to take a look at the properties of an DB2 8.2 Stored Procedure but several fields show only errors. Originally I wanted to see the code of the procedure.

TEXT

An internal error occured:
Exception: java.lang.ClassCastException
java.lang.ClassCastException: com.onseven.dbvis.sql.TextData
The error may have affected the application state.
Please notify vendor.
Stack Trace:
java.lang.ClassCastException: com.onseven.dbvis.sql.TextData
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)


PROCEDURE_ID:

An internal error occured:
Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Long
The error may have affected the application state.
Please notify vendor.
Stack Trace:
java.lang.ClassCastException: java.lang.Long
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

PARM_COUNT:

An internal error occured:
Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Integer
The error may have affected the application state.
Please notify vendor.
Stack Trace:
java.lang.ClassCastException: java.lang.Integer
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

PARM_SIGNATURE:

An internal error occured:
Exception: java.lang.ClassCastException
java.lang.ClassCastException: com.onseven.dbvis.sql.BinaryData
The error may have affected the application state.
Please notify vendor.
Stack Trace:
java.lang.ClassCastException: com.onseven.dbvis.sql.BinaryData
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

CREATE_TIME:

An internal error occured:
Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.sql.Timestamp
The error may have affected the application state.
Please notify vendor.
Stack Trace:
java.lang.ClassCastException: java.sql.Timestamp
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

RESULT_SETS:

An internal error occured:
Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Integer
The error may have affected the application state.
Please notify vendor.
Stack Trace:
java.lang.ClassCastException: java.lang.Integer
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

TEXT_BODY_OFFSET:

An internal error occured:
Exception: java.lang.ClassCastException
java.lang.ClassCastException: java.lang.Long
The error may have affected the application state.
Please notify vendor.
Stack Trace:
java.lang.ClassCastException: java.lang.Long
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.F.ā(Unknown Source)
    at com.onseven.dbvis._.a.ă(Unknown Source)
    at com.onseven.dbvis._.a.ā(Unknown Source)
    at com.onseven.dbvis._.U.ą(Unknown Source)
    at com.onseven.dbvis._.a$3.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.I.A.f.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)

Roger Bjärevall

said over 17 years ago

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available

Peter,

Embarrassing bug... it will be fixed. Workaround is to double click the cell in the "Procedures" grid to see for example Text.

Regards

Roger

anonymous

said over 17 years ago

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

Re: DbVisualizer 5.1.1.8 now available

Hi there,

here's a new bug I'm experiencing with Informix and DBVis, tested in 5.1 and 5.1.1.8

When I try to access the DDL of a table (as well as for "create table") with two secondary keys as a primary key, I get the following output:

5.1.1.8
An internal error occured:

Exception: java.lang.NullPointerException
java.lang.NullPointerException

The error may have affected the application state.
Please notify vendor.

Stack Trace:

java.lang.NullPointerException
    at com.onseven.dbvis.R.A.D.c(Unknown Source)
    at com.onseven.dbvis.R.A.D.a(Unknown Source)
    at com.onseven.dbvis.a.G.B.F.a(Unknown Source)
    at com.onseven.dbvis.a.B.A.B$A.execute(Unknown Source)
    at com.onseven.dbvis.F.B.H.construct(Unknown Source)
    at se.pureit.swing.util.SwingWorker$2.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)


5.1.1
14:05:28 [ERROR] IndexOutOfBoundsException: row=0 column=0 rowCount=0 columnCount=18
Exception in thread "AWT-EventQueue-1" java.lang.NullPointerException
    at com.onseven.dbvis.Q.A.D.?(Unknown Source)
    at com.onseven.dbvis.Q.A.D.?(Unknown Source)
    at com.onseven.dbvis.Z.G.B.F.?(Unknown Source)
    at com.onseven.dbvis.Z.B.A.B.?(Unknown Source)
    at com.onseven.dbvis.Z.B.E.?(Unknown Source)
    at com.onseven.dbvis.Z.B.E.?(Unknown Source)
    at com.onseven.dbvis.Z.B.E.access$100(Unknown Source)
    at com.onseven.dbvis.Z.B.E$1.ancestorAdded(Unknown Source)
    at javax.swing.AncestorNotifier.fireAncestorAdded(Unknown Source)
    at javax.swing.AncestorNotifier.componentShown(Unknown Source)
    at java.awt.Component.processComponentEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at com.onseven.dbvis.H.A.d.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)


---------------
Here's the original 'create table' script:

CREATE TABLE map_server_dienste
(
   id_server int,
   id_dienste int,
   CONSTRAINT map_server_dienste_PK PRIMARY KEY (id_server,id_dienste)
);

ALTER TABLE map_server_dienste
ADD CONSTRAINT foreign2
FOREIGN KEY (id_dienste)
REFERENCES dienste(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE map_server_dienste
ADD CONSTRAINT foreign1
FOREIGN KEY (id_server)
REFERENCES server(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
CREATE INDEX 104_10 ON map_server_dienste(id_dienste);
CREATE INDEX 104_9 ON map_server_dienste(id_server);

Hans Bergsten

said over 17 years ago

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available

Hi Dirk,

I'm looking into the Informix DDL problem you reported. I cannot reproduce the exact same thing with:

  Informix Dynamic Server
  10.00.UC6TL
  IBM Informix JDBC Driver for IBM Informix Dynamic Server
  3.00.JC3

Are you using a different Informix and/or JDBC driver version? 

Also, the CREATE and ALTER statements you included do not seem to be using Informix syntax for the constraint name (the CONSTRAINT keyword and the name must come after the declaration, e.g., after PRIMARY KEY ...) and the index names are not valid identifiers. Are these statement generated with some other tool, or is there some Informix option for accepting ANSI syntax that I'm not aware of?

I did, however, find some regression errors in this area that _may_ be the cause of the problem you see. Please let me know the version numbers so I can try to verify that fixing these errors also fixes the problem you encountered.

Thanks,
Hans

anonymous

said over 17 years ago

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

Re: DbVisualizer 5.1.1.8 now available

Hi Hans,
I suppose, I was a little lazy there ;) 
The output I posted was actually generated by  Squirrel. Here's the output from dbschema from the unix machine.

Informix Dynamic Server
9.40.HC2
IBM Informix JDBC Driver for IBM Informix Dynamic Server
3.00.JC3

-------------------------------
DBSCHEMA Schema Utility       INFORMIX-SQL Version 9.40.HC2
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number xxxxxxxxxxxxxxxxx

{ TABLE "informix".map_server_dienste row size = 8 number of columns = 2 index size  = 31 }
create table "informix".map_server_dienste
  (
    id_server integer not null ,
    id_dienste integer not null ,
    primary key (id_server,id_dienste)  constraint "informix".map
  );
revoke all on "informix".map_server_dienste from "public";



alter table "informix".map_server_dienste add constraint (foreign
    key (id_server) references "informix".server  constraint "informix"
    .foreign1);

alter table "informix".map_server_dienste add constraint (foreign
    key (id_dienste) references "informix".dienste  constraint
    "informix".foreign2);

-------------------------------

Thanks for your help
Dirk

Hans Bergsten

said over 17 years ago

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available

Hi Dirk,

Thanks for the additional information. Hopefully my corrections to the problems I found in this area also fix the problem you ran into. We don't have access to Informix 9.40.HC, so I can't say for sure, but it seems likely based on the nature of the problems I found. Please test again when the next version is released.

Thanks,
Hans

anonymous

said over 17 years ago

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

Re: DbVisualizer 5.1.1.8 now available

I suppose this is more a feature request than a bug.

I notice I can select several rows in the data tab, create an equal number of empty rows in a similar table on another server then paste the data from the first server into the empty rows on the second.

This works great when I need to quickly copy 10 rows of data but falls down when I try to copy 100 at a time. If I try to paste the 100 copied data rows into a single blank row, only 1 record is created.

Ideally, if I am pasting data into a newly-created empty row and there is more than one row of data to be pasted, it should create new empty rows to hold the remaining data to be copied.

This way, it would work more like MS Access (whose only valid use IMHO is for copying data between ODBC link tables using the windows clipboard) where you can paste several rows worth of clipboard data into an empty row and it will copy all the rows you pasted instead of just the first one.

Great effort with the last few EAP releases BTW - the way filtering and data editing works now is a wonderful improvement.

Roger Bjärevall

said over 17 years ago

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available

Hi,

We'll add a dialog in the next version asking what to do if there are more rows in the clipboard then selected rows in the grid. The options are: [b]Add Rows[/b] or [b]Don't Add Rows[/b]. This will then handle both the current scenario and the new one you describe.

Thanks for your feedback.

Regards

Roger

anonymous

said over 17 years ago

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

Re: DbVisualizer 5.1.1.8 now available - large sql statements

Hi roger,

when I load a file with a few larger sql statements dbvis becomes completely inresponsive. Editing the sql seems impossible and I have yet to see the format sql function applied to it. This happens in 5.1.1.1 and in 5.1.1.8.

do you have a good tip for me ? (I mailed the lang.sql to your address)
thanks,
Ronald.

Roger Bjärevall

said over 17 years ago

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.8 now available - large sql statements

Hi Ronald,

That SQL really re-define the phrase *a large statement* a bit... :-)

You're right that the formatting feature cannot handle it. I have just made 
some adjustments and now it seem to handle it properly. Find the correction
in the next version.

In your file the 1.5M SQL was on a single long line. This causes some performance problems in the SQL editor as it is much better handling multi row data then long rows. This is the reason why the editor is somewhat unresponsive while editing.

Best Regards

Roger

How can we help you today?

DbVisualizer 5.1.1.8 now available

Roger Bjärevall

Roger Bjärevall

anonymous

anonymous

Roger Bjärevall

anonymous

Hans Bergsten

anonymous

Hans Bergsten

anonymous

Roger Bjärevall

anonymous

Roger Bjärevall