Start a new topic

Informix 10 only Read-Only in DbVisualizer 6.06

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

Hello,

i connect a Informix ids 10 via the ibm jdbc-Driver.

In earlier versions of DBVisualizer (5.1.1) ist was possible to do a

Select * from myTable in the SQL-Editor and edit the Table-Data in the Grid of the ResultSet directly. Also, if i did rightClick in the grid i got option for
Create Insert-Script
Create Update-Script and so on

These things are not possible in 6.06. If i doubleClick in the Grid a get a window with a window-title "Cell Form (ReadOnly)".

Is ist a matter of Configuration of the DB-Connection or a Bug?

Jan Heidrich



Product:  DbVisualizer Personal 6.0.6
Build:  #1291 (2007/10/16 00:25)
Java VM:  Java HotSpot(TM) Client VM
Java Version:  1.6.0_03-b05
Java Vendor:  Sun Microsystems Inc.
OS Name:  Windows XP
OS Arch:  x86
OS Version:  5.1

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

Current profile: informix
Current facade: informix

[This reply is migrated from our old forums.]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
It turns out that the fix introduced in 6.0.7 is incomplete and only solves the problem for tables in the default schema. We will have a closer look and try to come up with a better solution. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
Product:  DbVisualizer Personal 6.0.7
Build:  #1294 (2007/12/06 15:21)
Java VM:  Java HotSpot(TM) Client VM
Java Version:  1.6.0_03-b05
Java Vendor:  Sun Microsystems Inc.
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]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
I tried it with 6.0.7 but it did not work for me.

10:25:17 [DEBUG AWT-EventQueue-1 B.invoke] RootConnection: IfxPreparedStatement.execute()
10:25:17 [DEBUG AWT-EventQueue-1 B.execute] Total rows/columns: 2/1. Rows after filtering: 2
10:25:17 [DEBUG Thread-26 E.?] elementName: 'GroupNode' label: 'Databases' type: 'Databases' on-empty-output: 'stop'
10:25:17 [DEBUG Thread-26 E.?] elementName: 'GroupNode' label: 'DBA Views' type: 'DBA' on-empty-output: 'stop'
10:25:17 [DEBUG AWT-EventQueue-1 A.?] Returning cloned generic Command for idref: getColumnNamesFor
10:25:17 [DEBUG AWT-EventQueue-1 A.?] Loading class using dynamic ClassLoader: com.informix.jdbc.IfxDriver
10:25:17 [DEBUG AWT-EventQueue-1 A.?] Loading class using dynamic ClassLoader: com.informix.jdbc.IfxDriver
10:26:00 [DEBUG Thread-27 H.?] Creating new connection: DefaultEditor-0 for sospos_jdbc_prod
10:26:00 [DEBUG Thread-27 H.?] Connecting: sospos_jdbc_prod
10:26:00 [DEBUG Thread-27 A.?] Loading class using dynamic ClassLoader: com.informix.jdbc.IfxDriver
10:26:00 [DEBUG Thread-27 A.?] Loading class using dynamic ClassLoader: com.informix.jdbc.IfxDriver
10:26:00 [DEBUG Thread-27 C.invoke] DefaultEditor-0: IfxSqliConnect.setAutoCommit(true)
10:26:00 [DEBUG Thread-27 H.?] Using facade: informix for sospos_jdbc_prod
10:26:00 [DEBUG Thread-27 H.execute] Executing...
10:26:00 [DEBUG Thread-27 H.setCurrentCatalog] DbConnection='sospos_jdbc_prod' Catalog='sospos' Schema='null' NewCatalog='sospos'
10:26:00 [DEBUG Thread-27 H.setCurrentSchema] DbConnection='sospos_jdbc_prod' Catalog='null' Schema='heidrich' NewSchema='heidrich'
10:26:00 [DEBUG Thread-27 C.invoke] DefaultEditor-0: IfxSqliConnect.prepareStatement("Select * from stg where mtknr=10000123 and semester=20072")
10:26:00 [DEBUG Thread-27 H.prepareStatement] SQL: Select * from stg where mtknr=10000123 and semester=20072
10:26:00 [DEBUG Thread-27 C.invoke] DefaultEditor-0: IfxSqliConnect.nativeSQL("Select * from stg where mtknr=10000123 and semester=20072")
10:26:00 [DEBUG Thread-27 B.invoke] DefaultEditor-0: IfxPreparedStatement.execute()
10:26:00 [DEBUG AWT-EventQueue-1 K.?] DbConnection='sospos_jdbc_prod' Catalog='sospos' Schema='heidrich' Table='stg' Column='%'
10:26:00 [DEBUG AWT-EventQueue-1 H.?] Edit not allowed: The column names do not match the columns in the table
10:26:24 [DEBUG Thread-28 H.execute] Executing...
10:26:24 [DEBUG Thread-28 H.setCurrentCatalog] DbConnection='sospos_jdbc_prod' Catalog='sospos' Schema='null' NewCatalog='sospos'
10:26:24 [DEBUG Thread-28 H.setCurrentSchema] DbConnection='sospos_jdbc_prod' Catalog='null' Schema='heidrich' NewSchema='public'
10:26:24 [DEBUG Thread-28 C.invoke] DefaultEditor-0: IfxSqliConnect.prepareStatement("Select * from stg where mtknr=10000123 and semester=20072")
10:26:24 [DEBUG Thread-28 H.prepareStatement] SQL: Select * from stg where mtknr=10000123 and semester=20072
10:26:24 [DEBUG Thread-28 C.invoke] DefaultEditor-0: IfxSqliConnect.nativeSQL("Select * from stg where mtknr=10000123 and semester=20072")
10:26:24 [DEBUG Thread-28 B.invoke] DefaultEditor-0: IfxPreparedStatement.execute()
10:26:24 [DEBUG AWT-EventQueue-1 K.?] DbConnection='sospos_jdbc_prod' Catalog='sospos' Schema='heidrich' Table='stg' Column='%'
10:26:24 [DEBUG AWT-EventQueue-1 H.?] Edit not allowed: The column names do not match the columns in the table

Seems to be the same Error as before.

Our Connection hasn't changed since:
Informix Dynamic Server
10.00.UC6
IBM Informix JDBC Driver for IBM Informix Dynamic Server
3.00.JC3

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

Re: Informix 10 only Read-Only in DbVisualizer 6.06
Jan, This is fixed in 6.0.7. http://www.minq.se/products/dbvis/download.html Best Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
That would be nice. Maybe it could be implemented as a option.
[This reply is migrated from our old forums.]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
This has to do with schema specification. The result set will be editable if you qualify the table name with the schema, i.e., SELECT * FROM mySchema.myTable. In DbVis versions prior to 6.0.x, an unqualified name was qualified with the default schema, so that may be why you didn't run into this. We'll probably restore that behavior in the next release. Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
We use Informix Dynamic Server V10.UC6 and the data is read-only on all clients using dbVisualizer 6.06.
[This reply is migrated from our old forums. The original author name has been removed]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
Hi, i just had a look on our sospos DB using DBVis 6.0.6 and IBM JDBC 3.00: no problems with the pord table using a "select *", keeps editable. (SOS V9, Informix 9.4) Bye, Peter
[This reply is migrated from our old forums. The original author name has been removed]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
10:51:56 [DEBUG Thread-12 H.?] Creating new connection: DefaultEditor-0 for sospos_jdbc_prod 10:51:56 [DEBUG Thread-12 H.?] Connecting: sospos_jdbc_prod 10:51:56 [DEBUG Thread-12 A.?] Loading class using dynamic ClassLoader: com.informix.jdbc.IfxDriver 10:51:56 [DEBUG Thread-12 A.?] Loading class using dynamic ClassLoader: com.informix.jdbc.IfxDriver 10:51:56 [DEBUG Thread-12 H.?] Using facade: informix for sospos_jdbc_prod 10:51:56 [DEBUG Thread-12 C.invoke] DefaultEditor-0: IfxSqliConnect.setAutoCommit(true) 10:51:56 [DEBUG Thread-12 L.execute] Executing... 10:51:56 [DEBUG Thread-12 L.setCurrentCatalog] DbConnection='sospos_jdbc_prod' Catalog='sospos' Schema='null' NewCatalog='sospos' 10:51:56 [DEBUG Thread-12 L.setCurrentSchema] DbConnection='sospos_jdbc_prod' Catalog='null' Schema='heidrich' NewSchema='heidrich' 10:51:56 [DEBUG Thread-12 C.invoke] DefaultEditor-0: IfxSqliConnect.prepareStatement("Select * from pord") 10:51:56 [DEBUG Thread-12 L.prepareStatement] SQL: Select * from pord 10:51:56 [DEBUG Thread-12 C.invoke] DefaultEditor-0: IfxSqliConnect.nativeSQL("Select * from pord") 10:51:56 [DEBUG Thread-12 B.invoke] DefaultEditor-0: IfxPreparedStatement.execute() 10:52:01 [DEBUG AWT-EventQueue-1 C.?] DbConnection='sospos_jdbc_prod' Catalog='sospos' Schema='heidrich' Table='pord' Column='%' 10:52:01 [DEBUG AWT-EventQueue-1 H.?] Edit not allowed: The column names doesn't match the columns in the table
[This reply is migrated from our old forums.]

Re: Informix 10 only Read-Only in DbVisualizer 6.06
Jan, DbVisualizer thinks the result set is not editable and don't enable the editing feature. Since you are executing a simple select * from editing should be allowed. To find out more about this please enable debug of DbVis as explained in: http://www.minq.se/products/dbvis/faq.html#6.11 Post or email the debug output. The lack of scripting options in the right click menu depends on the above. Regards Roger support@minq.se