Using java class in jsp

Question

I have java class having very simple method for database connection. Connection is established while using this code is jsp file but when i call this method from .java class it gives exception. the code i use to call that method is as fallow

  <% db d = new db();
d.db1("testing", "dspace", "dspace");
  %>

while the code is .java class is as fallow

 public boolean  db1 (String db, String username, String pwd) throws SQLException, ClassNotFoundException
                       {
            Connection connection; 

            Class.forName("org.postgresql.Driver");
            connection = DriverManager.getConnection(
                "jdbc:postgresql:5432//127.0.0.1:5432/testing", username,
                pwd);
            if(connection!= null)
                                   {
          System.out.println("done");
            }          
    return false;
    }

there error is

    org.apache.jasper.JasperException: PWC6033: Error in Javac compilation for JSP

You showed JSP code; show java code from where u calling db1() — Deepak Singhal, Jan 28 '13 at 06:39
The entire code of class `db` is not mentioned. So I will make some assumptions. If you have defined a custom constructor, make sure you explicitly put the default no argument constructor. — Santosh, Jan 28 '13 at 06:41
For better help sooner, post an [SSCCE](http://sscce.org/) (of JSP). — Andrew Thompson, Jan 28 '13 at 06:45
"error in javac compilation" is not the *cause* of the error. Please, post the cause, it should be there in the logs/output as well. — eis, Jan 28 '13 at 06:49
may be you don't have the postgre sql jar file in class path like we have it in mysql. — Bhavik Shah, Jan 28 '13 at 06:53
You Java code does not make a valid Java class, it only contains a single method declaration. Assuming you are only posting part of it. — Audrius Meškauskas, Jan 28 '13 at 06:57

score 1 · Answer 1 · answered Jan 28 '13 at 06:40

1

Try this

<% 
db d ;
try{
d = new db();
d.db1("testing", "dspace", "dspace");
}catch(Exception e){
 //do something
 }
  %>

As your code is not handling the runtime exceptions.

answered Jan 28 '13 at 06:40

TheWhiteRabbit

15,480
4
33
57

1

also `<%@page import="your.db.class" %>` – TheWhiteRabbit Jan 28 '13 at 06:42

score 1 · Answer 2 · answered Jan 28 '13 at 07:40

1

Shouldn't the DB URL be

"jdbc:postgresql://127.0.0.1:5432/testing"

instead of

"jdbc:postgresql:5432//127.0.0.1:5432/testing"

?

answered Jan 28 '13 at 07:40

TechSpellBound

2,505
6
25
36

score 0 · Answer 3 · answered Jan 28 '13 at 13:56

You are making a jar mistake i think but please show complete errors list Like below:

org.apache.jasper.JasperException: PWC6033: Error in Javac compilation for JSP

PWC6197: An error occurred at line: 9 in the jsp file: /index.jsp
PWC6199: Generated servlet error:
';' expected

More detail will ease us to solve your problem

score 0 · Answer 4 · answered Jan 28 '13 at 14:07

Try

 <% db d = new db();
    try{
       d.db1("testing", "dspace", "dspace");
    }catch(Exception e){
       //wtf?
    }
 %>

Even there are some cases not specified.

What if the connection is broken
What if the connection is closed
What if the connection is timedout
What if the connection is dirty
What if the database not available anymore
What if the database removed
What if the databaseserver not available
What if the databaseserver timed out
What if the user not available
What if the user has no right
...

Hey you can get rid of the db.java using jstl/sql and jndi.

score -3 · Answer 5 · answered Jan 28 '13 at 08:44

-3

I don't think so that you used Class.forname in JSP please try encapsulate

answered Jan 28 '13 at 08:44

kennedy

23
1
1
4

Using java class in jsp

5 Answers5