Re: JDBC/SQL Contributions

2018-11-12 Thread Nikolay Izhikov
Hello,Peter.

Welcome to Ignite community!
First of all, please, subscribe to dev-list.
Processes of code and doc contribution are described on wiki

https://cwiki.apache.org/confluence/display/IGNITE/How+to+Contribute

> which repo should I clone? It looks like there are two.

https://github.com/apache/ignite


В Вт, 13/11/2018 в 00:42 +, Peter Borissow пишет:
> Dear Devs,I starting experimenting with Ignite using java+jdbc over the 
> weekend. Really cool technology! In my tests, I ran into a couple issues that 
> I might have some time to help fix. For example:
> 
>   (1) Ignite doesn't support auto incrementing keys so you can't use SQL
>   keywords like "BIGSERIAL". Instead, you must explicitly set an ID
>   https://issues.apache.org/jira/browse/IGNITE-5625  
> https://apacheignite.readme.io/docs/id-generator
>  
>   (2) Related to above. You cannot retrieve values via rs.getGeneratedKey()
>   The following statement throws an error:
>   conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
>  
>   (3) ResultSet Concurrency of CONCUR_UPDATABLE throws an exception
>   stmt = conn.createStatement(rs.TYPE_FORWARD_ONLY, rs.CONCUR_UPDATABLE);
>   However, CONCUR_READ_ONLY works.
>  
>   (4) RS metadata is incomplete. Many fields types are returned as "object"
>  
>   (5) Strings must be explicitly cast to CLOB for "text" fields
>   Value conversion failed [from=java.lang.String, to=java.sql.Clob]
>   
> org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.convert(DmlUtils.java:117)
> 
> 
> What is the process for fixing bugs and implementing new features? I don't 
> see the process documented on the site.
> Also, which repo should I clone? It looks like there are two.
> 
> Finally, is there someone I can work with directly to help get started? For 
> example, I see that "pavel-kuznetsov" has been working on the JDBC metadata. 
> Maybe we can collaborate on issues 4+5?
> 
> 
> Thanks in advance,Peter
> 


signature.asc
Description: This is a digitally signed message part


JDBC/SQL Contributions

2018-11-12 Thread Peter Borissow
Dear Devs,    I starting experimenting with Ignite using java+jdbc over the 
weekend. Really cool technology! In my tests, I ran into a couple issues that I 
might have some time to help fix. For example:

  (1) Ignite doesn't support auto incrementing keys so you can't use SQL
  keywords like "BIGSERIAL". Instead, you must explicitly set an ID
  https://issues.apache.org/jira/browse/IGNITE-5625  
https://apacheignite.readme.io/docs/id-generator
 
  (2) Related to above. You cannot retrieve values via rs.getGeneratedKey()
  The following statement throws an error:
  conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
 
  (3) ResultSet Concurrency of CONCUR_UPDATABLE throws an exception
  stmt = conn.createStatement(rs.TYPE_FORWARD_ONLY, rs.CONCUR_UPDATABLE);
  However, CONCUR_READ_ONLY works.
 
  (4) RS metadata is incomplete. Many fields types are returned as "object"
 
  (5) Strings must be explicitly cast to CLOB for "text" fields
  Value conversion failed [from=java.lang.String, to=java.sql.Clob]
  
org.apache.ignite.internal.processors.query.h2.dml.DmlUtils.convert(DmlUtils.java:117)


What is the process for fixing bugs and implementing new features? I don't see 
the process documented on the site.
Also, which repo should I clone? It looks like there are two.

Finally, is there someone I can work with directly to help get started? For 
example, I see that "pavel-kuznetsov" has been working on the JDBC metadata. 
Maybe we can collaborate on issues 4+5?


Thanks in advance,Peter