Menu
▾
▴
eclipsesql-bugs — Bugs are forwarded to this list - DO NOT EMAIL IT DIRECTLY!
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(19) |
Nov
(6) |
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(5) |
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
(11) |
Nov
(37) |
Dec
(6) |
| 2009 |
Jan
(4) |
Feb
(18) |
Mar
(11) |
Apr
|
May
(8) |
Jun
(1) |
Jul
(6) |
Aug
(5) |
Sep
(3) |
Oct
(11) |
Nov
(9) |
Dec
(2) |
| 2010 |
Jan
|
Feb
(4) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
(39) |
Aug
|
Sep
(8) |
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
(4) |
Feb
(2) |
Mar
(2) |
Apr
(6) |
May
(4) |
Jun
(1) |
Jul
|
Aug
(2) |
Sep
|
Oct
(15) |
Nov
(1) |
Dec
(6) |
| 2012 |
Jan
(2) |
Feb
|
Mar
|
Apr
(2) |
May
(1) |
Jun
|
Jul
(2) |
Aug
(2) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(6) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: SourceForge.net <no...@so...> - 2011-10-19 15:19:56
|
Bugs item #3426001, was opened at 2011-10-19 10:58 Message generated for change (Comment added) made by kulinek You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3426001&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: eugene (kulinek) Assigned to: Nobody/Anonymous (nobody) Summary: failure to close connections Initial Comment: I tested several times - With Eclipse+sqlexplorer plugin I connect to JavaDB using embedded driver (from JDK 1.6.27) using derby.jar (new profile had to be created). Once connected I disconnect. That works fine. I go to SQLExplorer app (with eclipse built in) and try to connect but I get exception saying that there is someone else already connected. However, if I close the eclipse+plugin I can connect with SQLExplorer app. That means the connection was not released until I closed eclipse+plugin Note that JavaDB embedded allows only one connection to DB. ---------------------------------------------------------------------- >Comment By: eugene (kulinek) Date: 2011-10-19 11:19 Message: Same happens if I use SQL Explorer and Eclipse DTP. Closing connections does not release resources and the other app cannot connect until I actually shut down the whole app. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3426001&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-19 14:58:11
|
Bugs item #3426001, was opened at 2011-10-19 10:58 Message generated for change (Tracker Item Submitted) made by kulinek You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3426001&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: eugene (kulinek) Assigned to: Nobody/Anonymous (nobody) Summary: failure to close connections Initial Comment: I tested several times - With Eclipse+sqlexplorer plugin I connect to JavaDB using embedded driver (from JDK 1.6.27) using derby.jar (new profile had to be created). Once connected I disconnect. That works fine. I go to SQLExplorer app (with eclipse built in) and try to connect but I get exception saying that there is someone else already connected. However, if I close the eclipse+plugin I can connect with SQLExplorer app. That means the connection was not released until I closed eclipse+plugin Note that JavaDB embedded allows only one connection to DB. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3426001&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-07 17:48:14
|
Bugs item #3028298, was opened at 2010-07-12 10:03 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028298&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Closed Resolution: None Priority: 1 Private: No Submitted By: Roman V. Nikolaev (nikolaevroman) Assigned to: Nobody/Anonymous (nobody) Summary: Add tooltips for "Filter" button Initial Comment: Add tooltips for "Filter" button ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-07 19:48 Message: Released with 3.6.1 SR4 P1 ---------------------------------------------------------------------- Comment By: Davy Vanherbergen (dvanherbergen) Date: 2011-10-06 22:05 Message: Fix committed ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028298&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-07 17:44:43
|
Bugs item #3418589, was opened at 2011-10-04 19:58 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: None Priority: 5 Private: No Submitted By: cardonbj (cardonbj) Assigned to: Heiko Hilbert (hhilbert) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-07 19:44 Message: The problem is solved. I have deployed a patch on the update site. So after updating your SQL Expolrer installation all should be fine. ---------------------------------------------------------------------- Comment By: cardonbj (cardonbj) Date: 2011-10-06 18:18 Message: Great. Thanks for looking into this so quickly. SQL Explorer is a great tool. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 18:11 Message: I have found it. A fix made for DB2 with last release causes the change that the cataloge name is now displayed for mssql tables when 'Show table with schema' is on. I have to check what the problem with DB2 was for that change to found a solution which works for 'all' database systems. ---------------------------------------------------------------------- Comment By: cardonbj (cardonbj) Date: 2011-10-06 16:30 Message: I guess I should have checked the documentation before looking. Yes, it is showing DatabaseName.SchemaName.TableName Before upgrading to 3.6.1 I was only seeing SchemaName.TableName I don't really think seeing the DatabaseName there adds any value at all. You can create a table using: USE TestDatabase GO CREATE TABLE [test].[alpha]... etc ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 14:44 Message: How do you create such tables. In the documentation I found this: CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name .... Does this mean SchemaName = database, test = schema_name, aaa = table_name ? ---------------------------------------------------------------------- Comment By: cardonbj (cardonbj) Date: 2011-10-04 22:05 Message: o_O I have been using other versions of SQL Explorer since that date and nothing changed until I updated to 3.6.1. I am using Microsoft SQL Server 2008 with the jTDS 1.2.5 driver. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-04 20:22 Message: In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here. Which Databae do you use? So I can check which information is available from this database to resolve this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-06 20:45:08
|
Bugs item #3024215, was opened at 2010-07-02 10:52 Message generated for change (Settings changed) made by dvanherbergen You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3024215&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: Invalid Priority: 7 Private: No Submitted By: Roman V. Nikolaev (nikolaevroman) Assigned to: Heiko Hilbert (hhilbert) Summary: Disable count Initial Comment: In MySQL with InnoDB engine "SELECT COUNT(*) FROM table" executes VERY LONG TIME!!! It`s engine limitations. Please don`t count total number of rows in Database Explorer and don`t get preview. This features must be selective. Reproduce: 1. Create connection to mysql database with InnoDB table (>1000000 rows) 2. Double click on connection 3. Eclipse be suspended ---------------------------------------------------------------------- Comment By: Davy Vanherbergen (dvanherbergen) Date: 2011-10-06 22:44 Message: Neither the row count or the preview queries are executed by default. These queries will only trigger when you open those tabs. Keep in mind that these tabs can be sticky, i.e. when you look at a row count on one table and then select another table in the db structure view, the row count tab remains active and will show the row count for the newly selected table. ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-07 11:01 Message: P.P.S. Where eclipse error log? I find .log file in my .metadata folder. But in this file no interesting messages for this bug. ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-07 10:55 Message: Sorry. Step 2.3 double click on some table (with InnoDB engine, >1000000 rows). Problem not on database open, but on table open. P.S. I use local network to connect to databases. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2010-07-07 09:43 Message: As far as I know, we don't count rows on openning connection with double click. One problem are database servers with many databases/schemas in addition with slow network connection because the complete structure is read when structure view is opened. One problem I have is working via a VPN connection. Idle connections on the VPN chanel becomes broken. If you use such a connection it is possible to freeze eclispe. I don't see any chance to slove this problem becuase it seems that the databse (socket) request 'never' comes back. I can try to move all database request which are called from the UI-Thread into separated jobs, but this is not allways possible. So again the question: Do you have any exceptions in your eclispe error log? ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-02 10:58 Message: step 2: 2.1 double click on connection. 2.2 goto Database Struct 2.3 double click on database. SQL Explorer try to update Database Detail and you have step 3. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3024215&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-06 20:44:40
|
Bugs item #3024215, was opened at 2010-07-02 10:52 Message generated for change (Comment added) made by dvanherbergen You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3024215&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open >Resolution: Invalid Priority: 7 Private: No Submitted By: Roman V. Nikolaev (nikolaevroman) Assigned to: Heiko Hilbert (hhilbert) Summary: Disable count Initial Comment: In MySQL with InnoDB engine "SELECT COUNT(*) FROM table" executes VERY LONG TIME!!! It`s engine limitations. Please don`t count total number of rows in Database Explorer and don`t get preview. This features must be selective. Reproduce: 1. Create connection to mysql database with InnoDB table (>1000000 rows) 2. Double click on connection 3. Eclipse be suspended ---------------------------------------------------------------------- >Comment By: Davy Vanherbergen (dvanherbergen) Date: 2011-10-06 22:44 Message: Neither the row count or the preview queries are executed by default. These queries will only trigger when you open those tabs. Keep in mind that these tabs can be sticky, i.e. when you look at a row count on one table and then select another table in the db structure view, the row count tab remains active and will show the row count for the newly selected table. ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-07 11:01 Message: P.P.S. Where eclipse error log? I find .log file in my .metadata folder. But in this file no interesting messages for this bug. ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-07 10:55 Message: Sorry. Step 2.3 double click on some table (with InnoDB engine, >1000000 rows). Problem not on database open, but on table open. P.S. I use local network to connect to databases. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2010-07-07 09:43 Message: As far as I know, we don't count rows on openning connection with double click. One problem are database servers with many databases/schemas in addition with slow network connection because the complete structure is read when structure view is opened. One problem I have is working via a VPN connection. Idle connections on the VPN chanel becomes broken. If you use such a connection it is possible to freeze eclispe. I don't see any chance to slove this problem becuase it seems that the databse (socket) request 'never' comes back. I can try to move all database request which are called from the UI-Thread into separated jobs, but this is not allways possible. So again the question: Do you have any exceptions in your eclispe error log? ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-02 10:58 Message: step 2: 2.1 double click on connection. 2.2 goto Database Struct 2.3 double click on database. SQL Explorer try to update Database Detail and you have step 3. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3024215&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-06 20:05:19
|
Bugs item #3028298, was opened at 2010-07-12 10:03 Message generated for change (Comment added) made by dvanherbergen You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028298&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: None Priority: 1 Private: No Submitted By: Roman V. Nikolaev (nikolaevroman) Assigned to: Nobody/Anonymous (nobody) Summary: Add tooltips for "Filter" button Initial Comment: Add tooltips for "Filter" button ---------------------------------------------------------------------- >Comment By: Davy Vanherbergen (dvanherbergen) Date: 2011-10-06 22:05 Message: Fix committed ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028298&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-06 16:18:59
|
Bugs item #3418589, was opened at 2011-10-04 11:58 Message generated for change (Comment added) made by cardonbj You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BJ Cardon (cardonbj) Assigned to: Heiko Hilbert (hhilbert) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- >Comment By: BJ Cardon (cardonbj) Date: 2011-10-06 10:18 Message: Great. Thanks for looking into this so quickly. SQL Explorer is a great tool. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 10:11 Message: I have found it. A fix made for DB2 with last release causes the change that the cataloge name is now displayed for mssql tables when 'Show table with schema' is on. I have to check what the problem with DB2 was for that change to found a solution which works for 'all' database systems. ---------------------------------------------------------------------- Comment By: BJ Cardon (cardonbj) Date: 2011-10-06 08:30 Message: I guess I should have checked the documentation before looking. Yes, it is showing DatabaseName.SchemaName.TableName Before upgrading to 3.6.1 I was only seeing SchemaName.TableName I don't really think seeing the DatabaseName there adds any value at all. You can create a table using: USE TestDatabase GO CREATE TABLE [test].[alpha]... etc ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 06:44 Message: How do you create such tables. In the documentation I found this: CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name .... Does this mean SchemaName = database, test = schema_name, aaa = table_name ? ---------------------------------------------------------------------- Comment By: BJ Cardon (cardonbj) Date: 2011-10-04 14:05 Message: o_O I have been using other versions of SQL Explorer since that date and nothing changed until I updated to 3.6.1. I am using Microsoft SQL Server 2008 with the jTDS 1.2.5 driver. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-04 12:22 Message: In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here. Which Databae do you use? So I can check which information is available from this database to resolve this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-06 16:11:55
|
Bugs item #3418589, was opened at 2011-10-04 19:58 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BJ Cardon (cardonbj) Assigned to: Heiko Hilbert (hhilbert) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 18:11 Message: I have found it. A fix made for DB2 with last release causes the change that the cataloge name is now displayed for mssql tables when 'Show table with schema' is on. I have to check what the problem with DB2 was for that change to found a solution which works for 'all' database systems. ---------------------------------------------------------------------- Comment By: BJ Cardon (cardonbj) Date: 2011-10-06 16:30 Message: I guess I should have checked the documentation before looking. Yes, it is showing DatabaseName.SchemaName.TableName Before upgrading to 3.6.1 I was only seeing SchemaName.TableName I don't really think seeing the DatabaseName there adds any value at all. You can create a table using: USE TestDatabase GO CREATE TABLE [test].[alpha]... etc ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 14:44 Message: How do you create such tables. In the documentation I found this: CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name .... Does this mean SchemaName = database, test = schema_name, aaa = table_name ? ---------------------------------------------------------------------- Comment By: BJ Cardon (cardonbj) Date: 2011-10-04 22:05 Message: o_O I have been using other versions of SQL Explorer since that date and nothing changed until I updated to 3.6.1. I am using Microsoft SQL Server 2008 with the jTDS 1.2.5 driver. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-04 20:22 Message: In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here. Which Databae do you use? So I can check which information is available from this database to resolve this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-06 14:30:20
|
Bugs item #3418589, was opened at 2011-10-04 11:58 Message generated for change (Comment added) made by cardonbj You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BJ Cardon (cardonbj) Assigned to: Heiko Hilbert (hhilbert) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- >Comment By: BJ Cardon (cardonbj) Date: 2011-10-06 08:30 Message: I guess I should have checked the documentation before looking. Yes, it is showing DatabaseName.SchemaName.TableName Before upgrading to 3.6.1 I was only seeing SchemaName.TableName I don't really think seeing the DatabaseName there adds any value at all. You can create a table using: USE TestDatabase GO CREATE TABLE [test].[alpha]... etc ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 06:44 Message: How do you create such tables. In the documentation I found this: CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name .... Does this mean SchemaName = database, test = schema_name, aaa = table_name ? ---------------------------------------------------------------------- Comment By: BJ Cardon (cardonbj) Date: 2011-10-04 14:05 Message: o_O I have been using other versions of SQL Explorer since that date and nothing changed until I updated to 3.6.1. I am using Microsoft SQL Server 2008 with the jTDS 1.2.5 driver. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-04 12:22 Message: In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here. Which Databae do you use? So I can check which information is available from this database to resolve this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-06 12:44:01
|
Bugs item #3418589, was opened at 2011-10-04 19:58 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BJ Cardon (cardonbj) >Assigned to: Heiko Hilbert (hhilbert) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-06 14:44 Message: How do you create such tables. In the documentation I found this: CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name .... Does this mean SchemaName = database, test = schema_name, aaa = table_name ? ---------------------------------------------------------------------- Comment By: BJ Cardon (cardonbj) Date: 2011-10-04 22:05 Message: o_O I have been using other versions of SQL Explorer since that date and nothing changed until I updated to 3.6.1. I am using Microsoft SQL Server 2008 with the jTDS 1.2.5 driver. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-04 20:22 Message: In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here. Which Databae do you use? So I can check which information is available from this database to resolve this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-04 20:05:35
|
Bugs item #3418589, was opened at 2011-10-04 11:58 Message generated for change (Comment added) made by cardonbj You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BJ Cardon (cardonbj) Assigned to: Nobody/Anonymous (nobody) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- >Comment By: BJ Cardon (cardonbj) Date: 2011-10-04 14:05 Message: o_O I have been using other versions of SQL Explorer since that date and nothing changed until I updated to 3.6.1. I am using Microsoft SQL Server 2008 with the jTDS 1.2.5 driver. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-04 12:22 Message: In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here. Which Databae do you use? So I can check which information is available from this database to resolve this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-04 18:22:25
|
Bugs item #3418589, was opened at 2011-10-04 19:58 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BJ Cardon (cardonbj) Assigned to: Nobody/Anonymous (nobody) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-10-04 20:22 Message: In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here. Which Databae do you use? So I can check which information is available from this database to resolve this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-10-04 17:58:57
|
Bugs item #3418589, was opened at 2011-10-04 11:58 Message generated for change (Tracker Item Submitted) made by cardonbj You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: BJ Cardon (cardonbj) Assigned to: Nobody/Anonymous (nobody) Summary: Bad table sorting change in 3.6.1 Initial Comment: I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this: Namespace.TableName Now it looks like this: SchemaName.Namespace.TableName Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating: SchemaName.test.aaa SchemaName.zed.aaa SchemaName.test.alpha SchemaName.apple.beta SchemaName.fred.charlie Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled. This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3418589&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-08-03 08:44:31
|
Bugs item #3385088, was opened at 2011-08-03 00:02 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3385088&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Jonathan Carlson (joncrlsn) Assigned to: Nobody/Anonymous (nobody) Summary: Odd characters in SQL not being handled right? Initial Comment: Thanks for a great plugin. I've been happily running SQL Explorer 3.6.1 for the last few weeks. However, the plugin goes into la-la land when I execute this against a database (happens to be Postgres) update t_user set password = '/FkB31Sclr+awjyHLJzNv2kLThw=:eZ5iJTDcc10=' where user_id = 27; I never get a response back from the application and when I try to execute other SQL statements it throws a NullPointerException SQuirreL executes it fine against the exact same database instance. I suspect there is something in the syntax parser that doesn't like one of the characters in that string. I'm running Eclipse Helios Service Release 2 Thanks!! ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-08-03 10:44 Message: Hi Jonathan, I tried your statement against my MySql database. It completes without any problems. Check that you have switched 'Log Success Messages' on in the SQL Explorer preferences. Then try it again and look into Messages tab for results. Sometimes the Sql editor has a problem when trying to execute a statement at the end of the file. Then you'll get a NPE. The real cause I can't find yet. Please check your eclispe error log for more detailed error information. Thx Heiko ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3385088&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-08-02 22:02:54
|
Bugs item #3385088, was opened at 2011-08-02 17:02 Message generated for change (Tracker Item Submitted) made by joncrlsn You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3385088&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Jonathan Carlson (joncrlsn) Assigned to: Nobody/Anonymous (nobody) Summary: Odd characters in SQL not being handled right? Initial Comment: Thanks for a great plugin. I've been happily running SQL Explorer 3.6.1 for the last few weeks. However, the plugin goes into la-la land when I execute this against a database (happens to be Postgres) update t_user set password = '/FkB31Sclr+awjyHLJzNv2kLThw=:eZ5iJTDcc10=' where user_id = 27; I never get a response back from the application and when I try to execute other SQL statements it throws a NullPointerException SQuirreL executes it fine against the exact same database instance. I suspect there is something in the syntax parser that doesn't like one of the characters in that string. I'm running Eclipse Helios Service Release 2 Thanks!! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3385088&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-06-10 00:38:35
|
Bugs item #3314485, was opened at 2011-06-10 11:38 Message generated for change (Tracker Item Submitted) made by derbylock You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3314485&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Antony Tolokan (derbylock) Assigned to: Nobody/Anonymous (nobody) Summary: Syntax coloring doesn't work Initial Comment: 1) Open new editor 2) type "select * from t1" 3) word "select" will not be coloring. sometimes (when its first editor from starting eclipse) nothing will be coloured, sometimes only "selec" coloured, but "t" not. 1) Delete all curent editor's text 2) type "select * from t1" 3) move cursor to the start of line 4) type enter 5) type "/*" 5*) "select * from t1" not coloured 6) go to the end of the line "select * from t1" 7) type enter 8) type "*/" 8*) "select * from t1" still not coloured This is like a closed bug ID #1669397 (http://sourceforge.net/mailarchive/forum.php?thread_name=E1NOtoA-0001Dx-My%40565xhf1.ch3.sourceforge.com&forum_name=eclipsesql-bugs) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3314485&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-05-28 20:17:33
|
Bugs item #3028297, was opened at 2010-07-12 09:54 Message generated for change (Settings changed) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028297&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: None Priority: 5 Private: No Submitted By: Roman V. Nikolaev (nikolaevroman) Assigned to: Nobody/Anonymous (nobody) Summary: Double logic on table click in Database Scructure Initial Comment: Reproduce: 1. Connect to database 2. Switch to Database Structure 3. Double click on some table Then open Database Detail (for this table) and table name copied in SQL Editor window. For example: I write sql query in SQL Editor and want to see table colunms. I double click on table, and can see columns but my sql query now is broken: table name written in some place of sql query (in current cursor position). Need do something one. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-05-28 22:15 Message: The Database Details are shown because of a selection changed event. This is also thrown on a double click on the node, if it was not already selected. So you have to live with this. ;-) ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-14 08:27 Message: >If you click once on a Element in the database structure view the details >of this elemnet are schown (if available). >If you click double the text of the current element is copied from the >tree into the current editor, so you can easily pickup table and colum >names in your query. Ok. I understand. But double click copy table name in SQL Editor and open Database Detail simultaneously. You need stop open Database Detail on double click. It`s can be bug of Eclipse? My: Version: 3.6.0 Build id: I20100608-0911 SQL Explorer 3.5.1 (And I see the small bug in about window =) ) ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2010-07-13 15:40 Message: If you click once on a Element in the database structure view the details of this elemnet are schown (if available). If you click double the text of the current element is copied from the tree into the current editor, so you can easily pickup table and colum names in your query. If you want to expand/collpase a tree node (like table name) click on the arrow. Everything has tis own action no double logic. :-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028297&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-05-28 20:15:49
|
Bugs item #3028297, was opened at 2010-07-12 09:54 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028297&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Roman V. Nikolaev (nikolaevroman) Assigned to: Nobody/Anonymous (nobody) Summary: Double logic on table click in Database Scructure Initial Comment: Reproduce: 1. Connect to database 2. Switch to Database Structure 3. Double click on some table Then open Database Detail (for this table) and table name copied in SQL Editor window. For example: I write sql query in SQL Editor and want to see table colunms. I double click on table, and can see columns but my sql query now is broken: table name written in some place of sql query (in current cursor position). Need do something one. ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-05-28 22:15 Message: The Database Details are shown because of a selection changed event. This is also thrown on a double click on the node, if it was not already selected. So you have to live with this. ;-) ---------------------------------------------------------------------- Comment By: Roman V. Nikolaev (nikolaevroman) Date: 2010-07-14 08:27 Message: >If you click once on a Element in the database structure view the details >of this elemnet are schown (if available). >If you click double the text of the current element is copied from the >tree into the current editor, so you can easily pickup table and colum >names in your query. Ok. I understand. But double click copy table name in SQL Editor and open Database Detail simultaneously. You need stop open Database Detail on double click. It`s can be bug of Eclipse? My: Version: 3.6.0 Build id: I20100608-0911 SQL Explorer 3.5.1 (And I see the small bug in about window =) ) ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2010-07-13 15:40 Message: If you click once on a Element in the database structure view the details of this elemnet are schown (if available). If you click double the text of the current element is copied from the tree into the current editor, so you can easily pickup table and colum names in your query. If you want to expand/collpase a tree node (like table name) click on the arrow. Everything has tis own action no double logic. :-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3028297&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-05-28 20:02:16
|
Bugs item #3207893, was opened at 2011-03-12 18:05 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3207893&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface (example) Group: v1.0 (example) >Status: Closed Resolution: None Priority: 5 Private: No Submitted By: Robert Christiaanse (rwchristiaanse) Assigned to: Heiko Hilbert (hhilbert) Summary: Nullpointer exception when no database selected Initial Comment: OS: Windows 7 Ultimate 64 bits SqlExplorer version: sqlexplorer_plugin-3.6.1_SR1 (Eclipse plugin) Connector: mysql-connector-java-5.1.15 Bug: NullpointerException when no database selected Reproduction: Create a connection profile without a database selected in the URL, like jdbc:mysql://localhost:3306. In view "Database Structure" I can now see my databases, so this is just fine. Try to execute the following query in the SQL Editor: "SELECT * FROM mytable". There are different situations... Situation 1, no database is selected in the dropdown: A message "No database selected" is showed. This is correct. Situation 2, a database is selected in the dropdown: A message "java.lang.NullPointerException:null" is showed. This is not correct. Now change the query into: "SELECT * FROM mydatabase.mytable" Situation 3, no database is selected in the dropdown: A message "No database selected" is showed. This is not correct. The database is specified in the query. Situation 4, a database is selected in the dropdown (it does not matter which one): The query is executed. This is correct. Now I try to prevent this by specifying a database in the url in the connection profile. It now looks like this: jdbc:mysql://localhost/mydatabase:3306 or jdbc:mysql://localhost/mydatabase Not sure if this is correct, but what I do know is that it does not really help. I run into similar problems. ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-05-28 22:02 Message: No response :-( ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-03-19 09:36 Message: I tried to reproduce the NPE with the situations you described. I can't get one. There must be an other problem. Can you check your eclipse error log file, please. You will find it under: [current workspace]/.metadata/.log Or open the 'Error Log' view (Window / Show View / Other... / General / Error Log ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3207893&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-05-28 19:59:54
|
Bugs item #3269611, was opened at 2011-04-02 17:46 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3269611&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: None Priority: 5 Private: No Submitted By: thomas () Assigned to: Heiko Hilbert (hhilbert) Summary: NullPointerException in User.getDescription Initial Comment: Hi, when trying to do a "select * from xxx" statement on a local MySQL server with user "root" I get this NullPointerException: Caused by: java.lang.NullPointerException at net.sourceforge.sqlexplorer.dbproduct.User.getDescription(User.java:447) at net.sourceforge.sqlexplorer.dbproduct.User.hashCode(User.java:499) at org.eclipse.jface.viewers.CustomHashtable.hashCode(CustomHashtable.java:264) at org.eclipse.jface.viewers.CustomHashtable.get(CustomHashtable.java:236) at org.eclipse.jface.viewers.StructuredViewer.unmapElement(StructuredViewer.java:1926) at org.eclipse.jface.viewers.StructuredViewer.disassociate(StructuredViewer.java:642) at org.eclipse.jface.viewers.AbstractTreeViewer.disassociate(AbstractTreeViewer.java:838) at org.eclipse.jface.viewers.TreeViewer.disassociate(TreeViewer.java:1117) at org.eclipse.jface.viewers.AbstractTreeViewer.updateChildren(AbstractTreeViewer.java:2626) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefreshStruct(AbstractTreeViewer.java:1867) at org.eclipse.jface.viewers.TreeViewer.internalRefreshStruct(TreeViewer.java:721) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefreshStruct(AbstractTreeViewer.java:1874) at org.eclipse.jface.viewers.TreeViewer.internalRefreshStruct(TreeViewer.java:721) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1842) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1799) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1785) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1487) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1422) at org.eclipse.jface.viewers.TreeViewer.preservingSelection(TreeViewer.java:403) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1383) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1485) at org.eclipse.jface.viewers.ColumnViewer.refresh(ColumnViewer.java:537) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1444) at net.sourceforge.sqlexplorer.connections.ConnectionsView$5.run(ConnectionsView.java:216) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134) ... 22 more Version information: org.eclipse.platform (3.6.1.r361_v20100909-9pF78H4oFrRqo0j7kHFogDSz-B4nsSP2z-oW) "Eclipse Plattform" org.eclipse.rcp (3.6.1.r361_v20100827-9oBYFOtFkzKz-ApYk1gu5D_V) "Eclipse RCP net.sourceforge.sqlexplorer (3.6.1.v20110108_SR1) "SQLExplorer Plugin" MySQL version 5.5.10 JDBC driver: mysql-connector-java version 5.1.15-1 ---------------------------------------------------------------------- >Comment By: Heiko Hilbert (hhilbert) Date: 2011-05-28 21:59 Message: Fixed and released with 3.6.1 SR2 ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-04-12 02:27 Message: Thank you for the report. It was a little bit hard to reproduce but the NPE you have posted comes from an error occured when trying to delete a user from a connection profile. There is no dependency with running a querty. So the delete error I have fixed. This will be available with next SR. This exception is a 'temporarly' problem. After restarting eclispes the delted user is disapeared and no more Exception will occure. If the NPE on running the select statement still occures, check your error log for other Excpetin stack traces, please. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3269611&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-04-12 00:35:57
|
Bugs item #3062825, was opened at 2010-09-09 19:35 Message generated for change (Settings changed) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3062825&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: None Priority: 5 Private: No Submitted By: rzen () Assigned to: Nobody/Anonymous (nobody) Summary: Seeing this bug in SQL Explorer 3.5.1 Initial Comment: a relevant snippet from the .metadata/.log is coming right up ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3062825&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-04-12 00:34:32
|
Bugs item #3060267, was opened at 2010-09-06 11:39 Message generated for change (Settings changed) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3060267&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed Resolution: None Priority: 5 Private: No Submitted By: felix-oertel (felix-oertel) Assigned to: Nobody/Anonymous (nobody) Summary: Could not load mysql-Connector with v3.5.1 Initial Comment: I´m not able to load the mysqlconnector. There is no driver found in the jar. The problem does not appear with v3.5.0RC8. Doens´t matter, if RPC or plugin is used. Windows 7 64bit, Eclipse Helios PDT 32bit or Aptana 2.0.5 32bit, JDE is 32bit ---------------------------------------------------------------------- Comment By: Kevin Benton (s1kevin) Date: 2010-09-12 06:40 Message: While it was a bit confusing to figure out, when I added an extra class path pointing to the Connector/J driver I downloaded from mysql.com, I was able to add thenew driver, click on the driver, then click on List Drivers and saw the driver class name is com.mysql.jdbc.Driver in 3.1.14. I got that without issues but then again, I'm using CentOS and not Win7. Not what I would call intuitive, but I'm not sure much of this will be given the complexity. ---------------------------------------------------------------------- Comment By: felix-oertel (felix-oertel) Date: 2010-09-08 18:50 Message: Cheers! It is working. Shall I close? ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2010-09-07 20:24 Message: I can reproduce the problem and have a workaround. The problem seems to be that 'List drivers' can't detect the MySql Driver class. I have to setup an IDE on Win7 to find out why. But if you enter the driver class name: com.mysql.jdbc.Driver by hand into the combo box in the JDBC-Drivers dialog, it works. Itested it with MySql Connector 5.1.13 and 5.1.5 with 32 bit and 64 bit version of SQLExplorer standalone on Win7 64 bit. ---------------------------------------------------------------------- Comment By: felix-oertel (felix-oertel) Date: 2010-09-07 10:44 Message: Doesn´t matter. I tried with 3.1.14; 5.0.8; 5.1.13. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2010-09-06 16:23 Message: Which Version of mysqlconnector do you use? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3060267&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-04-12 00:29:17
|
Bugs item #3207893, was opened at 2011-03-12 18:05 Message generated for change (Settings changed) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3207893&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Interface (example) Group: v1.0 (example) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Robert Christiaanse (rwchristiaanse) >Assigned to: Heiko Hilbert (hhilbert) Summary: Nullpointer exception when no database selected Initial Comment: OS: Windows 7 Ultimate 64 bits SqlExplorer version: sqlexplorer_plugin-3.6.1_SR1 (Eclipse plugin) Connector: mysql-connector-java-5.1.15 Bug: NullpointerException when no database selected Reproduction: Create a connection profile without a database selected in the URL, like jdbc:mysql://localhost:3306. In view "Database Structure" I can now see my databases, so this is just fine. Try to execute the following query in the SQL Editor: "SELECT * FROM mytable". There are different situations... Situation 1, no database is selected in the dropdown: A message "No database selected" is showed. This is correct. Situation 2, a database is selected in the dropdown: A message "java.lang.NullPointerException:null" is showed. This is not correct. Now change the query into: "SELECT * FROM mydatabase.mytable" Situation 3, no database is selected in the dropdown: A message "No database selected" is showed. This is not correct. The database is specified in the query. Situation 4, a database is selected in the dropdown (it does not matter which one): The query is executed. This is correct. Now I try to prevent this by specifying a database in the url in the connection profile. It now looks like this: jdbc:mysql://localhost/mydatabase:3306 or jdbc:mysql://localhost/mydatabase Not sure if this is correct, but what I do know is that it does not really help. I run into similar problems. ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-03-19 09:36 Message: I tried to reproduce the NPE with the situations you described. I can't get one. There must be an other problem. Can you check your eclipse error log file, please. You will find it under: [current workspace]/.metadata/.log Or open the 'Error Log' view (Window / Show View / Other... / General / Error Log ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3207893&group_id=132863 |
|
From: SourceForge.net <no...@so...> - 2011-04-12 00:27:59
|
Bugs item #3269611, was opened at 2011-04-02 17:46 Message generated for change (Comment added) made by hhilbert You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3269611&group_id=132863 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: thomas () Assigned to: Heiko Hilbert (hhilbert) Summary: NullPointerException in User.getDescription Initial Comment: Hi, when trying to do a "select * from xxx" statement on a local MySQL server with user "root" I get this NullPointerException: Caused by: java.lang.NullPointerException at net.sourceforge.sqlexplorer.dbproduct.User.getDescription(User.java:447) at net.sourceforge.sqlexplorer.dbproduct.User.hashCode(User.java:499) at org.eclipse.jface.viewers.CustomHashtable.hashCode(CustomHashtable.java:264) at org.eclipse.jface.viewers.CustomHashtable.get(CustomHashtable.java:236) at org.eclipse.jface.viewers.StructuredViewer.unmapElement(StructuredViewer.java:1926) at org.eclipse.jface.viewers.StructuredViewer.disassociate(StructuredViewer.java:642) at org.eclipse.jface.viewers.AbstractTreeViewer.disassociate(AbstractTreeViewer.java:838) at org.eclipse.jface.viewers.TreeViewer.disassociate(TreeViewer.java:1117) at org.eclipse.jface.viewers.AbstractTreeViewer.updateChildren(AbstractTreeViewer.java:2626) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefreshStruct(AbstractTreeViewer.java:1867) at org.eclipse.jface.viewers.TreeViewer.internalRefreshStruct(TreeViewer.java:721) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefreshStruct(AbstractTreeViewer.java:1874) at org.eclipse.jface.viewers.TreeViewer.internalRefreshStruct(TreeViewer.java:721) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1842) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1799) at org.eclipse.jface.viewers.AbstractTreeViewer.internalRefresh(AbstractTreeViewer.java:1785) at org.eclipse.jface.viewers.StructuredViewer$7.run(StructuredViewer.java:1487) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1422) at org.eclipse.jface.viewers.TreeViewer.preservingSelection(TreeViewer.java:403) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1383) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1485) at org.eclipse.jface.viewers.ColumnViewer.refresh(ColumnViewer.java:537) at org.eclipse.jface.viewers.StructuredViewer.refresh(StructuredViewer.java:1444) at net.sourceforge.sqlexplorer.connections.ConnectionsView$5.run(ConnectionsView.java:216) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:134) ... 22 more Version information: org.eclipse.platform (3.6.1.r361_v20100909-9pF78H4oFrRqo0j7kHFogDSz-B4nsSP2z-oW) "Eclipse Plattform" org.eclipse.rcp (3.6.1.r361_v20100827-9oBYFOtFkzKz-ApYk1gu5D_V) "Eclipse RCP net.sourceforge.sqlexplorer (3.6.1.v20110108_SR1) "SQLExplorer Plugin" MySQL version 5.5.10 JDBC driver: mysql-connector-java version 5.1.15-1 ---------------------------------------------------------------------- Comment By: Heiko Hilbert (hhilbert) Date: 2011-04-12 02:27 Message: Thank you for the report. It was a little bit hard to reproduce but the NPE you have posted comes from an error occured when trying to delete a user from a connection profile. There is no dependency with running a querty. So the delete error I have fixed. This will be available with next SR. This exception is a 'temporarly' problem. After restarting eclispes the delted user is disapeared and no more Exception will occure. If the NPE on running the select statement still occures, check your error log for other Excpetin stack traces, please. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3269611&group_id=132863 |