Hi,

I have been trying to use the Planner model to generate relational algebra from calcite.

Everything seemed to be going very well and from a stand alone program I can call the planner and get back correct results.

The test code is as follows:

public static void main(String[] args){
final SqlStdOperatorTable stdOpTab = SqlStdOperatorTable.instance();
        MYSchema mySchema = new MySchema("details", null);
        final SchemaPlus rootSchema = Frameworks.createRootSchema(true);
        final FrameworkConfig config = Frameworks.newConfigBuilder()
        .defaultSchema(rootSchema.add("mine", mySchema))
        .operatorTable(stdOpTab)
        .build();

        Planner p = Frameworks.getPlanner(config);

        SqlNode parseR = null;
        try {
            parseR = p.parse("select c_custkey from customer limit 5");
        } catch (SqlParseException ex) {
Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
        }

        SqlNode validateR = null;
        try {
                p.validate(parseR);
        } catch (ValidationException ex) {
Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
        }
        RelRoot relR = null;
        try {
            relR = p.rel(validateR);
        } catch (RelConversionException ex) {
Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
        }
        LOGGER.error ("Result was " + relR);
        LOGGER.error ("Result project() " + relR.project());
LOGGER.error ("Result project() " + RelOptUtil.toString(relR.project()));

}

This all works fine, and I get the results I expect.

When I place this identical code in a method in a more complex call path I get an exception when trying to do the parse.

The error is:

Exception occurred: java.sql.SQLException: No suitable driver found for jdbc:calcite:

I am wondering if any one understands where this error is coming from? Its a little unclear to me why it is looking for a driver at all?

Any help with this would be much appreciated, looking forward to getting code working with 1.12.

regards

Reply via email to