gpt4 book ai didi

java - 在 Java NoInitialContextException 中使用 SQLite 的 sql2o

转载 作者:行者123 更新时间:2023-11-29 04:37:21 32 4
gpt4 key购买 nike

到目前为止,我得到了以下代码片段:

Sql2o sql2o = new Sql2o("jdbc:sqlite:test.db");

try (Connection connection = sql2o.open()) {
for (Column column : connection.createQuery("SELECT * FROM sometable").executeAndFetchTable().columns())
System.out.println(column.toString());
}

我正在使用这些依赖项:

<dependency>
<groupId>org.sql2o</groupId>
<artifactId>sql2o</artifactId>
<version>1.5.4</version>
</dependency>
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.15.1</version>
</dependency>

但是,这会在执行时抛出 NoInitialContextException。堆栈跟踪:

Exception in thread "main" java.lang.RuntimeException: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
at org.sql2o.JndiDataSource.getJndiDatasource(JndiDataSource.java:27)
at org.sql2o.Sql2o.<init>(Sql2o.java:36)
at me.mypackage.sqlitetest.SqliteTest.main(SqliteTest.java:11)
Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.lookup(Unknown Source)
at org.sql2o.JndiDataSource.getJndiDatasource(JndiDataSource.java:24)
... 2 more

我该如何解决这个问题?

最佳答案

尝试替换这一行

Sql2o sql2o = new Sql2o("jdbc:sqlite:test.db");

Sql2o sql2o = new Sql2o("jdbc:sqlite:test.db", null, null);

Sql2o类有一个只接受单个字符串的构造函数,但是该单个字符串是 JNDI 名称,而不是 JDBC 连接 URL。还有另一个构造函数接受三个字符串,用于连接 URL、用户名和密码。 SQLite 不使用用户名和密码,因此我们可以为它们指定 null 值。

关于java - 在 Java NoInitialContextException 中使用 SQLite 的 sql2o,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/40752052/

32 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com