K Dombroski

Just an fyi, I ended up completely rewriting the query using left outer joins with the "ChartOfAccounts" table as the left one, since that is the data that I need in every record, regardless of what's in the others; it's now 4+ times as long as it was, but it works on both systems. I would post it, but it's really huge. Basically, I'm taking query results of table c and left outer joining with entire query again on b1, left outer joining that with the entire query again on b2, etc, with the where and order by at the end. Thanks to Jeanne for giving me the idea with the multiple query suggestion.

Unfortunately, yes, it has to be done in a single query, or at least, I need a single result set containing all of that data, as the combined data needs to go into a single record (i.e. one row needs to contain Budget1Amount, Budget2Amount, etc). In addition, this query is highly dynamic, as there can be anywhere from 1 to 5 "columns" where the user can request budget amounts, year amounts, or estimated amounts, and the MonthXCashBasisAmount fields only apply if the user is requesting a year amount, etc. The code to make up this query takes about 175 lines of code because of all the if statements and for loops necessary (and will require more in order to check which database system is in use and do the necessary union/exclusion joins). Right now, though, if I can just figure out how to make this query work in db2, I can figure out how to make the dynamic part work later. Piece-mealing it together would be fine, so long as I can end up with a single result set that contains all the data I need for inserting into the table for the report.

This sounds like a crystal reports question rather than a sql question. I don't see anywhere in these forums that addresses crystal, so I will reference you to a forum that is specifically for crystal reports which I have found to be very helpful: http://www.tek-tips.com/

Found a page (http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/sqlp/rbafymst124.htm) with how to "simulate" full outer join on db2 (because for who knows why, db2 doesn't support full outer joins and thinks it's a good idea to force developers to double their code to get the same results...??)
Unfortunately, I have a dynamic query which may have anywhere from 1 to 5 full outer joins. Here is an example of a query that runs on sql server:
Select c.Element1Number,c.Element2Number,c.Element3Number,c.Element4Number,c.Element5Number,c.Element6Number, c.description as AccountDescription,c.AccountTypeCode, b1.amount as Budget1Amount, b2.amount as Budget2Amount, g3.Month1CashBasisAmt as Column3Month1,g3.Month2CashBasisAmt as Column3Month2,g3.Month3CashBasisAmt as Column3Month3, g3.Month4CashBasisAmt as Column3Month4, g3.Month5CashBasisAmt as Column3Month5,g3.Month6CashBasisAmt as Column3Month6, g3.Month7CashBasisAmt as Column3Month7,g3.Month8CashBasisAmt as Column3Month8, g3.Month9CashBasisAmt as Column3Month9, g3.Month10CashBasisAmt as Column3Month10,g3.Month11CashBasisAmt as Column3Month11,g3.Month12CashBasisAmt as Column3Month12, g4.Month1CashBasisAmt as Column4Month1,g4.Month2CashBasisAmt as Column4Month2,g4.Month3CashBasisAmt as Column4Month3, g4.Month4CashBasisAmt as Column4Month4, g4.Month5CashBasisAmt as Column4Month5,g4.Month6CashBasisAmt as Column4Month6, g4.Month7CashBasisAmt as Column4Month7,g4.Month8CashBasisAmt as Column4Month8, g4.Month9CashBasisAmt as Column4Month9, g4.Month10CashBasisAmt as Column4Month10,g4.Month11CashBasisAmt as Column4Month11,g4.Month12CashBasisAmt as Column4Month12, a.FirstNumberInRange, a.LastNumberInRange,a.description as RangeDescription From ChartOfAccounts c FULL OUTER JOIN BudgetDetails b1 on (c.id = b1.accountId and b1.budgetheaderid = '46') FULL OUTER JOIN BudgetDetails b2 on (c.id = b2.accountId and b2.budgetheaderid = '47') FULL OUTER JOIN GLSummary g3 on (c.id = g3.AccountId and year(g3.budgetStartDate) = '2004') FULL OUTER JOIN GLSummary g4 on (c.id = g4.AccountId and year(g4.budgetStartDate) = '2005') LEFT OUTER JOIN accountrangeoptions a on ((ElementPositionNumber = '5' and (c.Element5Number between a.FirstNumberInRange and a.LastNumberInRange))) where (c.AccountTypeCode = '5' or c.AccountTypeCode = '6') and (c.StatusCode <> 'D') AND b2.Amount <> '0' AND (c.element1Number >= 0 and c.element1Number <= 999999999) AND (c.element2Number >= 0 and c.element2Number <= 999999999) order by c.Element1Number,c.Element2Number,c.Element3Number,c.Element4Number,c.Element5Number,c.Element6Number How on earth do I fake this to get the same results in DB2?? Everything I have tried to date has resulted in errors about undefined tables.

I am trying to figure out how to make groups of users so that one set of users logs into one application and another set of users logs into another application, where both applications are running on the same server. Every time I try to do this, I end up ruining my server setup beyond repair so that it will no longer start no matter what I do. I am currently trying to get it back to what it was before when it was working, but I still cannot get my server to start. I recreated my server profile, and it started. As soon as I added in our normal LDAP settings, which were working fine before I did all this stuff, and which work fine for everyone else on my team, I started getting the same errors I was getting when I was messing with putting in groups. Here is the error I see, over and over again in the console, until it finally times out and stops:

Authentication failed when using LTPA. The exception is javax.naming.AuthenticationException: [LDAP: error code 49 - Bind principalDn points to referral.].

Google searching gives me 0 results. I have no idea what this means, what settings might possibly fix it, or anything. All I want at this point is for my server to start and things to be working the way they were before I tried messing with groups. Have been struggling with this for days. Please help!!

Thank you, Rob! That worked!

I'm trying to use reflection to call various methods based on values in a properties files.
Here is what I'm trying to accomplish:
DaoFactory.create<DaoCass>().<methodName>(params, onbhf, d);
Here is my code:
String daoCall = "create" +config.getDaoName(); String methodName = config.getDaoMethodName(); try { //eg. DaoFactory.createGLReportsDao().setupAccountActivity(params, onbhf, d); Method method = DaoFactory.class.getMethod(daoCall); Method method2 = (method.invoke(null)).getClass().getMethod(methodName, HashMap.class, User.class, Date.class); Class c2 = Class.forName(method2.getDeclaringClass().getName()); method2.invoke(c2,params, onbhf, d); } catch (Exception e) { e.printStackTrace(); //TODO log exception }
I keep getting an IllegalArgumentException from my method.invoke call. I have put in output statements, and the methods being called look right. I have tried using Class[] parameterTypes = { HashMap.class, User.class, Date.class }; to pass the parameter types in the getMethod call and then using an Object[] as the 2nd param in the method2.invoke, but that does not work either. I can't figure out what is wrong. The parameter types match what I'm declaring. What could be causing this exception?

Thanks for any help you can provide.

Cool, I did not know I could do that. Setting it to attachment does add in a prompt asking if they want to open or save, but I don't think the users will mind. Thanks!

I have an application where when the user submits the page, I want a report to come up in a new window, using the parameters that the user entered on the page. The current implementation opens the report in the same page, causing me to lose the rest of the application, because the report is a PDF. As it is right now, the parameters are being pass to the report renderer servlet via a request attribute. I would like to set it up so that when the user submits, it puts all the params into the request attribute, then forwards to the page again, but have javascript in the page to check for that request attribute, and if it is there, do a javascript openWindow call to call the servlet. However, I can't figure out how to get that request attribute into the new request being called from the javascript. Is this something that can even be done? How do I pass request attributes from a javascript new window call? If it can't be done, does anyone have any good ideas on another way to make the report open up in a new window? We are using Struts 1.2.7 for this application and the report renderer is a separate servlet.
This code works, but is not passing the parameters, of course, and so the report fails.
<script type="text/javascript" language="JavaScript"> <%if (request.getAttribute("parameterList") != null) {%> openReportWindow('reportRenderer?report=TransactionDetails','transdetail'); <%} %> </script>

I guess I just found the answer to my own question: it's an IE bug. Apparently, IE does not trigger a button if there is only one text box in the form. Why is anyone's guess.

For anyone else who happens to run across the same problem, the solution is to add a text box that has the style set to "display: none" so it will not show up on the page.

http://frustratedprogrammer.blogspot.com/2004/07/ie-bug-and-struts-forms-with-one-input.html

My initial guess would be that you trying to print a list item with an index from the string array. If you could post a sample from your jsp, perhaps I could see more.

I have searched and searched and can find no explanation for the odd behavior I am seeing on one of my pages. I am using Struts 1.2.7 and browsing using IE 7.0.5730.11.

On my page, I have a html:text field and a html:submit button (and some other buttons). If I hit enter while my cursor is in the text field, the page is submitted WITHOUT activating the submit button (or any other buttons), which is not the behavior I want, as I need to check to see if the submit button has been clicked in order to know what actions to take.

Another interesting thing I discovered is that if I add another text field or password field to the page, everything works great. But if it is any other type of input, it does not work, and if I remove the extra input, it doesn't work. There does not appear to be anything special about the text field. In fact, it seems to be if I have only one text field, regardless of which field it is, I see this odd behavior. As soon as I have two text fields, everything works great. It also does not seem to matter if they are struts text boxes or standard html text boxes.

If I remove all of the text fields, leaving only the submit button, hitting enter does absolutely nothing. This kind of makes sense, though, as even when there are text boxes on the page, hitting enter does nothing if I don't have my cursor in one of the text boxes.

Does anyone have an explanation for this? A way to make it work? I am at my wit's end on this. Thanks for any insight.

Ok, thanks so much for the explanation!

I'm trying to open a page in a new window, using the window.open method in javascript.
<a href="javascript :-o penAppWindow('${pageContext.request.contextPath}/auditorvoucherbatches.do?voucherType=1','vouchers')" class="tertiarymenulink">Auditor Vouchers</a>

Everything works fine, except when I leave the window and click on the link again. When I do that, it goes to the correct page but completely skips the action class, so any data that might have been changed is not displayed--the user is seeing an old copy of the page.
To clarify, here are the steps taken:
1: click on link--new window opens with list of items displayed on page
2: go through process in new window to add an item to the db, but do not click the button to go back and re-display the list.
3: leaving window open, go to main application window and click on the link again--focus is changed to the child window, the correct action mapping is called (so the correct page is displayed), but the action class is never hit. The list of items does not contain the new item I just added.
How is this possible? The only explanation I can come up with is that it is caching the page, but I added
<META HTTP-EQUIV="Pragma" CONTENT="no-cache"> <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache"> <META HTTP-EQUIV="Expires" CONTENT="-1">

to my jsp template, and it doesn't make any difference.
The only solution I have come up with is to essentially call it twice:
<html:link action="auditorapvouchers.do?voucherType=1" onklick="openAppWindow('${pageContext.request.contextPath}/auditorapvouchers.do?voucherType=1','apvouchers')" target="apvouchers" styleClass="tertiarymenulink">Auditor A/P Vouchers</html:link>

This makes it so it will always go through the action class at least once, but unfortunately, also means that it often goes through it twice (i.e. when first clicking on the link), which is a performance problem.
I can't seem to find anything on Google that addresses this. Does anyone have a clue as to what the problem is and how I can fix it?

I have useTaxRate defined as a double in my form. Will that not work?