JDBC/SQL Contributions

[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

[Nikolay Izhikov-2]

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 +0000, 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
>