You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Scott Fitzgerald <sf...@roadrunner.nf.net> on 2001/04/26 20:34:16 UTC
Database access problem
Hi Folks,
For those of you with ten minutes to spare, please read on.
I'm having trouble with my database test app. As a background, I'm writing
my Action and ActionForm classes in Visual Age for Java, then exporting my
classes to the WEB-INF\classes directory of my application. Within the lib
directory I include struts.jar and the jdbc thin drivers in .zip format (if
these are not needed here please tell me).
I have tried to run this two ways. The first was using the datasource tag in
the struts-config.xml file. I included it right after my action-mappings and
form-beans tag, all of which are included inside the struts-config tags.
When I start my Tomcat server, I receive an error in the console that says
basically that there are illegal characters after my action-mapping tag ends
(I.e. the datasource tag). The console will also give me a class not found
exception at java.sql.Datasource. After I point my browser at the war file I
get an error stating that it can't find the ActionMappings or
ActionFormBeans collection.
The second way I tried to run this was by simply establishing a connection
to the database manually in my Action class and using
Class.forName(jdbcUrl). However, this time, when I try run the app it will
crap out when I try to do the actual query and give me a class not found
exception at Class.forName(jdbcUrl) at the Tomcat console. The browser gives
me a null pointer exception. I think I have all the required imports within
my classes.
Using the datasource tag looks like it should be very straight forward but
I'm having no joy. For anyone who has read this far, I apologize for the
length of the message. I have included my code from the struts-config.xml
file and my Action class perform() method.
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE struts-config PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.0//EN"
"http://jakarta.apache.org/struts/dtds/struts-config_1_0.dtd">
<struts-config>
<form-beans>
<form-bean name="databaseForm"
type="dbtest.DatabaseForm"/>
</form-beans>
<action-mappings>
<action path="/dbtest"
type="dbtest.DatabaseAction"
name="databaseForm">
<forward name="success" path="/success.jsp" />
<forward name="fail" path="/fail.jsp" />
</action>
</action-mappings>
<data-sources>
<data-source
key="dbtest"
autoCommit="false"
description="Database Test"
driverClass="oracle.jdbc.driver.OracleDriver"
maxCount="4"
minCount="2"
password="password"
url="jdbc:oracle:thin:@servername:1521:XXXX"
user="username"
/>
</data-sources>
</struts-config>
public ActionForward perform(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws javax.servlet.ServletException, java.io.IOException {
//String jdbcDriver = "oracle.jdbc.driver.OracleDriver";
//String jdbcUrl = "jdbc:oracle:thin:@servername:1521:XXXX";
java.sql.Connection myConnection = null;
DatabaseForm theForm = (DatabaseForm) form;
String id = theForm.getPackage_id();
String description =null;
java.sql.ResultSet rs = null;
try
{
javax.sql.DataSource dataSource = servlet.findDataSource("dbtest");
myConnection = dataSource.getConnection();
System.out.println("You are here #1");
//Class.forName(jdbcDriver);
//System.out.println("You are here #2");
//myConnection = java.sql.DriverManager.getConnection(jdbcUrl);
myConnection = dataSource.getConnection();
java.sql.PreparedStatement stmt =
myConnection.prepareStatement(
"Select package_description From Packages Where package_id=" + id);
rs = stmt.executeQuery();
if (rs.next())
{
description = rs.getString("Package_Description");
}
else
{
description = "Empty";
}
theForm.setPackage_description(description);
}
catch (java.sql.SQLException sqle)
{
getServlet().log("Connection.process", sqle);
}
//catch (ClassNotFoundException e)
//{
//}
catch (NullPointerException npe)
{
}
finally
{
try
{
myConnection.close();
}
catch (java.sql.SQLException e)
{
getServlet().log("Connection.close", e);
}
}
//if (description != null)
//{
return mapping.findForward("success");
//}
//else
//{
//return mapping.findForward("fail");
//}
}
Any help is greatly appreciated,
Scott Fitzgerald
RE: Database access problem
Posted by st...@jline.com.
sorry, i didn't read the full details of your problem
earlier. however, for the below, just for kicks, try calling
newInstance() as in:
Class.forName(...).newInstance()
I've noticed some drivers require an actual instance somewhere to be
created just once.
jae
Scott Fitzgerald writes:
> Actually, it is jdbcDriver that I use in the call to Class.forName() not
> jdbcUrl. Sorry for the misprint.
RE: Database access problem
Posted by Scott Fitzgerald <sc...@colabnet.com>.
Actually, it is jdbcDriver that I use in the call to Class.forName() not
jdbcUrl. Sorry for the misprint.
Scott Fitzgerald
RE: Database access problem
Posted by Marouane Louah <Ma...@selftrade.com>.
hello
I' ve the same pb and i would like to know if you've find the solution
Thankx
-----Message d'origine-----
De : Robert Taylor [mailto:rtaylor@mulework.com]
Envoyé : jeudi 26 avril 2001 20:52
À : struts-user@jakarta.apache.org
Objet : RE: Database access problem
The second way I tried to run this was by simply establishing a
connection to the database manually in my Action class and using
Class.forName(jdbcUrl). However, this time, when I try run the app it will
crap out when I try to do the actual query and give me a class not found
exception at Class.forName(jdbcUrl) at the Tomcat console. The browser gives
me a null pointer exception. I think I have all the required imports within
my classes.
It is my understanding that it should be Class.forName(driverName). This
is how the class loader makes the driver available to your app and is also
the reason why you are getting a ClassNotFoundException.
HTH,
Robert
RE: Database access problem
Posted by Robert Taylor <rt...@mulework.com>.
The second way I tried to run this was by simply establishing a connection
to the database manually in my Action class and using
Class.forName(jdbcUrl). However, this time, when I try run the app it will
crap out when I try to do the actual query and give me a class not found
exception at Class.forName(jdbcUrl) at the Tomcat console. The browser gives
me a null pointer exception. I think I have all the required imports within
my classes.
It is my understanding that it should be Class.forName(driverName). This
is how the class loader makes the driver available to your app and is also
the reason why you are getting a ClassNotFoundException.
HTH,
Robert