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屋！