Skip to Main Content

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Vector<Vector> v = new Vector<Vector> problem to loop

843789Nov 21 2009 — edited Nov 21 2009
Hello. I have this enoying problem. ill just show it with code.
Vector<Vector> v = new Vector<Vector>();
Vector<String> s = new Vector<String>();

s.addElement("a");
s.addElement("b");
s.addElement("c");

v.add(s);
This is how it looks. Now i would like to loop it out using Iterator.
Object done = null;
Iterator itr = v.iterator();
  while (itr.hasNext()){
  done = itr.next();
}
The loop just goes thrue the first Vector, and the Object done now has the result [a,b,c]. How can i now loop the Object done so the result will be a,b,c.

Edited by: MagnusT76 on Nov 21, 2009 2:26 AM

Comments

Billy Verreynne

With a 12c wallet you only need the RA and/or CA certificate - and not the server certificate. Which seems to be what you have loaded? You did not also add the outlook.com server certificate to the wallet?

I still have wallet issues with 12c that do not exist with 11g - with strong RA/CA certificates not working in 12c wallet, but weak ones (with an old cypher for example) do.

seanzh

Thank you Billy,

No, I did not add "outlook.com" certificate, if I follow this blog https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6121/index-en.html I only need the topmost CA, which is Digicert Global Root Certificate but this doesn't make difference either so I am at my wit's end. I first tried on DB 11.2.0.4 with similar error: "ORA-28862: SSL connection failed", I thought 11G might be dated so I installed a brand new 12C for this purpose alone. the following is my screenshot on OWM

Screen Shot 2018-02-20 at 7.53.19 AM.png

Billy Verreynne

I suggest you file a SR with Oracle Support - do not see why your wallet should not work.

Bas de Klerk
Answer

Hi,

I'm not a mailserver specialist but to me it looks like there are a lot of (tiny) restrictions which make that APEX_MAIL/UTL_SMTP does not always work or is really hard to configure and/or debug. I found that a really easy and flexible way to get around that is have apex send it to a local (on db server) postfix instance which handles all the authentication etc. APEX then just listens locally for mail from apex and postfix forwards it to your endpoint. In ORA-29279: SMTP Permanent failure: 535 authentication failed (#5.7.1) I posted some links on how to configure this.

Regards

Bas

Marked as Answer by seanzh · Sep 27 2020
seanzh

Thank you Bas,

I tried your way: startup Postfix and edit 5-6 lines like relay host and password file, it works!

This is closest thing to normal client submission, see MS doc section here, it's called INDIRECT CLIENT SUBMISSION, it's slightly more restrictive such as I must use the login user email as sender address or else I got "550 5.7.60 SMTP; Client does not have permissions to send as this sender" but this is minor. I am also going to open support SR to see if I can get this working without another relay server. Wii post progress here should I get any from support.

Screen Shot 2018-02-21 at 3.05.50 PM.png

seanzh

actually I made progress, Oracle support helped a  bit.

1) I got it working oracle 11GR2, the 2 certificates are CORRECT ones( I guess the cloud service  alone might be enough but I just loaded 2, see above photo).  Making sure SSL/TLS settings is on "after connection is established", I picked YES which is incorrect, Oracle SR pointed this out. Besides this setting, I need reboot Oracle server to make sure Wallets and Instance setting taking effect ( strange). but otherwise it's good to go

2: 12.2 is NOT working,  there is a new  SECURE_HOST parameter which is missing for this GUI instance settings:  smtp.office365.com is  SAN alias of outlook.com, Apex mail gets complaining about : "certificate mismatch", I quote support notes here:

Now the error you are seeing ORA-24263: Certificate of the remote server does not match the target address.-----if TLS established after connection (the correct one) Is NOT really in the APEX configuration or something you can/should do on APEX side

I believe you are seeing what is describe in below Database Note, which is not something you can configure in any APEX instance setting, still I will ask developers if anything we could do and let you know

UTL_HTTP / UTL_SMTP Request Fail With ORA-24263 On A 12.2 Database ( Doc ID 2275666.1 )

*update: I got an internal patch from Joel Kallman and it solved this SAN thing, it added an extra parameter called SMTP_SECURE_HOST to point the real  CN (outlook.com here), I can't publish it here as it's  belonged to Oracle support.  This problem is considered solved

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 19 2009
Added on Nov 21 2009
2 comments
181 views