Hi YL,
You may also want to check that EOModeler is not quoting strings
with double quotes (") rather than single-quotes (') in ODBC, say by
auditing the same call to MySQL. And maybe check out which ODBC version
calls EOModeler is calling, and sounds like it could potentially(!) be
using legacy calls to the ODBC driver. I can't say I know enough about
ODBC to be able to guide you on that, but I believe the pgsql-odbc list
has a number of members who can.
Cheers,
EE
YL wrote:
Hi Kevin, you're right. When i type
pname = '\'Elim\''
in the EOModeler, it works (fetches the right match).
i can even do
pname like '\'Eli*\''
with the right results.
But what this mean in odbc level? (i don't need to add additional quotes for
other odbc data sources)
When query against numerical columns, things works quite well
----- Original Message -----
From: "Kevin Grittner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<pgsql-bugs@postgresql.org>
Sent: Monday, August 01, 2005 12:31 PM
Subject: Re: [BUGS] problem odbc 8.0 with EOModeler
It looks like this is being treated on the server as though the statement
is:
SELECT t0."pname", t0."person_id"
FROM "person" t0 WHERE t0."pname" = Elim
rather than:
SELECT t0."pname", t0."person_id"
FROM "person" t0 WHERE t0."pname" = 'Elim'
"YL" <[EMAIL PROTECTED]> 08/01/05 1:07 PM >>>
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <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" <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
