Mon Nov 29, 2021 5:29 am
Login Register Lost Password? Contact Us


get no tables when I connected HPCC by Squirrel-sql

Topics around the use of the JDBC driver for HPCC Systems

Fri Mar 08, 2013 10:06 am Change Time Zone

Hi:
When I connected to HPCC by Squirrel,I cannot see any tables . How can I view my tables? Is there any guidant PDF?

Regards!
battleman
 
Posts: 17
Joined: Mon Feb 04, 2013 9:24 am

Fri Mar 08, 2013 2:00 pm Change Time Zone

Hi, the JDBC documentation can be found here:
http://cdn.hpccsystems.com/install/jdbc ... 2beta1.pdf

The JDBC driver will only recognize HPCC files that contain a record definition (otherwise the driver won't know the structure of the file). See the note on page 7 in the doc.

Also, this thread might be helpful if your files do not contain rec defs:
http://hpccsystems.com/bb/viewtopic.php ... 3350#p3233

Otherwise, there could be a connectivity issue, in which case you'll have to take a look at the log output (on windows, at the bottom of SQUIRREL, there's a monitor icon you can click to view logs).

Look around this statement:
Fetching tables: http://<yourIp>:8010/WsDfu/DFUQuery?LogicalName=*&PageSize=100&PageStartFrom=0&rawxml_&filetype=Logical Files and Superfiles

Hope that helps. Let us know if there are any issues. Thanks.
rodrigo.pastrana@lexisnexis.com
 
Posts: 22
Joined: Fri Oct 07, 2011 2:24 pm


Return to Java Tools

Who is online

Users browsing this forum: No registered users and 1 guest

cron