Martin,
not being sure here 100%, but I guess what you are experiencing is a result of you
turning off quoted_identifier at the
driver level, but Castor still generating SQL statements that do include quotes.
Other than this, this is beyond my expertise at the moment ... :-(.
Just looking at your initial post, can you at least share with us the relevant portion
of the mapping file that caused this
error and soem of the generated SQL to see what the real problem is ?
Werner
On Thu, 4 Dec 2003 11:33:10 +0000, [EMAIL PROTECTED] wrote:
>
>Werner,
>
>I've managed to turn off the quoted_identifier from a jConnect
>configuration aspect. My problem now is the sql that gets generated
>doesn't seem to be valid because what gets generated is something like the
>following format :
>
>select "tablename"."columnname" from "tablename"
>
>This results in : com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax
>near '.'
>
>Is this a jConnect, database or castor issue ? (I Seem to remember
>reading that the double quotes are required for jdbc?)
>
>Is there anyway of controlling how the sql gets generated because if it
>resembles the following :
>
>select tablename.columnname from tablename
>
>it will execute fine.
>
>\Thanks.
>
>Martin.
>
>
>
>
>
>
>
>
>
> "Werner Guttmann" <[EMAIL PROTECTED]>
>
>
>
>
>
>
>
>
>
> 02/12/2003 18:51
>
>
>
>
>
> Please respond to castor-dev
>
>
>
>
>
>
>
>
>
>
>
>To: [EMAIL PROTECTED]
>cc:
>Subject: Re: [castor-dev] Any examples of Sybase jconnect
> xml file?
>
>
>Martin,
>
>can you show me what you need to do when using e.g. vanilla JDBC for
>connection setup ?
>
>Thanks
>Werner
>
>On Tue, 2 Dec 2003 17:22:15 +0000, [EMAIL PROTECTED] wrote:
>
>>Hi,
>>
>>Has anyone got any examples of using Sybase's jconnect jdbc driver and
>>hence have an example of the database.xml file?
>>
>>I have an issue where the driver reports an exception saying :
>>
>>"com.sybase.jdbc2.jdbc.SybSQLException: The identifier that starts with
>'"'
>>is too long. Maximum length is 28."
>>
>>I need to turn of the QUOTED_IDENTIFIER and I am not sure the format for
>>this in the database.xml configuration file.
>>
>>Any advice greatly accepted.
>>
>>Thanks
>>Martin.
>>
>>
>>
>>
>>
>>
>>
>>Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
>Empfaenger sein, so bitten wir hoeflich um eine
>Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist
>unzulaessig. Diese Nachricht dient lediglich
>dem Austausch von Informationen und entfaltet keine rechtliche
>Bindungswirkung. Aufgrund der leichten
>Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt
>uebernehmen.
>>
>>This message is confidential and may be privileged. If you are not the
>intended recipient, we kindly ask you to
>inform the sender. Any unauthorised dissemination or copying hereof is
>prohibited. This message serves for
>information purposes only and shall not have any legally binding effect.
>Given that e-mails can easily be subject to
>manipulation, we can not accept any liability for the content provided.
>>
>>-----------------------------------------------------------
>>If you wish to unsubscribe from this mailing, send mail to
>>[EMAIL PROTECTED] with a subject of:
>> unsubscribe castor-dev
>>
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
>
>
>
>
>
>
>Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein,
>so bitten wir hoeflich um eine
Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig.
Diese Nachricht dient lediglich
dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten
Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
>
>This message is confidential and may be privileged. If you are not the intended
>recipient, we kindly ask you to
inform the sender. Any unauthorised dissemination or copying hereof is prohibited.
This message serves for
information purposes only and shall not have any legally binding effect. Given that
e-mails can easily be subject to
manipulation, we can not accept any liability for the content provided.
>
>-----------------------------------------------------------
>If you wish to unsubscribe from this mailing, send mail to
>[EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
