ojb does not do escaping of column-names. so you have two possibilities
1.) change the offending column name 2.) find out what kind of syntax the jdbc-driver accepts
have you tried single quotes 'print' ?
jakob
Oleg Lebedev wrote:
Hi Jakob,
Here is an exerpt from my repository.xml.
<class-descriptor class="org.waterford.sequencer.data.Studinfo"
table="webspec312.dbo.StudInfo"
<field-descriptor id="2" name="print" column="Print" jdbc-type="INTEGER" /> </class-descriptor>
'Print' is a reserved keyword in SQL Server. When I change the column name to StudInfo.Print, i.e. column="StudInfo.Print', I get the same error. If I use [Print] or "Print" as the column name, then my JDBC driver throws an error saying that "Column [Print] (or "Print") does not exist".
Is there a way to force OJB to put column name in quotes or smth like that?
Thanks.
Oleg
-----Original Message-----
From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 10:03 AM
To: OJB Users List
Subject: Re: column name is a reserved keyword
hi oleg,
have you tried to change column names in repository.xml ? ojb would the use :
select A0.[name], A0.firstName from person A0
jakob
Oleg Lebedev wrote:
Hi,
I am changing an existing application to use OJB.
The problem that I ran into is that some of the column names are reserved keywords, e.g. 'print'. I need to configure OJB to put all column names in brackets, e.g. [print], when retrieving values from the database. Otherwise, SQL Server throws a "Reserved keyword" exception.
How do I do this?
Thanks.
Oleg
*************************************
This e-mail may contain privileged or confidential material intended
for the named recipient only.
If you are not the named recipient, delete this message and all
attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise
using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network. *************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED] ************************************* This e-mail may contain privileged or confidential material intended for the named recipient only. If you are not the named recipient, delete this message and all attachments. Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited. We reserve the right to monitor e-mail sent through our network. *************************************
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
