Topic: Retrieving data from Sybase
Retrieving data from Sybase
Hi,
I'm experiencing a problem with the Sybase connections. While I can successfully connect to the Sybase DB and pull in the metadata for an object, I am unable to run the jobs or preview the data because it fails with the error below, regardless of using the JDBC-ODBC bridge or the Sybase (net.sourceforge.jtds.jdbc.Driver) drivers.
Here is (portion of) the error when using the ODBC bridge:
""[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.""
And, almost identical error when using the Sybase driver (provided in the drop down list):
""java.util.concurrent.ExecutionException: org.eobjects.metamodel.MetaModelException: Could not execute query
org.eobjects.metamodel.MetaModelException: Could not execute query
Could not execute query
The column prefix '"Address"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
""
Any ideas? It seems that the datacleaner's "query builder" doesn't include the schema/database owner name.
I'm experiencing a problem with the Sybase connections. While I can successfully connect to the Sybase DB and pull in the metadata for an object, I am unable to run the jobs or preview the data because it fails with the error below, regardless of using the JDBC-ODBC bridge or the Sybase (net.sourceforge.jtds.jdbc.Driver) drivers.
Here is (portion of) the error when using the ODBC bridge:
""[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.""
And, almost identical error when using the Sybase driver (provided in the drop down list):
""java.util.concurrent.ExecutionException: org.eobjects.metamodel.MetaModelException: Could not execute query
org.eobjects.metamodel.MetaModelException: Could not execute query
Could not execute query
The column prefix '"Address"' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
""
Any ideas? It seems that the datacleaner's "query builder" doesn't include the schema/database owner name.
Hi sbadalov,
It could help if you post maybe some more of your log file. Find it in log/datacleaner.log
Can you identify the query that is being executed there?
It could help if you post maybe some more of your log file. Find it in log/datacleaner.log
Can you identify the query that is being executed there?
Thank you for pointing me to the log files. I now see the SQL statement and see the problem, which is in the syntax of the constructed sql statement. Or, possibly, the way my DB permissions are set up, and I'm going to clarify this with the DBA.
Please note how there is no 'dbo.' prefix in the SELECT clause:
"07:46:46.512 JdbcDataContext - Executing query: SELECT Address.AddressId
FROM dbo.Address
"
This statement fails even if I execute it from different tool. And it works fine (in my another tool) when I change it to
"SELECT dbo.Address.AddressId
FROM dbo.Address".
Here is entire log:
INFO 07:46:23.557 Bootstrap - Welcome to DataCleaner 2.3
INFO 07:46:23.573 Bootstrap - CLI mode=false, use -usage to view usage options
INFO 07:46:23.842 JaxbConfigurationReader - Configuration name: DataCleaner configuration
INFO 07:46:23.842 JaxbConfigurationReader - Configuration version: 2.3
INFO 07:46:23.842 JaxbConfigurationReader - Configuration description: Configures DataCleaner's initial environment. This includes an example datastore and some example reference data.
INFO 07:46:23.842 JaxbConfigurationReader - Author: eobjects.org
INFO 07:46:23.842 JaxbConfigurationReader - Created date: null
INFO 07:46:23.842 JaxbConfigurationReader - Updated date: null
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/beans' (and subpackages recursively)
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/output/beans' (and subpackages recursively)
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/panels' (and subpackages recursively)
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/result/renderer' (and subpackages recursively)
INFO 07:46:23.921 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/widgets/result' (and subpackages recursively)
INFO 07:46:23.984 DCModule - Succesfully read configuration from C:\Documents and Settings\badalovs\.datacleaner\2.3\conf.xml
INFO 07:46:23.984 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' complete
INFO 07:46:24.000 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' complete
INFO 07:46:24.032 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' complete
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.CsvDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreDictionary
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:24.047 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' complete
INFO 07:46:24.190 NamedPattern - compiling pattern: ([a-zA-Z0-9\._%+-]+)@([a-zA-Z0-9\._%+-]+\.[a-zA-Z0-9\._%+-]{2,4})
INFO 07:46:24.427 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' complete
INFO 07:46:24.443 LookAndFeelManager - Look and feel set to: [The JGoodies Plastic XP Look and Feel - © 2001-2009 JGoodies Karsten Lentzsch - com.jgoodies.looks.plastic.PlasticXPLookAndFeel]
INFO 07:46:25.710 Bootstrap - Welcome to DataCleaner 2.3
INFO 07:46:25.710 Bootstrap - CLI mode=false, use -usage to view usage options
INFO 07:46:26.090 JaxbConfigurationReader - Configuration name: DataCleaner configuration
INFO 07:46:26.090 JaxbConfigurationReader - Configuration version: 2.3
INFO 07:46:26.090 JaxbConfigurationReader - Configuration description: Configures DataCleaner's initial environment. This includes an example datastore and some example reference data.
INFO 07:46:26.090 JaxbConfigurationReader - Author: eobjects.org
INFO 07:46:26.090 JaxbConfigurationReader - Created date: null
INFO 07:46:26.090 JaxbConfigurationReader - Updated date: null
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/widgets/result' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/output/beans' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/panels' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/result/renderer' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/beans' (and subpackages recursively)
INFO 07:46:26.248 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' complete
INFO 07:46:26.280 DCModule - Succesfully read configuration from C:\Documents and Settings\badalovs\.datacleaner\2.3\conf.xml
INFO 07:46:26.280 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' complete
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.311 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' complete
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.311 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' complete
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.CsvDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreDictionary
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:26.485 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@1ff4f8a[Scopes.SINGLETON]]
INFO 07:46:26.485 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.panels.DCGlassPane: org.eobjects.datacleaner.panels.DCGlassPane@1774e47
INFO 07:46:26.549 NamedPattern - compiling pattern: ([a-zA-Z0-9\._%+-]+)@([a-zA-Z0-9\._%+-]+\.[a-zA-Z0-9\._%+-]{2,4})
INFO 07:46:26.881 LookAndFeelManager - Look and feel set to: [The JGoodies Plastic XP Look and Feel - © 2001-2009 JGoodies Karsten Lentzsch - com.jgoodies.looks.plastic.PlasticXPLookAndFeel]
INFO 07:46:26.897 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' complete
INFO 07:46:27.530 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.panels.DCGlassPane: org.eobjects.datacleaner.panels.DCGlassPane@3b9a5f
INFO 07:46:27.546 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@7ee46a[Scopes.SINGLETON]]
INFO 07:46:28.306 Bootstrap - Using default ExtensionSwap website hostname
INFO 07:46:28.401 ExtensionSwapInstallationHttpContainer - HTTP service for ExtensionSwap installation running on port 31389
INFO 07:46:29.145 Bootstrap - Using default ExtensionSwap website hostname
INFO 07:46:29.208 ExtensionSwapInstallationHttpContainer - HTTP service for ExtensionSwap installation running on port 31389
INFO 07:46:37.773 JdbcDataContext - Found schemaName: dbo
INFO 07:46:37.773 UsageAwareDatastore - Reusing existing DataContextProvider: UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.773 UsageAwareDataContextProvider - Usage incremented to 2 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.773 UsageAwareDatastore - Reusing existing DataContextProvider: UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.773 UsageAwareDataContextProvider - Usage incremented to 3 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.805 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@7ee46a[Scopes.SINGLETON]]
INFO 07:46:37.805 AdHocModule - Binding ad-hoc dependency for org.eobjects.analyzer.connection.Datastore: JdbcDatastore[name=SECMasterEntity_AT_SECPROD0_OLTP,url=jdbc:odbc:SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.836 UsageAwareDatastore - Reusing existing DataContextProvider: UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.836 UsageAwareDataContextProvider - Usage incremented to 4 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.884 UsageAwareDataContextProvider - Method close() invoked, usage decremented to 3 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.900 AdHocModule - Binding ad-hoc dependency for org.eobjects.analyzer.connection.Datastore: of(JdbcDatastore[name=SECMasterEntity_AT_SECPROD0_OLTP,url=jdbc:odbc:SECMasterEntity_AT_SECPROD0_OLTP])
INFO 07:46:37.900 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@7ee46a[Scopes.SINGLETON]]
INFO 07:46:37.900 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.widgets.tree.SchemaTree: org.eobjects.datacleaner.widgets.tree.SchemaTree[,0,0,0x0,invalid,alignmentX=0.0,alignmentY=0.0,border=,flags=16777568,maximumSize=,minimumSize=,preferredSize=,editable=false,invokesStopCellEditing=false,largeModel=false,rootVisible=true,rowHeight=17,scrollsOnExpand=true,showsRootHandles=false,toggleClickCount=2,visibleRowCount=20]
INFO 07:46:37.900 JdbcDataContext - Querying for table types [TABLE, VIEW] in catalog: null, schema: dbo
INFO 07:46:41.493 JdbcDataContext - Querying for columns in table: Address
INFO 07:46:46.512 JdbcDataContext - Applying fetch_size=35
INFO 07:46:46.512 JdbcDataContext - Executing query: SELECT Address.AddressId, Address.MasterEntityId, Address.ContactUsageTypeId, Address.Street1, Address.Street2, Address.Street3, Address.City, Address.State, Address.Zip, Address.RoomNumber, Address.BuildingName, Address.AlternativeBuildingName, Address.BuildingCd, Address.MailStopId, Address.Country, Address.IsPrivateResidence, Address.IsBadAddress, Address.IsPrimary, Address.IsActive, Address.IsDeleted, Address.CreatedDt, Address.CreatedBy, Address.CreatedByName, Address.UpdatedDt, Address.UpdatedBy, Address.UpdatedByName FROM dbo.Address
WARN 07:46:46.543 JdbcDataContext - Exception occurred when executing query: [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
java.sql.SQLException: [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:592)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:73)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:70)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:140)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:138)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
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)
ERROR 07:46:46.559 DCUncaughtExceptionHandler - Thread AWT-EventQueue-0 threw uncaught exception
java.lang.IllegalStateException: java.util.concurrent.ExecutionException: org.eobjects.metamodel.MetaModelException: Could not execute query
at org.eobjects.datacleaner.windows.DataSetWindow$2.done(DataSetWindow.java:168)
at javax.swing.SwingWorker$5.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
at sun.swing.AccumulativeRunnable.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
at javax.swing.Timer.fireActionPerformed(Unknown Source)
at javax.swing.Timer$DoPostEvent.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: org.eobjects.metamodel.MetaModelException: Could not execute query
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at javax.swing.SwingWorker.get(Unknown Source)
at org.eobjects.datacleaner.windows.DataSetWindow$2.done(DataSetWindow.java:145)
... 20 more
Caused by: org.eobjects.metamodel.MetaModelException: Could not execute query
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:619)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:73)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:70)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:140)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:138)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
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: [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:592)
... 11 more
Please note how there is no 'dbo.' prefix in the SELECT clause:
"07:46:46.512 JdbcDataContext - Executing query: SELECT Address.AddressId
FROM dbo.Address
"
This statement fails even if I execute it from different tool. And it works fine (in my another tool) when I change it to
"SELECT dbo.Address.AddressId
FROM dbo.Address".
Here is entire log:
INFO 07:46:23.557 Bootstrap - Welcome to DataCleaner 2.3
INFO 07:46:23.573 Bootstrap - CLI mode=false, use -usage to view usage options
INFO 07:46:23.842 JaxbConfigurationReader - Configuration name: DataCleaner configuration
INFO 07:46:23.842 JaxbConfigurationReader - Configuration version: 2.3
INFO 07:46:23.842 JaxbConfigurationReader - Configuration description: Configures DataCleaner's initial environment. This includes an example datastore and some example reference data.
INFO 07:46:23.842 JaxbConfigurationReader - Author: eobjects.org
INFO 07:46:23.842 JaxbConfigurationReader - Created date: null
INFO 07:46:23.842 JaxbConfigurationReader - Updated date: null
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/beans' (and subpackages recursively)
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/output/beans' (and subpackages recursively)
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/panels' (and subpackages recursively)
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' beginning
INFO 07:46:23.905 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/result/renderer' (and subpackages recursively)
INFO 07:46:23.921 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/widgets/result' (and subpackages recursively)
INFO 07:46:23.984 DCModule - Succesfully read configuration from C:\Documents and Settings\badalovs\.datacleaner\2.3\conf.xml
INFO 07:46:23.984 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' complete
INFO 07:46:24.000 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' complete
INFO 07:46:24.032 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' complete
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.032 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.CsvDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreDictionary
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:24.047 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:24.047 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' complete
INFO 07:46:24.190 NamedPattern - compiling pattern: ([a-zA-Z0-9\._%+-]+)@([a-zA-Z0-9\._%+-]+\.[a-zA-Z0-9\._%+-]{2,4})
INFO 07:46:24.427 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' complete
INFO 07:46:24.443 LookAndFeelManager - Look and feel set to: [The JGoodies Plastic XP Look and Feel - © 2001-2009 JGoodies Karsten Lentzsch - com.jgoodies.looks.plastic.PlasticXPLookAndFeel]
INFO 07:46:25.710 Bootstrap - Welcome to DataCleaner 2.3
INFO 07:46:25.710 Bootstrap - CLI mode=false, use -usage to view usage options
INFO 07:46:26.090 JaxbConfigurationReader - Configuration name: DataCleaner configuration
INFO 07:46:26.090 JaxbConfigurationReader - Configuration version: 2.3
INFO 07:46:26.090 JaxbConfigurationReader - Configuration description: Configures DataCleaner's initial environment. This includes an example datastore and some example reference data.
INFO 07:46:26.090 JaxbConfigurationReader - Author: eobjects.org
INFO 07:46:26.090 JaxbConfigurationReader - Created date: null
INFO 07:46:26.090 JaxbConfigurationReader - Updated date: null
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/widgets/result' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/output/beans' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/datacleaner/panels' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/result/renderer' (and subpackages recursively)
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' beginning
INFO 07:46:26.169 ClasspathScanDescriptorProvider - Scanning package path 'org/eobjects/analyzer/beans' (and subpackages recursively)
INFO 07:46:26.248 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.output.beans' complete
INFO 07:46:26.280 DCModule - Succesfully read configuration from C:\Documents and Settings\badalovs\.datacleaner\2.3\conf.xml
INFO 07:46:26.280 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.panels' complete
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.311 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.result.renderer' complete
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.311 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.datacleaner.widgets.result' complete
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.311 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.CsvDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.UsageAwareDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.connection.JdbcDatastore
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreDictionary
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.AbstractReferenceData
INFO 07:46:26.327 ReadObjectBuilder - Creating ReadObjectBuilder for new object of class: class org.eobjects.analyzer.reference.DatastoreSynonymCatalog
INFO 07:46:26.485 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@1ff4f8a[Scopes.SINGLETON]]
INFO 07:46:26.485 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.panels.DCGlassPane: org.eobjects.datacleaner.panels.DCGlassPane@1774e47
INFO 07:46:26.549 NamedPattern - compiling pattern: ([a-zA-Z0-9\._%+-]+)@([a-zA-Z0-9\._%+-]+\.[a-zA-Z0-9\._%+-]{2,4})
INFO 07:46:26.881 LookAndFeelManager - Look and feel set to: [The JGoodies Plastic XP Look and Feel - © 2001-2009 JGoodies Karsten Lentzsch - com.jgoodies.looks.plastic.PlasticXPLookAndFeel]
INFO 07:46:26.897 ClasspathScanDescriptorProvider - Scan of 'org.eobjects.analyzer.beans' complete
INFO 07:46:27.530 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.panels.DCGlassPane: org.eobjects.datacleaner.panels.DCGlassPane@3b9a5f
INFO 07:46:27.546 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@7ee46a[Scopes.SINGLETON]]
INFO 07:46:28.306 Bootstrap - Using default ExtensionSwap website hostname
INFO 07:46:28.401 ExtensionSwapInstallationHttpContainer - HTTP service for ExtensionSwap installation running on port 31389
INFO 07:46:29.145 Bootstrap - Using default ExtensionSwap website hostname
INFO 07:46:29.208 ExtensionSwapInstallationHttpContainer - HTTP service for ExtensionSwap installation running on port 31389
INFO 07:46:37.773 JdbcDataContext - Found schemaName: dbo
INFO 07:46:37.773 UsageAwareDatastore - Reusing existing DataContextProvider: UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.773 UsageAwareDataContextProvider - Usage incremented to 2 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.773 UsageAwareDatastore - Reusing existing DataContextProvider: UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.773 UsageAwareDataContextProvider - Usage incremented to 3 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.805 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@7ee46a[Scopes.SINGLETON]]
INFO 07:46:37.805 AdHocModule - Binding ad-hoc dependency for org.eobjects.analyzer.connection.Datastore: JdbcDatastore[name=SECMasterEntity_AT_SECPROD0_OLTP,url=jdbc:odbc:SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.836 UsageAwareDatastore - Reusing existing DataContextProvider: UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.836 UsageAwareDataContextProvider - Usage incremented to 4 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.884 UsageAwareDataContextProvider - Method close() invoked, usage decremented to 3 for UsageAwareDataContextProvider[datastore=SECMasterEntity_AT_SECPROD0_OLTP]
INFO 07:46:37.900 AdHocModule - Binding ad-hoc dependency for org.eobjects.analyzer.connection.Datastore: of(JdbcDatastore[name=SECMasterEntity_AT_SECPROD0_OLTP,url=jdbc:odbc:SECMasterEntity_AT_SECPROD0_OLTP])
INFO 07:46:37.900 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow: FactoryProxy[key=Key[type=org.eobjects.datacleaner.windows.AnalysisJobBuilderWindow, annotation=[none]], provider=com.google.inject.internal.ConstructorBindingImpl$Factory@7ee46a[Scopes.SINGLETON]]
INFO 07:46:37.900 AdHocModule - Binding ad-hoc dependency for org.eobjects.datacleaner.widgets.tree.SchemaTree: org.eobjects.datacleaner.widgets.tree.SchemaTree[,0,0,0x0,invalid,alignmentX=0.0,alignmentY=0.0,border=,flags=16777568,maximumSize=,minimumSize=,preferredSize=,editable=false,invokesStopCellEditing=false,largeModel=false,rootVisible=true,rowHeight=17,scrollsOnExpand=true,showsRootHandles=false,toggleClickCount=2,visibleRowCount=20]
INFO 07:46:37.900 JdbcDataContext - Querying for table types [TABLE, VIEW] in catalog: null, schema: dbo
INFO 07:46:41.493 JdbcDataContext - Querying for columns in table: Address
INFO 07:46:46.512 JdbcDataContext - Applying fetch_size=35
INFO 07:46:46.512 JdbcDataContext - Executing query: SELECT Address.AddressId, Address.MasterEntityId, Address.ContactUsageTypeId, Address.Street1, Address.Street2, Address.Street3, Address.City, Address.State, Address.Zip, Address.RoomNumber, Address.BuildingName, Address.AlternativeBuildingName, Address.BuildingCd, Address.MailStopId, Address.Country, Address.IsPrivateResidence, Address.IsBadAddress, Address.IsPrimary, Address.IsActive, Address.IsDeleted, Address.CreatedDt, Address.CreatedBy, Address.CreatedByName, Address.UpdatedDt, Address.UpdatedBy, Address.UpdatedByName FROM dbo.Address
WARN 07:46:46.543 JdbcDataContext - Exception occurred when executing query: [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
java.sql.SQLException: [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:592)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:73)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:70)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:140)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:138)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
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)
ERROR 07:46:46.559 DCUncaughtExceptionHandler - Thread AWT-EventQueue-0 threw uncaught exception
java.lang.IllegalStateException: java.util.concurrent.ExecutionException: org.eobjects.metamodel.MetaModelException: Could not execute query
at org.eobjects.datacleaner.windows.DataSetWindow$2.done(DataSetWindow.java:168)
at javax.swing.SwingWorker$5.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
at sun.swing.AccumulativeRunnable.run(Unknown Source)
at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
at javax.swing.Timer.fireActionPerformed(Unknown Source)
at javax.swing.Timer$DoPostEvent.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: org.eobjects.metamodel.MetaModelException: Could not execute query
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at javax.swing.SwingWorker.get(Unknown Source)
at org.eobjects.datacleaner.windows.DataSetWindow$2.done(DataSetWindow.java:145)
... 20 more
Caused by: org.eobjects.metamodel.MetaModelException: Could not execute query
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:619)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:73)
at org.eobjects.datacleaner.windows.DataSetWindow$1.call(DataSetWindow.java:70)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:140)
at org.eobjects.datacleaner.windows.DataSetWindow$2.doInBackground(DataSetWindow.java:138)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
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: [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The column prefix 'Address' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at org.eobjects.metamodel.jdbc.JdbcDataContext.executeQuery(JdbcDataContext.java:592)
... 11 more
Hi sbadalov,
Maybe you should try editing your Sybase connection string. On this page you can see the format:
http://jtds.sourceforge.net/faq.html#urlFormat
When you get an error because "dbo" is not included in the query, I think it is because you are making a general connecting to the database but not specifying a specific schema in the connection string (aka. the URL). Maybe you can add some more elements to the URL to make "dbo" implied by the connection.
Maybe you should try editing your Sybase connection string. On this page you can see the format:
http://jtds.sourceforge.net/faq.html#urlFormat
When you get an error because "dbo" is not included in the query, I think it is because you are making a general connecting to the database but not specifying a specific schema in the connection string (aka. the URL). Maybe you can add some more elements to the URL to make "dbo" implied by the connection.
It is clearly something to do with the role/privileges assgined to the Sybase database user whic I use to connect to the database. I tried it on another database, for the same user and object, and it generates exactly the same SQL query - without prefix dbo. in the SELECT clause - and works fine. I am having Sybase dbas to compare/fix user privileges/grants and will keep you posted.
Thank you.
Thank you.
Log in by clicking the login link at the top of the screen
Go back to forum.
