Cute Thing

Bo' that cute litle creature do remembers all ups and downs, monyong2 nya, bukan cuma liriknya!
Subhanallah, gw ga ragu sama sekali kalo metode ini bisa berhasil. Bukan berarti cewek kecil di atas punya masalah kerusakan otak loh yah. Tapi emang otak manusia itu Subhanallah deh. Ckckckck.

Recreate sequence using PL/ SQL

Recreate sequence using PL/ SQL:

For example, if the last value used by the Oracle sequence was 100 and you would like to reset the sequence to serve 225 as the next value. You would execute the following commands.

alter sequence seq_name increment by 124;
select seq_name.nextval from dual;
alter sequence seq_name increment by 1;

Now, the next value to be served by the sequence will be 225.

Seems handfull and confusing huh?
But it works just fine.
Just don't use it before exception DUP_VAL_ON_INDEX.
Or else, your sequence will grow like mushroom in rainy season :)

Alhamdulillah, Akhirnya

Francis-nya Indiana

Awww, ih, pengen gila punya pasangan kaya Francis Marijono.
Percaya diri, love it! It represents all good things that come after, kalem, romantis, penyayang, rasional.
And -this one is also come from gens and heritage- pebisnis handal.
Dansa di yacht pribadi, di dermaga di depan rumah pribadi, di Singapura!
Allah yang Maha Baik, saya mau saja merelakan semua itu demi ridho Mu. Tapi tetep aja saya mauuuuuuuuuuuuuuuuuuuuuu. Hehehehe.
Ok, should read deh Indiana Chronicles yang Lipstick.
Kamu mungkin bakal ngiri sama Indi atau naksir sama Francis, tapi jangan lupa, kamu (dan saya) punya hidup sendiri, karunia dari Allah. Jangan buat Dia sia-sia menciptakan kamu (dan saya) instead of menciptakan Francis, huehuheuhuehuehuehue.

Types of PL/ SQL Exceptions

List of exception you might want to catch in your PL/ SQL program

Takut, Bersyukur, Tawakkal

Alhamdulillah, another step closer to Pertamina

Showing Leaked Connection Stacktrace in WebLogic Server

This afternoon I was get very anxious about what shows in cgServer.log and nohup.out.

####Nov 6, 2006 5:35:16 PM WIT Warning JDBC galaxydev1 cgServer Finalizer anonymous BEA-001074 A JDBC pool connection leak was detected. A connection leak occurs when a connection obtained from the pool was not closed explicitly by calling close() and then was disposed by the garbage collector and returned to the connection pool. The following stack trace at create shows where the leaked connection was created.

But no stacktrace is printed there! Oh, how much I'am willing to fix that leaked connection.

Thank God, by just simply tick Enable Connection Leak Profiling from [domain_name]> JDBC Connection Pools> [connection_pool_name], the stacktrace was hanging there nicely.

Stack trace at connection create:

at weblogic.jdbc.wrapper.JTAConnection.init(JTAConnection.java:76)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:409)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:354)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305)
at com.indosat.csf.dao.DAOConnectionImp.getDBConnection(DAOConnectionImp.java:76)
at com.indosat.csf.geneva.adapter.CProductAccount.getProductId(CProductAccount.java:119)
at com.indosat.csf.geneva.adapter.CProductAccount.getProductList(CProductAccount.java:185)
at com.indosat.csf.geneva.adapter.CProductAccount.getProductbyAccount(CProductAccount.java:325)
at com.indosat.csf.process.main.modules.SearchProductbyAccount.perform(SearchProductbyAccount.jpd:130)

Yes! Next problem please ...

PR, Belajar UML

Secara hari ini waktunya cari2 tentang SCJP, ternyata ketemu page bagus untuk belajar UML. Jadi deh, PR untuk di baca di waktu yang tepat. Nih.