Sfrgttk

Does "he squandered his car on drink" sound natural?

"It doesn't matter" or "it won't matter"?

Giving feedback to someone without sounding prejudiced

The IT department bottlenecks progress, how should I handle this?

Mimic lecturing on blackboard, facing audience

Can I cause damage to electrical appliances by unplugging them when they are turned on?

Does the reader need to like the PoV character?

Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size?

Is there a RAID 0 Equivalent for RAM?

Why is the Sun approximated as a black body at ~ 5800 K?

Is this toilet slogan correct usage of the English language?

What (the heck) is a Super Worm Equinox Moon?

The Digit Triangles

When were female captains banned from Starfleet?

Stack Interview Code methods made from class Node and Smart Pointers

What is the English pronunciation of "pain au chocolat"?

Are Captain Marvel's powers affected by Thanos breaking the Tesseract and claiming the stone?

What does "Scientists rise up against statistical significance" mean? (Comment in Nature)

C++ check if statement can be evaluated constexpr

What fields between the rationals and the reals allow a good notion of 2D distance?

15% tax on $7.5k earnings. Is that right?

How could a planet have erratic days?

Taxes on Dividends in a Roth IRA

What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?

JDBC: pooled connection not seeing new row

Cannot update certain rows in innodb tablesjdbc: does setAutoCommit(true) commits past executions?JDBC connection error for SQL Server Databasejdbc connection string ORACLE , integrated securityJDBC local MSSQL Server connection stringMysql InnoDB vs Mongodb write performanceTomcat7 JDBC connection pool -> Connection has been abandonedPostgresql on AWS RDS JDBC Connection Refused, psql connection succeeedsWhat is the new JDBC 4.3 Connection Request feature with `beginRequest` & `endRequest` methods?What if a connection closes in the middle of a commit?

0

The problem here is easy to reproduce:

1) First a request creates a row. The front-end receives the row-ID.

2) Then another request is sent to read the row's data using the ID (like 200 ms
later).

3) There is no such row!!!

The architecture is for a high-throughput financial exchange. Many many orders per second need to be inserted into the DB. The implementation is in Java 8.

Each request-thread owns an open connection, inside a wrapper that stores some cached PreparedStatements as well. All specific for the application, that is why we're not using a regular pool.

All connections are kept in the transaction mode (autocommit=false) as 90% of the requests will end executing a transaction. Autocommit remains FALSE forever after creating the connection. "Selects" also use this connection.

Then each use of the connection uses the regular 'commit()' or 'rollback()' in the end. Selects do not call them. Only updates or inserts.

For the problem I'm seeing:

I found a "fix" that is to call 'commit()' or 'rollback()' before using the connection. By doing this, the data visible to the connection seems to be refreshed and it works fine. By the way, the tx-level is the default for Amazon Aurora MySQL, REPEATABLE_READ.

I have seen the existence of beginRequest() and endRequest() methods but their documentation got me a little bit confused.

My question is: is this the expected behaviour? What's the most performant approach to handle this? How to indicate to a connection that we want it to see refreshed data from DB?

Thanks

mysql jdbc aws-aurora auto-commit

share

asked 5 mins ago

Ernani SottomaiorErnani Sottomaior

1

New contributor

Ernani Sottomaior is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

The problem here is easy to reproduce:

1) First a request creates a row. The front-end receives the row-ID.

2) Then another request is sent to read the row's data using the ID (like 200 ms
later).

3) There is no such row!!!

The architecture is for a high-throughput financial exchange. Many many orders per second need to be inserted into the DB. The implementation is in Java 8.

Each request-thread owns an open connection, inside a wrapper that stores some cached PreparedStatements as well. All specific for the application, that is why we're not using a regular pool.

All connections are kept in the transaction mode (autocommit=false) as 90% of the requests will end executing a transaction. Autocommit remains FALSE forever after creating the connection. "Selects" also use this connection.

Then each use of the connection uses the regular 'commit()' or 'rollback()' in the end. Selects do not call them. Only updates or inserts.

For the problem I'm seeing:

I found a "fix" that is to call 'commit()' or 'rollback()' before using the connection. By doing this, the data visible to the connection seems to be refreshed and it works fine. By the way, the tx-level is the default for Amazon Aurora MySQL, REPEATABLE_READ.

I have seen the existence of beginRequest() and endRequest() methods but their documentation got me a little bit confused.

My question is: is this the expected behaviour? What's the most performant approach to handle this? How to indicate to a connection that we want it to see refreshed data from DB?

Thanks

mysql jdbc aws-aurora auto-commit

share

asked 5 mins ago

Ernani SottomaiorErnani Sottomaior

1

New contributor

Ernani Sottomaior is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

The problem here is easy to reproduce:

1) First a request creates a row. The front-end receives the row-ID.

2) Then another request is sent to read the row's data using the ID (like 200 ms
later).

3) There is no such row!!!

The architecture is for a high-throughput financial exchange. Many many orders per second need to be inserted into the DB. The implementation is in Java 8.

Each request-thread owns an open connection, inside a wrapper that stores some cached PreparedStatements as well. All specific for the application, that is why we're not using a regular pool.

All connections are kept in the transaction mode (autocommit=false) as 90% of the requests will end executing a transaction. Autocommit remains FALSE forever after creating the connection. "Selects" also use this connection.

Then each use of the connection uses the regular 'commit()' or 'rollback()' in the end. Selects do not call them. Only updates or inserts.

For the problem I'm seeing:

I found a "fix" that is to call 'commit()' or 'rollback()' before using the connection. By doing this, the data visible to the connection seems to be refreshed and it works fine. By the way, the tx-level is the default for Amazon Aurora MySQL, REPEATABLE_READ.

I have seen the existence of beginRequest() and endRequest() methods but their documentation got me a little bit confused.

My question is: is this the expected behaviour? What's the most performant approach to handle this? How to indicate to a connection that we want it to see refreshed data from DB?

Thanks

mysql jdbc aws-aurora auto-commit

share

asked 5 mins ago

Ernani SottomaiorErnani Sottomaior

1

New contributor

Ernani Sottomaior is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

Ernani SottomaiorErnani Sottomaior

1

New contributor

Ernani Sottomaior is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

Ernani SottomaiorErnani Sottomaior

1

New contributor

Ernani Sottomaior is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Ernani SottomaiorErnani Sottomaior

1

New contributor

Ernani Sottomaior is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Ernani SottomaiorErnani Sottomaior

1