java derby 用户安全_java-使用身份验证的Derby嵌入式数据库

默认情况下,Apache Derby嵌入式数据库不需要身份验证.我们可以在系统级别或数据库级别启用身份验证.我使用Java代码启用了系统级支持.

Properties p=System.getProperties();

p.put("derby.connection.requireAuthentication", "true");

然后,我尝试使用此连接URL创建数据库.

jdbc:derby:derbysample;create=true;user=root;password=root

当我运行这个

DriverManager.getConnection(connectionURL);

它创建数据库文件夹还会引发有关身份验证的错误吗？如何使用凭证创建数据库？

java.sql.SQLNonTransientConnectionException: Connection authentication

failure occurred. Reason: Invalid authentication.. at

org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown

Source) at

org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown

Source) at

org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)

at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown

Source) at

org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown

Source) at

org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown

Source) at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown

Source) at

org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown

Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown

Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown

Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown

Source) at

java.sql.DriverManager.getConnection(DriverManager.java:664) at

java.sql.DriverManager.getConnection(DriverManager.java:208) at

derbytest.DerbyTest.createConnection(DerbyTest.java:56) at

derbytest.DerbyTest.main(DerbyTest.java:39) Caused by: ERROR 08004:

Connection authentication failure occurred. Reason: Invalid

authentication.. at

org.apache.derby.iapi.error.StandardException.newException(Unknown

Source) at

org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown

Source) … 15 more

解决方法:

首先使用属性create = true指定要创建的数据库URL.

jdbc:derby:derbysample111;create=true

然后使用DriverManager获取连接.如果不存在,它将创建一个数据库.

conn = DriverManager.getConnection("jdbc:derby:derbysample111;create=true");

conn.setSchema("APP");

然后在derby中启用身份验证并设置用户和密码.它将设置数据库级别的身份验证.

Statement s = conn.createStatement();

s.executeUpdate("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(\n"

+ " 'derby.connection.requireAuthentication', 'true')");

s.executeUpdate("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(\n"

+ " 'derby.authentication.provider', 'BUILTIN')");

s.executeUpdate("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(\n"

+ " 'derby.user.root', '12345')");

s.executeUpdate("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(\n"

+ " 'derby.database.propertiesOnly', 'true')");

只需要设置一次.然后可以使用此URL访问您的数据库

jdbc:derby:derbysample111;create=true;user=root;password=12345

标签：derby,java

来源： https://codeday.me/bug/20191120/2040658.html