back to forum.

Topic: How to query a Table with a Space in its name?

Topic by
GordonShamway

2011-12-30
12:39

How to query a Table with a Space in its name?

I get an error when doing this. How can I work around this problem?

Reply by
kasper

2011-12-30
14:34
Hi Gordon,

Can you share the error message you get and a bit of information on what database you are using. In general space in names are discouraged, but the tool should of course support it if possible.

Reply by
GordonShamway

2012-01-03
08:24
Hi Kasper,
the error is as follows:

ERROR: An error occurred in the analysis job!
org.eobjects.metamodel.MetaModelException: Could not execute query
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:619)
at org.eobjects.analyzer.job.runner.RowProcessingPublisher.run(RowProcessingPublisher.java:176)
at org.eobjects.analyzer.job.tasks.RunRowProcessingPublisherTask.execute(RunRowProcessingPublisherTask.java:40)
at org.eobjects.analyzer.job.concurrent.TaskRunnable.run(TaskRunnable.java:63)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Falsche Syntax in der Nähe von '1005'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:592)
... 6 more

The Name of The Table is: ABC 1005$Posted Stock Document Header

PS: Sorry for the delay, I was on vacation

Reply by
beno

2012-01-03
15:13
An easy workariund could be to rename table or make a view that refers it.

You need to be logged in to participate

In order to post your own comments on this topic, you need to be logged in.

Username:

Log in by clicking the login link at the top of the screen

 

Go back to forum.