JSP, EJB in Jboss 4 with mySQL database. Error in connecting to database

Hi, i using JBoss 4-0-1 with jsp and mySQL database. I get this example from a book using stateless session beans. However i modify it so it can connect to mySQL database.

This is my code for jsp.

<%@ page import="asg.MusicEJB.*,

java.util.*,

javax.naming.Context,

javax.naming.InitialContext,

javax.rmi.PortableRemoteObject" errorPage="error.jsp" %>

<%--

The following 3 variables appear in a JSP declaration.

They appear outside the generated _jspService() method,

which gives themclass scope.

Since we want to initialize our Music EJB object once

and read the Music Collection database to get the

recording titles once, we placethis code inside

method jspInit().

The EJB business method getMusicList()

returns a collection of RecordingVO objects which we

store in ArrayList albums.

--%>

<%!

MusicHome musicHome;

Music mymusic;

ArrayList albums;

Properties properties=new Properties();

publicvoid jspInit(){

properties.put(Context.INITIAL_CONTEXT_FACTORY,"org.jnp.interfaces.NamingContextFactory");

properties.put(Context.PROVIDER_URL,"localhost:3306");

System.out.println("............................in properties");

try{

//Context initial = new InitialContext();

InitialContext jndiContext =new InitialContext(properties);

//Object ref = jndiContext.lookup("MusicEJB");

Object objref = jndiContext.lookup("java:comp/env/ejb/EJBMusic");

musicHome = (MusicHome)PortableRemoteObject.narrow(objref, MusicHome.class);

mymusic = musicHome.create();

albums = mymusic.getMusicList();

System.out.println(".............................in line 64");

}catch (Exception ex){

System.out.println("Unexpected Exception............: " +

ex.getMessage());

ex.printStackTrace();

}

<%--

The following scriptlet accesses the implicit

request object to obtain the current URL

and saves it to the session objectfor later retrieval.

It also saves variable mymusic, so we can

make remote calls to our Music EJB, and the collection of

RecordingVO objects. These variables will all be available

to other pages within the session.

--%>

String requestURI = request.getRequestURI();

session.putValue("url", requestURI);

session.putValue("mymusic", mymusic);

session.putValue("albums", albums);

<html>

<head>

<title>Music Collection Database Using EJB & JSP Version 9.7</title>

</head>

<h1><b><center>Music Collection Database Using EJB & JSP</center></b></h1>

<hr>

There are <%= albums.size() %> recordings.

Select Music Recording:

// Generate html <option> elements with the recording

// titles stored in each RecordingVO element.

// Obtain the current title from the session object

// (this will be null the first time).

String title;

String currentTitle = (String)session.getValue("curTitle");

if (currentTitle ==null) currentTitle ="";

RecordingVO r;

Iterator i = albums.iterator();

while (i.hasNext()){

r = (RecordingVO)i.next();

title = r.getTitle();

if (title.equals(currentTitle)){

out.println("<option selected>" + title +"</option>");

}

else{

out.println("<option>" + title +"</option>");

}

</select>

<%--

Provide a"View Tracks" button to submit

the requested title to page musicPost.jsp

--%>

</form>

</body>

</html>

Message was edited by:

chongming

[5766 byte] By [chongminga] at [2007-10-3 1:32:49]

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

JSP, EJB in Jboss 4 with mySQL database. Error in connecting to database

Enterprise & Remote Computing New Topic

Enterprise & Remote Computing Hot Topic

Enterprise & Remote Computing

All Classified