Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: shared.xml

  1. #1
    Join Date
    Nov 2008
    Posts
    777

    Question shared.xml

    I have several projects going in various stages of development and I would like to keep the database connections separate. What I was thinking of doing was having a separate shared.xml file for each project. To make this work I was planning on setting the "Shared objects file" field (Transformation settings ... Miscellaneous tab) with a value like this:

    ${Internal.Transformation.Filename.Directory}/shared2.xml

    HOWEVER, after I do that and then try to share a newly created database connection I get this:

    org.pentaho.di.core.exception.KettleFileException:
    org.apache.commons.vfs.FileSystemException: Could not create file "file:///C:/shared2.xml".
    Could not create file "file:///C:/shared2.xml".

    (see attached file for full trace.)

    If I hard code the file path (which I don't want to do) I don't get this error. Am I missing something or is there a bug with variable substitution in this field?
    Attached Files Attached Files
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  2. #2
    Join Date
    Jun 2007
    Posts
    260

    Default

    I can't speak about the error, but I can say that I use a properties file for achieving connections to different databases, and setting various filepaths and other options.

    I found the following article of tremendous value in doing this.
    http://rpbouman.blogspot.com/2011/05...iguration.html

  3. #3
    Join Date
    Nov 2008
    Posts
    777

    Default

    That certainly is an option but I'm still curious why variable substitution isn't working in the shared objects file field on the miscellaneous tab of the transformation settings.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.