Hi Bruno,
Postgresql 8.0 and 8.1 works with Creator2, but you have to cast all Postgresql own datatypes to SQL standard datatypes (for example "text", "varchar" to "varchar(number)") or don't use such datatypes for columns in your tables. Because Creator doesn't support this. This issue was mentioned in Creator forum, try search "postgresql" at
http://swforum.sun.com/jive/forum.jspa?forumID=123Roman.
On 2/20/06, Bruno Tezine <bruno@madnet.com.br> wrote:Hi all,
I'm creating a project inside "Sun Java Studio Creator 2" that tries to connect to my PostgreSQL 8.1 database using jdbc "8.1-405 jdbc3". When I create the datasource, it works fine and all my tables are displayed and tested ok, but when I add any visual component such as a table or drop down list into the designer, the "data bind" finds the datatable I want to use, but when I select it, it shows in red and do not allow me to add any column to the visual table. It seems to be a jdbc problem because the "data bind" allow me to add tables from other databases.
Does anybody know if postgresql jdbc already support "Sun Java Studio Creator 2"? I already tried with version 8.0 and 8.2 also.
Any help? :-)
Thanks in advance,
Bruno.