Product: Aqua Data Studio
Version: 17.0.0-alpha-31
Build #: 45458
Build Date: 2015-Aug-26 09:37:16 PM
Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=729,808,896; Total=729,808,896; Free=449,551,184; CPUs=8
Connect Sybase ASE-16.0
Create materialized views using below sql script:
create table mytable (
a int
, b varchar(20)
, constraint mytable_pk primary key nonclustered (a)
)
go
create table another (
a int
, c varchar(10)
, constraint another_pk primary key nonclustered (a)
)
go
insert mytable select 1, 'abc'
insert mytable select 2, 'def'
insert another select 1, 'ghi'
insert another select 2, 'jkl'
go
-- To prevent:
-- Precomputed result set cannot be created as some options have an inappropriate setting. Set ansinull on, arithabort on, arithignore off and string_rtruncation on.
set ansinull, arithabort, string_rtruncation on
set arithignore off
go
drop materialized view myview
go
create materialized view myview
constraint myview_ind1 unique (a)
as
select mt.a, mt.b, ant.c
from mytable mt
, another ant
where ant.a = mt.a
go
select *
from myview
go
insert mytable select 3, 'zzz'
go
select *
from myview
go
insert another select 3, 'yyy'
go
select *
from myview
go
And try to execute below scripting options
Select single materialized views->Script Object to window as/new window as/File as->Create
Select multiple materialized views->Script Object to window as/new window as/File as->Create.
Tools->schema script genetor->Select materialized views->Select Generate the create option.
Check view log:
java.lang.ClassFormatError: \\/\\/\\हिñçêČάй語简�?한\\/A͊ꌉꀷꍳintfinally
at \\.\\.\\हिñçêČάй語简�?한\\.Gꅞꐰꊬꊸassertelse.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Gꅞꐰꊬꊸassertelse.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Qꒉꏟ⠠ͧ2instanceof.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.Qꒉꏟ⠠ͧ2instanceof.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.t⣁ꎼꉀ⡀.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.L⢜ꌖꅄꉵ.a(Unknown Source)
at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Please refer V17.0.0-Alpha-31
I am having trouble reproducing this on windows 8.1 and ubuntu 14.04. Tried with build V17.0.0-Alpha-31 and from source and both are working without exceptions.