Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA .MYTABLE' in catalog 'MYDB' because names do not exactly match.

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA .MYTABLE' in catalog 'MYDB' because names do not exactly match.

Patrick Kaeding-2
Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA .MYTABLE' in catalog 'MYDB' because names do not exactly match. Hello

I am having trouble creating an export of my database using an org.dbunit.database.QueryDataSet.  When I call org.dbunit.dataset.xml.FlatXmlDataSet.write(IDataSet, OutputStream), I get the following stack trace:

java.lang.IllegalStateException: Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA  .MYTABLE' in catalog 'MYDB' because names do not exactly match.    at org.dbunit.database.ResultSetTableMetaData.scrollTo(ResultSetTableMetaData.java:297)    at org.dbunit.database.ResultSetTableMetaData.createColumnFromDbMetaData(ResultSetTableMetaData.java:262)    at org.dbunit.database.ResultSetTableMetaData.createMetaData(ResultSetTableMetaData.java:154)    at org.dbunit.database.ResultSetTableMetaData.createMetaData(ResultSetTableMetaData.java:131)    at org.dbunit.database.ResultSetTableMetaData.<init>(ResultSetTableMetaData.java:97)    at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:84)    at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:63)    at org.dbunit.database.ForwardOnlyResultSetTable.<init>(ForwardOnlyResultSetTable.java:65)    at org.dbunit.database.CachedResultSetTableFactory.createTable(CachedResultSetTableFactory.java:52)    at org.dbunit.database.AbstractDatabaseConnection.createQueryTable(AbstractDatabaseConnection.java:90)    at org.dbunit.database.AbstractDatabaseConnection.createTable(AbstractDatabaseConnection.java:115)    at org.dbunit.database.QueryTableIterator.getTable(QueryTableIterator.java:143)    at org.dbunit.dataset.stream.DataSetProducerAdapter.produce(DataSetProducerAdapter.java:83)    at org.dbunit.dataset.xml.FlatXmlWriter.write(FlatXmlWriter.java:124)    at org.dbunit.dataset.xml.FlatXmlDataSet.write(FlatXmlDataSet.java:341)

In researching this, I saw that someone else had this problem back in February, and fixed it using a snapshot build of 2.4.4.  I am using the regular release build of 2.4.4.

Any ideas?

Thanks,
Patrick

------------------------------------------------------------------------------

_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA .MYTABLE' in catalog 'MYDB' because names do not exactly match.

Luiz Eduardo Guida Valmont-2
because names do not exactly match 

Are you running your tests on a MySQL database? If so, please double check casing of names (since in that DBMS MYCOL is not the same as MyCoL).

2009/6/29 Patrick Kaeding <[hidden email]>
Hello

I am having trouble creating an export of my database using an org.dbunit.database.QueryDataSet.  When I call org.dbunit.dataset.xml.FlatXmlDataSet.write(IDataSet, OutputStream), I get the following stack trace:

java.lang.IllegalStateException: Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA  .MYTABLE' in catalog 'MYDB' because names do not exactly match.    at org.dbunit.database.ResultSetTableMetaData.scrollTo(ResultSetTableMetaData.java:297)    at org.dbunit.database.ResultSetTableMetaData.createColumnFromDbMetaData(ResultSetTableMetaData.java:262)    at org.dbunit.database.ResultSetTableMetaData.createMetaData(ResultSetTableMetaData.java:154)    at org.dbunit.database.ResultSetTableMetaData.createMetaData(ResultSetTableMetaData.java:131)    at org.dbunit.database.ResultSetTableMetaData.<init>(ResultSetTableMetaData.java:97)    at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:84)    at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:63)    at org.dbunit.database.ForwardOnlyResultSetTable.<init>(ForwardOnlyResultSetTable.java:65)    at org.dbunit.database.CachedResultSetTableFactory.createTable(CachedResultSetTableFactory.java:52)    at org.dbunit.database.AbstractDatabaseConnection.createQueryTable(AbstractDatabaseConnection.java:90)    at org.dbunit.database.AbstractDatabaseConnection.createTable(AbstractDatabaseConnection.java:115)    at org.dbunit.database.QueryTableIterator.getTable(QueryTableIterator.java:143)    at org.dbunit.dataset.stream.DataSetProducerAdapter.produce(DataSetProducerAdapter.java:83)    at org.dbunit.dataset.xml.FlatXmlWriter.write(FlatXmlWriter.java:124)    at org.dbunit.dataset.xml.FlatXmlDataSet.write(FlatXmlDataSet.java:341)

In researching this, I saw that someone else had this problem back in February, and fixed it using a snapshot build of 2.4.4.  I am using the regular release build of 2.4.4.

Any ideas?

Thanks,
Patrick

------------------------------------------------------------------------------

_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user



------------------------------------------------------------------------------

_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA .MYTABLE' in catalog 'MYDB' because names do not exactly match.

Loïc Lacombe-2
In reply to this post by Patrick Kaeding-2
In the first place, try 2.4.5. If this was a bug it may have been corrected since.
As far as I can remember, I have only seen this kind of stuff when I did not set the right sql factory. These are awfully vague memories, so it's probably not that...

Cheers.

Loïc Lacombe



On Mon, Jun 29, 2009 at 11:11 PM, Patrick Kaeding <[hidden email]> wrote:
Hello

I am having trouble creating an export of my database using an org.dbunit.database.QueryDataSet.  When I call org.dbunit.dataset.xml.FlatXmlDataSet.write(IDataSet, OutputStream), I get the following stack trace:

java.lang.IllegalStateException: Did not find column 'MYCOL' for <schema.table> 'MYSCHEMA  .MYTABLE' in catalog 'MYDB' because names do not exactly match.    at org.dbunit.database.ResultSetTableMetaData.scrollTo(ResultSetTableMetaData.java:297)    at org.dbunit.database.ResultSetTableMetaData.createColumnFromDbMetaData(ResultSetTableMetaData.java:262)    at org.dbunit.database.ResultSetTableMetaData.createMetaData(ResultSetTableMetaData.java:154)    at org.dbunit.database.ResultSetTableMetaData.createMetaData(ResultSetTableMetaData.java:131)    at org.dbunit.database.ResultSetTableMetaData.<init>(ResultSetTableMetaData.java:97)    at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:84)    at org.dbunit.database.AbstractResultSetTable.<init>(AbstractResultSetTable.java:63)    at org.dbunit.database.ForwardOnlyResultSetTable.<init>(ForwardOnlyResultSetTable.java:65)    at org.dbunit.database.CachedResultSetTableFactory.createTable(CachedResultSetTableFactory.java:52)    at org.dbunit.database.AbstractDatabaseConnection.createQueryTable(AbstractDatabaseConnection.java:90)    at org.dbunit.database.AbstractDatabaseConnection.createTable(AbstractDatabaseConnection.java:115)    at org.dbunit.database.QueryTableIterator.getTable(QueryTableIterator.java:143)    at org.dbunit.dataset.stream.DataSetProducerAdapter.produce(DataSetProducerAdapter.java:83)    at org.dbunit.dataset.xml.FlatXmlWriter.write(FlatXmlWriter.java:124)    at org.dbunit.dataset.xml.FlatXmlDataSet.write(FlatXmlDataSet.java:341)

In researching this, I saw that someone else had this problem back in February, and fixed it using a snapshot build of 2.4.4.  I am using the regular release build of 2.4.4.

Any ideas?

Thanks,
Patrick

------------------------------------------------------------------------------

_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user



------------------------------------------------------------------------------

_______________________________________________
dbunit-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user