John Sinues

In the Oracle example found here, the author describes how one can return a resultset from a Java stored procedure. The example is pretty straightforward and easy to understand. My concern, however, is the Java stored procedure prone to leaks? Since, you are returning a resultset, you cannot explicitly close the database connection, statement, or resultset. However, closing these objects are recomended to prevent things such as cursor leaks. Does anyone know how Oracle 9i handles things such as this?

TIA,
- John

Oracle's Enterprise Manager Console also does a nice job of displaying stored procedures. It shows the code (PL/SQL, Java), allows you to edit the code, or recompile it if necessary, export Java classes, plus much more. IMHO, it is not a quick as TOAD, but it does give you another alternative.
- John

Commenting out the above line from the sqlnet.ora file resolved the problem.

I think I resolved the issue. I commented out SQLNET.AUTHENTICATION_SERVICES= (NTS) from sqlnet.ora. Now it looks like I can connect.

I installed Oracle 9i as administrator of the local machine and can successfully establish a connection while logged on as administrator. However, when I log off and log in as myself onto the domain, I cannot connect. I've received both the
ORA-12571: TNS packet writer failure
and
ORA-03113: end-of-file on communication channel error
errors. The database and TNS name services are running.
tnsping reports:
Z:\>tnsping 192.168.1.100 TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 03-NOV-20 03 11:48:42 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: d:\oracle\ora92\network\admin\sqlnet.ora Used HOSTNAME adapter to resolve the alias Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.1. 100))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.100)(PORT=1521))) OK (30 msec)
sqlplus scott/tiger reports:
Z:\>sqlplus scott/tiger SQL*Plus: Release 9.2.0.1.0 - Production on Mon Nov 3 11:50:55 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-12571: TNS packet writer failure Enter user-name:
The sqlnet.log file reports the following error:
Fatal NI connect error 12631, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) VERSION INFORMATION: TNS for 32-bit Windows: Version 9.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production Time: 03-NOV-2003 12:25:20 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12631 TNS-12631: Username retrieval failed ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0
Any ideas what is preventing users of the domain from connecting to the Oracle database that was installed on the local machine and how I can fix this?
Specs: Win2K SP4
Oracle 9i
512 MB RAM
50 GB HDD
TIA,
- John
[ November 03, 2003: Message edited by: John Sinues ]
[ November 03, 2003: Message edited by: John Sinues ]
[ November 03, 2003: Message edited by: John Sinues ]

Finally, after an agonizing six weeks of waiting, I finally received the results for the Sun Certified Developer for the Java 2 Platform exam. I PASSED!

Here's the actual breakdown of the exam:
Test: Sun Certified Developer for the Java 2 Platform (310-027)
Date Taken: 2003-09-30 12:44:18.233
Registration Number: xxxxxxxxxx
Site: va19
Grade: P
Score: 146
Comment: This report shows the total points that could have been awarded in each section and the actual number of points you were awarded. This is provided to give you per-section feedback on your strengths. The maximum possible number of points is 155; the minimum to pass is 124.
Section Summary Report:
General Considerations: Maximum=58 Deductions=5 Actual=53
Documentation: Maximum=20 Deductions=2 Actual=18
GUI: Maximum=24 Deductions=2 Actual=22
Server: Maximum=53 Deductions=0 Actual=53
Total: Maximum=155 Deductions=9
Certification Score=146
Thanks to JavaRanch and all those people over the years who provided me with ideas and feedback for the Fly By Night assignment. I had one of the early assignments that required a conversion program. After three years and a number of life event changes, I'm very happy to have finally completed this certification.
It has been a great learning experience and I would encourage anyone considering the SCJD to go for it. I feel it would be even more beneficial if Sun (or whoever the graders are), if they could provide additional written feedback to the scores on both successful and unsuccessful results. I feel it would be a valuable asset for the candidate. On a positive note, I would like to give compliments to Sun for their quick responses. I ended up emailing who2contact@central.sun.com on numerous occasions to determine the status of my exam. They responded in a friendly and timely manner.
Sincerely,
John Sinues

You'll need to un-jar it. Try jar xvf <filename>. You may have to fully qualify the path of the jar executable, e.g. c:\j2sdk1.4.1_02\bin\jar
If you only have the JRE installed, then you'll need to download the SDK and install it.
- John

Congratulations.
How long did it take for Sun to post the results?
- John

I used origin and destination field in the search functionality. Is it enough?

Would you get more points if you search on all three: carrier, destination, and origin? It isn't difficult to implement all three criteria and if it keeps one from losing points, it seems worthwhile to implement.
I chose to filter by all three criteria even though my instructions say

the user should be able to select the origin and destination of flights.

One main reason to implement it is that it is a good way to ensure the criteriaFind method works correctly with various combinations of carrier, destination, and origin filter criteria.
- John
[ August 11, 2003: Message edited by: John Sinues ]

According to my FBN instructions, the following are valid configuration parameters:

DNS name of the server

Port number used by the server

Data file name(s)

java.rmi.server.codebase

security manager policy file

Failure to adhere to these directions will result in automatic failure.
My question is, do you think it is ok to to use -? as a command line argument to display a program's usage clause? My reasoning is YES, since this is not a configuration parameter. What do you think?
- John

Naveen,
In your FAQ, you can also mention the Sun vouchers can be purchased online at
SCJD Certification.
- John

Andrew,
I greatly appreciate your input.

To be honest - I don't understand what this code is doing.
Your first try catch block should create the file unless it exists, in which case you give an option to delete it.
Wouldn't it be easier just to use the normal File.exists() method rather than trying to create the file to verify if it exists?

After running the sample code that you provided, I kept wondering to myself, why didn't I use the File.exists() method The way I implemented the creation of the datafile, as you pointed out, was not clear. So I reworked the code using the File.exists() method and tested it this morning. Everything works now.
It's been awhile since I actually worked on my conversion program (January 2001 according to the header). I can finally see the end to this project. Just a couple more weeks then I think I'll be ready to take the plunge and submit my project and take the exam. Thanks again for your input and the code review -- you just saved me a couple of points!
- John
[ July 18, 2003: Message edited by: John Sinues ]

Hi Andrew,
Thanks for the quick response.
In response to some of your questions:
1. The example code that you provided works fine under Red Hat, SunOS, and Windows.
2. Methods/classes to create the file, here's a code excerpt:
: : Data airlineDataFile = null; try { airlineDataFile = new Data(outputFile, fieldInfo); } catch (IOException ioex) { char result = getUserResponse( "\n" + ioex.getMessage() + ". Remove file [Y/N]? "); if ((result != 'Y') && (result != 'y')) { System.out.println("No action taken. Exiting application."); System.exit(0); } } System.out.println(outputFile + " created."); (new File(outputFile)).delete(); if (airlineDataFile == null) { // An existing database file was deleted. Re-create it. try { airlineDataFile = new Data(outputFile, fieldInfo); } catch (IOException ioex) { System.out.println("ERROR: " + ioex.getMessage()); System.exit(0); } } : :

After looking at the code, again, I'm beginning to think the .delete() method is the culprit under Unix. What do you think?
- John

I have one of the earlier assignments which requires the development of a conversion program.
Under Windows, the program works fine. When I type
java -jar ConvertDB.jar flight_data.txt db.db
a db.db file is created in the local directory.
Unfortunately, under UNIX (Red Hat, Mandrake, and SunOS), running the same command does not result in a file being created. The program completes correctly and no errors are reported. However, if I create the file first by typing
touch db.db
then run the above command, everything behaves normally. I've tried different shells (sh, csh, tcsh, bash) with no success. Directory permissions are 777.
Any ideas?
- John

Thanks Andrew. You are correct in that I was using a variation of csh (tcsh in my case). After changing to sh or quoting the option, e.g. '-?', everything worked fine.
Thanks again,
- John