Birt Eclipse,通过ODBC连接到SQLite数据库?我需要特定的JDBC驱动程序供Birt使用吗? [英] Birt Eclipse, connecting to a SQLite database through ODBC? Do I need a specific JDBC driver for Birt to use?
问题描述
我已经为此工作了一段时间,不幸的是,以前很少接触Birt以及JDBC/ODBC.我一直在搜索,但无法最终确定Birt能够通过ODBC连接到SQLite数据库所需的内容.
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.
我已经在Windows计算机上设置了SQLit数据库以使用ODBC.但是,从这里,我无法弄清楚在Birt Report Designer中-> New data source-> JDBC数据源应该放置什么以便访问数据库.
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"
我的ODBC/SQLite数据库的路径是否为驱动程序URL"字段?
Is the path to my ODBC / SQLite db the "Driver URL" field?
非常感谢您提出任何建议.
I would greatly appreciate any advice on this.
推荐答案
有一个 JDBC驱动程序专门用于SQLite,因此您不必使用网桥.
There is a JDBC driver specifically for SQLite, so you don't have to use a bridge.
URL应为:
jdbc:sqlite:/path/to/my.db
班级是org.sqlite.JDBC
.
这篇关于Birt Eclipse,通过ODBC连接到SQLite数据库?我需要特定的JDBC驱动程序供Birt使用吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!