Java async database driver for MySQL and PostgreSQL written in Kotlin: https://github.com/jasync-sql/jasync-sql
Questions tagged [jasync-sql]
12 questions
2
votes
1 answer
Why Mysql INT(10) unsigned column to row.getLong throws exception in jasync-sql
INT(10) unsigned in mysql has limit up to 4b+ and when use with getLong of row, it throws the following error:
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long
at…
oshai
- 14,865
- 26
- 84
- 140
1
vote
0 answers
Spring boot 2.7 webflux r2dbc use jasync-r2dbc-mysql
When I upgrade my project from spring boot 2.6.6 to 2.7.0, use r2dbc will got the error like this:
2022-06-16 12:40:51.655 [][][ERROR][][db-sql-netty-thread-2] - Operator called default onErrorDropped
java.lang.AbstractMethodError: Method…
J. Hu
- 53
- 8
1
vote
0 answers
Extracting data from a JOOQ query when using Jasync
When using JOOQ to create the queries and Jasync to execute the queries, how does one get the RowData back into JOOQ Records?
This is my notransaction helper which does a suspendable non-async query
override suspend fun notransaction(f:…
Jan Vladimir Mostert
- 12,380
- 15
- 80
- 137
1
vote
1 answer
Connection timed out when no query running
I am using vertx.io 3.6.3 and jasync-sql v 1.1.13 for mysql as lib to manage data persistence, The query at QA Env is fine but sometime I receive error message from lib like that…
Trong Tran
- 21
- 5
1
vote
1 answer
How to close Jasync Postgresql connection when not in use
Here's the docs of the management of the connection pool, and looks like maxIdleTime property is responsible for closing the connection. But unfortunately every 4-5 second 3 debug message still comes with some weird title testAvailableItems.
Here is…
Animesh Sahu
- 7,445
- 2
- 21
- 49
1
vote
1 answer
Jasync vertx library connection pool not working
I'm trying to use the com.github.jasync.sql.db library for vertx. I've provided the configuration and set the maxPoolSize to 200. However, during the load generation test; only 7 connections are made to the DB instead of 200
I am unsure what's going…
user782400
- 1,617
- 7
- 30
- 51
0
votes
1 answer
Micronaut jasync configuring SSL Mode Required fails
I'm trying to configure Micronaut SQL jasync with the following configuraiton:
jasync:
client:
host: myhost
port: 5432
database: mydb
username: myusername
password: mypassword
maxActiveConnections: 10
ssl:
mode:…
user16385390
- 1
- 1
0
votes
2 answers
Instantiating classes from non-reified type parameters
I'm building an ORM for use with jasync-sql in Kotlin and there's a fundamental problem that I can't solve. I think it boils down to:
How can one instantiate an instance of a class of type T, given a
non-reified type parameter T?
The well known…
HJCee
- 163
- 2
- 6
0
votes
1 answer
How to connect to Google Cloud SQL (MySQL) with jasync-sql?
I'm having a spring application with maven. I want to communicate with a cloud SQL MySQL database I have in GCP asynchronously.
I tried following the getting started code and wrote this:
Connection connection = MySQLConnectionBuilder
…
Diksha
- 1
0
votes
1 answer
Class not found for inline method - what can cause that?
I am getting an error with the following stacktrace:
java.lang.NoClassDefFoundError: com/github/jasync/sql/db/ConcreteConnectionBase$flatten$$inlined$mapTry$1
at…
oshai
- 14,865
- 26
- 84
- 140
0
votes
1 answer
Error when executing query with jasync-sql: "Can't run query because there is one query pending already"
We're currently using jasync-sql PostgreSQL async library in a Ktor service and we're getting:
14:02:20.005 [DefaultDispatcher-worker-1] ERROR com.github.jasync.sql.db.postgresql.PostgreSQLConnection - Can't run query because there is one query…
oshai
- 14,865
- 26
- 84
- 140
-1
votes
2 answers
Query for specific columns sqlalchemy
I have the table soldiers:
class Soldier(Base):
__tablename__ = "soldiers"
id = Column(String(36), default=lambda: str(uuid4()), primary_key=True, unique=True)
name = Column(String(50), nullable=False)
service_number =…
Lee Skies
- 31
- 6