--- [EMAIL PROTECTED] wrote:
> I just downloaded your SQLiteJDBC driver, since it seems to be the
> only one that works with SQLGrinder. However, it fails to parse tables
> that contain a space in the name.
The actual exceptions with the java call stack would be helpful.
But try this anyway:
--- MetaData.java-orig 2007-07-24 14:04:13.000000000 -0400
+++ MetaData.java 2007-07-24 14:05:07.000000000 -0400
@@ -347,7 +347,7 @@
// the command "pragma table_info('tablename')" does not embed
// like a normal select statement so we must extract the information
// and then build a resultset from unioned select statements
- rs = stat.executeQuery("pragma table_info ("+tbl+");");
+ rs = stat.executeQuery("pragma table_info('"+escape(tbl)+"');");
boolean colFound = false;
for (int i=0; rs.next(); i++) {
@@ -424,7 +424,7 @@
ResultSet rs;
Statement stat = conn.createStatement();
- rs = stat.executeQuery("pragma table_info("+escape(table)+");");
+ rs = stat.executeQuery("pragma table_info('"+escape(table)+"');");
sql = "select "
+ "null as TABLE_CAT, "
____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
