server 1.1.54289 jdbc 1.3 insert data about clickhouse-native-jdbc HOT 6 CLOSED

yes，it's releasing...

from clickhouse-native-jdbc.

Could u please show us the code? So we can reproduce and look into this problem

from clickhouse-native-jdbc.

ok ,

create table:
CREATE TABLE all_test(
url String,
host String,
topDomain String,
ipaddr String,
country String,
province String,
area String,
ispID String,
audioVideoType UInt8,
euAccessDate Date,
euAccessTime UInt64
)
ENGINE = MergeTree(euAccessDate, (host,topDomain,audioVideoType), 8192);

java code :

Class.forName("com.github.housepower.jdbc.ClickHouseDriver");
Connection connection = DriverManager.getConnection("jdbc:clickhouse://localhost:9000","default","lyd.ai");
Statement stmt = connection.createStatement();
PreparedStatement pstmt = connection.prepareStatement("INSERT INTO all_test VALUES(?, ?, ?,?,?,?,?,?,?,?,?)");
for (int i = 0; i < 10; i++) {
pstmt.setString(1, "www.baidu.com/tt/t.q");
pstmt.setString(2, "www.baidu.com");
pstmt.setString(3, "baidu.com");
pstmt.setString(4, "127.0.0.1");
pstmt.setString(5, "**");
pstmt.setString(6, "北京");
pstmt.setString(7, "北京");
pstmt.setString(8, "电信");
pstmt.setByte(9, (byte)0);
pstmt.setDate(10, java.sql.Date.valueOf("2005-12-12"));
pstmt.setLong(11, 2018080912);
pstmt.addBatch();
}
pstmt.executeBatch();

from clickhouse-native-jdbc.

Thanks for your feedback. We mistake the Chinese String size , fixed

from clickhouse-native-jdbc.

Is it the latest in maven repository ？

from clickhouse-native-jdbc.

V1.4-stable is on the maven central.

https://mvnrepository.com/artifact/com.github.housepower/clickhouse-native-jdbc/1.4-stable

from clickhouse-native-jdbc.