Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: UNC pathes again - where to go from here ?

  1. #1
    Join Date
    Mar 2007
    Posts
    16

    Question UNC pathes again - where to go from here ?

    Hello,

    sorry but we need to come back to the problems with the windows UNC pathes.

    The situation:
    - we can examine/list the files in an UNC directory using "Get File Names"
    - but when we try to pass that result to a "Text File Input", it tries to
    read the (correct) file names from d:\ (kettle install drive)
    - we assume this is java bug 4723726, right ?
    http://bugs.sun.com/bugdatabase/view...bug_id=4723726
    - the workaround is to use drive mappings ("X:") instead of UNC pathes
    - but system drive mappings are not accessible when started as a windows service
    - unfortunately this is our situation: our individual kettle jobs are fired from
    SQLServer, which is run as a service.

    We are pretty desperate by now. We tried to manually re-insert the UNC server
    part into the file name, but this is getting dirtier and dirtier as we build
    new jobs.

    What do you suggest we do ?

    - is a fix/workaround from you on the way ?
    -> do you maybe call File.toUri() or Uri.normalize() in places where it's not
    absolutely necessary ?
    -> is this a problem in the VFS ? could you use VFS in a way that would not
    trigger the problem ?

    - should we patch kettle to use a VFS including SMB support ? would this
    work, or again break in File.normalize() ?

    - should we patch something else ?
    -> "Get File Names" to return files "as is"
    -> "Text File Input" to hardcode our current UNC path, or maybe always prepend
    the file name with the content of a javascript variable.

    - any more ideas ?

    Any help and thoughts are appreciated! We're happy to collaborate on this,
    but I guess we would need some pointers in the right directions..

    Thanks and Cheers,
    Tom.
    Tom Eicher --- www.tomeicher.de

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    >- should we patch kettle to use a VFS including SMB support ? would this
    >work, or again break in File.normalize() ?

    That would probably work, yes.

    >- unfortunately this is our situation: our individual kettle jobs are fired from
    >SQLServer, which is run as a service.

    That is very unfortunate, yes.

    We don't use File anymore, only VFS stuff these days. This is indeed a VFS problem.

    Matt

  3. #3
    Join Date
    Mar 2007
    Posts
    16

    Default

    Strange, according to
    http://issues.apache.org/bugzilla/show_bug.cgi?id=6746
    it's supposed to work...?
    Tom Eicher --- www.tomeicher.de

  4. #4
    Join Date
    Mar 2007
    Posts
    16

    Default

    Okay, now we start kettle using a .bat batch file anyway, it seems we are able to give
    "net use ..."
    commands there, which will create the drive mappings for the running process (only).

    /tom.
    Tom Eicher --- www.tomeicher.de

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.