Thread: Re: Staroffice compatability
Hmmm... It says on the requirements page that users have used DbVisualizer with PostgreSQL before. Hold on... Okay. I'm running Sparc Solaris 8 (07/01 build), with the latest patch cluster, the recommend Java patches, and Java 1.3(1.3.1_01 to be precise) and I'm getting exceptions when I even try to install it --- let alone trying to get it to accessPostgreSQL. Screenshots look cool, though... Wyatt > > Hi Dave, > > One of the best tools I've found that "needs to work" with PostgreSQL is > DbVisualizer : > > http://www.ideit.com/products/dbvis/ > > Truly awesome, free Java based tool for doing ERD type stuff. > > :) > > Regards and best wishes, > > Justin Clift > > Dave Cramer wrote: > > > > Ok, with the latest changes and some logging added to the driver I have > > been able to fix the driver to work with staroffice6 beta > > > > I am having some difficulty getting it to work with druid however. At > > this point druid won't even load the driver. I am pretty confident that > > I can get around this today. > > > > Are there any other tools out there that people are using that I can > > check for compatability with? > > > > Dave > > -- > "My grandfather once told me that there are two kinds of people: those > who work and those who take the credit. He told me to try to be in the > first group; there was less competition there." > - Indira Gandhi > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
Hi Wyatt, I've only tried it on Mandrake 7.2 systems, running either JDK 1.2.2 or JDK 1.3.1. I remember it didn't work using these JDK's, but it DID work using the version that comes with its own JDK. Don't know if the same would apply to Solaris though. :) Regards and best wishes, Justin Clift wyatt@draggoo.com wrote: > > Hmmm... It says on the requirements page that users have used DbVisualizer with PostgreSQL before. Hold on... > > Okay. I'm running Sparc Solaris 8 (07/01 build), with the latest patch cluster, the recommend Java patches, and Java 1.3(1.3.1_01 to be precise) and I'm getting exceptions when I even try to install it --- let alone trying to get it to accessPostgreSQL. Screenshots look cool, though... > > Wyatt > > > > > Hi Dave, > > > > One of the best tools I've found that "needs to work" with PostgreSQL is > > DbVisualizer : > > > > http://www.ideit.com/products/dbvis/ > > > > Truly awesome, free Java based tool for doing ERD type stuff. > > > > :) > > > > Regards and best wishes, > > > > Justin Clift > > > > Dave Cramer wrote: > > > > > > Ok, with the latest changes and some logging added to the driver I have > > > been able to fix the driver to work with staroffice6 beta > > > > > > I am having some difficulty getting it to work with druid however. At > > > this point druid won't even load the driver. I am pretty confident that > > > I can get around this today. > > > > > > Are there any other tools out there that people are using that I can > > > check for compatability with? > > > > > > Dave > > > > -- > > "My grandfather once told me that there are two kinds of people: those > > who work and those who take the credit. He told me to try to be in the > > first group; there was less competition there." > > - Indira Gandhi > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
I've gotten DBVisualizer to connect easily enough, but it has problems with the metadata. In my case, DBVis is running on a windows PC with Sun's 1.3.1 JRE and connecting to a PGSQL 7.1 database on Debian Linux. It seems to choke on the metadata problems in the JDBC driver, but at least connects nicely. (I know I'm connecting because I can use the "SQL commander" part of DBVis to look at my tables without a problem.) I'm excited to hear that you've got the MetaData part working... I guess it's time for me to learn how to compile my own driver instead of downloading the last stable jar. Is there source out there that will work with 7.1, or do I need to upgrade my PGSQL to 7.2 before I can start? -Nick > -----Original Message----- > From: pgsql-jdbc-owner@postgresql.org > [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of wyatt@draggoo.com > Sent: Tuesday, October 30, 2001 10:28 PM > To: justin@postgresql.org > Cc: pgsql-jdbc@postgresql.org > Subject: Re: [JDBC] Staroffice compatability > > > Hmmm... It says on the requirements page that users have used > DbVisualizer with PostgreSQL before. Hold on... > > Okay. I'm running Sparc Solaris 8 (07/01 build), with the latest > patch cluster, the recommend Java patches, and Java 1.3 (1.3.1_01 > to be precise) and I'm getting exceptions when I even try to > install it --- let alone trying to get it to access PostgreSQL. > Screenshots look cool, though... > > Wyatt > > > > > Hi Dave, > > > > One of the best tools I've found that "needs to work" with PostgreSQL is > > DbVisualizer : > > > > http://www.ideit.com/products/dbvis/ > > > > Truly awesome, free Java based tool for doing ERD type stuff. > > > > :) > > > > Regards and best wishes, > > > > Justin Clift > > > > Dave Cramer wrote: > > > > > > Ok, with the latest changes and some logging added to the > driver I have > > > been able to fix the driver to work with staroffice6 beta > > > > > > I am having some difficulty getting it to work with druid however. At > > > this point druid won't even load the driver. I am pretty > confident that > > > I can get around this today. > > > > > > Are there any other tools out there that people are using that I can > > > check for compatability with? > > > > > > Dave > > > > -- > > "My grandfather once told me that there are two kinds of people: those > > who work and those who take the credit. He told me to try to be in the > > first group; there was less competition there." > > - Indira Gandhi > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
Nick, I think you will need to wait a few days. Dave hasn't yet checked in his fixes for this. Once he does, I will make new builds of the jar files and post them on jdbc.postgresql.org. The 7.2 jars should be backwardly compatible with a 7.1 database. We have tried in this release to provide backward compatibility. The 7.2 driver should also work against 7.0 (at least as well as the 7.1 driver worked against 7.0). thanks, --Barry Nick Fankhauser wrote: > I've gotten DBVisualizer to connect easily enough, but it has problems with > the metadata. > > In my case, DBVis is running on a windows PC with Sun's 1.3.1 JRE and > connecting to a PGSQL 7.1 database on Debian Linux. It seems to choke on the > metadata problems in the JDBC driver, but at least connects nicely. (I know > I'm connecting because I can use the "SQL commander" part of DBVis to look > at my tables without a problem.) > > I'm excited to hear that you've got the MetaData part working... I guess > it's time for me to learn how to compile my own driver instead of > downloading the last stable jar. Is there source out there that will work > with 7.1, or do I need to upgrade my PGSQL to 7.2 before I can start? > > -Nick > > >>-----Original Message----- >>From: pgsql-jdbc-owner@postgresql.org >>[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of wyatt@draggoo.com >>Sent: Tuesday, October 30, 2001 10:28 PM >>To: justin@postgresql.org >>Cc: pgsql-jdbc@postgresql.org >>Subject: Re: [JDBC] Staroffice compatability >> >> >>Hmmm... It says on the requirements page that users have used >>DbVisualizer with PostgreSQL before. Hold on... >> >>Okay. I'm running Sparc Solaris 8 (07/01 build), with the latest >>patch cluster, the recommend Java patches, and Java 1.3 (1.3.1_01 >>to be precise) and I'm getting exceptions when I even try to >>install it --- let alone trying to get it to access PostgreSQL. >>Screenshots look cool, though... >> >>Wyatt >> >> >>>Hi Dave, >>> >>>One of the best tools I've found that "needs to work" with PostgreSQL is >>>DbVisualizer : >>> >>>http://www.ideit.com/products/dbvis/ >>> >>>Truly awesome, free Java based tool for doing ERD type stuff. >>> >>>:) >>> >>>Regards and best wishes, >>> >>>Justin Clift >>> >>>Dave Cramer wrote: >>> >>>>Ok, with the latest changes and some logging added to the >>>> >>driver I have >> >>>>been able to fix the driver to work with staroffice6 beta >>>> >>>>I am having some difficulty getting it to work with druid however. At >>>>this point druid won't even load the driver. I am pretty >>>> >>confident that >> >>>>I can get around this today. >>>> >>>>Are there any other tools out there that people are using that I can >>>>check for compatability with? >>>> >>>>Dave >>>> >>>-- >>>"My grandfather once told me that there are two kinds of people: those >>>who work and those who take the credit. He told me to try to be in the >>>first group; there was less competition there." >>> - Indira Gandhi >>> >>>---------------------------(end of broadcast)--------------------------- >>>TIP 6: Have you searched our list archives? >>> >>>http://archives.postgresql.org >>> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 6: Have you searched our list archives? >> >>http://archives.postgresql.org >> >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > >