detecting SQL system

Поиск
Список
Период
Сортировка
Искать
От
John R Pierce
Тема
detecting SQL system
Дата
Msg-id
025a01c4a13e$8459f9f0$0200a8c0@hogranch.com
Список
Дерево обсуждения
Detecting SQL_ASCII databases Oliver Jowett <oliver@opencloud.com>
Re: Detecting SQL_ASCII databases Kris Jurka <books@ejurka.com>
Re: Detecting SQL_ASCII databases Oliver Jowett <oliver@opencloud.com>
Re: Detecting SQL_ASCII databases Kris Jurka <books@ejurka.com>
One of the Java developers in my group asked me today if there was any 
reliable and portable way he could query JDBC to find out what database he 
was connected to, Postgres vs Oracle vs TimesTen vs ???

So, I'm curious, are there any SQL standard methods of doing this?  Is the 
information_schema any part of the standard, i.e. could we

SELECT character_value FROM information.schema.sql_implementation_info
    WHERE implementation_info_name = 'SERVER NAME';

?

Or do we have to poke around at each of these DBMS servers and figure out 
whats unique about them ? 

В списке pgsql-jdbc по дате отправления
От: Kris Jurka
Дата:
От: Oliver Jowett
Дата:
Сообщение: Re: detecting SQL system
FAQ