Thread: ΑΠ: ΑΠ: [JDBC] Postgres and JBuilderX onLinux
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
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
Hello, I'have got the same problem for loading the postgres driver and the oracle driver in my Intranet web application (at run time, the error was unsuitable driver). This occurs because in java 1.3 the drivers were loaded with a system.setProperties method instead of a class.forName in Jbuilder9 with JDK1.4. We solved the problem now but I don't know if there is a better way to load the drivers. regards. Jean-Michel Zigna. At 12:05 24/02/2004 -0500, Dave Cramer wrote: >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 > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)