Несколько дней назад поставил dbForge Studio for Oracle.
Первые эмоции были очень положительные.
Но во время эксплуатации возникли ряд неудобств и ошибок:
1. Подключиться к БД получилось только через прямой режим. Через интерфейс oci так и не получилось... Oracle home студия видит, но соединение установить не может по причине: ORA-12154: TNS:невозможно разрешить заданный идентификатор соединения. В хелпе написано, что ошибка такая связана с неправильной конфигурацией клиента БД, хотя plsql developer и tnsping базу видят и проблем не возникало.
2. Периодически вываливаются исключения при работе в одном окне с несколькими запросами:
3. При выполнении некоторых запросов, например из v$sql также появляется ошибка:=========================
General
=========================
Application: dbForge Studio for Oracle
Product: Devart dbForge Studio for Oracle
Product Locale: Russian
Assembly: dbforgeoracle, Version=3.0.103.1, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files (x86)\Devart\dbForge Studio for Oracle\dbforgeoracle.exe
Global cache: False
Framework: 2.0.50727.5446
=========================
Exception Information
=========================
Message: Индекс и показание счетчика должны указывать на позицию в буфере.
Имя параметра: bytes
Source: Devart.XGrid
TargetSite: Void EndUpdate(Boolean)
HelpLink:
Type: System.Exception
Stack:
в Controls.Grid.GridControl.EndUpdate(Boolean synchronized)
в Controls.Grid.GridControl.EndUpdate()
в Controls.Grid.GridControl.OnLoaded()
в Controls.Editors.Container.EditorContainer.OnEndInit()
в Controls.Grid.GridControl.OnEndInit()
в Controls.Editors.Container.EditorContainer.EndInit()
в Devart.Shell.Controls.CustomGridControl.EndInit()
в aeo.a(Object A_0, ShowDataEventArgs A_1)
Message: Индекс и показание счетчика должны указывать на позицию в буфере.
Имя параметра: bytes
Source: mscorlib
TargetSite: System.String GetString(Byte[], Int32, Int32)
HelpLink:
Type: System.ArgumentOutOfRangeException
Stack:
в System.Text.UnicodeEncoding.GetString(Byte[] bytes, Int32 index, Int32 count)
в Devart.Data.Oracle.OracleLob.get_Value()
в axb.GetDisplayText(FormatInfo format, Object editValue)
в Controls.Editors.Repository.RepositoryItem.GetDisplayText(Object editValue)
в Devart.DbForge.RepositoryItemClobEdit.GetDisplayText(Object editValue)
в Devart.DbForge.ClobEditViewInfo.GetDisplayText()
в Controls.Editors.ViewInfo.BaseEditViewInfo.OnEditValueChanged()
в Controls.Editors.ViewInfo.BaseEditViewInfo.set_EditValue(Object value)
в Devart.DbForge.ClobEditViewInfo.set_EditValue(Object value)
в n6.set_EditValue(Object value)
в Controls.Grid.Views.Grid.ViewInfo.GridViewInfo.UpdateCellEditViewInfo(GridCellInfo cell, Point mousePos, Boolean canFastRecalculate, Boolean calc)
в Controls.Grid.Views.Grid.ViewInfo.GridViewInfo.CreateCellEditViewInfo(GridCellInfo cell, Boolean calc, Boolean allowCache)
в Controls.Grid.Views.Grid.ViewInfo.GridViewInfo.CalcColumnBestWidth(GridColumn column)
в Controls.Grid.Views.Base.ColumnView.CalcColumnBestWidth(GridColumn column)
в Devart.Shell.Controls.CustomGridView.CalcColumnBestWidth(GridColumn column)
в Devart.Shell.Controls.CheckColumnGridView.CalcColumnBestWidth(GridColumn column)
в Devart.Shell.Controls.CustomGridView.BestFitColumns()
в Devart.Shell.Controls.CustomGridView.LayoutChanged()
в Controls.Grid.Views.Base.BaseView.EndUpdateCore(Boolean synchronized)
в Devart.Shell.Controls.CheckColumnGridView.EndUpdateCore(Boolean synchronized)
в Controls.Grid.GridControl.EndUpdate(Boolean synchronized)
=========================
Window Layout
=========================
Active document window: 'SQL5.sql*' (Code)
Documents:
Name: 'AKUZMIN.AK_TOOLS', Caption: 'AKUZMIN.AK_TOOLS*', Visible: False, Active view: 'Code', Initial view: ''
Name: 'SQL.sql', Caption: 'SQL.sql*', Visible: False, Active view: 'Code', Initial view: 'Code'
Name: 'AKUZMIN.PROCEDURE1', Caption: 'AKUZMIN.PROCEDURE1*', Visible: False, Active view: 'Code', Initial view: ''
Name: 'SQL1.sql', Caption: 'SQL1.sql*', Visible: False, Active view: 'Code', Initial view: 'Code'
Name: 'SQL2.sql', Caption: 'SQL2.sql*', Visible: False, Active view: 'Code', Initial view: 'Code'
Name: 'SQL5.sql', Caption: 'SQL5.sql*', Visible: True, Active view: 'Code', Initial view: 'Code'
Name: 'SQL6.sql', Caption: 'SQL6.sql*', Visible: False, Active view: 'Code', Initial view: 'Code'
Name: 'SQL8.sql', Caption: 'SQL8.sql*', Visible: False, Active view: 'Code', Initial view: 'Code'
Name: 'SQL4.sql', Caption: 'SQL4.sql*', Visible: False, Active view: 'Code', Initial view: 'Code'
Toolwindows (visible or have been shown in current session):
Caption: 'Стартовая страница', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed
Caption: 'Схема документа', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Окно вывода', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Проект', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: AutoHidden
Caption: 'Фрагменты кода', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: AutoHidden
Caption: 'Менеджер сессий', Visible: 'False', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Tabbed
Caption: 'Схема проекта', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Список ошибок', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Монитор событий', Visible: 'False', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Tabbed
Caption: 'Свойства', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Проводник', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
=========================
Projects
=========================
No projects
=========================
Connections
=========================
[email protected]:RKRUS (current) (open) - 'User Id=akuzmin;Server=172.27.155.25;Unicode=True;Direct=True;Sid=RKRUS;'. Server version Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
=========================
Loaded Assemblies
=========================
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
dbforgeoracle, Version=3.0.103.1, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.1 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/dbforgeoracle.exe
Devart.Shell.Studio, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Studio.DLL
Devart.Shell.Interfaces, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Interfaces.DLL
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Devart.Shell.Utils, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Utils.DLL
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Devart.Shell.CommonRes, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.CommonRes.DLL
Devart.XBars, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XBars.DLL
Devart.XEditors, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XEditors.DLL
Devart.XData, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XData.DLL
Devart.XUtils, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XUtils.DLL
Devart.Shell.Controls, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Controls.DLL
mscorlib.resources, Version=2.0.0.0, Culture=ru, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
System.Windows.Forms.resources, Version=2.0.0.0, Culture=ru, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_ru_b77a5c561934e089/System.Windows.Forms.resources.dll
Devart.Shell.Projects, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Projects.DLL
Devart.Shell.TextEditor, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.TextEditor.DLL
Devart.Studio.Help, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Studio.Help.DLL
Devart.DbForge.SqlComplete.Oracle, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.SqlComplete.Oracle.DLL
Devart.DbForge.SqlComplete, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.SqlComplete.DLL
Devart.DbForge.Interfaces, Version=4.0.39.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.39.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Interfaces.DLL
Devart.DbForge.Repository, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Repository.DLL
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
Devart.DbForge.Repository.Oracle, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Repository.Oracle.DLL
Devart.DbForge.LanguageService.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.LanguageService.Oracle.DLL
Devart.DbForge.LanguageService, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.LanguageService.DLL
Devart.DbForge.Utils, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Utils.DLL
Devart.DbForge.CommonServices, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.CommonServices.DLL
Devart.DbForge.Oracle, Version=3.0.103.1, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.1 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Oracle.DLL
Devart.DbForge.Provider, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Provider.DLL
Devart.DbForge.Data.Interfaces, Version=5.0.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.8.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Interfaces.DLL
Devart.DbForge.Data.Oracle, Version=5.0.35.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.35.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Oracle.DLL
Devart.DbForge.DbObjectsUI.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjectsUI.Oracle.DLL
Devart.DbForge.DbObjectsUI, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjectsUI.DLL
Devart.DbForge.DbObjects.Oracle, Version=3.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjects.Oracle.DLL
Devart.DbForge.DbObjects, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjects.DLL
Devart.DbForge.DbEditors.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbEditors.Oracle.DLL
System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
Devart.BrowseObjects, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Utils.dll
Devart.Ole.UndoManager, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Ole.UndoManager.DLL
Devart.Shell.TextEditor.Interfaces, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.TextEditor.Interfaces.DLL
Devart.DbForge.Debugger, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Debugger.DLL
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Antlr3.Runtime.DLL
System.resources, Version=2.0.0.0, Culture=ru, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.resources/2.0.0.0_ru_b77a5c561934e089/System.resources.dll
System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
Devart.DbForge.DataEditor.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DataEditor.Oracle.DLL
Devart.DbForge.DataEditor, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DataEditor.DLL
Devart.XGrid, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XGrid.DLL
Ionic.Zip.Reduced, Version=1.9.1.2, Culture=neutral, PublicKeyToken=09af7300eec23701 1.9.1.2 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Ionic.Zip.Reduced.DLL
Devart.Shell.Wizard, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Wizard.DLL
Devart.DbForge.DbEditors, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbEditors.DLL
Devart.Studio.Browser, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Studio.Browser.DLL
Devart.XTreeList, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XTreeList.DLL
OciCall.dll, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Oracle.dll
=========================
System Information
=========================
Wow64 detected.
Processor architecture: amd64
Processor quantity: 4
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
Total physical memory: 5882Mb
Available virtual memory: 6043Mb
Operating System Name: Windows 7 Home Basic
Operating System Version: Microsoft Windows NT 6.1.7601 Service Pack 1
UAC: Disabled
Elevation Level: Default
Instances: 2
Culture: Russian (Russia)
Process started at 09/14/2011 14:11:35
Report created at 09/15/2011 20:44:57
4. Нет подсказок по полям при обращении к view(по крайней мере к системным, например v$session,v$process).=========================
General
=========================
Application: dbForge Studio for Oracle
Product: Devart dbForge Studio for Oracle
Product Locale: Russian
Assembly: dbforgeoracle, Version=3.0.103.1, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files (x86)\Devart\dbForge Studio for Oracle\dbforgeoracle.exe
Global cache: False
Framework: 2.0.50727.5446
=========================
Exception Information
=========================
Message: Индекс и показание счетчика должны указывать на позицию в буфере.
Имя параметра: bytes
Source: mscorlib
TargetSite: System.String GetString(Byte[], Int32, Int32)
HelpLink:
Type: System.ArgumentOutOfRangeException
Stack:
в System.Text.UnicodeEncoding.GetString(Byte[] bytes, Int32 index, Int32 count)
в Devart.Data.Oracle.OracleLob.get_Value()
в axb.GetDisplayText(FormatInfo format, Object editValue)
в Controls.Editors.Repository.RepositoryItem.GetDisplayText(Object editValue)
в Devart.DbForge.RepositoryItemClobEdit.GetDisplayText(Object editValue)
в Devart.DbForge.ClobEditViewInfo.GetDisplayText()
в Controls.Editors.ViewInfo.BaseEditViewInfo.OnEditValueChanged()
в Controls.Editors.ViewInfo.BaseEditViewInfo.set_EditValue(Object value)
в Devart.DbForge.ClobEditViewInfo.set_EditValue(Object value)
в n6.set_EditValue(Object value)
в Controls.Grid.Views.Grid.ViewInfo.GridViewInfo.UpdateCellEditViewInfo(GridCellInfo cell, Point mousePos, Boolean canFastRecalculate, Boolean calc)
в Controls.Grid.Views.Grid.ViewInfo.GridViewInfo.CreateCellEditViewInfo(GridCellInfo cell, Boolean calc, Boolean allowCache)
в Controls.Grid.Views.Grid.ViewInfo.GridViewInfo.RequestCellEditViewInfo(GridCellInfo cell)
в Controls.Grid.Views.Grid.Drawing.GridPainter.DrawRegularRowCell(GridViewDrawArgs e, GridCellInfo ci)
в Controls.Grid.Views.Grid.Drawing.GridPainter.DrawRegularRow(GridViewDrawArgs e, GridDataRowInfo ri)
в Controls.Grid.Views.Grid.Drawing.GridPainter.DrawRow(GridViewDrawArgs e, GridRowInfo ri)
в Controls.Grid.Views.Grid.Drawing.GridPainter.DrawRows(GridViewDrawArgs e)
в Controls.Grid.Views.Grid.Drawing.GridPainter.DrawContents(GridViewDrawArgs e)
в Controls.Grid.Views.Grid.Drawing.GridPainter.Draw(ViewDrawArgs ee)
в Controls.Grid.Views.Base.BaseView.Draw(GraphicsCache e)
в Controls.Grid.GridControl.OnPaint(PaintEventArgs e)
в System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean disposeEventArgs)
в System.Windows.Forms.Control.WmPaint(Message& m)
в System.Windows.Forms.Control.WndProc(Message& m)
в Controls.Editors.Container.EditorContainer.WndProc(Message& m)
в Controls.Grid.GridControl.WndProc(Message& m)
в Devart.Shell.Controls.CustomGridControl.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
=========================
Window Layout
=========================
Active document window: 'SQL.sql*' (Code)
Documents:
Name: 'SQL.sql', Caption: 'SQL.sql*', Visible: True, Active view: 'Code', Initial view: 'Code'
Toolwindows (visible or have been shown in current session):
Caption: 'Стартовая страница', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed
Caption: 'Окно вывода', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Проект', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Фрагменты кода', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Схема проекта', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'False', State: AutoHidden
Caption: 'Свойства', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
Caption: 'Проводник', Visible: 'True', DefaultVisibility: 'Layout', IsControlCreated: 'True', State: Docked
=========================
Projects
=========================
No projects
=========================
Connections
=========================
[email protected]:RKRUS (current) (open) - 'User Id=akuzmin;Server=172.27.155.25;Unicode=True;Direct=True;Sid=RKRUS;'. Server version Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
=========================
Loaded Assemblies
=========================
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
dbforgeoracle, Version=3.0.103.1, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.1 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/dbforgeoracle.exe
Devart.Shell.Studio, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Studio.DLL
Devart.Shell.Interfaces, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Interfaces.DLL
System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Devart.Shell.Utils, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Utils.DLL
System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Devart.Shell.CommonRes, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.CommonRes.DLL
Devart.XBars, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XBars.DLL
Devart.XEditors, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XEditors.DLL
Devart.XData, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XData.DLL
Devart.XUtils, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XUtils.DLL
Devart.Shell.Controls, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Controls.DLL
mscorlib.resources, Version=2.0.0.0, Culture=ru, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
System.Windows.Forms.resources, Version=2.0.0.0, Culture=ru, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_ru_b77a5c561934e089/System.Windows.Forms.resources.dll
Devart.Shell.Projects, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Projects.DLL
Devart.Shell.TextEditor, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.TextEditor.DLL
Devart.Studio.Help, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Studio.Help.DLL
Devart.DbForge.SqlComplete.Oracle, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.SqlComplete.Oracle.DLL
Devart.DbForge.SqlComplete, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.SqlComplete.DLL
Devart.DbForge.Interfaces, Version=4.0.39.0, Culture=neutral, PublicKeyToken=09af7300eec23701 4.0.39.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Interfaces.DLL
Devart.DbForge.Repository, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Repository.DLL
System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
Devart.DbForge.Repository.Oracle, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Repository.Oracle.DLL
Devart.DbForge.LanguageService.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.LanguageService.Oracle.DLL
Devart.DbForge.LanguageService, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.LanguageService.DLL
Devart.DbForge.Utils, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Utils.DLL
Devart.DbForge.CommonServices, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.CommonServices.DLL
Devart.DbForge.Oracle, Version=3.0.103.1, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.1 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Oracle.DLL
Devart.DbForge.Provider, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Provider.DLL
Devart.DbForge.Data.Interfaces, Version=5.0.8.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.8.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Interfaces.DLL
Devart.DbForge.Data.Oracle, Version=5.0.35.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.35.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Data.Oracle.DLL
Devart.DbForge.DbObjectsUI.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjectsUI.Oracle.DLL
Devart.DbForge.DbObjectsUI, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjectsUI.DLL
Devart.DbForge.DbObjects.Oracle, Version=3.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjects.Oracle.DLL
Devart.DbForge.DbObjects, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbObjects.DLL
Devart.DbForge.DbEditors.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DbEditors.Oracle.DLL
System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
Devart.BrowseObjects, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null 0.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.Utils.dll
Devart.Ole.UndoManager, Version=1.0.0.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.0.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Ole.UndoManager.DLL
Devart.Shell.TextEditor.Interfaces, Version=1.3.20.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.3.20.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.Shell.TextEditor.Interfaces.DLL
Devart.DbForge.Debugger, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.Debugger.DLL
Antlr3.Runtime, Version=0.3.0.37313, Culture=neutral, PublicKeyToken=09af7300eec23701 0.3.0.37313 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Antlr3.Runtime.DLL
System.resources, Version=2.0.0.0, Culture=ru, PublicKeyToken=b77a5c561934e089 2.0.0.0 C:/Windows/assembly/GAC_MSIL/System.resources/2.0.0.0_ru_b77a5c561934e089/System.resources.dll
Devart.DbForge.DataEditor.Oracle, Version=3.0.103.0, Culture=neutral, PublicKeyToken=09af7300eec23701 3.0.103.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DataEditor.Oracle.DLL
Devart.DbForge.DataEditor, Version=5.0.115.0, Culture=neutral, PublicKeyToken=09af7300eec23701 5.0.115.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.DbForge.DataEditor.DLL
System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 2.0.0.0 C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
Devart.XGrid, Version=9.2.11.0, Culture=neutral, PublicKeyToken=09af7300eec23701 9.2.11.0 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Devart.XGrid.DLL
Ionic.Zip.Reduced, Version=1.9.1.2, Culture=neutral, PublicKeyToken=09af7300eec23701 1.9.1.2 C:/Program Files (x86)/Devart/dbForge Studio for Oracle/Ionic.Zip.Reduced.DLL
=========================
System Information
=========================
Wow64 detected.
Processor architecture: amd64
Processor quantity: 4
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
AMD Phenom(tm) II N930 Quad-Core Processor AMD64 Family 16 Model 5 Stepping 3
Total physical memory: 5882Mb
Available virtual memory: 5983Mb
Operating System Name: Windows 7 Home Basic
Operating System Version: Microsoft Windows NT 6.1.7601 Service Pack 1
UAC: Disabled
Elevation Level: Default
Instances: 2
Culture: Russian (Russia)
Process started at 09/15/2011 19:54:30
Report created at 09/15/2011 20:50:39
5. Нет возможности открыть из файла пакет/тело пакета. открыть можно как текстовый файл. Возможно я не нашел такой опции...
6. Из-за ошибок парсинга кода plsql крайне сложно проводить навигацию по коду/схеме документа:
- нет группировки по логическим выражениям: if,elsif,else, end if.
- нет группировки по for .. loop, loop, forall.
- не отрабатывает группировка по блокам в случае если встречается "=>"
- не отрабатывает группировка курсора в случае если название таблицы соответствует системному(например transaction).
- в некоторых случаях блок закрывается при end loop; и end if;
- закрывает блок на "tr.transdate where tr" в участке кода:
Код: Выделить всё
forall i in l_pd.first..l_pd.last
update appcrm.transaction tr set tr.receivedate = tr.transdate where tr.rowid=l_rid(i);
forall i in l_pd.first..l_pd.last
insert into updated_rec values(l_rid(i),l_pd(i));
- подсказки по декларированным типам не работают(писали, что не не поддержан TYPE в соседнем посте);
- переход к декларации типа также не работает(писали, что не не поддержан TYPE в соседнем посте).
7. Не всегда удобно дожидаться выполнения запроса в режиме профилирования, чтобы посмотреть план запроса. Возможно есть опция по просмотру только плана запроса без его выполнения, но я не нашел.
Напоследок хотелось бы добавить, что среда понравилась, но к сожалению из-за обилия проблем работать по крайней мере с запросами и plsql пакетами крайне проблематично.
Надеюсь, что среда будет продолжать развиваться, и новые билды не заставят себя ждать.
Спасибо