[sqlite] SQLite with Eclipse BIRT?

This may be way off-topic (or really a BIRT bug), but I'm trying to use eclipse BIRT to create a report off a sqlite DB: 1) add jni dll path to eclipse startup parameters 2) setup sqlite driver in BIRT data sources 3) create new report datasource pointing to existing sqlite DB and test connection

RE: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

Christian, I understand Windows is poor, but I do not fully understand the compilation process. The mkopc3.exe is actually created- so this itself cannot be the problem. Not having awk doesn't seem to be an issue for compiling the 3.2.1-based driver either (see 1). Sorry, I'm confused :( Andi

RE: [sqlite] Compiling Sqlite JDBC driver (Compiler question)

After I've been able to overcome the initial compiler problem (missing library installation), I'm faced with a new one: 1) Compiling JDBC wrapper for 3.2.1 works fine 2) Compiling JDBC wrapper for 3.3.5 fails: cl -Gs -EHsc -D_WIN32 -nologo -Zi -DOS_WIN=1 -D_CRT_SECURE_NO_DEPRECATE -DNDEBUG=1

[sqlite] Compiling Sqlite JDBC driver (Compiler question)

Hello, I hope this isn't too off-topic, really more a compiler question than SQLITE. I'm trying to compile Christian Werner's Sqlite JDBC driver under WinXP using Platform SDK and VS2005. This process breaks with the follwing error message: Microsoft (R) Program Maintenance Utility Version

RE: [sqlite] Error message: too much SQL parameters

You're right- found the limiting DEFINE in the JDBC driver sources- thanks! Andi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. Mai 2006 15:38 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Error message: too much SQL parameters <[EMAIL

RE: [sqlite] SQLite wrapper Java Linux: No suitable driver

Make sure the sqlite_jni.dll DLL is in your path! Andi -Original Message- From: Pasquale Imbemba [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. Mai 2006 18:41 To: SQLite Subject: [sqlite] SQLite wrapper Java Linux: No suitable driver Hi, I am using the sqlite wrapper by Christian

RE: [sqlite] Possible bug with non-standard characters in column names

Not sure- I've tried this through JDBC and the command line client, I'm not a developer at that level :( Thanks, Andreas -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. Mai 2006 18:42 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Possible bug

[sqlite] Error message: too much SQL parameters

I'm inserting into a table with 71 columns, trying to populate all columns in one (prepared) statement with JDBC. I'm receiving this error message: SQLITE.Exception: too much SQL parameters. Any ideas? Thanks, Andi This message is for the designated recipient only and may contain privileged,

[sqlite] Possible bug with non-standard characters in column names

Creating a table like this: CREATE TABLE test1 (loader_id INTEGER PRIMARY KEY, loader_status VARCHAR(255)); ALTER TABLE test1 ADD name VARCHAR(255); ALTER TABLE test1 ADD straße VARCHAR(255); ALTER TABLE test1 ADD plz VARCHAR(255); Raises an SQL error: malformed database schema - near "plz":