FunDA (17) - Demonstration: Exceptions handling and Finalizers

As a tool library that can run safely, in order to ensure the security of occupied resources, support for exception handling and final clean-up is indispensable. FunDA's data stream, FDAPipeLine, generally starts by reading database data to form data sources. In order to ensure that every data source can be used safely, FunDA provides a post-pr ...

Posted by drakkon on Thu, 20 Dec 2018 13:24:04 -0800

java jdbc curd && learning document [translation]

jdbc tutorial https://www.tutorialspoint.com/jdbc/jdbc-sample-code.htm (English) http://www.yiibai.com/jdbc/jdbc-sample-code.html#article-start (Chinese) jdbc curd example http://www.codejava.net/java-se/jdbc/jdbc-tutorial-sql-insert-select-update-and-delete-examples (English) http://www.cnblogs.com/sbj-dawn/p/7111990.html (Chinese) 2 Crea ...

Posted by TwistedLogix on Thu, 20 Dec 2018 02:24:04 -0800

ssm project uses Mybatis dynamic splicing sql statements, the generated sql Chinese is displayed as??? Questions (Chinese parsing of configuration file sql statements)

Scene reappearance There is a table. Now we want to query whether a character field in the table contains some keywords. Example: there is a field tag in the table; now it is to determine whether the tag contains keywords, the number of keywords is uncertain, so we need to use dynamic sql statements to splice, and screen out tags that cont ...

Posted by alpinec on Wed, 19 Dec 2018 20:18:05 -0800

Resolution of mysql No operations allowed after connection closed connection exception

Spring Boot Multi-data Source Configuration and No Operation Allowed After Connected Closed Connection Anomaly Solution Recently, when the project went online, it encountered a weird bug. Let's start with my project configuration: Spring Booot + Spring MVC + Spring Data JPA + two MySql s That is, my project has multi ...

Posted by jswash on Tue, 18 Dec 2018 19:21:04 -0800

PICE(2):JDBCStreaming - gRPC-JDBC Service

In an akka-cluster environment, JDBC databases are separated from other nodes in the cluster from the point of view of data invocation. This is because the JDBC database is not distributed and does not have the transparency of node location. Therefore, JDBC database server must provide data manipulation through service mode. In this scenario, t ...

Posted by cr55dan on Tue, 18 Dec 2018 02:21:05 -0800

PICE (1): Programming In Clustered Environment - Programming Mode in Cluster Environment

First of all, I declare that the so-called programming mode in the title is a process control programming mode that I personally consider in the cluster environment of cross-node (jvm). It is conceived purely according to actual needs and has no theoretical support. In May, I shared some ideas about programming mode in cluster environment on sc ...

Posted by tryin_to_learn on Sat, 15 Dec 2018 18:06:04 -0800

Spring Cloud Spring Boot mybatis Distributed Microservice Cloud Architecture (25) Integration of MyBatis

Integrating MyBatis in Spring is not much to say. Spring Boot has been used extensively recently, so tidy up the steps of integrating MyBatis in Spring Boot. I searched Spring Boot's articles on integrating MyBatis, and the methods are old and cumbersome. After reviewing the documentation, we have actually supported simpler integration and use. ...

Posted by Frozenlight777 on Fri, 14 Dec 2018 06:21:03 -0800

Talk about fail fast of hikari and tomcat jdbc pool

order This paper mainly studies the fail fast of hikari and tomcat jdbc pool in the case of Midway database hanging. Experimental code @Test public void testDatabaseDownAndUp() throws SQLException, InterruptedException { LOGGER.info("begin to wait for database down and up"); for(int c=0;c<10;c++){ LOGGER.info("execute:"+(c+1)); ...

Posted by alan543 on Tue, 11 Dec 2018 03:18:06 -0800

Use of JDBC dbutils and c3p0 dbcp connection pool

1. jdbc:jdbc is a set of specifications (a set of interfaces) specified by oracle company.Driver: jdbc implementation class. Provided by database vendors.We can operate different databases through a set of specifications (polymorphism)jdbc role:Connect databaseSend sql statementProcessing result 2. jdbc operation steps:1. database and table2. ...

Posted by mark_and_co on Mon, 10 Dec 2018 16:33:05 -0800