newbie: CMD-line tutorial and Sybase SQLAnywhere

From: Tore Halset (halse..vv.ntnu.no)
Date: Fri Aug 30 2002 - 04:22:01 EDT

  • Next message: Andrus: "Re: newbie: CMD-line tutorial and Sybase SQLAnywhere"

    Hello!

    I am using Sybase SQLANywhere throu ODBC. Cayenne nightly/2002-8-29.

    The modeler seem to work ok. The creation of AUTO_PK_SUPPORT from modeler
    worked ok.

    Looks like the generated SQL are bad. Same error with SybaseAdapter and
    JdbcAdapter.

    C:\javadev\cayennetest>c:\j2sdk1.4.0_01\jre\bin\java test.Main f
    WARN DefaultOperationObserver: query exception
    java.sql.SQLException: [Sybase][ODBC Driver][Adaptive Server
    Anywhere]Syntax er
    or or access violation: near 't0' in ..._ID FROM .GALLERY [t0] WHERE
    UPPER(t0..
    .
            at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106)
            at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)
            at sun.jdbc.odbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:4229)
            at
    sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection
    java:470)
            at
    sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection
    java:438)
            at
    org.objectstyle.cayenne.conn.ConnectionWrapper.prepareStatement(Conn
    ctionWrapper.java:298)
            at
    org.objectstyle.cayenne.access.trans.QueryAssembler.createStatement(
    ueryAssembler.java:133)
            at
    org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java
    245)
            at
    org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.
    ava:345)
            at
    org.objectstyle.cayenne.access.DataContext.performQueries(DataContex
    .java:756)
            at
    org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.
    ava:763)
            at
    org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.
    ava:687)
            at test.Main.findGallery(Main.java:74)
            at test.Main.runTutorial(Main.java:44)
            at test.Main.main(Main.java:36)
    WARN DefaultOperationObserver: global exception
    org.objectstyle.cayenne.CayenneRuntimeException: Query exception.
            at
    org.objectstyle.cayenne.access.SelectObserver.nextQueryException(Sel
    ctObserver.java:154)
            at
    org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java
    270)
            at
    org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.
    ava:345)
            at
    org.objectstyle.cayenne.access.DataContext.performQueries(DataContex
    .java:756)
            at
    org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.
    ava:763)
            at
    org.objectstyle.cayenne.access.DataContext.performQuery(DataContext.
    ava:687)
            at test.Main.findGallery(Main.java:74)
            at test.Main.runTutorial(Main.java:44)
            at test.Main.main(Main.java:36)

    This archive was generated by hypermail 2.0.0 : Fri Aug 30 2002 - 04:22:10 EDT