[GitHub] [shardingsphere] dissdic commented on issue #15134: to consider the sqlType of value parameter when setting the value to the corresponding placeholder in a executing SQL

[GitBox <gi...@apache.org>]

dissdic commented on issue #15134:
URL: https://github.com/apache/shardingsphere/issues/15134#issuecomment-1128539034

   sorry,I've worked on other things recently,so i don't have the stacktrace info right now,i will reply you with it later.basicly the problem i encounter is just like what you said.In my case,the automatic type conversion didn't work,cause when using shardingsphere in my project,the implementation of PreparedStatement was switched from PgPreparedStatement to ShardingSpherePreparedStatement,and the  PgPreparedStatement seems do all the type conversion if you see the source code while the ShardingSpherePreparedStatement don't
   I'm not sure if the JDBC driver or the PgSql server would do the type conversion like you said,I'll give you the stacktrace i got.
    
   
   
   1814788049
   ***@***.***
   
   
   
    
   
   
   
   
   ------------------ 原始邮件 ------------------
   发件人: ***@***.***>; 
   发送时间: 2022年5月17日(星期二) 中午11:26
   收件人: ***@***.***>; 
   抄送: ***@***.***>; ***@***.***>; 
   主题: Re: [apache/shardingsphere] to consider the sqlType of value parameter when setting the value to the corresponding placeholder in a executing SQL (Issue #15134)
   
   
   
   
   
    
   Hi @dissdic
    Could you provide more details about your issue?
    Database like PostgreSQL will handle the type conversion on server side, which means user can provide string as value no matter what the column's type is. And the JDBC Driver may handle the type conversion stuff implicitly.
    
   —
   Reply to this email directly, view it on GitHub, or unsubscribe.
   You are receiving this because you were mentioned.Message ID: ***@***.***>


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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