Member Avatar for mmiikkee12

I just got a JSP hosting account and I'm wondering how I can connect to the PostgreSQL DB and execute queries. According to the host's FAQ, the database URL is:
jdbc:postgresql://localhost/username,username,password
.

  • 2 Contributors
  • 4 Replies
  • 134 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by mmiikkee12
Member Avatar for keibi

You don't access databases through JSP. JSP comes paired up with servlets written in Java. The servlets (and underlying classes) does all the heavy work, while the JSPs just view the results.

Member Avatar for mmiikkee12

You can't just do it with

<%
DB access code here
%>

?

Member Avatar for keibi

No idea, I never tried. I manage my database connections with Hibernate (persistence framework), and put only view code in the jsp's.

Member Avatar for mmiikkee12

Anyway, what's the Java code for accessing the DB?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.