ozzy – Page 15 – another wp blog

find all columns in oracle named as district_id

I had a problem today. it was about changing all district_id in a whole database. so I need to find who used district_id as column name in tables in oracle.

here is how I find it.
Select COLUMN_NAME,table_name from user_tab_columns where table_name in ( select object_name from user_objects where object_type=’TABLE’ ) and COLUMN_NAME =’DISTRICT_ID’ and I changed all values from found tables.

test your disks in linux

I have a linux server which has 2 disks on it. one of them is SSD and other is SATA disk. I wondered how fast is ssd is here is the output 🙂 root@mascix.com: ~ # hdparm -t /dev/sdc /dev/sdc: Timing buffered disk reads: 598 MB in 3.00 seconds = 199.03 MB/sec root@mascix.com: ~ # hdparm -t /dev/sda /dev/sda: Timing buffered disk reads: 266 MB in 3.00 seconds = 88.55 MB/sec I should say this test done when server has load on it. pretty nice

EndoSession

one of my dead project which was about endoscopic data capture and saving in mp4 format. which was using blackmagic card to capture all data and it was working in linux with power of QT and ffmpeg.

I was thinking I may publish in google code svn repo. but there is no development plan on it so no need to have any repo. people who need to capture data from blackmagic capture card and save it in video file may find this as helpfull example.

strange java hibernate story from today

today I was developing a new request from customer. its not a big issue just adding a new Boolean field will cover the request and will work happly ever after. I added my new “isActive” field into hbm xml then pojo. and started the app in windows with tomcat maven plugin. there was nothing wrong hibernate started up smoothly and update the table and added my new field into the persistent level. I like hibernate more, everyday 🙂

its just like a dog. best friend of men. which helps for everything and expects only our love 😀 anyway I decided to deploy our new class to server which runs weblogic 11g. I went to ssh and run “svn up” then “mvn install” then went back to weblogic console for updating our big webapp. then I gave the path of war and said update then started the app. then started waiting log to come and make me smile 🙂 and it said there is no getisactive function in the class. I just added and run in my laptop it was working fine. how the hell it happens I have no idea. java and oracle has a lot issues and terminology and keywords. I probably clash with one of them.

then I convert my field name to XboxActive and changed function names respectively. then without trying in my laptop directly deployed it. and it started working. sometime I dont have the power to investigate all details of a problem. and this is one of them 🙂

just a simple note dont use “isActive field ine a complex hibernate spring project if it runs on weblogic” 🙂

publishing and reading from jms

simple java class for reading and writing to weblogic jms. import java.net.URL; import java.rmi.RemoteException; import java.util.ArrayList; import java.util.Hashtable; import java.util.List; import javax.jms.Message; import javax.jms.MessageListener; import javax.jms.MessageProducer; import javax.jms.ObjectMessage; import javax.jms.Queue; import javax.jms.QueueConnection; import javax.jms.QueueConnectionFactory; import javax.jms.QueueReceiver; import javax.jms.QueueSession; import javax.jms.Session; import javax.jms.TextMessage; import javax.naming.Context; import javax.naming.InitialContext; import org.apache.axis.AxisFault; public class ReadFromRemoteJms{ public static void main(String args[]) { try { Hashtable env = new Hashtable(); env.put(Context.INITIAL_CONTEXT_FACTORY, “weblogic.jndi.WLInitialContextFactory”); env.put(Context.SECURITY_PRINCIPAL, “weblogicusername”); env.put(Context.SECURITY_CREDENTIALS, “weblogicpassword”); env.put(Context.PROVIDER_URL, “t3://ipaddress:7711”); InitialContext context = new InitialContext(env); QueueConnectionFactory connFactory = (QueueConnectionFactory) context.lookup(“jms/QueueConnectionFactory”); QueueConnection conn = connFactory.createQueueConnection(); QueueSession session = conn.createQueueSession(false, Session.AUTO_ACKNOWLEDGE); Queue q = (Queue) context.lookup(“jms/XboxEventQueue”); QueueReceiver receiver = session.createReceiver(q); conn.start(); ObjectMessage m = (ObjectMessage) receiver.receive(); SomeObjectYouPutIntoJms e = (SomeObjectYouPutIntoJms) m.getObject(); System.out.println(“Message Received: ” + e.getMsisdn()); session.close(); conn.close(); } catch (Exception ex) { ex.printStackTrace(); } } }

swt and maven example

Swt does not come from maven repo with the latest version. but you can use this pom to use latest swt version from nexus testing repo.

pom.xml:
<project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://maven.apache.org/POM/4.0.0" xsi:schemalocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelversion>4.0.0</modelversion> <group>mascix</groupid> <artifact>MavenSwt</artifactid> <version>0.0.1-SNAPSHOT</version> <dependencies> <dependency> <group>org.eclipse.swt</groupid> <artifact>org.eclipse.swt.win32.win32.x86_64</artifactid> <version>3.6.2</version> </dependency> </dependencies> <repositories> <repository> <id>nexus-testing</id> <layout>default</layout> <url>http://maven.eclipse.org/nexus/content/repositories/testing/</url> </repository> </repositories></project>
for a working example eclipse project visit this

chrome code completion ability for canary

I just learned google chrome canary. its kind of an experimental version of google chrome browser. anyways while I was checking out. I saw new code completion ability and I love it.

chek this out:

chrome used to have code completion but not like this selecting from list I love it.

java xsd den class çıkarma

elde bir xsd var ve buna uygun gelen xml lerin java objelerine dönüştürülmesi lazım. bu iş için bi aralar xmlbeans kullanmıştım bakınırken gördümki. jvm e jaxb gelmiş ve başka lib gerektirmeden xml den obje yapılabiliyor.

xsd den clasları generate etmek için

xjc netsis.xsd

bulunulan folder altında generated diye bir foldera gereken classlar çıkar. gelen xml den java objesi yapmak içinde.

ClassLoader cl = ObjectFactory.class.getClassLoader(); JAXBContext jc = JAXBContext.newInstance("com.erke.sm", cl); Unmarshaller u = jc.createUnmarshaller(); Object o = u.unmarshal( new File( "ehe.xml" ) ); NewDataSet nds=(NewDataSet)o; for(Table t:nds.getTable()){ System.out.println("t.getSTOKKODU():"+t.getSTOKKODU()); }

daha farklı yollarla örnekler.

eclipse axis problemleri ve çözümü

elimde bir wsdl var tahminim 2005 den kalma. bu wsdlden webservisi oluşturmam lazım. evvela wsimport ile denedim ama

src-resolve.4.2: Error resolving component ‘soapenc:Array’. It was detected that ‘soapenc:Array’ is in namespace

ve bir sürü devamı var. denedim bişeyler import etmeyi ama gözümde kesmedi şimdi servisi bozmuş olurum fark etmeden. axis2 ile denedim oda buna benzer bir hata verdi. sonunda zaten wsdl 2005 den kalma axis1.4 le yapabilirim diye düşündüm. eclipse le bir güzel oluşturdum deploy.wsdd ve undeploy.wsdd falan çıktı. classlar hazır implementasyonu belli ama localhostdan kendisine ulaşamıyorum 🙂

http://localhost:8080/services/servisPort?wsdl

bu adresden wsdli vermesi lazım. ama böyle bir servis yoktur diyor. okurken öğrendimki webserverı çalıştırdıktan sonra

java -cp $(for i in ~/tools/axis-1_4/lib/*.jar ; do echo -n $i: ; done). org.apache.axis.client.AdminClient -lhttp://localhost:8080/services/AdminService deploy.wsdd

komutunu çalıştırmak gerekiyormuş. buda o esnada çalışan axis sistemine elde yazılı olan servisi load ediyor. ama uygulama start olduğunda bunu yapıyor olması lazım. ve arada bir exception gözüme çarpıyor.

server-config.wsdd bulanamadı hatası. önce deploy.wsdd nin ismini değiştirip direk bu dosya gibi yazdım bu sefer servis wsdl i gelmiyor ama servis var gibi. ulaşmaya çalışınca gelmiyor 🙂 neyse araştırırken öğrendim server config wsdd nasıl oluşturulur

cd webapps/axis/WEB-INF
java -cp $AXIS_CLASSPATH org.apache.axis.utils.Admin server deploy.wsdd

bulunan servera configi çıkarıyor. amma uzun sürdü bir servis ayarlaması. bazen bu tip durumlarda vs.net ve asmx i özlemiyor değilim orda bir webservisi yapmak genelde 10 bilemedin 30 dk lık iş. bu yaklaşık 5 saatimi aldı. gerçi bu wsdl ile .netde bir sürü arıza çıkarabilirdi ya neyse 🙂

REDIT
ahahaha çok güldüm kendime. ulan axis taglı başka yazı varmı diye bloga bakındım buyrun vs.net lede bu bazı wsdlleri çalışır duruma getirmek çok zaman alıyormuş 🙂

ufak bir java testi yaptım

benchmark işinden anlamam ama sakin sakin her önüme geleni uygularım durum şudur.

http://www.ibm.com/developerworks/java/library/j-benchmark1/index.html
adresdeki kodları java 1.6 1.7 ve jrockit için çalıştırdım aldığım sonuçları yayınlamak istedim. hesapta jrockit çok hızlı olmalıydı ama hiç bir parametre vermeyip çalıştırdığımda aldığım sonuçlar aşşağıdadır.

jrockit – Execution time: 666.827578 milliseconds
java 1.6 – Execution time: 63.405173999999995 milliseconds
java 1.7 – Execution time: 47.170781 milliseconds

java 1.7 – Execution time: 7.730915779 seconds to compute result = 1580674560
jrockit – Execution time: 108.46286744800001 seconds to compute result = 1580674560
java 1.6 – Execution time: 7.7936518580000005 seconds to compute result = 1580674560

bir ara zamanım olunca parametreleriylede denerim 🙂 ama herhangi bir parametre vermeyince 1.7 sanki hızlı gibi =)