Topic: How to query a Table with a Space in its name?
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?
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.
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.
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
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
An easy workariund could be to rename table or make a view that refers it.
Log in by clicking the login link at the top of the screen
Go back to forum.


