Posts

Showing posts from September, 2012

Kill a process using a Port

Image
This is gonna be a fast post, sometimes I get a error in NetBeans that says I can't run the application because the port 8081 is used by other app, then I have to kill that app. first we have to find it running the next command in a Console netstat -n -o This will print Protocol | Local Address | ForeginAddress | State | PID the important columns are " Local Address " where you will search for the port and " PID " that will show you the Process ID that is using it.. when you find it, type the next command changing the PID that is using the port in this case it is 5275 taskkill /PID 5272 if you get any trouble, add /F to force it to end. That's all.... Celebrate like kashiyuka because you killed that annoying Process and after do it 4 times more you will get a " Killing Spree " ;)

Copy All the data from a DataBase using Apex

Image
Sometimes we don't have access to the Data Base it self and we can't make an export of the Data Base, in my case, I can only access through Apex, so I had to find a way to copy all the data to other Data Base, and probably, as it happened to me, all what you have found is the long way, download Table by table and then upload it, well, that could be enough if you have less than 10 tables, but if you have more, it would take many time, many click.. and bajh, We're to lazy to do it :P and I don't if you've heard this were you live, but "The Laziness is the mother of all inventions" hehehe.. Unfortunately ( And forgive me by lying with 'all' in the tittle ) this method will not work with tables that have columns of type Clob, Blob or Long ( and maybe others ). Maybe this will not be a problem if your data base has not many tables with data of that type, then you can use it for the others and upload one by one the tables with columns of that type.