4:04 a.m.
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Attachments: UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:04 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo updated TEIIDDES-927:
---------------------------------
Attachment: UfficioTecnico.xmi
The xmi generated
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:59 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-927:
---------------------------------------
Luca,
Can you verify that you can query a table in your "sa" schema using just the
Data Tools feature and your "UfficioTecnico" connection profile?
1) Right-click select "Connect" action
2) Open connection profile tree until you can select one of your tables
3) Right-click select "Data > Sample Contents"
You should also be able to select your connection profile and right-click select
"Open SQL Scrapbook" and perform ad-hoc queries.
If these queries do not work, then it's not a Teiid Designer issue, but something in
your connection profile/driver/DB permissions setup.
Teiid Designer's Preview Data feature actually uses the same Data Tools query
mechanism as you'd see above but be querying through a VDB on your running Teiid
server.
Barry
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:27 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo commented on TEIIDDES-927:
--------------------------------------
Done the proposed steps and all worked, the "Database development perspective"
works all correctly.
Also the "Open SQL Scrapbook".
It seems that the "running man" is disabled and for some strange reason it does
not link well with the connection.
Unfortunately since SQLserver is not my "well known" DB I'm not so helpfull
in debugging the stuff.
I send you a picture of the "Database development perspective" it seems to me
that the tree of the connection is a bit deeper than expected (regarding to the steps
followed during the import, but again I may be talking nonsense).
Luca
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:29 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo updated TEIIDDES-927:
---------------------------------
Attachment: sqlserver.png
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:33 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo commented on TEIIDDES-927:
--------------------------------------
BTW "sa" is not the schema, but the user.
The schema is "dbo" within the "ContinuumDB" catalog
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:04 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo commented on TEIIDDES-927:
--------------------------------------
Reopening today the eclipse installation I notice these warnings:
A handler conflict occurred. This may disable some commands.
Conflict for
'com.metamatrix.modeler.internal.ui.actions.CopyFullNameAction':HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.CopyFullNameAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CopyFullNameAction@1d22f81),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.CopyFullNameAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CopyFullNameAction@1d22f81),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'find':HandlerActivation(commandId=find,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.FindAction@fe6dab),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=find,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.FindAction@fe6dab),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'rename':HandlerActivation(commandId=rename,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.RenameAction@c34941),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=rename,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.RenameAction@c34941),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'undo':HandlerActivation(commandId=undo,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.UndoAction@145839b),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=undo,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.UndoAction@145839b),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'delete':HandlerActivation(commandId=delete,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.DeleteAction@1c31f72),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=delete,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.DeleteAction@1c31f72),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for
'com.metamatrix.modeler.internal.ui.actions.SetDatatypeAction':HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.SetDatatypeAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.SetDatatypeAction@f25560),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.SetDatatypeAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.SetDatatypeAction@f25560),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for
'com.metamatrix.modeler.internal.ui.actions.OpenAction':HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.OpenAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.OpenAction@1769fc1),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.OpenAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.OpenAction@1769fc1),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'bookmark':HandlerActivation(commandId=bookmark,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.BookmarkAction@52b341),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=bookmark,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.BookmarkAction@52b341),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'copy':HandlerActivation(commandId=copy,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CopyAction@40ec31),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=copy,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CopyAction@40ec31),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'selectAll':HandlerActivation(commandId=selectAll,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.SelectAllAction@1d08aaf),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=selectAll,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.SelectAllAction@1d08aaf),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'print':HandlerActivation(commandId=print,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.TablePrintAction@1c0e843),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=print,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.TablePrintAction@1c0e843),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'redo':HandlerActivation(commandId=redo,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.RedoAction@394482),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=redo,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.RedoAction@394482),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for
'com.metamatrix.modeler.internal.ui.actions.CloneAction':HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.CloneAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CloneAction@3cbf64),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.CloneAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CloneAction@3cbf64),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'cut':HandlerActivation(commandId=cut,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CutAction@191e0c9),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=cut,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CutAction@191e0c9),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for
'com.metamatrix.modeler.internal.ui.actions.PasteSpecialAction':HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.PasteSpecialAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.PasteSpecialAction@204119),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.PasteSpecialAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.PasteSpecialAction@204119),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for
'com.metamatrix.modeler.internal.ui.actions.EditAction':HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.EditAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.EditAction@1ad7222),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.EditAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.EditAction@1ad7222),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for
'com.metamatrix.modeler.internal.ui.actions.CopyNameAction':HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.CopyNameAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CopyNameAction@123034b),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=com.metamatrix.modeler.internal.ui.actions.CopyNameAction,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.CopyNameAction@123034b),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Conflict for 'paste':HandlerActivation(commandId=paste,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.TableClipboardPasteAction@53e9ed),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
HandlerActivation(commandId=paste,
handler=ActionHandler(com.metamatrix.modeler.internal.ui.actions.TableClipboardPasteAction@53e9ed),
expression=AndExpression(ActivePartExpression(com.metamatrix.modeler.internal.ui.editors.ModelEditor@455c33),WorkbenchWindowExpression(org.eclipse.ui.internal.WorkbenchWindow(a)12a45c7)),sourcePriority=1064960)
Also there is this error:
Unable to select any database object(s) that match sa
Could some of these help in the solution?
Thanks
Luca
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:05 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-927:
---------------------------------------
The HandlerActivation warnings logged are covered under TEIIDDES-874 and are unrelated to
this defect.
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:32 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo commented on TEIIDDES-927:
--------------------------------------
Any news on this problem?
Thanks
Luca
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:54 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo commented on TEIIDDES-927:
--------------------------------------
Tryed with 7.4, but no luck can someone help on this (new eclipse installation clean from
scratch)?
The runnimg man is always disabled, but the DB developer perspective works all right?
Could be something that get missed in the reverse eng?
Could be something related to the sqlserver drivers? I'm using sqlserver4.jar that is
placed somewhere in the PC (not placed in any "eclipse/TEIID folder) but referenced
in the driver creation.
I'm stuck!!!
Luca
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:21 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-927:
---------------------------------------
your xmi file (model) contains connection properties which include a URL :
key="connection:connection-url"
value="jdbc:sqlserver://10.102.59.4\SQLEXPRESS;databaseName=ContinuumDB"
Not sure the impact of // and \ characters in same URL on Windows.
In order for the Preview Data action to be enabled you need the following:
1) Preview is enabled ( See drop-down option in the Teiid View toolbar)
2) There is a connected Teiid server instance defined in the Teiid View
3) A valid executable relational table or procedure must be selected
4) If a view table or procedure is selected, then the backing transformation must
represent a valid SQL Query
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:45 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo commented on TEIIDDES-927:
--------------------------------------
I'll try to sum up steps.
1) installed eclipse 3.6 from scratch
2) added teiid7.4
3) created new teiid project
4) import "metadata from jdbc database"
5) added a new connection profile (choosing sql server and adding driver and all the
stuff)
6) tested connection and it works
7) imported tables and views following the wizard
8) tables and views created and are correct
9) should be able to "preview data" from the running man but... it's
disabled
I've also followed some steps form documentation (chapter 10 of User Guide) but the
connection profile is set and seems right, it doesn't ask for password but password is
not listed in connection profile info (maybe for security reason) even if I checked the
save password option ad some step before.
Since if I change perspective and go to DB developer and run a query it works (but ask for
fully qualified name so "dbo"."nametable" and it seems strange, but
this could be something that in the model get lost?) I should not need any Teiid server
around.
I'm not testing any views as for now, just the base model (the blue one just to
understand)
Luca
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:47 a.m.
New subject: [JBoss JIRA] Issue Comment Edited: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
luca gioppo edited comment on TEIIDDES-927 at 6/21/11 3:45 AM:
---------------------------------------------------------------
I'll try to sum up steps.
1) installed eclipse 3.6 from scratch
2) added teiid7.4
3) created new teiid project
4) import "metadata from jdbc database"
5) added a new connection profile (choosing sql server and adding driver and all the
stuff)
6) tested connection and it works
7) imported tables and views following the wizard
8) tables and views created and are correct
9) should be able to "preview data" from the running man but... it's
disabled
I've also followed some steps from documentation (chapter 10 of User Guide) but the
connection profile is set and seems right, it doesn't ask for password but password is
not listed in connection profile info (maybe for security reason) even if I checked the
save password option ad some step before.
Since if I change perspective and go to DB developer and run a query it works (but ask for
fully qualified name so "dbo"."nametable" and it seems strange, but
this could be something that in the model get lost?) I should not need any Teiid server
around.
I'm not testing any views as for now, just the base model (the blue one just to
understand)
Luca
was (Author: gioppoluca):
I'll try to sum up steps.
1) installed eclipse 3.6 from scratch
2) added teiid7.4
3) created new teiid project
4) import "metadata from jdbc database"
5) added a new connection profile (choosing sql server and adding driver and all the
stuff)
6) tested connection and it works
7) imported tables and views following the wizard
8) tables and views created and are correct
9) should be able to "preview data" from the running man but... it's
disabled
I've also followed some steps form documentation (chapter 10 of User Guide) but the
connection profile is set and seems right, it doesn't ask for password but password is
not listed in connection profile info (maybe for security reason) even if I checked the
save password option ad some step before.
Since if I change perspective and go to DB developer and run a query it works (but ask for
fully qualified name so "dbo"."nametable" and it seems strange, but
this could be something that in the model get lost?) I should not need any Teiid server
around.
I'm not testing any views as for now, just the base model (the blue one just to
understand)
Luca
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:53 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-927) SQLServer import problem
[
https://issues.jboss.org/browse/TEIIDDES-927?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-927:
---------------------------------------
Luca, the Preview Data feature is designed to query data through a sample Preview (i.e.
sample) VDB which DOES require a connection to a Teiid server.
See 2) above "There is a connected Teiid server instance defined in the Teiid
View"
SQLServer import problem
------------------------
Key: TEIIDDES-927
URL: https://issues.jboss.org/browse/TEIIDDES-927
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.3
Environment: Windows XP
Reporter: luca gioppo
Labels: preview, sqlserver2005
Attachments: sqlserver.png, UfficioTecnico.xmi
Made import from SQL Server, tables imported correctly, but "Preview data" does
not work also this essor is in the message lock
"Unable to select any database object(s) that match sa"
eclipse.buildId=M20110210-1200
java.version=1.6.0_04
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=it_IT
Framework arguments: -product org.eclipse.epp.package.java.product
Command-line arguments: -os win32 -ws win32 -arch x86 -product
org.eclipse.epp.package.java.product
Any hint?
Thanks
Luca
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5405
days inactive
5474
days old
teiid-designer-issues@lists.jboss.org
13 comments
2 participants
participants (2)
-
Barry LaFond (JIRA) -
luca gioppo (JIRA)