get no tables when I connected HPCC by Squirrel-sql

Fri Mar 08, 2013 10:06 am

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!

Fri Mar 08, 2013 2:00 pm

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.