Sunday, April 16, 2006

What 360 degrees Database Programming Means


As some of you have asked me privately -- don't be shy, post your comments :), what the h. does 360 degree database programming means? Well, 4 things that i will elaborate on in following posts: (1) the database functionality itself, (2) calling database functionality from within the database, (3) calling database functionality from outside (client, middle-tier, etc), and (4) calling external system/functionality from within the database.

44 comments:

Anonymous said...

Any tool(s) recommended to this approach?

Kuassi Mensah said...

Thanks for your comment.
I guess you are referring to IDEs. For (i) i.e., building user-defined database funtionality (using PL/SQL and /or Java), as well as (4) i.e., calling out external system from within the database you can use Oracle JDeveloper as well as third party IDEs that support the Oracle database. Alternatively, for Java only, you can use any Java and/or Eclipse-based IDE to build the functionaliy then upload in the database, using loadjava command-line. In my next posts I'll touch on tools for making database functionality known to SQL and other components (internally and externally).

Kuassi Mensah said...

For PL/SQL, i'd also recommend the Oracle SQL Developer (formerly RAPTOR).

Anonymous said...

Thank you.

Mike said...

Kuassi,

I just read your book "Oracle Database Programing with Java and Web Services". It's really an amazing book.

I have a question about Oracle RAC and JDBC FCF. My question is if I used RAC, then I don't need to configure the connection pool from the Application Server side, e.g. WebSphere. Is it correct?

Kuassi Mensah said...

Mike,

Thanks for your appreciation of the book. Yes, you might not need to use Websphere's connection pool if the Java components can manage the persistence itself (i.e., POJO, Servlet, JSP, Bean-managed persistence EJB, and so on) however, as soon as you need transactional service from the container, it'll fail. The real and complete solution is for WebSphere to recognize OracleDataSource.

For those who do not have the book (yet!)the following blog entry http://db360.blogspot.com/2007/01/is-your-java-application-failoverproof.html descibes JDBC suppport for RAC.

Kuassi

Mike said...

Kuassi,

With FCF enabled, what kinds of Oracle RAC failure senarios can be handled by FCF? At what senarios actions need to be taken from application tier?

Thanks,
Mike

Kuassi Mensah said...

Hi Mike,

I think the following blog entry responds to your questions: http://db360.blogspot.com/2007/01/is-your-java-application-failoverproof.html

Kuassi

Mike said...

Hi Kuassi,

I am testing with our DBA about enabling FCF. It works fine when we bring down the service. But we got a problem when bring down the instance. We get the following error, and FCF does not work this time. The DDBC driver we used is of version: 10.2.0.3.0. Do you have any idea what could be the problem?

Thanks a lot,
Mike

=========
Caused by:
java.sql.SQLException: OALL8 is in an inconsistent state
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1021)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:233)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:512)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:80)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
at org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:684)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:681)

Kuassi Mensah said...

Mike,

"OALL8 is in an inconsistent state" is usually a bug in the driver itself (i.e, the state machine). An OALL8 related bug has been fixed in 10.1.0.4 and 10.2.0.3 but this is the first time we are hearing about RAC related OALL8. I am told that you need to file a TAR to help investigation.

Good Luck, Kuassi

Mike said...

Kuassi,

Thanks for your reply. I figured out the problem I mentioned in my last message. In my code, I did the retry only one time. That's why I got the OALL8 message. Somehow, there is a delay for the establishment of the reconnection. After I changed my code to keep retrying, and this time it works. And it turned out after retrying 16 times, the new connections were established to the second instance.

After solving that problem, we got a new one. That is the connection load balance didn't work as expected. We have two Oracle instances running in our RAC, and I have 10 connections. When I first started my app, all these 10 connections went to only one instance, not load balanced to two instances. We have the following property set up in the connection URL:

DESCRIPTION = (LOAD_BALANCE=on)

Is this the correct setting? When I google this settings, I found some people set the LOAD_BALANCE to "true", and some set it to "YES". Which one is correct?

Thanks,
Mike

Kuassi Mensah said...

Hi Mike,

Up to 10.1, we only offer connect-time load balancing, set
LOAD-BALANCING=On and in addition PREFER_LEAST_LOADED_NODE_[listener]=OFF

in 10.2 (both RDBMS and JDBC), we furnish Runtime Connection Load Balancing, using Workload Metrics. This is well documented in the book.

Good luck, Kuassi

Ayisha said...

Nice and knowledgeable gifts for everyone-
booksshelf
knowledge
books
liberary
kitaben
Books and references
books

mineral makeup said...

companies marketing mineral makeups and also get the best bargains in mineral makeup you can imagine,
find aout how to consolidate your students loans or just how to lower your actual rates.,
looking for breast enlargements? in Rochester,
homeopathy for eczema learn about it.,
Allergies, information about lipitor,
save big with great bargains in mineral makeup,

change edition interviewing motivational people preparing second
,

interviewing motivational people preparing second time
,

interviewing people motivational preparing for a second time
,

black mold exposure
,

black mold exposure symptoms
,

black mold symptoms of exposure
,

free job interview questions
,

free job interview answers
,

interview answers to get a job
,

lookfor hair styles for fine thin hair
,

search hair styles for fine thin hair
,

hair styles for fine thin hair
,

beach resort in the philippines
,

great beach resort in the philippines
,

luxury beach resort in the philippines
,
iron garden gates, here,
iron garden gates,
wrought iron garden gates
, here
,
wrought iron garden gates
,
You: The Owner's Manual: An Insider's Guide to the Body That Will Make You Healthier and Younger
,
eat eating mindless more than think we we why
,


texturizer,
texturizers here,
black hair texturizer,
find aout how care curly hair,
find about how to care curly hair,
care curly hair,
lipitor rash,
lipitor reactions,
new house ventura california,
the house new houston tx,
new house washington dc,
new house pa philadelphia,
san antonio tx house new,
house new pa philadelphia,
new house washington dc,
new house ventura california,
the house new houston tx,
house new san antonio tx,
the house new houston tx, that you are looking for,
new house ventura california, you need to buy,
new house washington dc,
house new pa philadelphia,
new house san antonio tx,

hair surgery transplant
,

air filter allergy
,

refurbished dell laptop computers
,

hair surgery transplant
,

air filter allergy
,

refurbished dell laptop computers
,

hair surgery transplant
,

air filter allergy
,

refurbished dell laptop computers
,

chocolate esophagus heartburn study
,

chocolate esophagus heartburn study
be informed,

digestion healing healthy heartburn natural preventing way
,

digestion healing healthy heartburn natural preventing way
,
sew skirts, 16simple styles you can make!,
sew what skirts 16 simple styles you,
rebates and discounts on sunsetter awnings,
sunsetter awnings discounts and rebates,
discount on sunsetter awnings


truck and bus tires 12r 22.5, get the best price,
tires truck and bus 12r 22.5 best price,
tires truck bus tires12r 22.5 best price,
plush car seat strap covers,
car seat strap covers,plush,
car seat strap, plush covers,
oscoda voip phone systems, the best!,
oscoda voip the phone system,
oscoda voip phone systems,
exterior iron gates,
oriental wrought iron gates,
powder coated iron garden fencing,

iron gates said...

black mold exposure,
black mold symptoms of exposure,

wrought iron garden gates,
your next iron garden gates, here,

hair styles for fine thin hair,
search hair styles for fine thin hair,

night vision binoculars,
buy, night vision binoculars,

lipitor reactions,
lipitor reactions,

luxury beach resort in the philippines,
beach resort in the philippines,

homeopathy for baby eczema.,
homeopathy for baby eczema.,

save big with great mineral makeup bargains,
companies marketing mineral makeups,

prodam iphone praha,
Apple prodam iphone praha,

iphone clone cect manual,
manual for iphone clone cect,

fero 52 binoculars night vision,
fero 52 night vision,

best night vision binoculars,
buy, best night vision binoculars,

computer programs to make photo albums,
computer programs, make photo albums,

Anonymous said...

We specialize in laptop battery,laptop AC adapters. All our products are brand new, with the excellent service from our laptop battery of customer service team.
the most convenient and cheap replacement battery online shop in uk. We specialize in laptop batteries, laptop AC adapters.
All our laptop AC adapters are brand new, with the excellent service from our customer service team.
the most convenient and cheap battery online shop in uk.
You can find some battery and adapter from here is very cool.

Anonymous said...

bez depozytu bonus free pieniadze dla nowych aktualne zastawienie bonusów
aktualny bonus bez depozytu
Poker Stars nie depozytów, wolne william hill Poker bankroll Mansion darmo pieniądze, mansion Poker wolne pieniądze w pokera, nie deposit
bonusy za darmo
poker za darmo , bonusy bez depozytu, graj w pokera bez obligacji texas hold bankroll buduj wolno ale dokładnie odbiór dla poker rooms Promocje dla nowych graczy
titan room mansion party poker pkr bet most i inne platformy room omaha texas hold em

Poker bonus without deposit … Free without deposit poker cash say requirments. Good day. No deposit poker bonus… Free online game without signing upays
online poker site free start up money
Complete list of the best free poker money free poker bankroll online poker site free start up money
texas omaha or room of glory online poker site free start up money free poker cash bankroll
no deposit poker bankroll
. Walker Poker is a free for me, state of the , softwalay online poker no deposit poker bankroll
free poker bankroll for mansion uniqe poker room rooms uniqe room poker
leading provider of free money promotions.Bonus Codes that give You Free Poker Money without making a deposit.
free and no deposit poker bankroll
free poker cash and money, chips build bankroll without deposit
sorry if spam for you ..

Anonymous said...

童裝批發
童裝批發
童裝
童裝
酒店喝酒
酒店消費
暑假打工
寒假打工
酒店經紀人
酒店現領
禮服店
酒店小姐
酒店兼職
酒店上班
酒店兼職
禮服店
酒店上班
酒店打工
酒店小姐
酒店經紀
酒店兼差
假日打工
台北酒店經紀
寒暑假打工
專業酒店經紀
酒店藝名
台北酒店
酒店日保
酒店入行
台北禮服店
酒店類型
酒店午場
酒店規定
酒店行政
酒店資訊

Anonymous said...

Get a $50 plus $50 free poker bankrolls. Blog bet365 with 100's of players online. Startup money and funding cash.
Free start bankroll are involved for any black and white people. So Poker blog and you can find all possible bonuses for turkey and dominicana.
Detailed reviews for the top platform. Stay away from poker pages, be sure that you friendly online and have nice freeroll.
Good poker sponsorship and free blog rules.
As alvays welcome.

Edwin said...

Buy Kamagra
Earn Google
Viagra Cialis
Cheap Kamagra
Cheap Viagra
Cheap Cialis
Make Money on Google
M65 Jacket
M65 Field Jacket
Airline Dog Carrier
Airline Dog Carriers
Viagra Cialis
Earn Google
Airline Dog Carrier
Airline Dog Carriers
Airline Approved Dog Carriers
ED Hardy Wholesale
Copy DVD Software
How to Send Fax
14k Yellow Gold
Redneck Costume
14k Gold Heart
Tandem Baby Stroller

kimberly sayer said...

costa rica fishing vacations
sport fishing in costa rica
costa rica fishing charters
costa rica deep sea fishing
costa rica fishing package
costa rica sport fishing
costa rica fishing tours
costa rica fishing lodge
costa rica fishing trips
fishing jaco costa rica
costa rica surf fishing
fishing in costa rica
tours of costa rica
costa rica fishing
saltwater fishing
offshore fishing
manuel antonio
salmon fishing
sport fishing
fishing guide

http://www.fishingcostaricaexperts.com

inversiones rentables said...

Great information, you have a wonderful blog and an excellent article!!

VUONG said...

先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
事業再生
経営計画書
経営改革
経営改善
会社分割
経営コンサルティング
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
浮気調査 東京
浮気調査 東京
備考調査 追跡調査 東京
不倫調査 離婚調査 東京
浮気調査 素行調査 東京 
ストーカー相談 ストーカー対策 東京
結婚調査 結婚詐欺 東京
信用調査 企業調査 東京
調査料金 東京
身上調査 身元調査 身辺調査 東京
所在調査 東京
夫 妻 浮気 東京

VUONG said...

結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
結婚相談所 東京
ビジネス英会話
ビジネス英語 メール
英語塾
社会人入試
ビジネススクール 英語
ニキビ跡
パッケージ
会社設立 東京
エンジニア 派遣
東横 賃貸
田園都市 賃貸
デザイナーズ 賃貸
恵比寿 賃貸
学芸大学 賃貸
目黒 賃貸
中目黒 賃貸
新築 賃貸
ペット可 賃貸
三軒茶屋 賃貸
エンジニア転職
販売管理
過払い
任意整理
液晶テレビ 激安

VUONG said...

先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
事業再生
経営計画書
経営改革
経営改善
会社分割
経営コンサルティング
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
婚活 相談
浮気調査 東京
浮気調査 東京
備考調査 追跡調査 東京
不倫調査 離婚調査 東京
浮気調査 素行調査 東京 
ストーカー相談 ストーカー対策 東京
結婚調査 結婚詐欺 東京
信用調査 企業調査 東京
調査料金 東京
身上調査 身元調査 身辺調査 東京
所在調査 東京
夫 妻 浮気 東京

Lots in Costa Rica said...

Hello I want to congratulate to them by its site of the Web of the excellent looks like entertained and very good very to me it elaborated. I invite them to that they explore a little on my Web site. Lots in Costa Rica

britney sayers said...

costa rica tours, shopping online, costa rica fishing, jaco fishing charters, costa rica whale watching, costa rica dolphin watching, costa rica party boat, panama fishing, fishing costa rica los suenos, los suenos fishing charters, costa rica fishing los suenos, los suenos costa rica fishing, costa rica los suenos fishing, fishing costa rica los suenos, los suenos fishing charters, costa rica fishing los suenos, los suenos costa rica fishing charters, costa rica los suenos fishing,
http://www.kingtours.com/.

Ephesus said...

I loved every moment of our tour. Istanbul, cappadocia and ephesus are fantastic city. We saw so many historical places and guide was very informative. We definitely recommend it. http://www.packagetoursturkey.com - http://www.touroperatoristanbul.com We visited Istanbul for the first time on your tour turkey tours we are from Cappadocia tours Greece and we just loved it! istanbul tours We finally were able to see sights that we had only heard from our friends who visited I have to say that this trip was fantastic. I had a great time in Turkey. Everything went on very well actually much better than we expected istanbul travel Our guide was very friendly and ephesus tours he knew all details of history. Thanks for everything.

istanbul said...

TTG Travel Agency is a leading travel agency and tour operator in istanbul Turkey with more than seven years of professional travel service. Because of our dedication and commitment to your needs istanbul travel we are able to offer you better quality of service at lower prices than other operators. http://www.istanbulhotels.com We provide hundreds of elaborately pre-designed Turkey tour packages, Turkey tours discounted, Guided turkey hotels and Turkey Tours, and we also provide customized travel service that is organized according to your specific needs and requirements http://www.istanbulhotels.com Our tours are professionally guided, intimate, and safe.

dell laptop batteries said...

nice your blog and very nice dear your blog Ranking is too Good we like its you can see our also website for online shopping......
laptop batteries

Anonymous said...

cheap chanel handbags
imitation bags
replica marc jacobss
coach imitation
imitation prada
imitation gucci
replica chloe bags

nike free run 2 said...

Nike Free 3.0 womens shoes sale,
Nike Free Run plus 2 2011 style shoes
Nike free run plus shoe for sale,
Nike free run womens cheap on sale,
Cheap Nike free run shoes Australia,
Nike free run shoes Australia collection,
Nike free 2011 style shoes.

Patrick Stephenson said...

It is such an interesting thing having this post of yours. I was interested with the topic as well as the flow of the story. Keep up doing this. cheap kamagra

vegas weddings and receptions said...

I just read your book "Oracle Database Programing with Java and Web Services". It's really an amazing book.

vegas weddings and receptions said...

In my next posts I'll touch on tools for making database functionality known to SQL and other components (internally and externally).

Elliott Broidy said...

Interesting

vegas weddings and receptions said...

In my next posts I'll touch on tools for making database functionality known to SQL and other components (internally and externally).

vegas weddings and receptions said...

Bean-managed persistence EJB, and so on) however, as soon as you need transactional service from the container, it'll fail. The real and complete solution is for WebSphere to recognize OracleDataSource.

Costa Rica Weddings said...

Costa
Rica Fishing Packages
, Costa
Rica Fishing Boats
, Costa Rica Fishing,
Costa Rica Sport
Fishing Packages
, Costa Rica
Fishing
, Costa Rica
Fishing Packages All Inclusive
, Fishing Trips Costa Rica,
Los Suenos Costa Rica Fishing,
Los Suenos Costa Rica Fishing Charters
, Costa Rica Fishing Vacation Packages,
Costa Rica Fishing Packages All
Inclusive
, Costa Rica Fishing
Trips
, Costa Rica Fishing Trips
All Inclusive
, Sport Fishing
Costa Rica
, Costa Rica Sport
Fishing Charters
, Sportfishing
In Costa Rica
, Jaco Costa Rica
Fishing Charters
, Jaco Costa
Rica Fishing Packages
, Jaco
Costa Rica Sport Fishing

Costa Rica Weddings said...

Costa Rica
Weddings
, Costa Rica
Wedding Packages
, Costa
Rica Weddings All Inclusive
,Wedding In Jaco Costa Rica,
Costa Rica Beach Weddings,
Los Suenos Wedding,
Jaco Costa Rica Wedding,
Jaco Wedding Planner,
Costa Rica Married,
Wedding Planning Costa Rica,
Costa Rica Wedding Locations,
Costa Rica Wedding Venues,
Costa Rica Wedding Packages All
Inclusive
, Costa Rica
Wedding Planner
, Getting
Married Costa Rica
, Costa
Rica Destination Weddings


Los Suenos Costa Rica,
Los Suenos Costa Rica Condos For Rent,
Los Suenos Costa Rica Vacation Rentals,
Los Suenos Condos For Rent,
Los Suenos Vacation Rentals,
Los Suenos Condominiums,
Los Suenos Condo Rental

wasirdenature said...

kenapa keputihan tidak normal dan mengeluarkan nanah obat kutil herbal di kemaluan cara menghilangkan kutil kemaluan secara alami tips menghindari kutil kelamin tips menghilangkan kencing nanah cara mengobati kelamin keluar nanah obat alam tradisional kencing bernanah obat kutil di kemaluan pria obat kemaluan keluar nanah Obat Ambeien Ampuh Tradisional Resep Obat Wasir obat alami untuk gejala wasir Mengobati Wasir Secara Alami Obat ampuh atasi wasir Obat herbal efektif menyembuhkan wasir Obat untuk kelamin laki laki keluar cairan nanah Obat kemaluan keluar nanah atau gonore Obat cairan nanah keluar dari alat kelamin Mengapa kencing sakit dan keluar cairan nanah Mengapa kencing perih dan keluar nanah Mengapa nanah keluar dari kelamin Obat untuk kutil di sekitar bibir vagina Obat kencing nanah manjur menghilangkan benjolan kutil di vagina wanita

wasirdenature said...

cara mengobati kemaluan keluar nanah obat kemaluan keluar nanah ujung kemaluan keluar nanah obat penis keluar nanah kelamin pria keluar nanah obat kelamin pria keluar nanah obat kelamin pria keluar nanah mengapa alat kelamin keluar nanah kemaluan laki laki keluar nanah kemaluan keluar nanah kemaluan keluar cairan nanah mengapa kemaluan keluar nanah cairan nanah keluar dari kemaluan kencing perih dan keluar cairan nanah cairan nanah keluar dari kemaluan pria mengapa cairan nanah keluar dari kemaluan kemaluan pria keluar nanah penyebab kemaluan keluar cairan nanah cara mengobati kemaluan keluar nanah kemaluan keluar nanah di sertai perih saat kencing mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kelamin keluar nanah mengobati kemaluan pria yang keluar nanah

lionelmessi10 said...

cara mengobati kemaluan keluar nanah obat kemaluan keluar nanah ujung kemaluan keluar nanah obat penis keluar nanah kelamin pria keluar nanah obat kelamin pria keluar nanah obat kelamin pria keluar nanah mengapa alat kelamin keluar nanah kemaluan laki laki keluar nanah kemaluan keluar nanah kemaluan keluar cairan nanah mengapa kemaluan keluar nanah cairan nanah keluar dari kemaluan kencing perih dan keluar cairan nanah cairan nanah keluar dari kemaluan pria mengapa cairan nanah keluar dari kemaluan kemaluan pria keluar nanah penyebab kemaluan keluar cairan nanah cara mengobati kemaluan keluar nanah kemaluan keluar nanah di sertai perih saat kencing mengobati kemaluan keluar nanah pada pria mengobati kemaluan keluar cairan nanah pada pria mengobati kelamin keluar nanah mengobati kemaluan pria yang keluar nanah

lionelmessi10 said...

kenapa keputihan tidak normal dan mengeluarkan nanah obat kutil herbal di kemaluan cara menghilangkan kutil kemaluan secara alami tips menghindari kutil kelamin tips menghilangkan kencing nanah cara mengobati kelamin keluar nanah obat alam tradisional kencing bernanah obat kutil di kemaluan pria obat kemaluan keluar nanah Obat Ambeien Ampuh Tradisional Resep Obat Wasir obat alami untuk gejala wasir Mengobati Wasir Secara Alami Obat ampuh atasi wasir Obat herbal efektif menyembuhkan wasir Obat untuk kelamin laki laki keluar cairan nanah Obat kemaluan keluar nanah atau gonore Obat cairan nanah keluar dari alat kelamin Mengapa kencing sakit dan keluar cairan nanah Mengapa kencing perih dan keluar nanah Mengapa nanah keluar dari kelamin Obat untuk kutil di sekitar bibir vagina Obat kencing nanah manjur menghilangkan benjolan kutil di vagina wanita