sqlserver connection with ias
weblogic.jdbc.mssqlserver4.Driver
weblogic.codeset
windows-1254
sweetdev useful links
http://espace.sig.echonet/sweetdev/sweetbook/2_2_2/Sweetbook-2_2_2.htm (English)
http://wikinet.group.echonet/display/ITPSInetSweetdev/Home (Wiki ıin english)
http://wikinet.group.echonet/display/ITPSInetSweetdev/SweetDEV+-+Components+-+Table (customizatıon of the table tag)
http://www.ideotechnologies.com/documentation/sweetdev-en/help-doc.htm
http://www.ideotechnologies.com/documentation/javadoc/
http://espace.sig.echonet/downloads/
ftp upload java code
package com.xt.db.oracle;
import sun.net.TelnetOutputStream;
import sun.net.ftp.FtpClient;
public class FTPUploader
{
public FTPUploader()
{
}
public void putFileOverFTP(byte dataBytes[], int startpos, int endpos, String saveFile, String tip)
throws Exception
{
String server = "";
if("1".equals(tip))
server = "165.198.192.238";
else if("2".equals(tip))
server = "165.198.192.246";
String user = "xttest";
String passwd = "XTtest3";
FtpClient ftpClient = new FtpClient();
ftpClient.openServer(server);
ftpClient.login(user, passwd);
ftpClient.cd("/");
ftpClient.cd("/usr/tmp");
ftpClient.ascii();
//ftpClient.binary();
TelnetOutputStream netOut = ftpClient.put(saveFile);
netOut.write(dataBytes, startpos, endpos);
netOut.close();
ftpClient.closeServer();
}
}
ejb3
slaytlarini sitemizde bulabilirsiniz.
http://www.bilgidat a.com/egitim/ 2006/distobj/ index.html
Iyi calismalar,
ajax first step
bir kurs var. Kursun wiki'si http://theajaxworks hop.com ve web sayfasi
http://www.javapass ion.com/ajaxcode camp.
Bilginize...
popup window açarken doldurmak
{
var generator=window.open('','name','height=400,width=500');
generator.document.write('
generator.document.write('');
generator.document.write('');
generator.document.write('
This page was generated by
the main window.
generator.document.write('
Close the popup.
generator.document.write('');
generator.document.close();
}
Database webservis koymak ve çalıştırmak
10.2.* database kurulumu yapılması
loadjava -thin -user sys/oracle@localhost:1521:orcl -resolve -synonym -verbose -grant public /oracle/ora10g/oc4j/soap/lib/soap.jar /oracle/ora10g/oc4j/lib/dms.jar /oracle/ora10g/lib/servlet.jar /oracle/ora10g/oc4j/j2ee/home/lib/ejb.jar /oracle/ora10g/oc4j/j2ee/home/lib/mail.jar /oracle/ora10g/oc4j/j2ee/home/lib/jssl-1_2.jar
Aynı anda yüklenmesine dikkat edilmeli bir arada yüklenince hata vermiyorlar
C:\jdev1012_2\jdev\lib\jdev-rt.jar
C:\jdev1012_2\jdev\lib\ext\wsakbnk.jar
sqlplus "/as sysdba"
alter system set utl_file_dir='C:/utl' scope=SPFILE;
shutdown immediate;
startup;
drop user ws cascade;
CREATE USER ws IDENTIFIED BY ws;
GRANT CREATE SESSION
, CREATE TABLE
, CREATE TRIGGER
, CREATE SEQUENCE
TO ws;
GRANT CONNECT, RESOURCE TO WS
/
grant create database link to ws with admin option;
execute dbms_java.grant_permission('WS','SYS:java.util.PropertyPermission','*','read,write');
execute dbms_java.grant_permission( 'WS', 'SYS:java.net.SocketPermission','localhost:8988', 'connect,resolve' );
execute dbms_java.grant_permission( 'WS', 'SYS:java.net.SocketPermission','213.153.170.76', 'connect,resolve' );
ALTER USER WS DEFAULT TABLESPACE USERS
/
execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\firmaBilg.txt', 'delete' )
execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\firmaBilg.txt', 'write' )
execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\ilBilg.txt', 'delete' )
execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\ilBilg.txt', 'write' )
execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\uomBilg.txt', 'delete' )
execute dbms_java.grant_permission( 'WS', 'SYS:java.io.FilePermission', 'c:\utl\uomBilg.txt', 'write' )
loadjava -thin -user ws/ws@localhost:1521:ORCL EPENTGStub.java
ws ile bağlanıp kontrol edip gerekirse tekrar compile edilmeli.
CREATE OR REPLACE FUNCTION WS.katarUomTypeCnt RETURN NUMBER AS
LANGUAGE JAVA NAME 'com.xt.akbnk.EPENTGStub.katarUomTypeCnt() return java.lang.Integer';
/
calling oracle stored procedure from java
CallableStatement stmt = conn.prepareCall(query);// register the type of the out param - an Oracle specific type
stmt.registerOutParameter(1, OracleTypes.CURSOR);// set the in param
stmt.setFloat(2, price);// execute and retrieve the result
setstmt.execute();
ResultSet rs = (ResultSet)stmt.getObject(1);// print the results
while (rs.next()) {
System.out.println(
rs.getString(1) + "\t" + rs.getFloat(2) + "\t" + rs.getDate(3).toString()
);
}