Start a new topic

DbVisualizer 5.1.1.9 now available

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

Hi, DbVisualizer 5.1.1.9 (early access) is now available: http://www.minq.se/products/dbvis/eap Best Regards Roger

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

Re: DbVisualizer 5.1.1.9 now available
Roger,

thanks for the fix, users and roles are working now.

@ Hans:
Here's the complete debugging output.

Thanks guys for working on those bugs. DBVis is getting pretty usable with Informix 9.xx  ;-)

(not to mention that there isn't much else on the market to compete price)

So thanks again,
Dirk
------------------------------------------------------------
16:42:03 [DEBUG AWT-EventQueue-1 L.execute] Executing...
16:42:03 [DEBUG AWT-EventQueue-1 L.prepareStatement] SQL: SELECT
    *
FROM
    informix.systables
WHERE
    tabtype   = 'T'
    and tabid > 99
    and owner like 'informix'
    and tabname like 'map_server_dienste'
ORDER BY
    tabname
16:42:03 [DEBUG AWT-EventQueue-1 L.prepareStatement] nativeSQL from driver: SELECT
    *
FROM
    informix.systables
WHERE
    tabtype   = 'T'
    and tabid > 99
    and owner like 'informix'
    and tabname like 'map_server_dienste'
ORDER BY
    tabname
16:42:03 [DEBUG AWT-EventQueue-1 B.execute] Total rows/columns: 1/20. Rows after filtering: 1
16:42:05 [DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 [DEBUG Thread-21 L.execute] Executing...
16:42:05 [DEBUG Thread-21 O.?] index=[1] name=[name] value=[map_server_dienste] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[2] name=[schema] value=[informix] type=[String] options=[]
16:42:05 [DEBUG Thread-21 L.prepareStatement] SQL: SELECT     owner,     tabname FROM     informix.systables WHERE     tabname   = ?    AND owner = ?
16:42:05 [DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     owner,     tabname FROM     informix.systables WHERE     tabname   = ?    AND owner = ?
16:42:05 [DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 [DEBUG Thread-21 L.execute] Executing...
16:42:05 [DEBUG Thread-21 O.?] index=[1] name=[name] value=[map_server_dienste] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[2] name=[schema] value=[informix] type=[String] options=[]
16:42:05 [DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.colname,     c.coltype,     c.collength,     d.default,     c.colno FROM     informix.systables t,     informix.syscolumns c,     OUTER(informix.sysdefaults d) WHERE     t.tabid       = c.tabid     AND c.tabid   = d.tabid     AND c.colno   = d.colno     AND t.tabname = ?    and t.owner   = ?ORDER BY     c.colno
16:42:05 [DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.colname,     c.coltype,     c.collength,     d.default,     c.colno FROM     informix.systables t,     informix.syscolumns c,     OUTER(informix.sysdefaults d) WHERE     t.tabid       = c.tabid     AND c.tabid   = d.tabid     AND c.colno   = d.colno     AND t.tabname = ?    and t.owner   = ?ORDER BY     c.colno
16:42:05 [DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 [DEBUG Thread-21 L.execute] Executing...
16:42:05 [DEBUG Thread-21 O.?] index=[1] name=[name] value=[map_server_dienste] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[2] name=[schema] value=[informix] type=[String] options=[]
16:42:05 [DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrtype    = 'P'     AND t.tabname = ?    and t.owner   = ?
16:42:05 [DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrtype    = 'P'     AND t.tabname = ?    and t.owner   = ?
16:42:05 [DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 [DEBUG Thread-21 L.execute] Executing...
16:42:05 [DEBUG Thread-21 O.?] index=[1] name=[name] value=[map_server_dienste] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[2] name=[schema] value=[informix] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[3] name=[colId] value=[1] type=[Integer] options=[]
16:42:05 [DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 [DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 [DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 [DEBUG Thread-21 L.execute] Executing...
16:42:05 [DEBUG Thread-21 O.?] index=[1] name=[name] value=[map_server_dienste] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[2] name=[schema] value=[informix] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[3] name=[colId] value=[2] type=[Integer] options=[]
16:42:05 [DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 [DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.colname FROM     informix.systables t,     informix.syscolumns c WHERE     t.tabid       = c.tabid     AND t.tabname = ?    AND t.owner   = ?    AND c.colno  = ?
16:42:05 [DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 [DEBUG Thread-21 L.execute] Executing...
16:42:05 [DEBUG Thread-21 O.?] index=[1] name=[name] value=[map_server_dienste] type=[String] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[2] name=[schema] value=[informix] type=[String] options=[]
16:42:05 [DEBUG Thread-21 L.prepareStatement] SQL: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16,     r.ptabid,     r.primary,     r.delrule FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c,     informix.sysreferences r WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrid   = r.constrid     AND c.constrtype = 'R'     AND t.tabname    = ?    AND t.owner = ?
16:42:05 [DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     c.constrname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16,     r.ptabid,     r.primary,     r.delrule FROM     informix.systables t,     informix.sysindexes i,     informix.sysconstraints c,     informix.sysreferences r WHERE     t.tabid          = i.tabid     AND i.idxname    = c.idxname     AND c.constrid   = r.constrid     AND c.constrtype = 'R'     AND t.tabname    = ?    AND t.owner = ?
16:42:05 [DEBUG Thread-21 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
16:42:05 [DEBUG Thread-21 L.execute] Executing...
16:42:05 [DEBUG Thread-21 O.?] index=[1] name=[tableId] value=[100] type=[Long] options=[]
16:42:05 [DEBUG Thread-21 O.?] index=[2] name=[name] value=[100_7] type=[String] options=[]
16:42:05 [DEBUG Thread-21 L.prepareStatement] SQL: SELECT     t.owner,     t.tabname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i WHERE     t.tabid             = i.tabid     AND t.tabid         = ?    AND trim(i.idxname) = ?
16:42:05 [DEBUG Thread-21 L.prepareStatement] nativeSQL from driver: SELECT     t.owner,     t.tabname,     i.part1,     i.part2,     i.part3,     i.part4,     i.part5,     i.part6,     i.part7,     i.part8,     i.part9,     i.part10,     i.part11,     i.part12,     i.part13,     i.part14,     i.part15,     i.part16 FROM     informix.systables t,     informix.sysindexes i WHERE     t.tabid             = i.tabid     AND t.tabid         = ?    AND trim(i.idxname) = ?
e = java.lang.NullPointerException
java.lang.NullPointerException
    at com.onseven.dbvis.R.A.D.?(Unknown Source)
    at com.onseven.dbvis.R.A.D.?(Unknown Source)
    at com.onseven.dbvis.a.F.B.F.?(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)

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Hi Dirk, Thanks for the debug page; we're getting closer. Can you please run the following SQL statement in the SQL Commander and post the result? SELECT c.constrname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16, r.ptabid, r.primary, r.delrule FROM informix.systables t, informix.sysindexes i, informix.sysconstraints c, informix.sysreferences r WHERE t.tabid = i.tabid AND i.idxname = c.idxname AND c.constrid = r.constrid AND c.constrtype = 'R' AND t.tabname = 'map_server_dienste' AND t.owner = 'informix' It seems like it returns different results for Informix 9 and 10, which would explain the problem and hopefully point to a solution (I may need you help with more tests depending on where this leads). Thanks, Hans
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Dirk, One more things. Can you please run this query as well: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = where is the "r.tabid" value from the query I asked you to run earlier. Thanks, Hans
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: DbVisualizer 5.1.1.9 now available
Hi Hans,
here's the debugging output from the first statement, the result is attached as a csv.


08:19:01 [DEBUG Thread-13 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
08:19:01 [DEBUG Thread-13 L.execute] Executing...
08:19:01 [DEBUG Thread-13 L.prepareStatement] SQL: SELECT c.constrname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16, r.ptabid, r.primary, r.delrule FROM informix.systables t, informix.sysindexes i, informix.sysconstraints c, informix.sysreferences r WHERE t.tabid = i.tabid AND i.idxname = c.idxname AND c.constrid = r.constrid AND c.constrtype = 'R' AND t.tabname = 'map_server_dienste' AND t.owner = 'informix'
08:19:01 [DEBUG Thread-13 L.prepareStatement] nativeSQL from driver: SELECT c.constrname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16, r.ptabid, r.primary, r.delrule FROM informix.systables t, informix.sysindexes i, informix.sysconstraints c, informix.sysreferences r WHERE t.tabid = i.tabid AND i.idxname = c.idxname AND c.constrid = r.constrid AND c.constrtype = 'R' AND t.tabname = 'map_server_dienste' AND t.owner = 'informix'
08:19:01 [DEBUG AWT-EventQueue-1 H.?] Edit not allowed: More then one table is referenced in the FROM clause



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

Re: DbVisualizer 5.1.1.9 now available
... and here's the rest. Thanks for looking into that!

Greets
Dirk
--------------------------------------------
08:23:31 [DEBUG Thread-16 L.prepareStatement] SQL: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 100
08:23:31 [DEBUG Thread-16 L.prepareStatement] nativeSQL from driver: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 100
08:23:31 [DEBUG AWT-EventQueue-1 H.?] Edit not allowed: More then one table is referenced in the FROM clause
08:23:41 [DEBUG Thread-17 L.setCurrentCatalog] DbConnection='dirk_flens' Catalog='dirk_flens' Schema='null' NewCatalog='dirk_flens'
08:23:41 [DEBUG Thread-17 L.execute] Executing...
08:23:41 [DEBUG Thread-17 L.prepareStatement] SQL: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 103
08:23:41 [DEBUG Thread-17 L.prepareStatement] nativeSQL from driver: SELECT t.owner, t.tabname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = 103
08:23:41 [DEBUG AWT-EventQueue-1 H.?] Edit not allowed: More then one table is referenced in the FROM clause

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Thanks Dirk, I need the value of one more column, so can you please run this query for one of the "r.tabid" values from the previous query? SELECT t.owner, t.tabname, i.idxname, i.part1, i.part2, i.part3, i.part4, i.part5, i.part6, i.part7, i.part8, i.part9, i.part10, i.part11, i.part12, i.part13, i.part14, i.part15, i.part16 FROM informix.systables t, informix.sysindexes i WHERE t.tabid = i.tabid AND t.tabid = Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: DbVisualizer 5.1.1.9 now available
Hi Hans,

here's the result.

Greets
Dirk

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Dirk, Thanks for all your help with this. I have located the problem and it will be fixed in the next version. In case you wonder, it was related to differences in the naming conventions for auto-generated indexes between different Informix versions. Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
Roger,
I miss the dbvis.vmoptions file. Is the way to increase the memory changed ? When I load the lang.sql file I see a cpu going crazy and I assume that when I give it a little more memory to play with it will behave better.

regards,
Ronald.
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Ronald, You just need to create the [b]dbvis.vmoptions[/b] file and put the options in it. It is not created with the .zip variant of the installer. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available
Hi Roger,

it seems, that the commit/rollback icons and menu items always are disabled.
I've set "Auto Commit" at Tool and Connect-Properties to false.

Thanks for your great work.

Regards
Frank
[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Frank, We'll look into the commit/rollback problem. Thanks for your post. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: DbVisualizer 5.1.1.9 now available - undo format long sql
Hi Roger,

I just tried to format the long sql and it worked and pretty fast too. Given the length of the text I can imagine it is a problem to undo this
 but in that case I expect undo to give a warning or that it is disabled. What dbvis does now is delete words from the sql from the end.

that is not what one expects from an undo operation. Redo undoes the delete operation so that is ok.

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

Re: DbVisualizer 5.1.1.9 now available


I stumbled across the following error (included below) while using the navigator feature.

It looks like the query DBVis uses isn't correct for the field data type.

As it's a "char for bit data" field the value should be enclosed as follows:

x'20021006123949311084000000'

NOT simply

'20021006123949311084000000'

The x is all important. This is pretty consisten and this happens across all char for bit data fields I've tried through the navigator.


An error occured while executing the database request for:
DB2/6000
SQL08023
IBM DB2 JDBC Universal Driver Architecture
2.8.46

Short message:
Illegal Conversion

The command that caused the problem:
select * from SCHEMA.TABLE where FIELD = '20021006123949311084000000'

Long Message:
Illegal Conversion

Details:
   Type: com.ibm.db2.jcc.a.SqlException
   Error Code: -99999
   SQL State: null

System Information:
Product: DbVisualizer Personal 5.1.1.9
Build: #1224 (2007/06/13 00:44)
Java VM: Java HotSpot(TM) Tiered VM
Java Version: 1.7.0-ea-b12
Java Vendor: Sun Microsystems Inc.
OS Name: Windows 2000
OS Arch: x86
OS Version: 5.0

[This reply is migrated from our old forums.]

Re: DbVisualizer 5.1.1.9 now available
Mark, Sorry for the delay on this one. You're right in that DbVisualizer don't fully handle CHAR FOR BIT DATA properly. I'll file this as an issue. Regards Roger