René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"named binding is not supported by jasync driver","articleBody":"Hi I am hitting the above error when my program execute to this:\r\n```\r\nimport org.springframework.beans.factory.annotation.Qualifier;\r\nimport org.springframework.data.r2dbc.repository.Query;\r\nimport org.springframework.data.r2dbc.repository.R2dbcRepository;\r\nimport reactor.core.publisher.Flux;\r\n\r\n@Qualifier(\"dftConnectionFactory\")\r\npublic interface DTFBillRepo extends R2dbcRepository\u003cBill, BillPk\u003e {\r\n    \r\n    @Query(\"\"\"\r\n        select * from Bill where CAST(Bill_Time AS DATE) = CAST(:targetDate AS DATE)\r\n        \"\"\")\r\n    Flux\u003cBill\u003e findByBillTimeOn(String targetDate);\r\n    \r\n    Flux\u003cBill\u003e findBillByStoreNo(String storeNo);\r\n    \r\n}\r\n\r\n```\r\n\r\nThe Error:\r\n```\r\n2024-09-06T20:34:14.479+08:00 ERROR 32780 --- [evois] [onPool-worker-1] a.w.r.e.AbstractErrorWebExceptionHandler : [eb4d9693-1]  500 Server Error for HTTP POST \"/api/1.0/dtf/bill\"\r\n\r\njava.lang.UnsupportedOperationException: named binding is not supported by jasync driver P0_targetDate=2024-09-05T10:12:35.342\r\n\tat com.github.jasync.r2dbc.mysql.JasyncStatement.bind(JasyncStatement.kt:65) ~[jasync-r2dbc-mysql-2.2.4.jar:na]\r\n\tSuppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException:\r\nError has been observed at the following site(s):\r\n\t*__checkpoint ⇢ Handler com.efixion.evois.dtf.api.DtfController#billTransfer(BillTransferDto) [DispatcherHandler]\r\n\t*__checkpoint ⇢ HTTP POST \"/api/1.0/dtf/bill\" [ExceptionHandlingWebHandler]\r\nOriginal Stack Trace:\r\n\t\tat com.github.jasync.r2dbc.mysql.JasyncStatement.bind(JasyncStatement.kt:65) ~[jasync-r2dbc-mysql-2.2.4.jar:na]\r\n\t\tat org.springframework.r2dbc.core.DefaultDatabaseClient$StatementWrapper.bind(DefaultDatabaseClient.java:581) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat org.springframework.r2dbc.core.binding.NamedBindMarkers$NamedBindMarker.bind(NamedBindMarkers.java:102) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat org.springframework.data.r2dbc.core.NamedParameterUtils$ExpandedQuery.bind(NamedParameterUtils.java:534) ~[spring-data-r2dbc-3.3.3.jar:3.3.3]\r\n\t\tat org.springframework.data.r2dbc.core.NamedParameterUtils$ExpandedQuery.bindTo(NamedParameterUtils.java:601) ~[spring-data-r2dbc-3.3.3.jar:3.3.3]\r\n\t\tat org.springframework.data.r2dbc.repository.query.StringBasedR2dbcQuery$ExpandedQuery.bindTo(StringBasedR2dbcQuery.java:219) ~[spring-data-r2dbc-3.3.3.jar:3.3.3]\r\n\t\tat org.springframework.r2dbc.core.DefaultDatabaseClient$DefaultGenericExecuteSpec.lambda$getResultFunction$9(DefaultDatabaseClient.java:394) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat org.springframework.r2dbc.core.ResultFunction.apply(ResultFunction.java:64) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat org.springframework.r2dbc.core.DefaultFetchSpec.lambda$all$1(DefaultFetchSpec.java:77) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat org.springframework.r2dbc.core.DelegateConnectionFunction.apply(DelegateConnectionFunction.java:48) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat org.springframework.r2dbc.core.DelegateConnectionFunction.apply(DelegateConnectionFunction.java:33) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat org.springframework.r2dbc.core.DefaultDatabaseClient.lambda$inConnectionMany$6(DefaultDatabaseClient.java:147) ~[spring-r2dbc-6.1.12.jar:6.1.12]\r\n\t\tat reactor.core.publisher.FluxUsingWhen.deriveFluxFromResource(FluxUsingWhen.java:122) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.FluxUsingWhen.access$000(FluxUsingWhen.java:53) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.FluxUsingWhen$ResourceSubscriber.onNext(FluxUsingWhen.java:195) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.onNext(FluxMap.java:122) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onNext(FluxOnErrorResume.java:79) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onNext(FluxOnErrorResume.java:79) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.onNext(FluxMap.java:122) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.MonoCompletionStage$MonoCompletionStageSubscription.apply(MonoCompletionStage.java:121) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat reactor.core.publisher.MonoCompletionStage$MonoCompletionStageSubscription.apply(MonoCompletionStage.java:67) ~[reactor-core-3.6.9.jar:3.6.9]\r\n\t\tat java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:934) ~[na:na]\r\n\t\tat java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:911) ~[na:na]\r\n\t\tat java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:510) ~[na:na]\r\n\t\tat java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2179) ~[na:na]\r\n\t\tat com.github.jasync.sql.db.util.FutureUtilsKt.success(FutureUtils.kt:16) ~[jasync-pool-2.2.4.jar:na]\r\n\t\tat com.github.jasync.sql.db.mysql.MySQLConnection.onOk(MySQLConnection.kt:225) ~[jasync-mysql-2.2.4.jar:na]\r\n\t\tat com.github.jasync.sql.db.mysql.codec.MySQLConnectionHandler.channelRead0(MySQLConnectionHandler.kt:124) ~[jasync-mysql-2.2.4.jar:na]\r\n\t\tat io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:99) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) ~[netty-codec-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) ~[netty-codec-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1407) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:918) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562) ~[netty-transport-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:994) ~[netty-common-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.112.Final.jar:4.1.112.Final]\r\n\t\tat java.base/java.lang.Thread.run(Thread.java:1583) ~[na:na]\r\n```\r\n\r\n\r\n\r\nI am using \r\n```\r\n\u003cparent\u003e\r\n        \u003cgroupId\u003eorg.springframework.boot\u003c/groupId\u003e\r\n        \u003cartifactId\u003espring-boot-starter-parent\u003c/artifactId\u003e\r\n        \u003cversion\u003e3.3.3\u003c/version\u003e\r\n        \u003crelativePath/\u003e \u003c!-- lookup parent from repository --\u003e\r\n \u003c/parent\u003e\r\n \r\n\u003cdependency\u003e\r\n      \u003cgroupId\u003ecom.mysql\u003c/groupId\u003e\r\n      \u003cartifactId\u003emysql-connector-j\u003c/artifactId\u003e\r\n      \u003cscope\u003eruntime\u003c/scope\u003e\r\n  \u003c/dependency\u003e\r\n  \u003cdependency\u003e\r\n      \u003cgroupId\u003ecom.github.jasync-sql\u003c/groupId\u003e\r\n      \u003cartifactId\u003ejasync-r2dbc-mysql\u003c/artifactId\u003e\r\n      \u003cversion\u003e2.2.4\u003c/version\u003e\r\n  \u003c/dependency\u003e\r\n  \r\n```\r\n\r\nDoes anyone know why the name binding is not working ?\r\n\r\nTQIA","author":{"url":"https://github.com/juzweb","@type":"Person","name":"juzweb"},"datePublished":"2024-09-06T12:42:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/425/jasync-sql/issues/425"}