Birt Eclipse,通过 ODBC 连接到 SQLite 数据库? Birt 需要使用特定的 JDBC 驱动程序吗?
我已经在这方面工作了一段时间,不幸的是以前很少接触 Birt 以及 JDBC / ODBC。我一直在搜索,但无法最终弄清楚 Birt 需要什么才能通过 ODBC 连接到 SQLite 数据库。
我已在 Windows 计算机上设置 SQLit 数据库以使用 ODBC。然而,从这里我无法弄清楚,在 Birt Report Designer->新数据源->我应该放入 JDBC 数据源来访问数据库。
我是否需要为此安装特定的驱动程序以用作“驱动程序类”
我的 ODBC / SQLite 数据库的路径是“驱动程序 URL”字段吗?
我将非常感谢对此的任何建议。
I have been working on this for a while now and, unfortunately have little previous exposure to Birt as well as JDBC / ODBC. I've been searching and searching but can't conclusively figure out what I need for Birt to be able to connect to an SQLite database through ODBC.
I have setup the SQLit db on my windows machine to use ODBC. From here, however, I can't figure out, in the Birt Report Designer-> New data source-> JDBC data source what I am supposed to put in in order to access the DB.
Do I need a specific driver for this that I need to install to use as the "Driver Class"
Is the path to my ODBC / SQLite db the "Driver URL" field?
I would greatly appreciate any advice on this.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
有一个专门用于 SQLite 的 JDBC 驱动程序,因此您不必使用桥接器。
URL 应该是:
类是
org.sqlite.JDBC
。There is a JDBC driver specifically for SQLite, so you don't have to use a bridge.
The URL should be:
The class is
org.sqlite.JDBC
.正如最初的答案所指出的,您可以下载 SQLite JDBC 驱动程序。下载后,您需要将 JAR 正确部署到 BIRT 中,以便驱动程序在 eclipse 设计器中可用。放入 JAR:
一旦 JAR 存在,重新启动 Eclipse/BIRT,您应该能够非常轻松地创建 SQLite 数据源。
祝你好运!
As the initial answer points out, you can download the SQLite JDBC driver. Once downloaded, you need to correctly deploy the JAR into BIRT so the driver will be available in the eclipse designer. Put the JAR in:
Once the JAR is there, re-start Eclipse/BIRT and you should be able to create a SQLite data source pretty easily.
Good Luck!