[teiid-issues] [JBoss JIRA] (TEIID-4398) Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format

[Bram Gadeyne (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13364364#comment-13364364 ] 

Bram Gadeyne commented on TEIID-4398:
-------------------------------------

Thank you [~rareddy],

I've tried converting our vdb file but I get an error:

D:\teiid9.2.0\bin>teiid-convert-vdb.bat D:\workspaceTeiid\IZ\vdb3.24.vdb
Exception in thread "main" org.teiid.deployers.VirtualDatabaseException: TEIID40106 VDB vdb3 deployment failed.  Override translators are not allowed
in embedded mode.
        at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:771)
        at org.teiid.runtime.EmbeddedServer.deployVDBZip(EmbeddedServer.java:764)
        at org.teiid.runtime.util.ConvertVDB.convert(ConvertVDB.java:111)
        at org.teiid.runtime.util.ConvertVDB.main(ConvertVDB.java:70)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.jboss.modules.Module.run(Module.java:330)
        at org.jboss.modules.Main.main(Main.java:505)
Press any key to continue . . .

Indeed we are using an override translator for sybase to set the property JtdsDriver=true;

I've then created a copy of our vdb file that points to the regular sybase translator and removed the override translator.

Then the process generates indeed a clear ddl file. Can I suggest to add " > output.ddl' to the documentation and to remove the pause statement at the end of the script? 

The script generates the DDL file on STDOUT but if you add > output.ddl it does not print the "Press any key to continue..." in the console but in the output.ddl file so to the user it is not clear that the script is just waiting for a user to press a key.




> Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format
> -----------------------------------------------------------------------------
>
>                 Key: TEIID-4398
>                 URL: https://issues.jboss.org/browse/TEIID-4398
>             Project: Teiid
>          Issue Type: Task
>          Components: Build/Kits
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 9.2
>
>         Attachments: teiid-convert-vdb.bat, teiid-convert-vdb.sh
>
>
> Write a command line utility and provide in "bin" directory to convert the Designer based .vdb file with index metadata into -vdb.xml file and/or newer DDL format.
> This can be used to migrate the older VDBs mach easier to newer formats without use of Designer tooling.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)