cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ольга Ткачева <tkachovao...@gmail.com>
Subject Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Date Tue, 12 Jan 2010 13:42:41 GMT
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 <andrus@objectstyle.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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message