Thread: ΑΠ: ΑΠ: ΑΠ: [JDBC]Postgres and JBuilderX onLinux
when i'm adding a database and trying to establish a connection i can only choose between com.borland.datastore.jdbc.DataStoreDriver, interbase.interclient.Driver etc at the driver combo box Same happens when i try to use database pilot and add a new URL How can i add postgresql driver in that list? -----Αρχικό μήνυμα----- Από: "Dave Cramer" <pg@fastcrypt.com> Αποστολή: Τρίτη, 24 Φεβρουαρίου 2004 5:05 μμ Προς: "kstergiou@in.gr" <kstergiou@in.gr> Κοιν.: "pgsql-jdbc@postgresql.org" <pgsql-jdbc@postgresql.org> Θέμα: Re: ΑΠ: ΑΠ: [JDBC]Postgres and JBuilderX onLinux I'm not sure what you mean by other drivers ?? Which screen? dave On Tue, 2004-02-24 at 12:01, kstergiou@in.gr wrote: > thenks for the advice > Now i can use the driver through jbuilder but still > i can't see it with the other drivers (oracle, db2 etc) > this might be a CLASSPATH problem or i must declare it > somewhere else also? > > regards > > > > -----Αρχικό μήνυμα----- > Από: "Dave Cramer" <pg@fastcrypt.com> > Αποστολή: Τρίτη, 24 Φεβρουαρίου 2004 12:26 μμ > Προς: "kstergiou@in.gr" <kstergiou@in.gr> > Θέμα: Re: ΑΠ: [JDBC] Postgres and JBuilderX onLinux > > Ok, > > First create a library for postgres > > project-> properties -> required libraries -> new library > > then > > in the tools->enterprise setup add a new database driver and choose the > postgres library, jbuilder will create the postgresql.config file for > you > > Dave > On Tue, 2004-02-24 at 05:19, kstergiou@in.gr wrote: > > I copied the .jar file in JBuilderX/lib (i tried also JbuilderX/lib/ext) then > > from menu i chose Tools -> Enterprise Setup and i added the driver > > I can't see the postgres jdbc with the other drivers (interbase, oracle, etc) > > but i haven't tried to add it manually in the code. > > > > JBuilder help says that i need a postgres.config file so it will be built > > the libraries it needs. > > > > How can i add pgsql driver with the others so i can access the db from jbuilder tools? > > > > When i try to access the db from programs i wrote outside jbuilder everything > > works ok. > > > > > > > > -----Αρχικό μήνυμα----- > > Από: "pgsql-jdbc-owner@postgresql.org" <pgsql-jdbc-owner@postgresql.org> εκ μέρους "Dave Cramer" <pg@fastcrypt.com> > > Αποστολή: Τρίτη, 24 Φεβρουαρίου 2004 2:15 πμ > > Προς: "kstergiou@in.gr" <kstergiou@in.gr> > > Κοιν.: "pgsql-jdbc@postgresql.org" <pgsql-jdbc@postgresql.org> > > Θέμα: Re: [JDBC] Postgres and JBuilderX on Linux > > > > what did you try? I set it up in a few seconds ? > > > > Dave > > On Mon, 2004-02-23 at 20:30, kstergiou@in.gr wrote: > > > I'm trying to setup the jdbc driver for postgres on jbuilder > > > i followed the advice from jbuilder help but i failed. I only have the jar > > > file and i think i need the postgres.config also but i don't know where to find > > > it. Can someone inform me how or where to find it ? > > > If there is any other way to do it please tell me how to do it > > > > > > Any help will be really appreciated > > > > > > Thanks in advance > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 5: Have you checked our extensive FAQ? > > > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > > -- Dave Cramer 519 939 0336 ICQ # 14675561
OK, I guess I learn something new here too, in the database pilot, select options and then add the driver and sample url, then it will be available. Dave On Wed, 2004-02-25 at 06:12, kstergiou@in.gr wrote: > when i'm adding a database and trying to establish a connection > i can only choose between com.borland.datastore.jdbc.DataStoreDriver, > interbase.interclient.Driver etc at the driver combo box > Same happens when i try to use database pilot and add a new URL > How can i add postgresql driver in that list? > > > > > -----Αρχικό μήνυμα----- > Από: "Dave Cramer" <pg@fastcrypt.com> > Αποστολή: Τρίτη, 24 Φεβρουαρίου 2004 5:05 μμ > Προς: "kstergiou@in.gr" <kstergiou@in.gr> > Κοιν.: "pgsql-jdbc@postgresql.org" <pgsql-jdbc@postgresql.org> > Θέμα: Re: ΑΠ: ΑΠ: [JDBC]Postgres and JBuilderX onLinux > > I'm not sure what you mean by other drivers ?? > > Which screen? > > dave > On Tue, 2004-02-24 at 12:01, kstergiou@in.gr wrote: > > thenks for the advice > > Now i can use the driver through jbuilder but still > > i can't see it with the other drivers (oracle, db2 etc) > > this might be a CLASSPATH problem or i must declare it > > somewhere else also? > > > > regards > > > > > > > > -----Αρχικό μήνυμα----- > > Από: "Dave Cramer" <pg@fastcrypt.com> > > Αποστολή: Τρίτη, 24 Φεβρουαρίου 2004 12:26 μμ > > Προς: "kstergiou@in.gr" <kstergiou@in.gr> > > Θέμα: Re: ΑΠ: [JDBC] Postgres and JBuilderX onLinux > > > > Ok, > > > > First create a library for postgres > > > > project-> properties -> required libraries -> new library > > > > then > > > > in the tools->enterprise setup add a new database driver and choose the > > postgres library, jbuilder will create the postgresql.config file for > > you > > > > Dave > > On Tue, 2004-02-24 at 05:19, kstergiou@in.gr wrote: > > > I copied the .jar file in JBuilderX/lib (i tried also JbuilderX/lib/ext) then > > > from menu i chose Tools -> Enterprise Setup and i added the driver > > > I can't see the postgres jdbc with the other drivers (interbase, oracle, etc) > > > but i haven't tried to add it manually in the code. > > > > > > JBuilder help says that i need a postgres.config file so it will be built > > > the libraries it needs. > > > > > > How can i add pgsql driver with the others so i can access the db from jbuilder tools? > > > > > > When i try to access the db from programs i wrote outside jbuilder everything > > > works ok. > > > > > > > > > > > > -----Αρχικό μήνυμα----- > > > Από: "pgsql-jdbc-owner@postgresql.org" <pgsql-jdbc-owner@postgresql.org> εκ μέρους "Dave Cramer" <pg@fastcrypt.com> > > > Αποστολή: Τρίτη, 24 Φεβρουαρίου 2004 2:15 πμ > > > Προς: "kstergiou@in.gr" <kstergiou@in.gr> > > > Κοιν.: "pgsql-jdbc@postgresql.org" <pgsql-jdbc@postgresql.org> > > > Θέμα: Re: [JDBC] Postgres and JBuilderX on Linux > > > > > > what did you try? I set it up in a few seconds ? > > > > > > Dave > > > On Mon, 2004-02-23 at 20:30, kstergiou@in.gr wrote: > > > > I'm trying to setup the jdbc driver for postgres on jbuilder > > > > i followed the advice from jbuilder help but i failed. I only have the jar > > > > file and i think i need the postgres.config also but i don't know where to find > > > > it. Can someone inform me how or where to find it ? > > > > If there is any other way to do it please tell me how to do it > > > > > > > > Any help will be really appreciated > > > > > > > > Thanks in advance > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > > TIP 5: Have you checked our extensive FAQ? > > > > > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > > > -- Dave Cramer 519 939 0336 ICQ # 14675561
To get your app to see the PG driver, you can use the Add Library, but to get the *IDE* to see it for design, make a file called Postgres.config in /.../JBuilderX/lib/ext with the line addpath C:\Documents and Settings\Andrew Lazarus\jbproject\classes\pg74.1jdbc3.jar (obviously modified for your own paths; works on Unix with forward slashes). The pay versions of JBuilder are supposed to generate the config file when you add the library, but the free one won't.