SQL Power Software Forum

Hello

I downloaded Wabit 0.9.6 today and I'm having some difficulty running a query without errors and need some help. I created a new data source to a server that has Microsoft SQL Server 2005 installed with a test database. I'm using JRE 5.0 Update 14 and used the default JDBC driver that came preinstalled with Wabit for SQL Server 2005. So when I drag a table to create a query I'm selecting all the fields and executing the query and i get the following error:

Database Product Name: Microsoft SQL Server
Database Product Version: 9.00.3042
Database Driver Name: Microsoft SQL Server 2005 JDBC Driver
Database Driver Version: 1.1.1501.101

Executed at Jun 26, 2009 3:45:35 PM EDT, took 62 milliseconds
Your query could not be executed due to the following error:

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '2'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.execute(StatementDecorator.java:84)
at ca.sqlpower.wabit.query.QueryCache.executeStatement(QueryCache.java:804)
at ca.sqlpower.wabit.query.QueryCache.executeStatement(QueryCache.java:770)
at ca.sqlpower.swingui.query.SQLQueryUIComponents$ExecuteSQLWorker.doStuff(SQLQueryUIComponents.java:389)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:60)
at java.lang.Thread.run(Unknown Source)

Your query could not be executed due to the following error:
Incorrect syntax near '2'.
See above for more details.

Hi Agill,

Thanks for trying out Wabit. From the stack trace it looks like we might not be quoting a part of your query correctly. The probable cause is you have a column or alias in your query that looks like "name 2" which would need to be quoted. If this is the problem you can put quotes around the name as a workaround until we get the issue fixed. If you still have the query or can quickly recreate it you can send us the generated query by going to the SQL tab and pasting the query text from there into the forum and we can look into fixing it. If you don't want to post your query then if you can find which part of the query needs to be quoted and let us know we can work with that as well.

Thomas

This is a copy of the SQL query from the tab:

SELECT Customer.No_, Customer.Name, Customer.Search Name, Customer.Name 2, Customer.Contact, Customer.Chain Name, Customer.Language Code, Customer.Payment Terms Code, Customer.Shipping Agent Code, Customer.Amount
FROM rxna-test.dbo.Customer Customer

I just noticed i get the same error for every column thats has a name with - or a space such as the 2 above and or the space for "Language Code". I tested by deselecting the Customer.Name 2 column and i received an error for Customer.Language Code. Is there a way around this? Even if i deselect the troublesome columns i get an error on the database name since it has a "-" in it. Thanks for your help.

Hi Agill,

I've added quoting to all of the column, table, schema, catalog and alias names. This way if you place spaces or other characters in any of your table names, etc they will be quoted. You can get a build with this fix in it from our Hudson server here and try it out. Let us know if that fixes your problem or if it still exists and thanks for helping us identify this problem.

Thomas

I cannot get to the this link http://pag.sqlpower.ca:8080/hudson/job/wabit/1378/ says IE cannot display the page? any ideas?

I'm not sure why IE cannot display the page, I'm able to get it to load in IE 8 and 7 OK. Since I'm guessing you're using Windows you can download the version of Wabit with the fix from this link http://pag.sqlpower.ca:8080/hudson/job/wabit/1378/artifact/target/Wabit-Setup-Windows-0.9.7-20090629133216.exe.

Thomas

I'm using IE 7 as well, i can get to http://pag.sqlpower.ca/page/splash and log into my account but when i click on that link it gives me the ie message. is there a way to get to that specific file through the website?

You can get to Hudson from the Wabit download page (The Wabit download page is under Power*Tools, Wabit BI Reporting Tool in the top menu and then the free download link on the left bar). If you scroll down to the bottom of the download page there is a link titled "Continuous Integration Builds". That link leads into the Wabit builds on Hudson. Any of the builds from 1378 or newer should have the fix. If that doesn't work and you're on Windows the link I placed in my last post is a direct link to a version of Wabit with the fix and you should be able to download Wabit from it without opening a new page.

Thomas

This message was edited 1 time. Last update was at 2009-06-29 15:41:23

ok i finally got to the site, just used my external line for internet. will see how this goes.

thanks

I'm not sure why you can't get access to Hudson. I'm able to get Hudson to load on our XP machine running IE 7. The settings for IE 7 on the machine seems to be the defaults, medium-high security level, medium privacy level and the pop-up blocker turned on. I also haven't found anyone who's had problems with accessing Hudson from IE7. Is there some configuration or setting that may be blocking the page from loading? You could also try upgrading to IE 8 and see if that allows you to view the builds.

Thomas

i think its being blocked on our network here not too sure why. But i got the download for a newer version of wabit setup file you sent me and it works great, no errors. Thank you so much for your help!