Seek The Sun Slowly

Q by viswanatharaju
I am currently working in Java/J2EE technologies and Oracle Technologies. I have very good knowledge of Oracle (SQL, PL/SQL and Performance Tuning). I want to tune my career as a Data Architect in the current Application. Please, guide me in this aspect.
Re by rshyleshnair
Visw[......]

Read More…

Q by shajie
hi Sir, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users[......]

Read More…

Q by paulachen
Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future[......]

Read More…

Question by Lysoka
Hello,
I’m a student and a newbie. I wanna learn Java in relation to SAP-BAPIs. My Test db is Oralce and I wanna develope a small application(call it a batch) that stores SAP Jobs(e.g meta data) in to my test Oracle db. The application should also be able to do bidirectional[......]

Read More…

Back to Home Previous Course
Deleting a row can be straightforward: Just use deleteRow method of the ResultSet:
rs.deleteRow( );
However, the Driver we are using, the ClientDriver, leaves a blank row in place of the data that was deleted. If you try to move to that row using your Next or Previous bu[......]

Read More…

Back to Home Previous Course Next Course
Before you can save a new record, you have to move the Cursor to something called the Insert Row. This creates a blank record in the ResultSet. You then add the data to the ResultSet:
rs.moveToInsertRow( );
rs.updateInt(“ID”, newID);
rs.updateStri[......]

Read More…

Back to Home Previous Course Next Course
We have three buttons that refer to new records: New Record, Save New Record, and Cancel New Record. The New Record button will only clear the Text Fields, and ready them for new data to be entered. We can also disable some other buttons, including the New Re[......]

Read More…

Back to Home Previous Course Next Course
The ResultSet has Update methods that allow you to update records not only in the ResultSet itself, but in the underlying database. Let’s see how it works.
Make your form a bit longer. Now add a new panel to the form. Add a new button to the panel. Chan[......]

Read More…

Back to Home Previous Course Next Course
Moving to the first and last records of your database is a lot easier.
Double click your First button to create the code stub. Now add the following code:

We have no need of an IF … ELSE Statement, now. The only thing we need to do is move the Cursor t[......]

Read More…

Back to Home Previous Course Next Course
The code for the Previous button is similar to the Next button. But instead of using rs.Next, you use rs.Previous.
Return to the Design window and double click your Previous button to create a code stub.
Instead of typing out all that code again, simply copy [......]

Read More…