Ryan G Johnson

no intermittant commits.

I can have it wait until they are done, but there may be a need to kill immediately.

If I do a kill command from unix, i can't force a sql exception, it kills the thread? I don't get it. This is are background processes. I would have to re-write the framework to message the background processes to exit gently. Not practical. I was hoping for an API.

Oracle's sqlplus utility has an 'autocommit' command, when it is off, if you kill the sqlplus session it does NOT commit. So I hoped there would be something similiar for jdbc.

top anyone?

We have a background process that runs every few minutes. It opens up several sessions and each performs works. When we take the system down for maintenance we have a korn shell script that kill -15 the java threads.

Problem is that even though autocommit is off insert,update,delete that have been made are being committed when the session shuts down and we would like it to roll back.

Writing code to handle a graceful shutdown and have it roll back would be a significant effort. Is there a jdbc flag that will tell oracle 'if this session dies on you rollback and don't commit unless we specifically say so'.

i am using the same driver as other people i work with who can connect.

I also use the following:

Connection conn = DriverManager.getConnection (url, userName, password);

know this has been posted repeatedly. However, I have tried all the generic solutions Mine is a little different.

1. I can connect with SQLPLUS to the database. I am on windows XP connecting to Oracle 10g on a Solaris box. So the listener is running.

2. Here is my tnsnames.ora entry which works with SQLPLUS:
I can tnsping this address


SID_NAME = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP_NUMBER)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SID_NAME) ) )


I am trying to run the following sample code:

/* * This sample shows how to list all the names from the EMP table * * It uses the JDBC THIN driver. See the same program in the * oci8 samples directory to see how to use the other drivers. */ package basic; // You need to import the java.sql package to use JDBC import java.sql.*; class Employee { public static void main (String args []) throws SQLException { // Load the Oracle JDBC driver DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); // Connect to the database // You must put a database name after the @ sign in the connection URL. // You can use either the fully specified SQL*net syntax or a short cut // syntax as <host>:<port>:<sid>. The example uses the short cut syntax. String url = "jdbc :-o racle:thin:@IP_NAME:1521:SID_NAME"; String userName = "USERNAME"; String password = "PASSWORD"; if (args.length > 0) url = args[0]; if (args.length > 1) userName = args[1]; if (args.length > 2) password = args[2]; //Connection conn = // DriverManager.getConnection (url, userName, password); Connection conn = DriverManager.getConnection("jdbc :-o racle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=IP_NUMBER:1521)(PORT=1521)))(CONNECT_DATA=(SID=SID_NAME)(SERVER=DEDICATED)))", "USERNAME", "PASSWORD"); // Create a Statement Statement stmt = conn.createStatement (); // Select the ENAME column from the EMP table ResultSet rset = stmt.executeQuery ("select object_name from user_objects"); // Iterate through the result and print the employee names while (rset.next ()) System.out.println (rset.getString (1)); } }

I also used the following IP

i meant banking dev.


the code is right here:

http://examples.oreilly.com/jakarta/

banking.war

i am assuming its because the book is 3 years old and struts has changed. oreilly is usually pretty good.

javax.s ervlet.jsp. JspException: Cannot find message resources under key
org.apache.struts.action. MESSAGE

I am trying to run the sample banking application that comes with the O'reilly Jakarta Struts book. I am using Resin.

I got struts-blank to work. I deployed the banking.war and turned on resin, it autodeployed.

Here are the contents of my struts-config.xml

Please not the following line at the bottom:
<message-resources parameter="BankingMessageResources" null="false"/>

<?xml version="1.0" encoding="ISO-8859-1" ?> <!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd"> <struts-config> <form-beans> <form-bean name="loginForm" type="com.oreilly.struts.banking.form.LoginForm"/> <form-bean name="accountInformationForm" dynamic="true" type="org.apache.struts.action.DynaActionForm"> <form-property name="accounts" type="java.util.ArrayList"/> </form-bean> <form-bean name="accountDetailForm" dynamic="true" type="org.apache.struts.action.DynaActionForm"> <form-property name="view" type="com.oreilly.struts.banking.view.AccountDetailView"/> </form-bean> </form-beans> <global-exceptions> <exception key="global.error.invalidlogin" path="/login.jsp" scope="request" type="com.oreilly.struts.banking.service.InvalidLoginException"/> </global-exceptions> <global-forwards> <forward name="Login" path="/login.jsp" /> <forward name="SystemFailure" path="/systemerror.jsp" /> <forward name="SessionTimeOut" path="/sessiontimeout.jsp" /> </global-forwards> <action-mappings> <action path="/login" type="com.oreilly.struts.banking.action.LoginAction" scope="request" name="loginForm" validate="true" input="/login.jsp"> <forward name="Success" path="/action/getaccountinformation" redirect="true"/> <forward name="Failure" path="/login.jsp" redirect="true"/> </action> <action path="/logout" type="com.oreilly.struts.banking.action.LogoutAction" scope="request"> <forward name="Success" path="/login.jsp" redirect="true"/> </action> <action path="/getaccountinformation" type="com.oreilly.struts.banking.action.GetAccountInformationAction" scope="request" name="accountInformationForm" validate="false"> <forward name="Success" path="/account_information.jsp"/> </action> <action path="/getaccountdetail" type="com.oreilly.struts.banking.action.GetAccountDetailAction" scope="request" name="accountDetailForm" validate="false"> <forward name="Success" path="/account_detail.jsp"/> </action> </action-mappings> <controller contentType="text/html;charset=UTF-8" debug="3" locale="true" nocache="true"/> <message-resources parameter="BankingMessageResources" null="false"/> </struts-config>

Here is the contents of the BankingMessageResources.properties which is located at: C:\resin-2.1.11\webapps\banking\WEB-INF\classes

# Labels label.accessnumber=Access Number label.pinnumber=Pin Number label.accounts=Accounts label.balance=Balance label.totalassets=Total Assets label.account=Account label.balance=Available Balance label.description=Description label.amount=Amount label.deposits=Deposits label.withdrawls=Withdrawls label.openingbalance=Opening Balance # Links link.customeragreement=Customer Agreement link.privacy=Privacy link.security=Security link.viewaccountdetail=View Account Detail # Page Titles title.login=Struts Online Banking - Account Login title.accountinfo=Struts Online Banking - Account Information title.accountdetail=Struts Online Banking - Account Detail # Button Labels label.button.login=Login # Error messages global.error.invalidlogin=<li>Invalid Access Number and/or Pin</li> global.error.login.requiredfield=<li>The {0} is required for login</li> # Images image.logo=images/logo.gif image.logo.alt=Struts Online Banking image.logout=images/logout.gif image.logout.alt=Logout image.strutspower=images/struts-power.gif image.strutspower.alt=Powered By Struts image.transfer=images/transfer.gif image.transfer.alt="Transfer Funds" image.clear=images/clear.gif

There is a post on O'reilly, with someone who is having the same problem. I don't quite understand what he is saying:

I really like the book and it was really a great book for me to learn struts.

Though i have some question on the storefront-dev example code.

When i deployed it i always get this error:

javax.servlet.jsp.JspException: Cannot find message resources under key

org.apache.struts.action.MESSAGE

I tried removing some of the line errors in the index.jsp just to see if it will

work. It did but when i click a new link like viewdetail there it was again. The error part seems to be in the bean tag. it seems it cannot find the message-resources "StorefrontMessageResources". is there any change to be made in the struts-config.xml? anyway, im using the latest version of resin and jdk 1.4. I


Here is the code from index.jsp

<%@ page contentType="text/html; charset=utf-8" %> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %> <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %> <html:html locale="true"> <head> <html:base/> <title><bean:message key="title.login"/></title> <link rel="stylesheet" href="stylesheets/login_style_ie.css" type="text/css"> </head> <body topmargin="0" leftmargin="5" marginheight="0" marginwidth="0" bgcolor="#6699FF"> <html:form action="login" focus="accessNumber"> <table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#6699FF"> <tr><td><html:img srcKey="image.logo" width="79" height="46" altKey="image.logo.alt" border="0"/></td></tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr><td bgcolor="#000000"> <table border="0" cellpadding="0" cellspacing="0" width="1" height="2"></table></td></tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="1" height="1"> <tr><td></td></tr> </table> <table> <tr><td></td></tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="590"> <tr><td width="15" height="31"></td><td width="12"></td></tr> <tr> <td width="15"></td> <td width="575" bgcolor="#FFFFFF" colspan="2"> <table cellpadding="0" cellspacing="0" border="0" width="575" height="3"><tr><td></td></tr></table> </td> </tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="590" bgcolor="#ffffff"> <tr> <td width="15" bgcolor="#6699FF"></td> <td width="15"></td><td width="379"></td> <td width="15"></td> <td width="15"></td> <td width="15"></td> </tr> <tr><td></td></tr> <tr> <td bgcolor="#6699FF" width="15"></td> <td></td> <td valign="top"> <table border="0" cellpadding="0" cellspacing="0"> <tr class="fieldlabel"> <td class="error"><html:errors/></td> </tr class="fieldlabel"> <tr class="fieldlabel"> <td><bean:message key="label.accessnumber"/></td> </tr> <tr> <td><html:text property="accessNumber" size="9" maxlength="9"/></td> <td></td> </tr> <tr class="fieldlabel"><td height="10"></td></tr> <tr class="fieldlabel"><td><bean:message key="label.pinnumber"/></td></tr> <tr class="fieldlabel"> <td><html :-P assword property="pinNumber" size="9" maxlength="9"/></td> </tr> <tr><td height="10"></td></tr> <tr><td><html:submit styleClass="fieldlabel" value="Login"/></td></tr> <tr><td></td></tr> </table> </td> <td width="151" valign="top"><html:img srcKey="image.strutspower" altKey="image.strutspower.alt"/></td> </tr> </table> <%@include file="include/footer.jsp"%> <br> </html:form> </body> </html:html>

what do i add the .tld file to? how do i add it in eclipse?

this is what i have at the top. I added the tag you requested.

<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" pefix="bean" %>

I am getting an error when i use bean:write with eclipse. I am assuming i need add an external jar. which one do i add?

I see ApplicationResources.properties referenced everywhere, but when I google it, I can't find what it is or how to define it. I am assuming that this is what defines it in the web.xml:
<init-param> <param-name>application</param-name> <param-value>ApplicationResources</param-value> </init-param>
If there is no directory in front it, does it go in the WEB-INF directory? I have the struts download and I don't see an ApplicationResources.properties in any of the .war samples?

Where can I find documentation on how to put data into this file and what the standards also about how to use it in the application?

Merrill-- you said that the .do made struts look for my action class?

I have a submitAction.class file in: C:\resin-2.1.11\webapps\myproject\WEB-INF\classes\hansen\playground

is my mapping setup wrong in my struts-config.xml ?

I have another post. I couldn't find the mapping when I did:

<html:form action="/submit.do">

when i removed the .do it worked fine. Why didn't it work with .do? someone explained it, but I didn't follow it. Something about being passed to an action class? I have an action class.

i bounced the webserver and now it works.