# test-mybatis-one-to-many-insert-update-delete

**Repository Path**: rox2k/test-mybatis-one-to-many-insert-update-delete

## Basic Information

- **Project Name**: test-mybatis-one-to-many-insert-update-delete
- **Description**: mybatis one-to-many insert update and delete test
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2020-03-04
- **Last Updated**: 2021-06-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# test-mybatis-one-to-many-insert

## Configuration

```datasource.properties``` is to define datasource properties.
Each set should have unique prefix.

```ini
# HSQLDB
hsqldb.driver=org.hsqldb.jdbcDriver
hsqldb.url=jdbc:hsqldb:mem:bulkinsert
hsqldb.username=sa
hsqldb.password=

# PostgreSQL
postgresql.driver=org.postgresql.Driver
postgresql.url=jdbc:postgresql:bulkinsert
postgresql.username=bulkinsert
postgresql.password=

# Oracle
oracle.driver=oracle.jdbc.driver.OracleDriver
oracle.url=jdbc:oracle:thin:@192.168.57.101:1521:ORCL
oracle.username=bulkinsert
oracle.password=bulkinsert
```

In ```BulkInsertTestBase.java```, you can configure basic runtime parameters.

```java
// the number of rows to insert
protected static final int numOfRows = 10;
// which datasource setting to use
private static final String propertyPrefix = "mysql";
```



## Ref

- [mybatis-inserts-one-to-many-relationship](https://stackoverflow.com/questions/33028923/mybatis-inserts-one-to-many-relationship) 
- [mybatis-bulk-insert](https://github.com/harawata/mybatis-bulk-insert).