You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/01/26 02:04:07 UTC

[GitHub] [shardingsphere] hebing0625 opened a new issue #9164: db connection in sharding-jdbc still does not support array type

hebing0625 opened a new issue #9164:
URL: https://github.com/apache/shardingsphere/issues/9164


   hi,
   
   There still has a issue when I try to create array with connection as below:
   
   `Connection conn = shardingDataSource.getConnection();`
   `conn.createArrayOf("int8", new Long[]{1L, 2L, 3L});`
   
   A SQLFeatureNotSupportedException will be thrown.
   
   I trace the codes and find such snippets in SQLFeatureNotSupportedException.java:
   
   `@Override public final Array createArrayOf(final String typeName, final Object[] elements) throws SQLException {`
   `throw new SQLFeatureNotSupportedException("createArrayOf"); }`
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] sandynz commented on issue #9164: db connection in sharding-jdbc still does not support array type

Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #9164:
URL: https://github.com/apache/shardingsphere/issues/9164#issuecomment-787061223


   Hi @hebing0625 , you could use `java.sql.PreparedStatement.setObject` for now, e.g. `statement.setObject(1, new long[]{1, 2, 3})`.
   
   I'll try to support `java.sql.Connection.createArrayOf`.
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] hebing0625 commented on issue #9164: db connection in sharding-jdbc still does not support array type

Posted by GitBox <gi...@apache.org>.
hebing0625 commented on issue #9164:
URL: https://github.com/apache/shardingsphere/issues/9164#issuecomment-767989636


   Do you have plan to support it in future? 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #9164: db connection in sharding-jdbc still does not support array type

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9164:
URL: https://github.com/apache/shardingsphere/issues/9164#issuecomment-768002793


   Hi,
   
   I am unsure now. We definitely want to have excellent support for JDBC Driver. However, there are so many features to do currently. Also,  there are many contributors willing to have a try to fix it. That's why I ask your interest. Benefit yourself and others.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #9164: db connection in sharding-jdbc still does not support array type

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9164:
URL: https://github.com/apache/shardingsphere/issues/9164#issuecomment-767273840


   Hi @hebing0625 ,
   
   You're right. ShardingSphere does not implement this interface of JDBC currently.
   BTW, have you tried this interface with other database driver, like MySQL or Postgre?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #9164: db connection in sharding-jdbc still does not support array type

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9164:
URL: https://github.com/apache/shardingsphere/issues/9164#issuecomment-767273840


   Hi @hebing0625 ,
   
   You're right. ShardingSphere does not implement this interface of JDBC currently.
   BTW, have you tried this interface with other database driver, like MySQL or Postgre?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu closed issue #9164: db connection in sharding-jdbc still does not support array type

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9164:
URL: https://github.com/apache/shardingsphere/issues/9164


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org