Query error

[Pa...@capgroup.com]

I am getting the following error when running OJB with the SQL Server
JSQLConnect driver

>[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the query (for a com.itcs.multiLanguage.LabelMap):
Incorrect syntax near the keyword 'DESC'.

Did any one already have the same issue ? How could I track it down ?

Thanks and regards,

Patrick Reyes

Re: Query error

[Jakob Braeuchi <jb...@gmx.ch>]

hi patrick,

the best solution is to use the p6spy jdbc-driver :

     <jdbc-connection-descriptor
           default-connection="true"
           jcd-alias="default"
           platform="MySQL"
           jdbc-level="2.0"
           driver="com.p6spy.engine.spy.P6SpyDriver"
           protocol="jdbc"
            ......

and

    # the mysql open source driver
    realdriver=org.gjt.mm.mysql.Driver

in spy.properties.

or you can enable tracing the sql-generator in ojb.properties:


# Logger for SqlGenerator, useful for debugging generation of SQL
org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=DEBUG



hth
jakob



Patrick_Reyes@capgroup.com wrote:

>I am getting the following error when running OJB with the SQL Server
>JSQLConnect driver
>
>  
>
>>[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
>>    
>>
>during the execution of the query (for a com.itcs.multiLanguage.LabelMap):
>Incorrect syntax near the keyword 'DESC'.
>
>Did any one already have the same issue ? How could I track it down ?
>
>Thanks and regards,
>
>Patrick Reyes
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>  
>