TDengine icon indicating copy to clipboard operation
TDengine copied to clipboard

Windows10 TD3.0 connect failed

Open steven-design opened this issue 3 years ago • 6 comments

Bug Description Windows10 TD3.0,通过Java jdbc连接数据库失败

To Reproduce Steps to reproduce the behavior:

  1. 配置本机host 127.0.0.1 td1
  2. java spring boot程序数据库连接为:jdbc:TAOS://td1:6030?user=root&password=taosdata
  3. 参考示例代码: https://github.com/taosdata/TDengine/blob/3.0/docs/examples/java/src/main/java/com/taos/example/JNIConnectExample.java
  4. 程序执行数据库连接报错如下: Exception in thread "main" java.lang.NoSuchMethodError: setByteArray at com.taosdata.jdbc.TSDBJNIConnector.initImp(Native Method) at com.taosdata.jdbc.TSDBJNIConnector.init(TSDBJNIConnector.java:43) at com.taosdata.jdbc.TSDBDriver.connect(TSDBDriver.java:162) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270)

Expected Behavior 连接数据库正常

Screenshots Exception in thread "main" java.lang.NoSuchMethodError: setByteArray at com.taosdata.jdbc.TSDBJNIConnector.initImp(Native Method) at com.taosdata.jdbc.TSDBJNIConnector.init(TSDBJNIConnector.java:43) at com.taosdata.jdbc.TSDBDriver.connect(TSDBDriver.java:162) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270)

Environment (please complete the following information):

  • OS: [Windows10 家庭版]
  • Memory 16G, CPU i5 八核, current Disk Space 1T
  • TDengine Version [3.0.1 windowsServer版]

Additional Context Add any other context about the problem here.

steven-design avatar Sep 05 '22 08:09 steven-design

we will check on this

yu285 avatar Sep 12 '22 06:09 yu285

Is there any result on this problem how we can solve it. I have the same problem...

Mark916 avatar Sep 19 '22 03:09 Mark916

Please also update source code example for 3.0* version.We had a lot of trouble running Demo

Mark916 avatar Sep 19 '22 03:09 Mark916

I have the same problem... how should i solve this problem ?

zeweilin avatar Sep 20 '22 03:09 zeweilin

what is the JDBC version we used ?

it should be 3.0.0 , please confirm this ~

yu285 avatar Sep 20 '22 03:09 yu285

I guess it is an authority problem for a Windows user.

There is a taos.dll under C:\TDengine\driver ,please copy it to C:\Windows\System32 ,if it already existed just overwrite it

yu285 avatar Sep 20 '22 08:09 yu285

I try to copy C:\TDengine\driver\taos.dll to C:\Windows\System32, JDBC version set 3.0.0 but, the problem remains.

steven-design avatar Sep 22 '22 02:09 steven-design

解决了的话踢我一下

dafuge avatar Sep 27 '22 03:09 dafuge

I guess it is an authority problem for a Windows user.

There is a taos.dll under C:\TDengine\driver ,please copy it to C:\Windows\System32 ,if it already existed just overwrite it

对我有效,点赞

zeje avatar Oct 01 '22 08:10 zeje

同样遇到了此问题,移动了dll文件,但是仍未解决: java.lang.NoSuchMethodError: setByteArray at com.taosdata.jdbc.TSDBJNIConnector.initImp(Native Method) ~[taos-jdbcdriver-3.0.0.jar:na] at com.taosdata.jdbc.TSDBJNIConnector.init(TSDBJNIConnector.java:43) ~[taos-jdbcdriver-3.0.0.jar:na] at com.taosdata.jdbc.TSDBDriver.connect(TSDBDriver.java:162) ~[taos-jdbcdriver-3.0.0.jar:na] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1643) ~[druid-1.2.11.jar:1.2.11] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1709) ~[druid-1.2.11.jar:1.2.11] at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2813) ~[druid-1.2.11.jar:1.2.11]

Loadhao avatar Dec 06 '22 08:12 Loadhao

同样遇到了此问题,移动了dll文件,但是仍未解决: java.lang.NoSuchMethodError: setByteArray at com.taosdata.jdbc.TSDBJNIConnector.initImp(Native Method) ~[taos-jdbcdriver-3.0.0.jar:na] at com.taosdata.jdbc.TSDBJNIConnector.init(TSDBJNIConnector.java:43) ~[taos-jdbcdriver-3.0.0.jar:na] at com.taosdata.jdbc.TSDBDriver.connect(TSDBDriver.java:162) ~[taos-jdbcdriver-3.0.0.jar:na] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1643) ~[druid-1.2.11.jar:1.2.11] at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1709) ~[druid-1.2.11.jar:1.2.11] at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2813) ~[druid-1.2.11.jar:1.2.11]

可以加微信 a15652223354做具体排查

yu285 avatar Dec 06 '22 09:12 yu285

dafuge

I try to copy C:\TDengine\driver\taos.dll to C:\Windows\System32, JDBC version set 3.0.0 but, the problem remains.

可以加微信 a15652223354做具体排查

yu285 avatar Dec 06 '22 09:12 yu285

解决了的话踢我一下

可以加微信 a15652223354做具体排查

yu285 avatar Dec 06 '22 09:12 yu285