• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

First try with Glassfish and Postgresql

 
Ranch Hand
Posts: 159
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi - I'm trying for the first time to use a database with JSF and Glassfish. However, before I try writing any code, I wanted to test out the code in chapter 10 of "Core JavaServer Faces" to see if database access works with my configuration, and it does not!

I configured the server as given in the book, and specified the JNDI name as "jdbc/mydb", and compiled the code provided, created a war file and deployed it. Online I found a file called "postgresql-8.3dev-601.jdbc4.jar.zip", copied it to my "/glassfish/domains/domain1/lib/ext/" folder, as instructed and started the server and the application. However, after starting the application and attempting to log in on its test page, I get the "Internal Error" message produced by the code. In checking the log at localhost:4848 I get various error messages saying that the connection was refused, including that I should check TCP/IP.

Could someone kindly advise me on what is going wrong, as until I can get an example running from the book, I can't go any further. The book says on page 466 that I first have to create a table with a few entries, with an example given, but nothing is said as to how I can do that.

Some help would be most appreciated.

Christopher Sharp
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Christopher,
Can you access Postgresql through the command line? Do you have Glassfish configured to connect to Postgresql on the correct port.
 
Christopher Sharp
Ranch Hand
Posts: 159
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Jeanne Boyarsky:
Christopher,
Can you access Postgresql through the command line? Do you have Glassfish configured to connect to Postgresql on the correct port.



Hi Jeanne,

The whole problem is that I'm new to this and I don't know how to configure Glassfish to work with Postgresql, even though I followed the instructions in Geary and Hortmann.

I'm also unable to run Postgresql from the command line. I have Ubunto Linux, and installed postgresql version 8.3.0-1~feisty1 using the Synaptic Package Manager. I found that it installed a large number of files, including the executable posgres in the path /usr/lib/postgresql/8.3/bin . In attempting to execute this from root I get the message that it can only be started as an unprivileged user. When I attempt to execute it as a normal user it complains that I need to specify the --config-file or -D invocation or set the PGDATA environment varaible.

Also I don't know what connection port to use. For some reason Geary and Horstmann give 5432 in figure 10-2 on page 458, and I used exactly what they gave.

Christopher
 
Jeanne Boyarsky
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Christopher,
I'm replying to the part about postgresql here. You might want to start a new thread in an app server forum (below on the forum list) for how to configure Glassfish. In general, I usual troubleshoot the database part first anyway. After all, you can't connect to a db through the server if the database isn't up!

When using postgresql, there are two parts.
1) Starting up postgresql - either as a service/startup script/cron job or through the provided "start postgresql" script. Does this work?
2) Next you access the database through a client. I think psql.exe comes bundled. (I'm not sure because I downloaded the bundle with a GUI client too.) The command for starting psql at the command line is:
PostgreSQL\8.2\bin> psql.exe" -h localhost -p <port> user password
 
reply
    Bookmark Topic Watch Topic
  • New Topic