no, iam using the jdk1.8.0_11
Julian Hyde <[email protected]> schrieb am 18:55 Donnerstag, 22.Dezember
2016:
PS We do not support JDK 1.9 yet. The case is
https://issues.apache.org/jira/browse/CALCITE-1258
<https://issues.apache.org/jira/browse/CALCITE-1258>. The Java folks changed
the compiler to more strictly adhere to the spec, and as a result broke a lot
of our code.
> On Dec 22, 2016, at 9:42 AM, Julian Hyde <[email protected]> wrote:
>
> You’re using JDK 1.9 (beta), aren’t you?
>
>> On Dec 22, 2016, at 9:08 AM, Julian Stenzel <[email protected]>
>> wrote:
>>
>> jesus... "jdbc:calcite:model=database/config.json instead of
>> jdbc:calcite:database/config.json ... now its working (table found).
>> Did someone encounter this runtime exception before ? It is thrown after
>> the execution of my queryCaused by: java.lang.RuntimeException: Uncompilable
>> source code - incompatible types: org.apache.calcite.linq4j.Ord.OrdList<?
>> extends E> cannot be converted to
>> java.util.List<org.apache.calcite.linq4j.Ord<E>>
>>
>> https://i.imgsafe.org/c0814e5291.png
>>
>> Julian
>>
>>
>> Julian Stenzel <[email protected]> schrieb am 9:47 Donnerstag,
>>22.Dezember 2016:
>>
>>
>> I'll try it, but i think that no connection to the database is established
>> at all (over my java application).
>>
>>
>>
>> Julian Hyde <[email protected]> schrieb am 23:33 Mittwoch, 21.Dezember
>>2016:
>>
>>
>> I think you should use the default lex, make sure identifiers are the
>> correct case, and double-quote them in your query:
>>
>> select count(*) from “mongoDB”.”ZIPS”
>>
>> If that doesn’t work I don’t know what else to do.
>>
>> I’ve logged https://issues.apache.org/jira/browse/CALCITE-1549
>> <https://issues.apache.org/jira/browse/CALCITE-1549> to give a more
>> descriptive error message in cases like this.
>>
>> Julian
>>
>>
>>> On Dec 20, 2016, at 12:45 PM, Julian Stenzel <[email protected]>
>>> wrote:
>>>
>>> i tried zips, ZIPS and every available lex. Still dont work.
>>> Is my program code right ?
>>> Julian
>>>
>>> Julian Hyde <[email protected]> schrieb am 18:29 Dienstag, 20.Dezember
>>>2016:
>>>
>>>
>>> Maybe the “zips” table is upper-case. If so, your SQL query should be
>>>
>>> select count(*) from mongoDB.ZIPS
>>>
>>> It may not be the cause, but you should also change
>>>
>>> defaultSchema: ‘mongo'
>>>
>>> to
>>>
>>> defaultSchema: 'mongoDB'
>>>
>>> The difference between sqlline and Java is that sqlline is using the
>>> default lexical policy (because sqlline doesn't pass a Properties object
>>> when it opens a connection). If you want to use a lexical policy from
>>> sqlline, you need to add “;lex=SQL_SERVER” to the connect string.
>>>
>>> Julian
>>>
>>>
>>>> On Dec 20, 2016, at 8:24 AM, Julian Stenzel <[email protected]>
>>>> wrote:
>>>>
>>>> Hello Team,
>>>> atm iam trying to execute some queries in java.
>>>> my code:
>>>> Class.forName("org.apache.calcite.jdbc.Driver");info = new
>>>> Properties();info.setProperty("lex", "SQL_SERVER");
>>>> connection =
>>>> DriverManager.getConnection("jdbc:calcite:database/config.json",
>>>> info);statement = connection.createStatement();
>>>> ResultSet resultSet = statement.executeQuery("select count(*) from
>>>> mongoDB.zips");//
>>>> or select count(*) from zips
>>>> my config.json:
>>>> { version: '1.0', defaultSchema: 'mongo', schemas: [ { type:
>>>> 'custom', name: 'mongoDB', factory:
>>>> 'org.apache.calcite.adapter.mongodb.MongoSchemaFactory', operand: {
>>>> host: 'localhost', database: 'darwin_test',
>>>> } } ]}
>>>> i encounter Caused by:
>>>> org.apache.calcite.sql.validate.SqlValidatorException: Table
>>>> 'mongoDB.zips' not found. The query works fine with sqlline.bat and the
>>>> same config (config.json). Am I making any obvious mistake?Thank
>>>> youJulian
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
>>
>
