db-ojb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edson Carlos Ericksson Richter" <edson.rich...@mgrinformatica.com.br>
Subject Re: Problem with keyword as column name
Date Fri, 03 Oct 2003 12:46:09 GMT
MS SQL accepts keywords in two ways: using [] and using ". Have you tested

<field-descriptor column="\"Key\""
            jdbc-type="VARCHAR"
            name="key"/>


I think the only problem should be with XML sintax... Jakob, the escaped values should be
sent directly to database (but then we are loosing the database independency, since escaped
sintax could differ from database to database).

Edson

  ----- Original Message ----- 
  From: Jakob Braeuchi 
  To: OJB Users List 
  Sent: Friday, October 03, 2003 5:20 AM
  Subject: Re: Problem with keyword as column name


  hi oliver,

  what would the correct sql look like using the escaped column name ?

  jakob

  Oliver Rutherfurd wrote:

  >I'm having problems using OBJ (1.0rc3) to access a table in SQL Server which
  >has a column named "Key".  I defined the field in my repository.xml file
  >like so:
  >
  >    <field-descriptor column="Key"
  >            jdbc-type="VARCHAR"
  >            name="key"/>
  >
  >I get the following error:
  >
  >    java.sql.SQLException: [JCDEVDB]Incorrect syntax near the keyword 'Key'.
  >
  >I tried to escape the column name in the repository.xml file, like so:
  >
  >    <field-descriptor column="[Key]"
  >            jdbc-type="VARCHAR"
  >            name="key"/>
  >
  >I got the following error:
  >
  >    java.util.NoSuchElementException: Could not obtain next object: Error
  >reading from result set: [TDS Driver]Column '[Key]' not found.
  >
  >Much as I'd like to change the column name, so this problem would just go
  >away, it's not an option.  How can I get this to work?
  >
  >Thanks,
  >-Ollie
  >
  >
  >---------------------------------------------------------------------
  >To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
  >For additional commands, e-mail: ojb-user-help@db.apache.org
  >
  >
  >  
  >


  ---------------------------------------------------------------------
  To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
  For additional commands, e-mail: ojb-user-help@db.apache.org



  ---
  Outgoing mail is certified Virus Free.
  Checked by AVG anti-virus system (http://www.grisoft.com).
  Version: 6.0.522 / Virus Database: 320 - Release Date: 29/9/2003
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message