in oracle ReturnTypesMappingTest has error generating schema
SEVERE: Error generating schema...
java.sql.SQLException: ORA-01754: a table may contain only one column of
type LONG
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
in test generate 2 long column: LONGVARBINARY_COLUMN LONG RAW NULL,
LONGVARCHAR_COLUMN LONG VARCHAR NULL
12 января 2010 г. 11:48 пользователь Andrus Adamchik <andru..bjectstyle.org
> написал:
>
> On Jan 11, 2010, at 1:45 PM, Рябицкий Евгений wrote:
>
> Strange result... looks like I have to install Postgress to check it
>> myself... :)
>>
>> Evgeny.
>>
>
> Hi Evgeny,
>
> looking at most test failures in Olga's tests, I see that most failures are
> caused by various DB incompatibilities, and have nothing to do with the
> change itself, but rather with the unit tests themselves not being
> compatible with a given DB. Olga just logged one issue (CAY-1363) that is
> actually a bug in Cayenne. Others are similar, such as:
>
> * MySQL truncating milliseconds (so the test has to be written to compare
> with precision up to the nearest second)
> * Precision and scale not declared for decimal values, causing loss of
> precision in some DB's
> * Max length for VARCHAR being 255 on some DBs
>
> Those fairly benign issues would cause massive test failures, and
> potentially hide the real issues. And those affect not only the current
> patch, but also your earlier commit per
> http://svn.apache.org/viewvc?view=revision&revision=889168
>
> We may need your help to make your tests compatible with other DB's. Olga
> is about to send a patch on top of your patch fixing some of the above
> things (and also fix CAY-1363). Can you take it from there and install at
> least PostgreSQL and MySQL and try to make your tests run on those (in
> addition to Oracle, HSQLDB, and anything else you might be testing against)?
>
> This would be of tremendous help to us, as your changes touch on JDBC
> internals that are very sensitive to DB and driver type and version.
>
> Andrus
>
>
>
>
-- Olga Tkacheva
This archive was generated by hypermail 2.0.0 : Tue Jan 12 2010 - 08:43:17 EST