Re: problem odbc 8.0 with EOModeler - Mailing list pgsql-bugs

Thanks Eric and Kevin for the responses to my post.

My Testing table was
Person (person_id int not null, name varchar(32))
and my query typed in EOModeler is
  name = 'Elim'

EOModeler has an interface letting you specify connection method.
There are adaptors (oracle, informix, sybase...) and odbc data source
the choose from.

My headache is that for the same setting and table in difference
database server and odbc datasource, i have no problem with the
query except when i switch the data source to postgresql odbc.

It has two things not normal to me: [unlike other database and odbc,
postgresql-odbc reveals no database column type list to EOModeler
which i believe a missing of some api standard to other odbc
implementations.
For example, mysql odbc lets EOModeler show the available column
types such as int, mediumint, tinyint, char, varchar, text ....So that
one can specify column types when model an entity (table)] and the error
msg (from EOModeler)

SQLExecDirect in -[ODBCChannel evaluateExpression:(<ODBCSQLExpression:
"SELECT  t0."pname", t0."person_id" FROM "person" t0  WHERE t0."pname" = ?"
withBindings:(1:Elim(pname))>)]
S1000-7: ERROR:  column "elim" does not exist
(sorry I took the quotes around the column name 'pname' in my previous post)

Means that somehow my matching value 'Elim' been interpreted as column
name!!!
since the same query works perfect with other kind of odbc data sources, i
guess
this really indicate that EOModeler and postgresql-odbc can not communicate
correctly. in other words, postgresql-odbc has special API's that not make
sense to
EOModeler.



----- Original Message -----
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <elim@pdtnetworks.net>; <pgsql-bugs@postgresql.org>
Sent: Monday, August 01, 2005 8:25 AM
Subject: Re: [BUGS] problem odbc 8.0 with EOModeler


Is the column name "Elim" or "elim"?  If the former, try putting quotes
around it, as required by the ANSI and ISO standards for mixed case
identifiers.  Some database products fail to comply with the standards in
this respect.  PostgreSQL comes close, although it treats unquoted
identifers as all lower case rather than all upper case as required by the
standards.

-Kevin


>>> "YL" <elim@pdtnetworks.net> 07/30/05 3:48 PM >>>
I've used EOModeler with odbc for MS SQL Server,
MySQL and MS Access with no problem. But got
problem with postgre odbc driver. (the newest one)

EOMOdeler cannot get postgresql column types' info
through odbc. Also, It cannot interact with EOModeler
for very simple query:

SQLExecDirectin - [ODBCChannel evaluateExpression:
(<ODBCSQLExpression: "SELECT t0.pname,t0.person_id
FROM person t0 WHERE t0.pname = ? " withBindings:
(1:Elim(name)) >)]
S 1000-7: ERROR: column 'elim' doesnot exitst

EOModeler is an app in WebObjects (www.apple.com)
I'm using version 4.5.1 ObjC. EOModeler has adaptors
for Oracle, Infomix, Sybase, Openbase. All works very
well.

My guess is that postgresql-odbc has some non-standard
api and so EOModeler fails to work with it.




--

Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005