Archive for September, 2007

asker kontun Dağıtımı

Thursday, September 20th, 2007

Acemi birliğini tamamlayan kontun dağıtımı kıbrıs 39.tümene çıkmış adam adayı çok sevdi her yerde oraya çıkıyo bu gidişle oraya yerleşecek zindan şaplanma fazla ( kesin tankla falan gelir şimdi bu askerden yakışır ).Hayırlı teskereler.

executing pl/pgsql function in postgre and java

Thursday, September 20th, 2007

CREATE OR REPLACE FUNCTION squre_root(integer)
RETURNS double precision AS
$BODY$
BEGIN
return SQRT($1);
END; $BODY$
LANGUAGE ‘plpgsql’ VOLATILE;
ALTER FUNCTION squre_root(integer) OWNER TO hede;

to execute this procedure in pgadmin  : select squre_root( 9 );

import java.sql.*;

public class PlSqlTest {
public static void main(String args[]) {
CallableStatement stmt = null;

int a=9;

System.out.println(”\nArray Parameter Test\n”);
try {
Class.forName(”org.postgresql.Driver”);

Connection conn = DriverManager.getConnection(”jdbc:postgresql://localhost/hede”, “hede”,”hede”);

conn.setAutoCommit(false);
stmt = conn.prepareCall(”{?= call squre_root(?)}”);
stmt.registerOutParameter(1, java.sql.Types.DOUBLE);
stmt.setInt(2, a );
stmt.execute();
double result = stmt.getDouble(1);

System.out.println(”\nThe result is ” + result);

conn.close();
}
catch (SQLException se) {
System.out.println(”\nA SQL exception occurred.”);
System.out.println(”\nError code: ” + se.getErrorCode());
System.out.println(”\nSQL state: ” + se.getSQLState());
se.printStackTrace();
}
catch (Exception e) {
System.out.println(”\nSome other exception occurred.\n”);
e.printStackTrace();
}
}
}

Bugun CcemAlp Doğum günü

Thursday, September 20th, 2007

Beşiktaşlı Oldu!!! Hollanda’ya inek sağmaya gitti inek diye bunu sağıyorlar gömülmüş kodlara kafasını kaşıyamıyor Taa twenteden Tansuya laf yetiştiriyor.Kanqa doğumgünün kutlu olsun nice senelerede oralarda yaşlanma.

Mutluluklar Enver & Burcu Altın

Monday, September 10th, 2007

08.09.2007 Tarihinde Dünya evine giren şirket kanqamızın her ne kadar nikaha gitmek nasip olmasa Mutluluklar diliyerek tebrik ediyorum.Notumuda Düşüyorum geçmiş olsun birader birini daha kaybettik bu genç yaşta.

Darısı Başıma Hülya

Monday, September 10th, 2007

06.09.2007 Tarihinde Dünya evine girmek üzere ilk adımı nişanlanarak geçen Hülya Çakmakçı kanqamızın Tebrik ediyoruz Mutluluklar Diliyorum.

openCDS device Management

Thursday, September 6th, 2007

Open cds can dedect device type and automaticaly generates,imports configuration file on opencds Device Creation if a new device is detected, and autoCreate is false the subscriber will be given a “Device Not Supported” message. If autoCreate is true, we’ll gather as much info as possible from the UAProf and populate the device repository. New devices may be quarantined -meaning they can’t be used by subscribers until an administrator processes them in the Catalog Server.A notification email can be sent when a new device is created. If left blank, no emails will be sent.

autoCreate.newDevice=true

quarantine.newDevice=false

newDevice.notification.emailAddress=email@dns

Note:This autoCreate process doesn’t work properly.like Nokia N80 or N73 ,we expect to see openCDS 5.1 version (may be released in September 2007 ).

If you create your application using XMLRPC This can not include create method.

we solve this problem add a jsp file to subscriberportal to compile this jsp use subscriberportalapi.jar.

<%@page import=”com.sun.content.server.subscriberapi.ISystemService”%>
<%@page import=”com.sun.content.server.subscriberapi.ApiServiceFactory”%>
<%@page import=”com.sun.content.server.subscriberapi.IModel”%>
<%@page import=”com.sun.content.server.subscriberapi.ApiUtil”%>
<%@page import=”com.sun.content.server.server.webapps.common.UIHelper”%>
<%@page import=”com.sun.content.server.subscriberapi.IApiContext”%>

<%
String userAgent = request.getHeader(”user-agent”);
System.out.println(”Model Created info:Starting!!!”);

//while using webbrowser it creates more than more mozilla device types

if (!userAgent.startsWith(”Mozilla”)){
try{
ApiUtil.initTransaction();
UIHelper.configureAPI(request);
IApiContext apiContext = UIHelper.getApiContext(request);
UIHelper.configureAPIRequest(apiContext);
ISystemService ss = ApiServiceFactory.getSystemService(null);
IModel newModel = ss.createModel(request);
System.out.println(”Model Created info:Stopping !!!”);
}
catch(Exception e){
e.printStackTrace();
}
finally{
ApiUtil.commitTransaction();
}
}%>

Use redirection turn back to your aplication. this is a nail ( Turkish called ” çakma “) solution.