Simon Birch

I'm trying to merge data from a SQL server database with data from a DB2 database, and I've hit a snag. The DB2 database sits on a mainframe and sorts data in an EBCDIC based order (i.e. letters before numbers). The SQL database, and Java .compareTo() place numbers before letters.

I'd like to change the collation used by DB2 and I'm told that it can be done by providing a parameter on binding my SQL. I'm having some problems find out how to do this in Java though. Any help or pointers would be greatly appreciated.

We are using DB2 version 7, and SQL Server 2000.

A snippet of my current Java code:
String q = "some SQL here with an ORDER BY"; Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); db2Connection = DriverManager.getConnection(connectionString, user, password); statement = db2Connection.createStatement(); resultSet = statement.executeQuery(q);

I occasionally find myself wanting to re-read one of the replies to a question I asked some time ago.

Unfortunately, the only way I've found of doing this is to first locate any post I've made on the forums so that I can access the 'Profile' page and from there the 'View recent Posts' link.

As I'm not a frequent poster of questions, I've first got to find a post I've made... (spot the infinate loop).

Have I missed a link somewhere that would enable me to see recent posts without having to first find another post that I've made?

I'm sure this must be something daft on my part.

When the expected output is 00:03:16.492, I'm getting 01:03:16.492
When the expected output is 01:19:56.492, I'm getting 02:19:56.492
If I try setting the time to 0 I get 01:00:00.000

Here is the code;
public class Millis { public static void main(String[] args) { Date d = new Date(); SimpleDateFormat form = (SimpleDateFormat) DateFormat.getTimeInstance(); form.applyPattern("HH:mm:ss.SSS"); System.out.println(d.getTime()); System.out.println(form.format(d)); System.out.println(""); // This should be output as 00:03:16.492 d.setTime(196492); System.out.println(d.getTime()); System.out.println(form.format(d)); System.out.println(""); // This should be output as 01:19:56.492 d.setTime(4796492); System.out.println(d.getTime()); System.out.println(form.format(d)); System.out.println(""); } }

Hi Andrew, welcome to JavaRanch.

Java is case sensitive. All you need to do is make the file name 'MyFirstApp.java' rather than 'myfirstapp.java'.

Incidentally, this is also the reason you get the Exception statement when you remove 'public' from the program. You are trying to use a class called 'myfirstapp', but its actual name is 'MyFirstApp'.

Hope that helps.

Yes - I tried that sort of thing.

Again - the only reason I can think of to do this would be to limit the scope and life of a variable. I guess this is useful to clarify the intent of code, but I thought that methods ought to be kept as short as possible anyway. Adding an arbitrary block of code still seems redundant.

I tried the following - just out of curiosity;
public class Arbitrary { public static void main(String[] args) { System.out.println("Outer"); { System.out.println("Inner"); } } }

I was slightly surprised when it compiled and produced
Outer Inner

The only use I could think of was limiting variable scope - but that seems redundant given the limiting provided within 'normal' code blocks (if, for, etc)

Is this just 'the way it works', or is there a practical use for declaring arbitrary code blocks?

Hi,

The most obvious error in the code is the top line which should read
import java.util.*;

With this change the code compiles and runs fine for me.

I tried this, using the following properties
mbuf.append("Manifest-Version: 1.0\n"); mbuf.append("Class-Path: someother.jar\n");

Initally, I omitted the "\n" at the end of the Class-Path and it didn't appear in the manifest.mf file, although the Manifest-Version line did appear. Using the code above gave me a manifest.mf file with both lines in it.

Does this give you any help? Could we see your code in full?

Glad you got the code going Arto, but I'd really think about either not using the Thread or putting all the file handling into the Thread code.

I've done some experimenting. The problem you are having is caused by seperating the file writing and closing into different threads.

After the t.start(), the JVM will be executing two threads - one is your code in the run method, the other is the code folloing on from where you called start(). These two threads of execution have no guarantees about the order in which they will be processed, or about when one thread might be stopped and the other started.

I guess what you are experiencing is the JVM completing the raf.close() before it gets to the raf.write().

How to solve this depends on what you are trying to achieve. Do you actually NEED to use a sperate thread?

If not, the following might be a better approach (I'm using windows, so I've changed the file name for ease):
import java.io.*; public class Main { public static void main(String args[]) { RandomAccessFile raf = null; try { File f = new File("/test"); if(f.exists()) { f.delete(); } f.createNewFile(); raf = new RandomAccessFile(f, "rws"); raf.write("test".getBytes()); } catch (IOException ioe) { ioe.printStackTrace(); } finally { try { if (raf != null) { raf.close(); } } catch (IOException ioe) { ioe.printStackTrace(); } } } }

In that case, I would look at the object referred to by 'f'. The file name may be mangled in some way. Can you access the file through f? What do you get if you try
System.out.println(f.getName()); System.out.println(f.canRead());

That might help zero in on the problem.

I think what is happening here is that you are creating a Thread object with your own run method. But you never call any methods on the Thread object, so the code you have in the run method is never executed.

You need to call the start() method on Thread in order to execute the code in the run() method in a seperate thread.

Thanks for your reply Marc. Unfortunately, when I tried that, I got an almost identical error to the one I posted previously. Here it is (with line breaks this time )
[ServletException in:/jsp/bodytiles/reporting/reportSelection.jsp] Unable to compile class for JSP An error occurred at line: 27 in the jsp file: /jsp/bodytiles/reporting/reportSelection.jsp Generated servlet error: C:\WSAD\CIS\.metadata\.plugins\com.ibm.etools.server.core\tmp0\cache \localhost\server1\CISEAR\CISWeb.war\jsp\bodytiles\reporting \_reportSelection.java:248: cannot resolve symbol symbol : method setValue (java.lang.Integer) location: class org.apache.struts.taglib.html.RadioTag _jspx_th_html_radio_0.setValue(indexNumber); ^ 1 error '

Does this point to me doing something daft that is preventing the <%=indexNumber%> from working?

I'm trying to produce a list of items in a page by iterating over a List of those items. As long as I don't try to use a radio button, the list works fine. Unfortunately, the radio button is somewhat essential.

Here is a snippet of the code from the Action (by the way reportName is a misnomer at the moment - it's supposed to be the report index number)
List reportList = getBusinessFactory().getReportWriter().getReportDefinitions(); setAttributeInRequest(request, "reportDefinitions", reportList); ReportSelectionForm repSel = new ReportSelectionForm(); repSel.setReportName("0"); setAttributeInRequest(request, "reportSelectionForm", repSel);

The page contains the following:
<logic:iterate name="reportDefinitions" id="reportDefinition" indexId="indexNumber"> <tr> <td><html:radio name="reportDefinition" property="reportName" value='<%=pageContext.getAttribute("indexNumber")%>'/></td> <td><bean:write name="reportDefinition" property="reportNameViewable"/></td> <td><bean:write name="reportDefinition" property="reportDescription"/></td> </tr> </logic:iterate>

With this code, I get a JSP compilation error appearing in the web page.
[ServletException in:/jsp/bodytiles/reporting/reportSelection.jsp] Unable to compile class for JSP An error occurred at line: 27 in the jsp file: /jsp/bodytiles/reporting/reportSelection.jsp Generated servlet error: C:\WSAD\CIS\.metadata\.plugins\com.ibm.etools.server.core\tmp0\cache\ localhost\server1\CISEAR\CISWeb.war\jsp\bodytiles\reporting\ _reportSelection.java:248: cannot resolve symbol symbol : method setValue (java.lang.Object) location: class org.apache.struts.taglib.html. RadioTag _jspx_th_html_radio_0.setValue( pageContext.getAttribute("indexNumber")); ^ 1 error '


I've tried using an ordinary <input> tag with the same bit of script used in the html:radio tag above - and it lists fine, but doesn't initialise the radio button.

I must be doing something daft - but I've no idea what it is. Can anyone point me in the right direction (or even solve the problem!).

Thanks in advance.

[ Jess added new lines in the error message so the screen doesn't get stretched too far ]

[ January 24, 2005: Message edited by: Jessica Sant ]
[ January 24, 2005: Message edited by: Simon Birch ]

There are several tasts you need to perform to write the Phone class. In no particular order

Convert a letter to a number

Identify each letter of the entered word

Add each number to the actual phone number

Format the phone number

Which part of the program is causing you difficulty? Does breaking it down (e.g. like the above) help?

You could just try breaking down each of the above until you get to writing code.