Thread: JBuilder4 JDBC Explorer
Is anybody able to access Postgresql from the JBuilder4 Explorer? I have the following settings Driver: org.postgresql.Driver URL: jdbc:postgresql://localhost:5432/databasename It says: The driver: org.postgresql.Driver could not be loaded. This could be a problem with the driver itself or that the driver is not on the classpath. I have confirmed that I have included the most recent .jar file on my classpath (jdbc7.0-1.1.jar) I have also tried just postgresql.Driver as the Driver name.... and I get the same thing. What could be the problem?
I had a devil of an annoying time getting JBuilder to do this. Part of my problem was that I had installed JBuilder in /usr/local (I run it on Linux) owned by root, and for some operations it needs to be owned by the person running it. I could get JDBC Explorer to run only when I ran JBuilder as root. I ended up reinstalling JBuilder into my /home directory, and then made a library for the postgres JDBC driver in "User Home" by going to Tools -> Configure Libraries. It then worked. If all else fails try copying your jdbc driver jar file into JAVA_HOME/jre/lib/ext Then it will be available automatically to all apps without needing to put it in a claspath, either at the command line or in your JBuilder configuration. Hope this helps! Norm -------------------------------------- Norman Clarke Combimatrix Corp Software Development Harbour Pointe Tech Center 6500 Harbour Heights Pkwy, Suite 301 Mukilteo, WA 98275 tel: 425.493.2240 fax: 425.493.2010 -------------------------------------- On Wed, 4 Apr 2001, John Menke wrote: > Is anybody able to access Postgresql from the JBuilder4 Explorer? I have > the following settings > > Driver: org.postgresql.Driver > URL: jdbc:postgresql://localhost:5432/databasename > > It says: > > The driver: org.postgresql.Driver could not be loaded. This could be a > problem with the driver itself or that the driver is not on the classpath. > > > I have confirmed that I have included the most recent .jar file on my > classpath (jdbc7.0-1.1.jar) > > I have also tried just postgresql.Driver as the Driver name.... and I get > the same thing. > > What could be the problem? > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
Norman, I have JBuilder connecting to Postgres with the JDBC Explorer, but all I can't see my tables... all I see are 6 system tables and a procedure table. Can you see all your tables? What Ir really want to do is use the EntityBean mapper with Postgres but this produces similar problems in that it connects but cannot see any tables. Am I using the wrong driver? I am using (jdbc7.0-1.1.jar) I have also tried (jdbc7.0-1.2.jar) and have the same problem. -----Original Message----- From: Norman J. Clarke [mailto:norman@combimatrix.com] Sent: Wednesday, April 04, 2001 9:13 PM To: John Menke Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] JBuilder4 JDBC Explorer I had a devil of an annoying time getting JBuilder to do this. Part of my problem was that I had installed JBuilder in /usr/local (I run it on Linux) owned by root, and for some operations it needs to be owned by the person running it. I could get JDBC Explorer to run only when I ran JBuilder as root. I ended up reinstalling JBuilder into my /home directory, and then made a library for the postgres JDBC driver in "User Home" by going to Tools -> Configure Libraries. It then worked. If all else fails try copying your jdbc driver jar file into JAVA_HOME/jre/lib/ext Then it will be available automatically to all apps without needing to put it in a claspath, either at the command line or in your JBuilder configuration. Hope this helps! Norm -------------------------------------- Norman Clarke Combimatrix Corp Software Development Harbour Pointe Tech Center 6500 Harbour Heights Pkwy, Suite 301 Mukilteo, WA 98275 tel: 425.493.2240 fax: 425.493.2010 -------------------------------------- On Wed, 4 Apr 2001, John Menke wrote: > Is anybody able to access Postgresql from the JBuilder4 Explorer? I have > the following settings > > Driver: org.postgresql.Driver > URL: jdbc:postgresql://localhost:5432/databasename > > It says: > > The driver: org.postgresql.Driver could not be loaded. This could be a > problem with the driver itself or that the driver is not on the classpath. > > > I have confirmed that I have included the most recent .jar file on my > classpath (jdbc7.0-1.1.jar) > > I have also tried just postgresql.Driver as the Driver name.... and I get > the same thing. > > What could be the problem? > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
John, I had the same problem when I was running 7.0.3 - I may be wrong, but it seems the driver's presentation of the system catalog is pretty limited, so that's what you're stuck with. The newer 7.1 driver does not suffer from this problem, but I am not sure if it's backwards-compatible with 7.0.3. I am running 7.1RC2 with its included JDBC driver and it works very nicely for me. Norm -------------------------------------- Norman Clarke Combimatrix Corp Software Development Harbour Pointe Tech Center 6500 Harbour Heights Pkwy, Suite 301 Mukilteo, WA 98275 tel: 425.493.2240 fax: 425.493.2010 -------------------------------------- On Wed, 4 Apr 2001, John Menke wrote: > Norman, I have JBuilder connecting to Postgres with the JDBC Explorer, but > all I can't see my tables... all I see are 6 system tables and a procedure > table. Can you see all your tables? What Ir really want to do is use the > EntityBean mapper with Postgres but this produces similar problems in that > it connects but cannot see any tables. Am I using the wrong driver? I am > using (jdbc7.0-1.1.jar) I have also tried (jdbc7.0-1.2.jar) and have the > same problem.
Note: I'm dropping General due to the volume of emails. Please ensure that all JDBC questions go to the pgsql-jdbc list. Quoting John Menke <john@eagleinfosystems.com>: > Is anybody able to access Postgresql from the JBuilder4 Explorer? As JBuilder is used to develop the driver now, yes ;-) > I > have > the following settings > > Driver: org.postgresql.Driver > URL: jdbc:postgresql://localhost:5432/databasename > > It says: > > The driver: org.postgresql.Driver could not be loaded. This could be a > problem with the driver itself or that the driver is not on the > classpath. > > > I have confirmed that I have included the most recent .jar file on my > classpath (jdbc7.0-1.1.jar) With JBuilder its different. You have to tell it about the driver. Not sure about the other versions, but for JBuilder 4 Enterprise: 1: Tools -> Configure Libraries Create a new library, call it PostgreSQL and add the jar file to the library. 2: Tools -> Enterprise Setup Switch to the Database Drivers tab, click add and select the PostgreSQL library. You should then see PostgreSQL.config appear. Click OK, then shutdown and restart JBuilder. > I have also tried just postgresql.Driver as the Driver name.... and I > get the same thing. No, all post 7.0 drivers have org. prefixing them. Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
Quoting "Norman J. Clarke" <norman@combimatrix.com>: > John, > > I had the same problem when I was running 7.0.3 - I may be wrong, but > it seems the driver's presentation of the system catalog is pretty > limited, so that's what you're stuck with. Partly the values passed to getTables() defining what are Tables, System tables etc are not defined in the standard, and also not having access to JBuilder until recently hampered fixing it. > The newer 7.1 driver does not suffer from this problem, but I am not > sure if it's backwards-compatible with 7.0.3. No, as the system tables in 7.1 differ to 7.0.x, and the queries behind some of the MetaData methods are different. > I am running 7.1RC2 with its > included JDBC driver and it works very nicely for me. Should do as JBuilder4 Enterprise is what I'm using as an IDE now. Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/