Silvia : abril 2014

jueves, 24 de abril de 2014

Java Installation and Eclipse

https://www.java.com/en/download/help/windows_manual_download.xml#download

miércoles, 23 de abril de 2014

ELSIF PLSQL

ELSIF

IF condition1 THEN
   {...statements to execute when condition1 is TRUE...}

ELSIF condition2 THEN
   {...statements to execute when condition2 is TRUE...}

ELSE
   {...statements to execute when both condition1 and condition2 are FALSE...}

END IF;

http://www.techonthenet.com/oracle/loops/if_then.php

java.lang.IllegalArgumentException: argument type mismatch web service

ERROR [STDERR] AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.lang.IllegalArgumentException: argument type mismatch
faultActor:
faultNode:
faultDetail:

Error debido a que el código del cliente tiene tipos de datos diferentes al server dummy.

Lo resolví era debido a q el cliente lo habia generado y los datos habian sido del tipo bigInteger

y en el momento los modifiq a Integer, y cuando generé el server dummy se generó con BigInteger

pero los 2 debían ser iguales, entonces cambié el integer a bigInteger en el cliente y fue solucionado.

martes, 22 de abril de 2014

ERROR [STDERR] AxisFault NO FOUND

09:10:29,783 ERROR [STDERR] AxisFault
faultCode: {http://xml.apache.org/axis/}HTTP
faultSubcode:
faultString: (404)Not Found
faultActor:
faultNode:
faultDetail:
{}:return code: 404
<html><head><title>JBoss Web/2.1.3.GA - Error report</title><style></style> </head><body><h1>HTTP Status 404 - /DummyConsultaP/services/ValidacionPortabilidadStdBinding</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>/DummyConsultaP/services/ValidacionPortabilidadStdBinding</u></p><p><b>description</b> <u>The requested resource (/DummyConsultaP/services/ValidacionPortabilidadStdBinding) is not available.</u></p><HR size="1" noshade="noshade"><h3>JBoss Web/2.1.3.GA</h3></body></html>
{http://xml.apache.org/axis/}HttpErrorCode:404
09:10:29,783 ERROR [STDERR] (404)Not Found

Si el endpoint está en base de datos, por favor dale commit.

Es debido a q el call está apuntando a una url q no tiene un ws.

Address already in use: JVM_Bind /127.0.0.1:8080

Es debido a que el puerto está siendo utilizado por otro proceso, da control+suprimir y elimina el proceso oracle.exe que normalmente se ejecuta en el pto 8080 y reinicia el server de nuevo, esta vez debe iniciar sin problemas.

lunes, 21 de abril de 2014

IWAB0489E Error when deploying Web service to Axis runtime axis-admin failed with {http://xml.apache.org/axis/}HTTP (404)No Encontrado

First of all try to attach the axis2 runtime to your eclipse IDE , and then execute your service

I suppose this problem has something to do with your network and firewall , which is blocking your cobnection.

src-resolve: Cannot resolve the name to a(n) 'type definition' component.

To solve this , the

project explorer eclipse juno i cannot see it

just restart eclipse. the problem was because juno was new.!

dummy server wsdl java skeleton

You can use Apache Axis's wsdl2java to generate skeleton classes from the WSDL:

Just as a stub is the client side of a Web Service represented in Java, a skeleton is a Java framework for the server side. To make skeleton classes, you just specify the "--server-side --skeletonDeploy true" options to WSDL2Java.

...

The skeleton class is the class that sits between the Axis engine and the actual service implementation.

You would effectively be creating your own version of the server-side implementation of the web service. You can then implement the skeleton to return some stub/dummy data, deploy that to your application server, and then make web service calls to your skeleton just as you would to the live web service.

http://stackoverflow.com/questions/211995/dummy-web-service

jueves, 10 de abril de 2014

create package body in toad

To create a package body in toad, the simple way is copying the same structure of other package in the editor, so for example open 2 editors and compile, both of them structure and body, after that F5 to see the package created.

Here we have the STRUCTURE of the package:

CREATE OR REPLACE PACKAGE PHOSTOCLDS.SILVIQUIR_PKG AS
/******************************************************************************
NAME: SILVIQUIR_PKG
PURPOSE:

REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 10-04-2014 ext_squiroga 1. Created this package.
/******************************************************************************/
PROCEDURE PRC_INTFC002_BUSCAVALORESTIPO(TIPO IN VARCHAR2, TIPO_DOCU IN VARCHAR2, ID_OPERADOR IN NUMBER , MODALIDAD IN VARCHAR2, ID_TIPO_CLIENTE OUT VARCHAR2, ID_TIPO_DOC OUT VARCHAR2, OPERADOR OUT VARCHAR2, ID_MODALIDAD OUT VARCHAR2);

END;
/

Here we have the BODY of the package:

CREATE OR REPLACE PACKAGE BODY PHOSTOCLDS.SILVIQUIR_PKG AS

PROCEDURE PRC_INTFC002_BUSCAVALORESTIPO
(TIPO IN VARCHAR2, TIPO_DOCU IN VARCHAR2, ID_OPERADOR IN NUMBER , MODALIDAD IN VARCHAR2, ID_TIPO_CLIENTE OUT VARCHAR2, ID_TIPO_DOC OUT VARCHAR2, OPERADOR OUT VARCHAR2, ID_MODALIDAD OUT VARCHAR2)

IS
/******************************************************************************
NAME: PRC_INTFC002_BUSCAVALORESTIPO
PURPOSE:

REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 03-04-2014 SILVIA QUIROGA 1. Created this procedure.

NOTES:

Automatically available Auto Replace Keywords:
Object Name: PRC_INTFC002_BUSCAVALORESTIPO
Sysdate: 03-04-2014
Date and Time: 03-04-2014, 16:07:33, and 03-04-2014 16:07:33
Username: ext_squiroga (set in TOAD Options, Procedure Editor)
Table Name: (set in the "New PL/SQL Object" dialog)

******************************************************************************/
BEGIN

END PRC_INTFC002_BUSCAVALORESTIPO;

END SILVIQUIR_PKG;
/

viernes, 4 de abril de 2014

el componente '' se debe declarar PROCEDURE

Es por que no se está llamando apropiadamente el PROCEDIMIENTO, debes verificar que el PACKAGE SEA EL CORRECTO.

jueves, 3 de abril de 2014

JAVADOCS

/**
* Método que implementa la búsqueda de valores tipo
* @author Silvia Quiroga
* @param numA This is the first paramter to addNum method
* @param numB This is the second parameter to addNum method
* @return int This returns sum of numA and numB.
*/