jdbc连接不上
private static final String URL = "jdbc:gbasedbt-sqli://localhost:9091:GBASEDBTSERVER=gbase01;user=gbasedbt;password=20250723";
gbasedbt@gbase01:/home/user/gbasetest$ java -cp .:gbasedbtjdbc_3.6.3_2_561324.jar g8sLargeFileMultiThreadTest
java.sql.SQLException: Incorrect password or user com.gbasedbt.asf.IfxASFRemoteException: gbasedbt@gbase01 is not known on the database server.
at com.gbasedbt.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1481)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.gbasedbt.jdbc.Driver.connect(Driver.java:267)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
at g8sLargeFileMultiThreadTest.main(g8sLargeFileMultiThreadTest.java:27)
Caused by: com.gbasedbt.asf.IfxASFRemoteException: gbasedbt@gbase01
at com.gbasedbt.asf.Connection.recvConnectionResponse(Connection.java:811)
at com.gbasedbt.asf.Connection.establishConnection(Connection.java:1753)
at com.gbasedbt.asf.Connection.<init>(Connection.java:539)
at com.gbasedbt.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1376)
... 8 more
连不上啊，在dbaccess里面可以看到是有gbasedbt这个用户的，然后节点我命名为gbase01，可以确定密码是对的，怎么解决呢
评论
https://8s.gbasedbt.com/?file=05_%E5%BA%94%E7%94%A8%E7%A8%8B%E5%BA%8F%E5%BC%80%E5%8F%91/051_JDBC%E9%A9%B1%E5%8A%A8%E5%BA%94%E7%94%A8%E7%A4%BA%E4%BE%8B
gbasedbt@gbase01:/home/user/gbasetest$ javac -cp .:gbasedbtjdbc_3.6.3_2_561324.jar JdbcSample.java
java -cp .:gbasedbtjdbc_3.6.3_2_561324.jar JdbcSample
Exception in thread "main" java.sql.SQLException: 密码错误或用户 com.gbasedbt.asf.IfxASFRemoteException: gbasedbt@gbase01 在数据库服务器上未知。
at com.gbasedbt.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1481)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.gbasedbt.jdbc.Driver.connect(Driver.java:267)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at JdbcSample.main(JdbcSample.java:15)
Caused by: com.gbasedbt.asf.IfxASFRemoteException: gbasedbt@gbase01
at com.gbasedbt.asf.Connection.recvConnectionResponse(Connection.java:811)
at com.gbasedbt.asf.Connection.establishConnection(Connection.java:1753)
at com.gbasedbt.asf.Connection.(Connection.java:539)
at com.gbasedbt.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1376)
... 8 more
> database testdb;
Database selected.
Elapsed time: 0.001 sec
> select * from sysusers;
username gbasedbt
usertype D
priority 9
password
defrole
1 row(s) retrieved.
Elapsed time: 0.002 sec
> GRANT CONNECT TO gbasedbt;
Permission granted.
Elapsed time: 0.001 sec
> exit;
Database closed.
dbaccess - -
connect to 'testdb@gbase01' user 'gbasedbt'
Your evaluation license will expire on 2026-06-24 00:00:00
> connect to 'testdb@gbase01' user 'gbasedbt';
ENTER PASSWORD:
951: Incorrect password or user gbasedbt@gbase01 is not known on the database server.
Error in line 1
Near character position 1
这个密码和linux用户密码不是一个吗，我用passwd改的密码也不行
重启下数据库
onmode -ky && oninit -vy
我是在data studio工具里点扩容后，数据库文件权限变了
热门帖子
- 12025-12-01浏览数：182759
- 22023-05-09浏览数：25052
- 42023-09-25浏览数：18521
- 52020-05-11浏览数：17526
private static final String URL = "jdbc:gbasedbt-sqli://localhost:9091/testdb:GBASEDBTSERVER=gbase01;user=gbasedbt;password=20250723";
返回同样的报错
gbasedbt@gbase01:/home/user/gbasetest$ java -cp .:gbasedbtjdbc_3.6.3_2_561324.jar g8sLargeFileMultiThreadTest
java.sql.SQLException: Incorrect password or user com.gbasedbt.asf.IfxASFRemoteException: gbasedbt@gbase01 is not known on the database server.
at com.gbasedbt.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1481)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.gbasedbt.jdbc.Driver.connect(Driver.java:267)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
at g8sLargeFileMultiThreadTest.main(g8sLargeFileMultiThreadTest.java:27)
Caused by: com.gbasedbt.asf.IfxASFRemoteException: gbasedbt@gbase01
at com.gbasedbt.asf.Connection.recvConnectionResponse(Connection.java:811)
at com.gbasedbt.asf.Connection.establishConnection(Connection.java:1753)
at com.gbasedbt.asf.Connection.(Connection.java:539)
at com.gbasedbt.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1376)
... 8 more