I'm trying to get the SQLDataSourceServlet to work using the tq= argument for specifying column names. I have the Servlet setup in Tomcat 7 using a oracle ojdbc5.jar jdbc driver. When running the example I get an "java.sql.SQLException: ORA-00911: invalid character" exception and by looking at the source code I found that the SqlDataSourceHelper.java class (I presume in menthod getColumnId) wraps each column name in a ` character in the select clause, e.g. SELECT `name`, `population` FROM simple_example The Oracle driver doesn't seem to be very fond of this character and throws the ORA-00911 error. Has anybody else experienced this specific problem and possibly found a workaround for this? You help is much appreciated. Cheers Bernie
-- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
