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
