Thread: Browsing postgres database using the Eclipse QuantumDB plugin
Has anyone successfully connected and browsed a postgres database using the Eclipse QuantumDB plugin? I can connect and execute sql, but the existing table list is always empty as if no meta information is ever provided to the browser plugin. At first, I thought it might be a permission problem with the database user I provided, so I also tried it with the postgres user, but had the same results. I've always had QuantumDB work with Oracle, hsqldb, h2database, and other platforms.
On 11/22/2013 05:46 AM, Mike Kienenberger wrote: > Has anyone successfully connected and browsed a postgres database > using the Eclipse QuantumDB plugin? You might get a answer sooner here: http://sourceforge.net/p/quantum/discussion/24178/ > > I can connect and execute sql, but the existing table list is always > empty as if no meta information is ever provided to the browser > plugin. At first, I thought it might be a permission problem with > the database user I provided, so I also tried it with the postgres > user, but had the same results. > > I've always had QuantumDB work with Oracle, hsqldb, h2database, and > other platforms. > > -- Adrian Klaver adrian.klaver@gmail.com
Em 22/11/2013 12:54, Adrian Klaver escreveu: > On 11/22/2013 05:46 AM, Mike Kienenberger wrote: >> Has anyone successfully connected and browsed a postgres database >> using the Eclipse QuantumDB plugin? > > You might get a answer sooner here: > > http://sourceforge.net/p/quantum/discussion/24178/ > >> >> I can connect and execute sql, but the existing table list is always >> empty as if no meta information is ever provided to the browser >> plugin. At first, I thought it might be a permission problem with >> the database user I provided, so I also tried it with the postgres >> user, but had the same results. >> >> I've always had QuantumDB work with Oracle, hsqldb, h2database, and >> other platforms. >> >> > > Or you can try NetBeans 7.4 (perhaps, 7.4.1 is being released soon). Works like a charm for me. Regards, Edson
I wanted to make sure that it wasn't a permission configuration problem in postgres first, since all of the other databases have worked without a similar issue. On Fri, Nov 22, 2013 at 9:54 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote: > On 11/22/2013 05:46 AM, Mike Kienenberger wrote: >> >> Has anyone successfully connected and browsed a postgres database >> using the Eclipse QuantumDB plugin? > > > You might get a answer sooner here: > > http://sourceforge.net/p/quantum/discussion/24178/ > > >> >> I can connect and execute sql, but the existing table list is always >> empty as if no meta information is ever provided to the browser >> plugin. At first, I thought it might be a permission problem with >> the database user I provided, so I also tried it with the postgres >> user, but had the same results. >> >> I've always had QuantumDB work with Oracle, hsqldb, h2database, and >> other platforms. >> >> > > > -- > Adrian Klaver > adrian.klaver@gmail.com
Adrian, Thanks! Searching through those forum posts (I had tried doing general google searches first before posting here, but didn't turn up that forum) I found this: http://sourceforge.net/p/quantum/discussion/24178/thread/17724b28/?limit=25#1166 which seems to indicate that at least back in 2007, there was an issue with the quantum support for postgres. Perhaps that's still the case with the version I am using. On Fri, Nov 22, 2013 at 10:28 AM, Mike Kienenberger <mkienenb@gmail.com> wrote: > I wanted to make sure that it wasn't a permission configuration > problem in postgres first, since all of the other databases have > worked without a similar issue. > > > On Fri, Nov 22, 2013 at 9:54 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote: >> On 11/22/2013 05:46 AM, Mike Kienenberger wrote: >>> >>> Has anyone successfully connected and browsed a postgres database >>> using the Eclipse QuantumDB plugin? >> >> >> You might get a answer sooner here: >> >> http://sourceforge.net/p/quantum/discussion/24178/ >> >> >>> >>> I can connect and execute sql, but the existing table list is always >>> empty as if no meta information is ever provided to the browser >>> plugin. At first, I thought it might be a permission problem with >>> the database user I provided, so I also tried it with the postgres >>> user, but had the same results. >>> >>> I've always had QuantumDB work with Oracle, hsqldb, h2database, and >>> other platforms. >>> >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@gmail.com