Christian Nash

hi,

I am trying to access an ms access database. Have already setup the system dsn. i am able to access the database through a java file but not through the jsp and servlets.

below is the code i use to connect to the database:
static Connection getDBConnection() throws SQLException, ClassNotFoundException { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "C:/Documents and Settings/user/Desktop/db1.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database += filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end Connection con = null; // now we can get the connection from the DriverManager con = DriverManager.getConnection("jdbc:odbc:db1", "", ""); return con; }

I get the following exception:
[5/22/08 16:26:55:568 IST] 5121a309 SystemErr R java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader.findClass(CompoundClassLoader.java:390) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at com.ibm.ws.classloader.CompoundClassLoader.loadClass(CompoundClassLoader.java:300) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at java.lang.ClassLoader.loadClass(ClassLoader.java(Compiled Code)) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at java.lang.Class.forName1(Native Method) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at java.lang.Class.forName(Class.java(Compiled Code)) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at com.mindtree_odc01.trialweb.actions.InsertAction.getDBConnection(InsertAction.java:102) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at com.mindtree_odc01.trialweb.actions.InsertAction.getNextId(InsertAction.java:341) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at com.mindtree_odc01.trialweb.actions.InsertAction.insertAttachment(InsertAction.java:128) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at com.mindtree_odc01.trialweb.actions.InsertAction.execute(InsertAction.java:46) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) [5/22/08 16:26:55:568 IST] 5121a309 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

Hey dude,

You still have a long way to go since you are still only 18 years old. You can think of going for an mba only after another 3-4 years when you get a bachelors degree. DO NOT go for an online mba. They are of no use to you if you aren't strictly disciplined. If you do not get into any of the IIM's, it is not the end of the world. There are so many other institutes in India you can apply for. Though IIM's have a brand name, it will all be up to you to get noticed.

Do not worry, your time will come

No i do not want to merger these two files. I want to have a single properties file with the below key and value:

file_all.properties
------------------
xsl_file_path=WEB-INF/xsl/modify.xsl

Now i would like to access this file viz modify.xsl which is placed in the WEB-INF/xsl folder/directory of mmy web project. Would it be possible to access this file irrespective of whether it is a jar/war/simple file?

From above post, you can see that i have two property files with different paths for the values. I would like to have a single property file which would work under any scenario.

Hi all,

I have two property files having key value pairs. While the names of the keys are the same, the values of these keys are different in these files. viz.

file1.properties
------------------
xsl_file_path=file:///C:/Documents and Settings/Desktop/My_workspace/MyAppWeb/webApplication/xsl/modify.xsl

file2.properties
------------------
xsl_file_path=file:///apps/softcopies/WebSphere/AppServer/installedApps/SomeNetwork/MyApp.ear/MyAppWeb.war/xsl/modify.xsl

I want to have a single properties file and i want to access the key and value pair using relative paths. Please tell me how i can achieve such a thing. If you can suggest me some tutorials or examples, i would really appreciate it.

try inserting it as a BLOB[binary large object]

Oops Sorry...posted it again..Some system error..Please delete one of these posts. deeply regret the mistake..

(I deleted the other one. By the way I believe you can delete your own posts; you should see a little "Delete Post" icon at the bottom. - PC)
[ September 11, 2007: Message edited by: Paul Clapham ]

Hi,

I have an input xml file and an xsl file. The xsl converts the input xml into an output xml file. My doubt is: I have an element with 2 attributes in the input xml. I want these attributes in the output xml as well. Is it possible to retain these attribute names and values dynamically using the xsl file?
//This is similar to my input xml. <country> <state [B]name="Texas" population="1000"[/B]/> </country> I want the bolded portion in the output xml. Can it be done using xsl functions? If yes then please help..

Hey this is what i did....jsp1.jsp <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <html:html> <HEAD> <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" %> <META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <META name="GENERATOR" content="IBM WebSphere Studio"> <META http-equiv="Content-Style-Type" content="text/css"> <LINK href="theme/Master.css" rel="stylesheet" type="text/css"> </HEAD> <BODY> <html:form action="/action1"> Jsp1<html:submit value="Click here" /> </html:form> </BODY> </html:html> -------------------------------- Action1.java package demoproject.actions; import java.io.IOException; import java.util.ArrayList; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionError; import org.apache.struts.action.ActionErrors; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import demoproject.forms.FormBean1; /** * @version 1.0 * @author */ public class Action1 extends Action { public ActionForward perform( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { ActionErrors errors = new ActionErrors(); ActionForward forward = new ActionForward(); // return value try { FormBean1 bean1 = (FormBean1) form; ArrayList list = new ArrayList(); list.add("Christian"); list.add("Nash"); bean1.setArraylist(list); // do something here } catch (Exception e) { e.printStackTrace(); } return (mapping.findForward("success")); } } -------------------------------------- FormBean1.java package demoproject.forms; import java.util.ArrayList; import javax.servlet.http.HttpServletRequest; import org.apache.struts.action.ActionErrors; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionMapping; /** * Form bean for a Struts application. * @version 1.0 * @author */ public class FormBean1 extends ActionForm { ArrayList arraylist = new ArrayList(); public void reset(ActionMapping mapping, HttpServletRequest request) { // Reset field values here. } public ActionErrors validate( ActionMapping mapping, HttpServletRequest request) { ActionErrors errors = new ActionErrors(); // Validate the fields in your form, adding // adding each error to this.errors as found, e.g. // if ((field == null) || (field.length() == 0)) { // errors.add("field", new org.apache.struts.action.ActionError("error.field.required")); // } return errors; } /** * @return */ public ArrayList getArraylist() { return arraylist; } /** * @param list */ public void setArraylist(ArrayList list) { arraylist = list; } } -------------------------------------- jsp2.jsp <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <html:html> <bean :mrgreen: efine id="arraylist" name="formBean1" property="arraylist" type="java.util.Collection" /> <HEAD> <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" %> <META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <META name="GENERATOR" content="IBM WebSphere Studio"> <META http-equiv="Content-Style-Type" content="text/css"> <LINK href="theme/Master.css" rel="stylesheet" type="text/css"> </HEAD> <BODY> <html:form action="/action2"> Jsp2<html:submit value="Click here" /> </html:form> </BODY> </html:html> -------------------------------- Action2.java package demoproject.actions; import java.io.IOException; import java.util.ArrayList; import java.util.Iterator; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionError; import org.apache.struts.action.ActionErrors; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import demoproject.forms.FormBean1; /** * @version 1.0 * @author */ public class Action2 extends Action { public ActionForward perform( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { ActionErrors errors = new ActionErrors(); ActionForward forward = new ActionForward(); // return value try { FormBean1 bean1 = (FormBean1) form; ArrayList list = bean1.getArraylist(); Iterator iter = list.iterator(); while (iter.hasNext()) System.out.println(iter.next() + " in Action2"); } catch (Exception e) { e.printStackTrace(); } return (mapping.findForward("success")); } }

Hope this helps

The values come up as empty because you may not be sending this arrayList as a parameter during jsp form submit to Action 2 or some error in the jsp. Please post the jsp.

Hey Paul,

Thanks a lot for the inputs.

I implemented the above in a recursive manner (i made a rule in my xsl file) when I have to search for a particular word in a paragraph and make it bold (I pass the string/word to be boldened as a parameter to this rule). Was wondering if I can do this for some other words in the paragraph too.

Cheers,
Christian

Hi,

I have an xml file having certain elements.One of them is the biography element viz. <biography>My name is Christian</biography>. I have a corresponding xsl for this to generate a html format. I wanted to know as to how i can make the different parts of the text inside biography to appear as bold. i.e. i want the biography text to be output as My name is Christian. How can i write a xsl rule to check for multiple occurrences of these words in a paragraph? Will be thankful for any guidance.

Cheers,
Christian
[ August 06, 2007: Message edited by: Christian Nash ]

Hi,
Is it possible to highlight certain words in a paragraph irrespective of the occurrence of the words using the same template. for eg: I have a line of text like 'My name is Christian. Christian Roger Nash'. I would like to make both the words 'Christian' and 'Nash' bold. How can I do this?

Go through the Struts Survival Guide by Srikanth Shenoy. It explains everything in detail.

Go through the Struts Survival Guide by Srikanth Shenoy. It explains everything in detail.

Hi,

When i submit a form , the request is getting submitted twice. I'm using Websphere Application server which I have modified according to requirement. Also i use Struts as the frontend framework. Here i have created a custom servlet by extending the ActionServlet. I am not able to pin point the actual area where these two threads are starting. Have checked for repeated form submissions due to submit buttons. No problem in this case. Can anyone tell me where the problem might lie??
[ June 08, 2007: Message edited by: Christian Nash ]