All-
I have been having a horrible time trying to use the JDBC drivers (I have
tried pgjdbc7.2.jar, devpgjdbc2.jar, jdbc7.1-1.2.jar from
http://jdbc.postgresql.org/download.html; jdbc7.1-1.3 from
http://jdbc.fastcrypt.com/ and jxDBCon-net-jdbc2-0.9c.jar from sourceforge)
within the Forte development IDE (3.0 but with the latest modules and
patches running under windows2000). I have tried these drivers against
postgresql7.1.3 and 7.2 running under redhat 7.1.
The specific problem is that when it comes time to generate java classes
(based on the schema that has been automatically read into the ide). The
system either generates a few classes (but not all of them based on the
total number of tables) but then seems to have problems because it states
that the FK references a unique key and there are also problems because it
doesn't see the other tables that it needs to make the classes. This is the
best case senario. In the worst case senario no java classes are generated
(depending on the driver).
When the schema is read in, it does see all the tables although it doesn't
seem to see the columns on a few of the tables (which coincidentally are
also missed when the generate java classes options is selected.)
Therefore, it seems that within Forte the calls through the drivers
specifically to get column info on the tables is somehow only partially
working.
Any suggestions would be most helpful. At this point I am also checking out
the latest driver code and compiling that to see if it will work.
-Beth