| Connectivity to PostgreSQL? [message #6983] |
Sun, 15 January 2006 04:18  |
Eclipse User |
|
|
|
Hi,
Is there a way to connect to a PostgreSQL database? If so, where can I
find any software/docs/howto's/examples ? If not, is there anyone
working at such connectivity?
TIA
Joost
|
|
|
| Re: Connectivity to PostgreSQL? [message #7057 is a reply to message #6983] |
Wed, 18 January 2006 11:36  |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Joost Kraaijeveld wrote:
> Hi,
> Is there a way to connect to a PostgreSQL database? If so, where can I
> find any software/docs/howto's/examples ? If not, is there anyone
> working at such connectivity?
> TIA
> Joost
Joost,
I was able to get a very rudimentary connection to a PostgreSQL database
by creating a driver definition (choose "Apache Derby" then change the
name and values). The following values where specified:
Driver File: <point at your JDBC driver for PostgreSQL>
Driver Class: org.postgresql.Driver
Datbase Name: postgres
Connection URL: jdbc:postgresql:postgres
User ID: postgres
Password: <your password>
Upon connection, I was able to expand down to the "Schemas" level in the
Data Source Explorer. The reason why a full tree is not shown is because
we do not yet have a generic JDBC model and content provider. We are
working on these currently, and hope to have them available in the near
term. Once this is in place, then you should be able to connect to any
JDBC enabled database and get a tree in the Data Source Explorer that
shows essential content based on JDBC. The idea would then be to
specialize this model and content provider for particular databases, to
enable access to specific characteristics and features.
-- John Graham
Eclipse Data Tools Platform PMC
Sybase, Inc.
|
|
|
| Re: Connectivity to PostgreSQL? [message #7103 is a reply to message #7057] |
Thu, 19 January 2006 11:31 |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Update: We expect to have the generic JDBC functionality available in the
M3 build on 1/20.
Regards,
John Graham
Eclipse Data Tools Platform PMC
Sybase, Inc.
John Graham wrote:
> Joost Kraaijeveld wrote:
>> Hi,
>> Is there a way to connect to a PostgreSQL database? If so, where can I
>> find any software/docs/howto's/examples ? If not, is there anyone
>> working at such connectivity?
>> TIA
>> Joost
> Joost,
> I was able to get a very rudimentary connection to a PostgreSQL database
> by creating a driver definition (choose "Apache Derby" then change the
> name and values). The following values where specified:
> Driver File: <point at your JDBC driver for PostgreSQL>
> Driver Class: org.postgresql.Driver
> Datbase Name: postgres
> Connection URL: jdbc:postgresql:postgres
> User ID: postgres
> Password: <your password>
> Upon connection, I was able to expand down to the "Schemas" level in the
> Data Source Explorer. The reason why a full tree is not shown is because
> we do not yet have a generic JDBC model and content provider. We are
> working on these currently, and hope to have them available in the near
> term. Once this is in place, then you should be able to connect to any
> JDBC enabled database and get a tree in the Data Source Explorer that
> shows essential content based on JDBC. The idea would then be to
> specialize this model and content provider for particular databases, to
> enable access to specific characteristics and features.
> -- John Graham
> Eclipse Data Tools Platform PMC
> Sybase, Inc.
|
|
|
|
|
|
|
|
| Re: Connectivity to PostgreSQL? [message #569675 is a reply to message #6983] |
Wed, 18 January 2006 11:36 |
| Eclipse User |
|
|
|
Joost Kraaijeveld wrote:
> Hi,
> Is there a way to connect to a PostgreSQL database? If so, where can I
> find any software/docs/howto's/examples ? If not, is there anyone
> working at such connectivity?
> TIA
> Joost
Joost,
I was able to get a very rudimentary connection to a PostgreSQL database
by creating a driver definition (choose "Apache Derby" then change the
name and values). The following values where specified:
Driver File: <point at your JDBC driver for PostgreSQL>
Driver Class: org.postgresql.Driver
Datbase Name: postgres
Connection URL: jdbc:postgresql:postgres
User ID: postgres
Password: <your password>
Upon connection, I was able to expand down to the "Schemas" level in the
Data Source Explorer. The reason why a full tree is not shown is because
we do not yet have a generic JDBC model and content provider. We are
working on these currently, and hope to have them available in the near
term. Once this is in place, then you should be able to connect to any
JDBC enabled database and get a tree in the Data Source Explorer that
shows essential content based on JDBC. The idea would then be to
specialize this model and content provider for particular databases, to
enable access to specific characteristics and features.
-- John Graham
Eclipse Data Tools Platform PMC
Sybase, Inc.
|
|
|
| Re: Connectivity to PostgreSQL? [message #569754 is a reply to message #7057] |
Thu, 19 January 2006 11:31 |
| Eclipse User |
|
|
|
Update: We expect to have the generic JDBC functionality available in the
M3 build on 1/20.
Regards,
John Graham
Eclipse Data Tools Platform PMC
Sybase, Inc.
John Graham wrote:
> Joost Kraaijeveld wrote:
>> Hi,
>> Is there a way to connect to a PostgreSQL database? If so, where can I
>> find any software/docs/howto's/examples ? If not, is there anyone
>> working at such connectivity?
>> TIA
>> Joost
> Joost,
> I was able to get a very rudimentary connection to a PostgreSQL database
> by creating a driver definition (choose "Apache Derby" then change the
> name and values). The following values where specified:
> Driver File: <point at your JDBC driver for PostgreSQL>
> Driver Class: org.postgresql.Driver
> Datbase Name: postgres
> Connection URL: jdbc:postgresql:postgres
> User ID: postgres
> Password: <your password>
> Upon connection, I was able to expand down to the "Schemas" level in the
> Data Source Explorer. The reason why a full tree is not shown is because
> we do not yet have a generic JDBC model and content provider. We are
> working on these currently, and hope to have them available in the near
> term. Once this is in place, then you should be able to connect to any
> JDBC enabled database and get a tree in the Data Source Explorer that
> shows essential content based on JDBC. The idea would then be to
> specialize this model and content provider for particular databases, to
> enable access to specific characteristics and features.
> -- John Graham
> Eclipse Data Tools Platform PMC
> Sybase, Inc.
|
|
|
|
| Re: Connectivity to PostgreSQL? [message #569813 is a reply to message #7126] |
Fri, 20 January 2006 17:29 |
| Eclipse User |
|
|
|
Joost Kraaijeveld wrote:
> John Graham wrote:
>> Update: We expect to have the generic JDBC functionality available in
>> the M3 build on 1/20.
> I am looking forward to it.
Joost,
It's there in M3! :-) If you create a generic JDBC driver definition
using the values mentioned earlier in this thread, then a connection
profile based on that, then I am able to get a full content tree in DSE.
Regards,
John Graham
Eclipse Data Tools Platform PMC
Sybase, Inc.
|
|
|
| Re: Connectivity to PostgreSQL? [message #569989 is a reply to message #7148] |
Sat, 21 January 2006 10:33 |
| Eclipse User |
|
|
|
Hi John,
John Graham wrote:
> It's there in M3! :-) If you create a generic JDBC driver definition
> using the values mentioned earlier in this thread, then a connection
> profile based on that, then I am able to get a full content tree in DSE.
Yep, I get a tree also. The columns of the tables however do not show
the correct types (it displays "bigint" for "text") . I also get the
same exception as Haris Peco.
Is there a document that descibes clearly what to expect from this and
the final release of the DTP in terms of functionality?
Joost
|
|
|
| Re: Connectivity to PostgreSQL? [message #570385 is a reply to message #7262] |
Thu, 26 January 2006 10:05 |
| Eclipse User |
|
|
|
Hi Joost,
> Yep, I get a tree also. The columns of the tables however do not show
> the correct types (it displays "bigint" for "text") . I also get the
> same exception as Haris Peco.
We are investigating why the correct types are not displayed. The
exception noticed by Haris has been fixed, and that code will appear in
the next iteration build this week.
> Is there a document that descibes clearly what to expect from this and
> the final release of the DTP in terms of functionality?
There's a variety of documents on the three DTP project sites (Model Base,
Connectivity, SQL Dev) about plans and designs -- we do not have a
consolidated document for these. For generic JDBC connections we intend to
show a base amount of information that the generic models can deliver
without further database-specific specialization. We hope that this it
useful in itself, and also serves as a base where the community can build
out specializations for particular databases.
Regards,
John Graham
Eclipse Data Tools Platform PMC
|
|
|
|
Powered by
FUDForum. Page generated in 0.08026 seconds
Home