kohlersDagger commented on issue #2217:
URL: https://github.com/apache/iotdb/issues/2217#issuecomment-740551516
Yes i use the same IoTDB settings and jar , except
`waiting_time_when_insert_blocked` and `max_waiting_time_when_insert_blocked` .
Iotdb server runs in the docker container , the memory size is 8G while
running .
The Java program uses the spring boot wIth JDBC framework, and the
connection pool configuration is as follows:
```
spring:
datasource:
driverClassName: org.apache.iotdb.jdbc.IoTDBDriver
url: jdbc:iotdb://x:x:x:x:6667/
username: root
password: root
hikari:
maximum-pool-size: 16
idle-timeout: 60000
connection-timeout: 10000
max-lifetime: 3600000
pool-name: IoTDB-Pool
```
As for data access layer , the general code logic is as follows :
```
@Autowired
private DataSource dataSource;
public void writeIoTDB(String sql) throws SQLException {
Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
statement.close();
connection.close();
}
```
what's more , `@Async` is used to improve efficiency .
That's all the details.
-------
I plan to reproduce this with a new iotdb of the same version & same jdbc .
this may take a while .
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
