nachfren's questions

I have the following table:

CREATE TABLE PRODUCTO
( 
"clave" NUMBER NOT NULL ENABLE,
"precio" NUMBER(10,2),
"descripcion_prodcto" BLOB
);

The field descripcion_prodctocontains a pdf with a description of the product, I need from SQL Developer (or any sql editor) to download those pdf in a path, with the file name containing clave+ precio.pdf

There are about 500 records.

I've tried with SQL Developer, but it only lets me download one at a time. Does anyone know a way to be able to download several at once?

edit:

With the following procedure, remove the pdf file, but when opening it, it tells me that it is an erroneous file:

DECLARE
l_file      UTL_FILE.FILE_TYPE;
l_buffer    RAW(32767);
l_amount    BINARY_INTEGER := 32767;
l_pos       NUMBER := 1;
l_blob      BLOB;
l_blob_len  NUMBER;
BEGIN

SELECT descripcion_prodcto
    INTO   l_blob
    FROM   PRODUCTO
WHERE  clave='001';

l_blob_len := DBMS_LOB.getlength(l_blob);

-- Open the destination file.
l_file := UTL_FILE.fopen('RUTA','PRUEBA.pdf','wb',32767);


DBMS_LOB.read(l_blob, l_amount, l_pos, l_buffer);
UTL_FILE.put_raw(l_file, l_buffer, TRUE);
l_pos := l_pos + l_amount;

-- Close the file.
UTL_FILE.fclose(l_file);

END;

Opening the pdf with Sql Developer and Adobe Acrobat the pdf is seen correctly.

Could it be because the pdf contains accent marks and is badly encoded?

I have a program that queries a REST service in python, and the Java server that processes the requests.

python

import requests
import json

from requests.auth import HTTPBasicAuth

headers={'Content-type':'application/json', 'Accept':'application/json'}
#Parametros peticion
parametros={
    "llamada":"S", 
    "backup":{
        "fecha":"2019-11-14T00:00:00",
        "codigo":"1W78-55155W8S"
        },
    "usuario":"MK001"
    }


r = requests.post(
    'http://localhost:8080/appapi/calculo/eje1',
    data=json.dumps(parametros),
    auth=HTTPBasicAuth('user', 'pass'),
    headers=headers
)

In the Java part:

@POST
@Path("/eje1")
@Consumes(MediaType.APPLICATION_JSON)
public Response setCalc(HashMap<String,String> object) {
    System.out.println(object);
    return Response.status(200).entity("").build();
}

When we execute the JSON

parametros={
"llamada":"S", 
"backup":{
    "fecha":"2019-11-14T00:00:00",
    "codigo":"1W78-55155W8S"
    },
"usuario":"MK001"
}

The parameters that come with a value are only llamadaand usuario, but backupit comes to me empty.

Do you know how to mount that particular Json? I can't modify the Java part.

I read an excel with:

FileInputStream fis = new FileInputStream(new File("C:\\miPlantilla.xlsx"));

XSSFWorkbook workbook = new XSSFWorkbook (fis);
XSSFSheet sheet;
if(condicion) {
    sheet = workbook.getSheetAt(0);
} else {
    sheet = workbook.getSheetAt(1);//<-Uso otra hoja
}
XSSFRow row;
XSSFCell cell;

//Modifico datos.

Now what I try to hide one of the two sheets:

if(condicion) {
    workbook.setSheetHidden(0, true);
} else {
    workbook.setSheetHidden(1, true);
}

But it throws me the exception:

Caused by: java.lang.IllegalArgumentException: Sheet index (2) is out of range (0..1)

Does anyone know what I'm doing wrong?

I try that for October 28, when the time change is made, highcharts02:00 appears painted on a graph twice the hour.

I got it to work with javascript and using the momentjs library: http://jsfiddle.net/nachfren/ozhqcj39/

The problem comes when I try to pass it to my project with PrimeReact.

import React, { Component } from 'react';
import Highcharts from 'highcharts/highstock'
import HighchartsReact from 'highcharts-react-official'
import {Moment} from 'moment-timezone'  // <- Visual Studio me dice que no estoy usando esta librería.

export class Consumos extends Component {
    constructor() {
        super();
    }

    render() {

        let options = {
            time: {
                timezone: 'Europe/Madrid'
            },
            title: {
                text: 'Consumos'
            },
            credits: {
                enabled: false
            },
            yAxis: {
                title: {
                    text: 'MWh'
                }
            },
            xAxis: {
                type: 'datetime'
            },

            series: [{
                name: Medida,
                data: [[66.11],[73.48],[50.65],[38.69],[70.14],[69.65],[14.66],[5.01],[4.23],[4.94],[3.06],[2.37],[1.98],[1.91],[1.83],[1.61],[1.56],[1.56],[1.57],[1.53],[1.55],[1.56],[1.52],[1.51],[1.98],[1.91],[1.83],[1.61],[1.56],[1.56],[1.57],[1.53],[1.55],[1.56],[1.52],[1.51],[1.98],[1.91],[1.83],[1.61],[1.56],[1.56],[1.57],[1.53],[1.55],[1.56],[1.52],[1.51],[1.98],[1.91],[1.83]],
                pointStart: Date.UTC(2018, 9, 27),
                pointInterval: 36e5//Horario (3600 * 1000)
            }]
        }

        return (

        <div className="ui-fluid">
                <HighchartsReact
                    highcharts={Highcharts}
                    constructorType={'stockChart'}
                    options={options}/>
        </div>
    );
    }
}

This way it paints the time for me 02:00only once. Does anyone see the error I have?

As a reminder, say that the line below indicates that it is not being used.

import {Moment} from 'moment-timezone'

I have a primereact component .

<TabView >
    <TabPanel header="Panel 1">
    </TabPanel>
    <TabPanel header="Panel 2">
    </TabPanel>
</TabView>

How can I show/hide a tab based on a concrete value?

I have a primefaces p:autocomplete component my question is if it is possible to paste several elements at the same time.

The component:

<p:autoComplete dropdown="true" id="instalacion" maxResults="100" 
    value="#{principalView.cochesSeleccionados}" 
    completeMethod="#{principalView.completeText}"
    forceSelection="true" multiple="true" 
    emptyMessage="Ningun dato coincide">

</p:autoComplete>

The bean:

@ManagedBean(name="principalView")
@ViewScoped
public class PrincipalView {
    List<String> results;
    List<String> cochesSeleccionados;

    @PostConstruct
    public void init() {
        results = new ArrayList<String>();
        results.add("BMW");
        results.add("AUDI");
        results.add("SEAT");
    }

    public List<String> completeText(String query) {
        return results;
    }
    // gettter and setter
    public List<String> getCochesSeleccionados() {
        return cochesSeleccionados;
    }

    public void setCochesSeleccionados(List<String> cochesSeleccionados) {
        this.cochesSeleccionados = cochesSeleccionados;
    }
}

My intention is to be able to copy from a site the elements:

BMW SEAT and by pasting it on the selected component.

Version: Server version: 10.1.32-MariaDB

I'm having trouble setting a password in mysql o mariadbusexampp 5.6

I install xampp I enter the console and mysql -u rootI log in fine.

Following different examples that I have seen on different web pages, I have tried different ways to change the password, each time I have uninstalled, I have installed xampp again.

Test 1:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('clave');

Test 2:

# mysqladmin -u root -p password clave
Enter password:

PC-CASA@DESKTOP-11KK10F c:\xampp
# mysql -u root -pclave
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.32-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use mysql
Database changed
MariaDB [mysql]>

Trying either of the two ways if I access from the console or the workbench it accesses perfectly, if I restart mysql it also accesses perfectly.

The problem comes when I load a *.sqlfile with 2 databases, the load is done correctly, I see the tables and everything, but when I restart mysql when trying to access it again, it gives me the error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Proof

MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'clave';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'root'@'localhost' IDENTIFIED BY 'clave'' at line 1
MariaDB [(none)]>

I have a table like the following:

<p:dataTable var="car" value="#{dtBasicView.cars}">
    <f:facet name="header">
        <p:outputLabel style="float:left">Resultados de búsqueda</p:outputLabel>
            <p:dataExporter type="xls" target="car" fileName="coches"/>
        </p:outputPanel>                                                          
    </f:facet>
    <p:column headerText="Id">
        <h:outputText value="#{car.id}" />
    </p:column>

    <p:column headerText="Year">
        <h:outputText value="#{car.year}" />
    </p:column>

    <p:column headerText="Brand">
        <h:outputText value="#{car.brand}" />
    </p:column>

    <p:column headerText="Color">
        <h:outputText value="#{car.color}" />
    </p:column>
</p:dataTable>

Now when exporting the excel it prints the 4 columns: id - year - brand - color.

How can you hide a column only in excel, but still see it on the web?

I have an excel *.xlsxwith a cell of type Número, the value that I have in the excel is 0,0794497914814776but the value that the method returns celda.getNumericCellValue()is:0,07944979148147759987

I have tried to convert the cell to text before reading it, but it throws me an exception:

celda.setCellType(CellType.STRING);
String a = celda.getStringCellValue();

This that I show helped me to read another excel, with a custom cell format.

The main problem I have is that the cell can contain 5, 10 or 15 decimal places and we need to respect the value that comes in the excel.

Can you read the exact value of the cell?

Case 1:

I have a Listwith a series of elements that can be repeated.

List<String> nombre;
nombre.add("Persona 1");
nombre.add("Persona 1");
nombre.add("Persona 1");
nombre.add("Persona 2");
nombre.add("Persona 3");
...

Using Lambda expressions is it possible to get the elements without repeating?

Departure:

Persona 1
Persona 2
Persona 3

( edited )

Case 2:

public class Persona {
   private String nombre;
   private int edad;

   Persona(String nombre, int edad) {
      this.nombre=nombre;
      this.edad=edad;
   }
   ... getter y setter

}

List<Persona> p;
p.add(new Persona("Persona 1", 20));
p.add(new Persona("Persona 1", 15));
p.add(new Persona("Persona 1", 12));
p.add(new Persona("Persona 2", 50));
p.add(new Persona("Persona 3", 20));

Departure

Persona 1
Persona 2
Persona 3

In the case of Persona 1I don't care what object it returns.

Edition 3

public class ConsultaBean {

    private static final long serialVersionUID = 6269862033023559153L;

    //Datos Cabecera
    private String negociador;
    private String descripcion;
    private String clave;
    //Detalle
    private Date fecha;
    private String hora;
    public String getNegociador() {
        return negociador;
    }
    public void setNegociador(String negociador) {
        this.negociador = negociador;
    }
    public String getDescripcion() {
        return descripcion;
    }
    public void setDescripcion(String descripcion) {
        this.descripcion = descripcion;
    }
    public String getClave() {
        return clave;
    }
    public void setClave(String clave) {
        this.clave = clave;
    }
    public Date getFecha() {
        return fecha;
    }
    public void setFecha(Date fecha) {
        this.fecha = fecha;
    }
    public String getHora() {
        return hora;
    }
    public void setHora(String hora) {
        this.hora = hora;
    }
    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((clave == null) ? 0 : clave.hashCode());
        result = prime * result + ((descripcion == null) ? 0 : descripcion.hashCode());
        result = prime * result + ((fecha == null) ? 0 : fecha.hashCode());
        result = prime * result + ((hora == null) ? 0 : hora.hashCode());
        result = prime * result + ((negociador == null) ? 0 : negociador.hashCode());
        return result;
    }
    @Override
    public boolean equals(Object obj) {
        if (this == obj)
            return true;
        if (obj == null)
            return false;
        if (getClass() != obj.getClass())
            return false;
        ConsultaBean other = (ConsultaBean) obj;
        if (clave == null) {
            if (other.clave != null)
                return false;
        } else if (!clave.equals(other.clave))
            return false;
        if (descripcion == null) {
            if (other.descripcion != null)
                return false;
        } else if (!descripcion.equals(other.descripcion))
            return false;
        if (fecha == null) {
            if (other.fecha != null)
                return false;
        } else if (!fecha.equals(other.fecha))
            return false;
        if (hora == null) {
            if (other.hora != null)
                return false;
        } else if (!hora.equals(other.hora))
            return false;
        if (negociador == null) {
            if (other.negociador != null)
                return false;
        } else if (!negociador.equals(other.negociador))
            return false;
        return true;
    }
}

I have a table and I want when they click on a button it takes them to the end of the page.

Table:

<p:datatable>
  ...
    <p:column style="width:32px;text-align: center">
        <p:commandButton id="btn" update="form" oncomplete="ScrollPage('anchorSecondPanel')"  icon="ui-icon-search" title="View">
       </p:commandButton>
    </p:column>
</p:datatable>

Below I have the anchor:

<a id="anchorSecondPanel"/>

The javascript function:

function ScrollPage(location) {
    window.location.hash=location;
}

The problem is that when I click on the button the first time it works, but the second time it doesn't direct to that anchor anymore.

Does anyone know the reason?

I have a table like the following in oracle:

SELECT * FROM ESTUDIANTES;

ID   NOMBRE   EDAD
--   ------   ----
1    Pepe     23
2    Maria    35
...

Can I somehow find out what date the inserts were made in that table?

With the following SELECTI see all the tables of a user:

SELECT table_name FROM all_tables where owner='usuario1'

Result:

TABLE_NAME
----------
USUARIOS
PRODUCTOS
CLIENTES
...(+300 tablas)

And with the sentence describeI see the structure of a table:

describe productos;

Result:

PRODUCTOS
Nombre               Nulo     Tipo           
-------------------- -------- -------------- 
id_productos         NOT NULL  NUMBER(5)
nombre_producto                VARCHAR2(255)
...

How could I unite these two functionalities?

I need to get the structure of all the tables which is almost 400 tables.

When I execute an UPDATE in MyBatis it hangs, if I put timeout"20" it interrupts the execution due to excess time.

Mappers:

<update id="actualizarUnaSalida" timeout="20">
    UPDATE dbo.TbSALIDAS 
    SET Facturado=1
    WHERE IdSalidas = 599
</update>

Call to Update

session = ConnectionFactory.getSessionCatalogos().openSession();
daoDetalleCatalogo = session.getMapper(DetalleCatalogoEspecialBeanMapper.class);

daoDetalleCatalogo.actualizarUnaSalida();//<- Entra pero no sale

As you can see, the UPDATE is as simple as possible in case the error came from parameters or something like that.

Although I don't put the Mappings, that's fine since I use the DetailCatalogEspecialBeanMapper class to do SELECT and that works.

As a detail I want to comment that when I run the application and it hangs on the Update if I open the SQL Management and try to do an UPDATE it doesn't work either, it's like it leaves it blocked, instead SELECT if it executes.

If anyone can give me a clue, I'd appreciate it.

I have the following html component to which I pass a Json:

<a href="javascript:abreModal('{ 'name':'John', 'age':'30', 'city':'New York'}');">
     Pulsador
</a>

And the Javascript function:

function abreModal(text) {
        //var text = '{ "name":"John", "age":"function () {return 30;}", "city":"New York"}';
        obj = JSON.parse(text);
        alert(obj.name);
}

The error firebug throws me is:

SyntaxError: missing ) after argument list

I suspect that the error is in the quotes abreModal(...)I have tried to change the quotes without result.

Any suggestion?

I have a simple select2:

<select id="material" class="form-control select2 select2-hidden-accessible" style="width: 100%;"  aria-hidden="true">
   <option value="1">PC</option>
   <option value="2">Raton</option>
   <option value="3">Teclado</option>
   <option value="4">Monitor</option>
</select>

Your statement:

$('#material').select2();

The component works as expected.

The problem is that I change its value by:

$("#material").val("3");

And I check that its value changes with alert($("#material").val());but it still shows the previous value.

That is, it does not update the component, how to solve this?

For the following statement:

for(var i = 0; i<3; i++){  
     alert("Primero->"+i);

     setTimeout(function() {
        alert("Segundo->"+i);
      }, (i+1)*600);

}

The output is the following:

First->0

First->1

First->2

Second->3

Second->3

Second->3

I need to use the index i in the alert.

I don't understand very well the execution of setTimeout, and why it waits for the for to finish to start the execution.

I have the following string:Un texto cualquiera 22/12/2016 fin texto

I am trying to get the position of 22/12/2016with the PATINDEX function:

SELECT PATINDEX('__/__/____', 'Un texto cualquiera 22/12/2016 fin texto');

But the function returns 0, do you know what I'm doing wrong?

The underscore _according to the microsoft link is for one character. patterns

Can the Android Studio emulator run on AMD FX processors?

At first it gave me errors like:

Intel HAXM is required to run this AVD. Your CPU does not support required features (VT-x or SVM)

Investigating I have realized that HAXM is an Intel technology, in AMD its equivalent is AMD-V, but looking on the internet I have seen this thread: Intel's HAXM equivalent for AMD on Windows OS in which it says that it is only supported in linux .

I have also tried to change the emulator from X86 to ARMEABI:

In this way it no longer generates errors and launches the emulator, but it does not finish executing:

I have left it for more than half an hour and it doesn't run, it stays like the previous image.

At the moment I am running the applications from my physical mobile, what do you recommend?

I am looking for a way to list some files with a specific extension, in a specific subfolder, that is:

Directorios: 
a>a1>a2
b>b1>b2

Siendo b   Carpeta
   |  
   |b1  Sub Carpeta
   - |
     |
     |b2 Sub
     -

I want to list all the *.txt that are in the folder that contains "1".

I am doing it with:

for /R C:\ /D %%v in (*1*) do (
   echo %%v
)

So I get the directories, and so I look for the files

for /R "C:\" %%f in (*txt) do (
                echo "%%f"
)

Of course the last one looks for the *txt of all the directories.

I have tried to do:

for /R C:\ /D %%v in (*1*) do (

   for /R %%v %%f in (*txt) do (
                echo "%%f"
   )
)

What I was trying to do was pass the path of %%v to be the file search.

I suppose there will be some expression to be able to do this.