Skip to Content
avatar image
Former Member

CSV driver

Hi,

I want to acces csv files from VC. I have installed a CSV driver http://csvjdbc.sourceforge.net/ into j2ee engine. But when I want to find or browse tables I get an error: "Error -21007 Search for table returned an error. DatabaseMetaData.getTablePrivileges(String,String,String, String[]) unsupported".

Anyone can help me with this problem?

Thanks in advance

Ivo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 29, 2006 at 02:21 PM

    Hi,

    we tried the same a few weeks ago. Except the driver from HXTT no CSV driver was working. I recommend to use the HXTT driver. We use it without any problem.

    There is a 30 day trial with 50 request in one session. That means a server restart after 50 requests.

    Drivers we tried relique CSV (csvjdbc.sourceforge.net), stels csv and two more.

    Here is the website: http://www.hxtt.com

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I'm right there with you Lars. We also tried the relique driver without success, then we use the HXTT driver and it works fine.

      Best Regards,

      Marcel

  • Feb 27, 2007 at 04:07 AM

    HXTT has limited usability. so I try jdbc driver you described. and it works fine.

    when you configure connection string in your portal, you have to describe as below,

    connection URL : jdbc:csv:csvdir?_CSV_Header=true

    Driver class path: org.relique.jdbc.csv.CsvDriver

    then you will suceed.

    Add comment
    10|10000 characters needed characters exceeded