Consider n=6 then,
Select each element that has 5 other higher values then itself. Being the 6th one, there should be 5 other elements bigger than the 6th one.
Why do you interfere mysqldump file with java? -r option will direct the output to file. Remove readers and writers and just execute the process, I suppose you will see the correct content in the "/Backup/zzzzz.sql" file. msyqldump will handle it. For more options see MySQL 5.1 Reference : mysqldump
Here is a sample code for you. What it does :
1) Creates a combobox
2) builds a model for combobox from items of type DemoModelItem (try commenting out overrided toString method)
3) sets combobox model
There are several way that comes to my mind
1. Why not declare 2 different cursors than use if statements to decide which cursor will be opened?
2. If you need some kind of fancy cursor declaration, you may union both SQLs (they need to select same types) and then make only one of them fetches data. Something like this
3. You may use dynamic sql with open cursor for ... using ... OPEN-FOR-USING
You may extend the list, but simple is safer so if I were you I would go for 1.
What is the value of "nol" variable before insert statement? It can be null and not populated by your first query. As Martin said you should debug your code, it will reveal the error.
You can not just start development at home for OAF. You need a development environment for Oracle Applications (E-Business Suite ERP software). There are some well known sources in this area, and lots of useful blogs. But I am sorry you need to access an enterprise software in order to run your first OAF page from your local machine which will be developed with the correct version of JDeveloper for OAF.
First find an EBS instance that you have access and then you can develop and test your first page.
Can you please use proper setXXX methods for sql statements? It is not that hard and saves a lot of time when passing values to queries Here you can start.
I am not familiar with WAS but it sounds like a driver issue. At least can you verify that your application running on WAS also uses the same version of Oracle JDBC driver as your local/standalone application does?
I suppose this is mysql database, anyways, can you put 97 in single quotes to see if it works. But you should use PreparedStatement and proper setXXX methods.
You can not just store blob pointer inputstream in memory. Either you should fetch all the bytes and store it in memory in order to use it in vInsertPhoto method (not good), or you should read some bytes and then write it immediately.
You have to merge your methods into one method that will read one row from Access DB then insert it to Oracle DB.