TwoDent's questions

Yes, the property name is usually obvious, but it's not working as expected.

<manifest ... >
...
<application android:allowBackup="true" ... >
    ...
</application>

I made a dumb Android app with a SQLite database to test this functionality. Supposedly with this property activated (and that is activated by default in API 23+) I can recover the database SQLiteonce it is reinstalled on the Phone, since the database is hosted in the Google Drive of the user account of current google put.

Install and uninstall to test, but the results were not as expected. If I uninstall the app and reinstall it, the data is lost. If that same application is only reinstalled, the data remains.

How then can I make this property work? (by uninstalling it and reinstalling it can I recover the internal database of the application?)

I'm trying to load values ​​to a select (or likebobox) dynamically from the server side with Spring Boot. I am also validating this form with the help of Hibernate Validator.

I'm having a very annoying problem that I can't explain why it's happening. In my form I have two comboboxes (or select), the first one is setting the values, while the second one (the dynamic one) is not. I even tried to put everything manually, but the annoying problem persists.

   <form:form id="form" modelAttribute="nuevoEvento" method="POST">
    <div class="containerLeft">
        <table>
                <tbody>
                    <tr>
                        <td><Label>Nombre del evento</Label></td>
                        <td><form:input type="text" path="titulo" /></td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="titulo"/></td></tr>
                    <tr>
                        <td><Label>Tipo de Evento</Label></td>
                        <td><form:select class="combobox" path="tipoEvento">
                                <form:option value="N/A">Seleccione el tipo</form:option>
                                <form:option value="Importante">Importante</form:option>
                                <form:option value="Informativo">Informativo</form:option>
                                <form:option value="Privado">Privado</form:option>
                            </form:select></td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="tipoEvento"/></td></tr>
                    <tr>
                        <td><Label>Salon del evento</Label></td>
                        <td>
                        <form:select class="combobox" path="salonId">
                            <form:options items="${listaSalones}"></form:options>
                        </form:select>
                        </td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="salonId"/></td></tr>
                    <tr>
                        <td><Label>Dia del evento</Label></td>
                        <td><form:input type="text" path="fechaEvento" id="txtfecha" readonly="readonly"/></td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="fechaEvento"/></td></tr>
                </tbody>
            </table>
            <input type="hidden" name="usuario" value="${principal.name}" />

The model class of this form is the following:

@TimeRangeConstraints.List({
@TimeRangeConstraints(
    fechaEvento="fechaEvento",
    horaInicio="horaInicio",
    horaCulminacion="horaCulminacion"
)
})
public class NuevoEvento {
@NotEmpty(message="Como se llamara el evento?")
@Size(max=40, message="Titulo invalido")
private String titulo;
@StringComboBoxConstraints
private String tipoEvento;
private String salonId;
private String url;
@NotEmpty(message="Seleccione la fecha del evento")
private String fechaEvento;
@NotEmpty(message="A que hora inicia el evento?")
private String horaInicio;
@NotEmpty(message="A que hora termina el evento?")
private String horaCulminacion;

public NuevoEvento() {}

public String getTitulo() {
    return titulo;
}

public void setTitulo(String titulo) {
    this.titulo = titulo;
}

public String getTipoEvento() {
    return tipoEvento;
}

public void setTipoEvento(String tipoEvento) {
    this.tipoEvento = tipoEvento;
}

public String getUrl() {
    return url;
}

public void setUrl(String url) {
    this.url = url;
}

public String getFechaEvento() {
    return fechaEvento;
}

public void setFechaEvento(String fechaEvento) {
    this.fechaEvento = fechaEvento;
}

public String getHoraInicio() {
    return horaInicio;
}

public void setHoraInicio(String horaInicio) {
    this.horaInicio = horaInicio;
}

public String getHoraCulminacion() {
    return horaCulminacion;
}

public void setHoraCulminacion(String horaCulminacion) {
    this.horaCulminacion = horaCulminacion;
}

public String getSalonId() {
    return salonId;
}

public void setSalon(String salon) {
    this.salonId = salon;
}

}

The attribute that is bothering is salonId... now, how am I loading those elements? Here they are, from the controller:

@Controller
@RequestMapping("/usuarios")
public class UserController {

@Autowired
SalonRepository salon;
@Autowired
UsuarioSalonRepository userSalon;

@GetMapping("/home")
public String goHome(Model model, Principal principal) {
    System.out.println(principal.getName() + " HA INICIADO SESION!!!");
    User logueado = (User)((Authentication)principal).getPrincipal();
    String userInfo = WebUtils.toString(logueado);
    model.addAttribute("userInfo",userInfo);
    model.addAttribute("principal",principal);
    return "/basics/home";
}

@GetMapping("/crearEvento")
public String irCrear(Model model, Principal principal) {
    model.addAttribute("nuevoEvento",new NuevoEvento());
    model.addAttribute("principal",principal);
    model.addAttribute("listaSalones",getSalones());
    return "/Usuarios/crearEvento";
}

@PostMapping("/crearEvento")
public String crearEvento(@Valid NuevoEvento nuevoEvento, BindingResult result,
        Model model, Principal principal) {
    System.out.println("CONTROLSITO: " + nuevoEvento.getSalonId());
    System.out.println("Nombre: " + nuevoEvento.getTitulo());
    System.out.println("Tipo: " + nuevoEvento.getTipoEvento());
    System.out.println("Id Salon: " + nuevoEvento.getSalonId());
    System.out.println("Dia: " + nuevoEvento.getFechaEvento());
    System.out.println("Hora Inicio: " + nuevoEvento.getHoraInicio());
    System.out.println("Hora Fin: " + nuevoEvento.getHoraCulminacion());
    System.out.println("URL: " + nuevoEvento.getUrl());
    if(result.hasErrors()) {
        model.addAttribute("principal",principal);
        return "/Usuarios/crearEvento";
    }else
        return "index";
}

@RequestMapping("/misEventos")
public String misEventos(Model model, Principal principal) {
    return "/Usuarios/misEventos";
}

@RequestMapping("/editarEvento")
public String irEditar(Model model, Principal principal) {
    return "/Usuarios/editarEvento";
}

@RequestMapping("/borrarEvento")
public String irBorrar(Model model, Principal principal) {
    return "/Usuarios/borrarEvento";
}

public Map<Integer,String> getSalones(){
    Map<Integer,String> salones = new LinkedHashMap<Integer,String>();
    Iterable<Salon> ls = salon.findAll();
    salones.put(0, "Seleccione un salon");
    int i = 1;
    for(Salon salon: ls) {
        salones.put(i, salon.getNombre());
        i++;
    }
    return salones;
}

}

If I submit, you can view the data that you enter, but not that of that "salonId" select...

It must be a silly mistake, but believe me I can't see where this is wrong

I would like to know how I can obtain only the time of a TimeStamp like the following:

From here I suppose that if I only get the time, it should give me 20:00 PM (I don't want seconds).

I have also read on the internet that people prefer to use Joda Time over the tools that Java already offers in its jdk.

How could I extract that information?

I am developing a web page with JavaServer Pages and I am facing the following problem: The page works correctly where I am developing (I use NETBEANS for it). When giving " Run Project `" the page receives the session variables very well.

When I give " Clean and build " to generate the file .WARto upload it to my hosting, and I execute the page from the domain (from the hosting), at times I lose the value contained in the session variable, and as a result of this, as a consequence they leave errors (the classic " Java Null Pointer Exception").

How am I manipulating the session variables? Ok, here are some snippets of code:

This right here is a servlet to login. I am saving two data, the user name and the user type. In addition to that, I establish a lifetime (1 hour):

Login log = new Login();   

    log.setEmail(request.getParameter("username"));
    log.setPassword(request.getParameter("password"));

    try {
        if (log.iniciarSesion()) {
            HttpSession session = request.getSession(false); <---- Llamo la sesion
            session.setAttribute("username", log.getEmail()); <---- guardo usuario
            session.setAttribute("tipo", log.getTipoUser().charAt(0)); <---- guardo tipo
            MessageController.setError(false);
            session.setMaxInactiveInterval(3600); <---- ajusto tiempo de vida (3600 segundos)
            switch (log.getTipoUser().charAt(0)) {
                case 'T':
                    response.sendRedirect("ListaObrasServlet?page=1");
                    break;
                case 'S':
                    response.sendRedirect("ListaTitularServlet?page=1");
                    break;
                default:
                    response.sendRedirect("ObrasServlet?page=1");
                    break;
            }
        } else {
            MessageController.setError(true);
            response.sendRedirect("index.jsp");
        }
    } catch (SQLException ex) {
        Logger.getLogger(LoginServlet.class.getName()).log(Level.SEVERE, null, ex);
    }

Now an example of how I retrieve the values:

<nav class="gtco-nav" role="navigation">
                <div class="gtco-container">

                    <div class="row">
                        <div class="col-sm-4 col-xs-12">
                            <div id="gtco-logo"><a href="index.jsp">VUDA </a></div>
                        </div>
                        <div class="col-xs-8 text-right menu-1">
                            <ul> 
                                <% if(session.getAttribute("tipo").toString().contains("U")){ %>
                                    ETC ETC ETC ETC
                                     <% }else if(session.getAttribute("tipo").toString().contains("T")){%>
                                    ETC ETC ETC ETC
                                <% }else if(session.getAttribute("tipo").toString().contains("S")){ %>
                                    ETC ETC ETC ETC
                                <%}%>
                                (mas y mas html)
                                <% if(session.getAttribute("tipo").toString().contains("U") ){%>
                                    ETC ETC ETC ETC
                                <% } %>
                                <li><a href="#">Contactenos</a></li>
                                  <li  class="btn-cta" <% if(session.getAttribute("username")!=null ) out.print("style='display:none;'");%>><a id="btn2" data-toggle="modal" data-target="#loginModal"><span>Usuario</span></a></li>
                                <li  class="btn-cta" <% if(session.getAttribute("username")!=null ) out.print("style='display:inline;'");else out.print("style='display:none;'");%>><a href="logoutServlet"><span>Cerrar Sesion</span></a></li>
                            </ul>
                        </div>
                    </div>

                </div>
            </nav>

Well, as I was saying, I repeat the problem: everything works fine when I run from netbeans , but when I upload the page to the hosting, I lose the value contained in the session when I change the page . There are moments when everything works fine, but out of nowhere that happens.

Note: In the XML file I also have the life time of the sessions with this:

<session-config>
    <session-timeout>
        60
    </session-timeout>
</session-config>

What could it be?

UPDATE: I discovered that the session actually dies as soon as you change the page in the hosting, and I don't understand why (The server is an Ubuntu Server). What is Netbeans supposed to do to keep them alive?

I'm pretty sure it's a configuration issue. On the server, in order to keep the sessions alive on each page, I have to use encodeURL... but this is too annoying for me. How do I make the GlassFish server keep the session alive? What I use in my Stack Web is:

• Operating System: Ubuntu Server 18.04 LTS

• Web Server: GlassFish Server 4.1.1

• Database: MySQL

• Programming language: Java Server Pages

good night.

I come to this page with a serious problem with android studio. What exactly is it?:

It turns out that I am developing an app, and after finishing fixing some bugs after a long time, I finally pay attention to android studio's constant suggestions to update the IDE. I obediently pay attention and start updating (Android Studio 3.0)... all good.

When I open my project that I was working on, the IDE suggests me to change the gradle version to be able to use the instant run and other functions...

My worst mistake... listen to him.

Now android studio throws me lots of unexplained errors in my AndroidManifest.xml file :

And in my classes I have the following error:

And again I swear to you: I haven't touched the code at all, just what the IDE did was change the gradle version to 3.0.0 because, as they say, it's a "recommended" practice.

How do I solve this headache with this IDE?

Hello,

I come to you for a big doubt that I have. I am seeing a subject that has to do with distributed databases, and we are instructed to carry out a small exercise, with an Access database... We are instructed to create a database, divide it and apply the concept of fragmentation.

I made 2 virtual machines in VMWare, I divided the database between those two machines already:

The changes are made correctly. Now comes the matter:

I want to split (or shard) the customers table horizontally:

As shown in these tables made in word:

I mean, I want to generate subtables... employeeA for a "branch" (Via España - virtual machine one) and employeeB for the other "branch" (5 de Mayo - virtual machine two). All this division is handled under the column "codemployee". In other words, each database has its respective employee table according to the branch where it is located. I've seen some videos on how to do fragmentation in SQLServer, MySql, but with Access, I haven't found anywhere...

I would appreciate your help

Buenas tardes,

I explain the scenario in more detail:

Suppose I am developing an application for android, and it needs to make queries to an external database (mysql server for example), even if it is only once.

I was surfing the web for a while regarding this topic, and as I have found, doing this from the same android application is dangerous and such a practice is not recommended. Since they maintain that by doing that, if some malicious person uses the correct tools, they take the application and decompile it... they will already have the database credentials (Obviously this is already mega dangerous) .

I know that more than one application must do something of this caliber... make a single query process to the mysql server (SQL SERVER, APACHE, WHATEVER) and load the necessary data to the client application using SQLite.

So I come up with the following question:

How then, could I connect to an external database securely?

I'm testing a bit of a Java Server Pages (JSP) framework called Java Server Faces (JSF). I made a base template and other client templates. The page is very simple, but there is an issue that I cannot solve, and it is this:

To my left I have a div, which contains a form with the icon (or "logo") of the page and below the links (). It turns out that when I get the text of the link by my Bean (or even if I write it directly in value), at the end of the string I get a "(#)". And in my labeling I have never put that anywhere...

<?xml version='1.0' encoding='UTF-8' ?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
  xmlns:ui="http://xmlns.jcp.org/jsf/facelets"
  xmlns:h="http://xmlns.jcp.org/jsf/html">

<h:head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <h:outputStylesheet library="css" name="blueprint/screen.css"/>
    <h:outputStylesheet library="css" name="blueprint/print.css"/>
    <h:outputStylesheet name="./css/cssLayout.css"/>      
    <title><h:outputText value="Pagina principal de la prueba!"></h:outputText></title>
</h:head>

<h:body>
    <div class="esqueleto">
    <div id="top" class="span-24 Last">
        <h:outputText value="Dan Java Server Faces Test"/>
    </div>
    <div class="span-24 Last">
        <div id="left" class="span-8">
            <h:form>
                <div id="mLogo"><h:graphicImage library="images" name="Evil-Smile.png"/></div>
                <div id="item"><h:commandLink value="Primera pagina" action="#{pageControler.Primera()}"/></div>
            </h:form>
        </div>
        <div id="content" class="span-16 Last">
            <div id="contenido">
            <ui:insert name="content">Content</ui:insert>
            </div>
        </div>
    </div>
    <div id="bottom" class="span-24 Last">
        Bottom
    </div>
    </div>
</h:body>
</html>

I thought they were CSS issues of the text-decoration, and as you can see, I have set it to "none", but no. How do I get rid of this annoying "(#)"?

I was looking at a C# class called Speech. I did a small test program to see how it sounded, and everything seemed very interesting. Now, the issue is that the only voice installed in the system is in English (of course) and is called "Anna".

Of course, if I write words in Spanish, being an English voice pronounces it strange. Somewhere I read that the voice should be installed in Spanish, but where do I get that? I also intend to test the voice recognition... will the English theme also affect the recognition? (I think surely yes..)

In my project I have two classes that generate Panels. I am using Inheritance:

The parent class is calledGodPanel

package Trivia.Secciones;

import java.awt.CardLayout;
import java.awt.Color;
import java.awt.Component;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Graphics;
import java.awt.Image;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.IOException;
import javax.imageio.ImageIO;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JPanel;
import net.miginfocom.swing.MigLayout;

public class GodPanel extends JPanel {
    private boolean end;
    private int i;
    private String paneles[], seccion[];

    public GodPanel(){
        setBackground(Color.BLACK);
        setLayout(new CardLayout());
        end = false;                  
    }

    public void showCard(String val){
        CardLayout cl = (CardLayout)this.getLayout();
        cl.show(this, val);
    }

    public void addCard(Component obj,String name){add(obj,name);}
    public void removeAll(String[] name){removeAll();}

    public void inicializarPaneles(String[] obj){
        paneles = null;
        paneles = obj;
    }

    public void inicializarSecciones(String[] obj){
        seccion = null;
        seccion = obj;
    }

    public JPanel createSlide(String url) throws IOException{
        JPanel panel = new JPanel(new MigLayout()){
        Image image = ImageIO.read(getClass().getResourceAsStream(url));
        @Override
            public void paintComponent(Graphics g){
                super.paintComponent(g);
                g.drawImage(image, 0, 0, null);
            }
        };
        panel.setBackground(Color.BLACK);
        panel.setPreferredSize(new Dimension(965,600));
        return panel;
    }

    public Component getBasicComponents(int op){
        switch (op) {
            case 1:
                JButton Bnext = new JButton(">>>");
                Bnext.setPreferredSize(new Dimension(50,20));
                Bnext.addActionListener(new ActionListener() {
                    @Override
                    public void actionPerformed(ActionEvent ae) {
                        if(i != paneles.length - 1){
                        i++;
                        showCard(paneles[i]);
                        if(i == paneles.length - 1){
                            end = true;
                        }
                      }
                    }
                });
                return Bnext;
            case 2:
                JButton Bant = new JButton("<<<");
                Bant.setPreferredSize(new Dimension(50,20));
                Bant.addActionListener(new ActionListener() {
                    @Override
                    public void actionPerformed(ActionEvent ae) {
                        if(i != 0){
                            i--;     
                            showCard(paneles[i]);
                        }
                    }
                });
                return Bant;
            case 3:
                JComboBox secciones = new JComboBox();
                secciones.setPreferredSize(new Dimension(515,28));
                for(String sec: seccion){secciones.addItem(sec);}
                return secciones;
            default:
                break;
        }
        return null;
    }

     public void enableComponents(Container container, boolean enable, int option) {
        Component[] components = container.getComponents();
        for (Component component : components) {
            switch(option){
                case 1:
                component.setEnabled(enable);
                break;
                case 2:
                component.setVisible(enable);
                break;
            }
            if (component instanceof Container) {
                enableComponents((Container)component, enable, option);
            }
        }
    }

    public void setPanelInicial(){showCard(paneles[0]); i=0;}
    public void setEnd(boolean v){end = v;}
    public boolean getEnd(){return end;}   
}

And this is a child class calledNivel3

package Trivia.Secciones;

import java.awt.Dimension;
import java.awt.Image;
import java.io.IOException;
import javax.swing.JLabel;
import javax.swing.JPanel;

public class Nivel3 extends GodPanel{
    private String[] nombres = {"A1","P2"};
    private JPanel[] paneles;
    private String[] sec = {"Centros Educativos","Situación Estructural y Equipamento de Planes",
    "Cantidad de Estudiantes por Niveles","Cantidad de Educadores por Niveles y Relacion Alumno/Educador",
    "Centros de Promocion Cultural","Grupos Culturales Representativos",
    "Instalaciones Deportivas y Condiciones"};

    public Nivel3() throws IOException{
        paneles = new JPanel[2];
        inicializarPaneles(nombres);
        inicializarSecciones(sec);
        for(int i=0;i<paneles.length-1;i++){
            paneles[i] = createSlide("/assets/FondoEdu.png");
            paneles[i].add(getBasicComponents(2), "split 4");
            paneles[i].add(getBasicComponents(1),"gapleft 10");
            paneles[i].add(new JLabel("Acceso Rapido: "),"gapleft 200");
            paneles[i].add(getBasicComponents(3),"wrap 20");
            if(i == (paneles.length - 1)){
                enableComponents(paneles[i],false,1);
            }
            for(String names: nombres){
                add(paneles[i],names);
            }
        }       
    }  
}

Ok, my "problem" (I put it in quotes, because the method works fine) is in the enableComponents. In the child class you notice that I create panels using loops for. Well, I'm trying to always make the last panel have ALL components disabled. I inserted a condition that, for unknown reasons, does not want to work:

if(i == (paneles.length - 1)) {
    enableComponents(paneles[i],false,1);
}

Could you give me ideas on how to disable everything only in the last panel if this cannot be fixed?

Good!

Look, I have a class called GIFPanel which inherits from the JPanel class

package Trivia;
import java.awt.Graphics;
import java.awt.Image;
import javax.swing.JPanel;

public class GIFPanel extends JPanel{
      private Image imagen;
      public GIFPanel(Image imagen){
          this.imagen = imagen;
      }

      @Override
      public void paintComponent(Graphics g){
          super.paintComponent(g);
          g.drawImage(imagen,0,0,getWidth(),getHeight(),this);
      }     
}

In my other class I create it and insert an image whose source was from a web address

Image img = Toolkit.getDefaultToolkit().getImage(new URL("https://media.giphy.com/media/l3q2XKiWAOl0qa1Tq/source.gif"));
menu = new GIFPanel(img);

Ok, it works fine, the gif plays even with the generated JAR... but... it's not really what I'm looking for. How so? A few days ago I asked about how to load images contained within packages of the same project in JAVA that were not through URLs, since when generating the jar file, the program responds with errors.

Try to do the same with the GIF file, but not even netbeans recognizes it. . .

The assets package already contains the GIF.

I want to avoid using links from the web since when there is a connection failure where it is going to be used, the program will crash (close).

How do I make it so that it can play the gif using the file contained in the package of my project?

I'm having a pretty awkward problem. I generated a test executable JAR file, and it is generating the following error:

Exception en thread "AWT-EventQueue-0" java.lang.IllegalArgumentException: URI is not hierarchical
    at java.io.File.<init>(Unknown Source)
    at Trivia.Interfaz.<init>(Interfaz.java:74)  <= mi codigo

Starting with the internal schematic of my project. I have the images of the program saved as separate packages.

The package where I have the images is called "assets".

Well, in the code when I load the images I have it written as follows:

Image img = ImageIO.read(new File(getClass().getResource("/assets/panama-16.png").toURI()));

Doing it this way doesn't give any kind of error and the program runs normally in the netbeans IDE, but the problem starts when I generate the JAR executable. And I read somewhere that this is caused by the reason that when generating the executable, what Netbeans does is compress all those files (ZIP), and of course, with that things change drastically in terms of the use of the URL .

My question is: How can I make all those images run normally from the JAR file inside a project package without any problem?

Good!

I am using Microsoft Access 2007 to do my practices at home together with JAVA and VB.NET. I ran the program that I had made in VB.NET when out of nowhere it reproaches me with the title message... I tried to re-download the database that I had in my cloud and replace it, but I get another error other than this:

And if I try to open the one I have in my JAVA project I get the following (the hateful message):

Try to reinstall the access database driver for the 2007 version, but the error persists. I read somewhere that the 32-bit version of this driver doesn't cause this problem, only the 64-bit one... but I'm currently using the 32-bit one.

Do you know the funniest thing of all? Is that when I run the JAVA version of the program, it runs normally as if nothing was happening. On the other hand, if I execute the version of the program in VB.NET, at once it sings me with the second error. The other databases that I have from other programs are working normally... only this database has given me this problem that I don't know how to solve. I thought about creating it all again, but it doesn't even let me import data or see the relationships...

How could I solve this heavy problem?

Update

Upon request I leave the code of both connections, both in VB.NET and in JAVA:

VB.NET

Module ModuleH
    Friend conexion As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Hospital.accdb;Persist Security Info=False;")

    Friend Sub ConectarBD()
        Try
            conexion.Open()
            MsgBox("Pulse aceptar para confirmar la carga de datos.")
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        conexion.Close()
    End Sub
End Module

JAVA

Manager class (Here I initialize the UcanAccess driver and the DB address)

public class GestorDB {
private Connection conn;
private final String driver;

public GestorDB(String direccionDB) throws ClassNotFoundException, SQLException{
    driver = "net.ucanaccess.jdbc.UcanaccessDriver";
    Class.forName(driver);
    conn = DriverManager.getConnection("jdbc:ucanaccess://"+direccionDB);
}

public Connection getConnection(){
    return conn;
}

Administrator class (I load the address of the DB)

public class Administrador {
private GestorDB gestor;
private String idActual;

public Administrador() throws ClassNotFoundException, SQLException{
    gestor = new GestorDB("*******SaludParaTodos\\src\\Hospital.accdb");
    idActual = "";
}    

public Connection obtenerConexion(){
    return gestor.getConnection();
}

I re-emphasize what happens:

• I can't open the Hospital.accdb database in Microsoft Access 2007 itself (I get those error messages).

• The program written in VB.NET does not recognize the database (it shows the same message as in the second image), while the JAVA version of the program works completely.

I am using JAVA to program a replica of a program that I have in VB.NET. I was creating the "DataGrids" (using JTable's) and programming Tooltips to appear on the cells of my JTable... yep, in JAVA you have to do everything from scratch.

Ok, my curiosity begins when writing the following lines of code an error is hung in the program:

 DataGridMed = new JTable(){
        @Override
        public Component prepareRenderer(TableCellRenderer renderer, int row, int col){
            Component c = super.prepareRenderer(renderer, row, col);
            if(c instanceof Component){
                JComponent jc = (JComponent) c;
                jc.setToolTipText((String) getValueAt(row,col)); <--- ERROR
            }
            return c;
        }
    };

I was a little indignant, because when I do a casting like that, am I not converting that value into a String object? When I change that line to .toString(), the error disappears completely...!

jc.setToolTipText(getValueAt(row,col).toString);

I clearly know that "String" is a class, and that it does not belong to the group of primitive data types (int, boolean, float, double . . . ). That's why when comparing two Strings, the "==" operator doesn't work and you need to use ".Equals()"... But in this case I'm not distinguishing what is the difference between casting and using . toString().

Exactly what happened here?

I'm having a horrible problem and the worst of all is that I can't find almost anything on the web about it! I am making a report in java with jaspersoft studio. I made the template already (it has two parameters) and followed the guide on the next page to the letter .

Ok, my code is the following:

public class Reportes{
private Administrador admin;

public Reportes() throws ClassNotFoundException, SQLException{
    admin = new Administrador();
}

public JRViewer obtenerPaciente(String ced) throws JRException{
    HashMap parameters = new HashMap();
    InputStream is = getClass().getResourceAsStream("assets/PerfilPaciente.jrxml");
    JRDesignQuery design = new JRDesignQuery();
    design.setText("SELECT * FROM Pacientes");
    JasperDesign jd = JRXmlLoader.load(is);
    jd.setQuery(design);
    parameters.put("Imagen", ClassLoader.getSystemResource("assets/perfil-azul.png").getPath());
    parameters.put("Cedula",ced);
    JasperReport report = JasperCompileManager.compileReport(jd);
    JasperPrint jp = JasperFillManager.fillReport(report, parameters, admin.obtenerConexion());
    JRViewer jrv = new JRViewer(jp);             
    return jrv;
}
}

And when I call that function in my JDialog, it throws me the following error:

net.sf.jasperreports.engine.JRException: java.net.MalformedURLException at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:251) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML (JRXmlLoader.java:230) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:218)

I get the following line of code:

InputStream is = getClass().getResourceAsStream("assets/PatientProfile.jrxml");

I have tried to place it "/PerfilPaciente.jrml", "PerfilPaciente.jrxml" and nothing. Nor because it is in the project folder.

How could I solve this?

PS: I place my resources all inside a project folder that I created called "assets", from there some images of my java program also come out, and it has not given me problems like this jrxml file.

Good! I come here with a small question: How exactly could you write a query using a Like and have it be parameterized? I am using UcanAccess with JAVA.

I have a window in my program that requires the use of the Like. I tried first writing it "normal" like this, but it wasn't what I was looking for:

SELECT Diagnostico FROM Historial WHERE CedulaP LIKE ? ORDER BY Fecha ASC

I needed to insert the percentage character (%) for it to work as I wanted... so what I did is write the following:

SELECT Diagnostico FROM Historial WHERE CedulaP LIKE CONCAT('%',?,'%') ORDER BY Fecha ASC

The query works fine, but I don't know why I had doubts as to whether doing it this way is safe or not (because of SQL Injection ). This code I wrote is where I prepare the PreparedStatementto execute the query:

public ResultSet SelectQuery(String[] values, String query) throws SQLException {
    PreparedStatement stmt = conn.prepareStatement(query);
    ResultSet rs;
    for(int i = 0; i<values.length; i++){
        stmt.setString(i + 1, values[i]);
    }
    rs = stmt.executeQuery();
    return rs;
}

Is the query safe the way I wrote it?

I am creating a replica of a program written in VB.NET in JAVA as a practice. I'm having an annoying problem and I haven't been able to exactly identify why it is caused... you see, I'm using some libraries downloaded from the following source:

http://toedter.com/jcalendar/

In VB.NET there is a component called DateTimePicker that does not exist in JAVA, and that is why I had to download libraries from the internet to obtain it. I'm using the JDateChooser component which is very similar to the one in VB.NET... the only difference is that when choosing a date from it, the component prints that date in the textfield with a short date format (10/24/2016) while that in the other original program, it printed it in a long date (Monday, October 24, 2016).

To get around this problem, I wrote a little function in my class so that we can say, "convert" or "translate" (whatever you want to call it) that format from a short date to a long date:

public String getFechaLarga(String fecha) throws ParseException{
    Calendar c = Calendar.getInstance();
    Date date = new SimpleDateFormat("MM/dd/yyyy").parse(fecha);
    c.setTime(date);
    String hoy=null;
    switch(c.get(Calendar.DAY_OF_WEEK)){
        case 1: hoy="Domingo,";break;
        case 2: hoy="Lunes, ";break;
        case 3: hoy="Martes, ";break;
        case 4: hoy="Miércoles, ";break;
        case 5: hoy="Jueves, ";break;
        case 6: hoy="Viernes, ";break;
        case 7: hoy="Sábado, ";break;
    }
    hoy = hoy + c.get(Calendar.DAY_OF_MONTH);
    switch(c.get(Calendar.MONTH)){
        case 0: hoy=hoy + " de enero";break;
        case 1: hoy=hoy + " de febrero";break;
        case 2: hoy=hoy + " de marzo";break;
        case 3: hoy=hoy + " de abril";break;
        case 4: hoy=hoy + " de mayo";break;
        case 5: hoy=hoy + " de junio";break;
        case 6: hoy=hoy + " de julio";break;
        case 7: hoy=hoy + " de agosto";break;
        case 8: hoy=hoy + " de septiembre";break;
        case 9: hoy=hoy + " de octubre";break;
        case 10: hoy=hoy + " de noviembre";break;
        case 11: hoy=hoy + " de diciembre";break;
    }
    hoy = hoy + " de " + c.get(Calendar.YEAR);
    return hoy;
}

The function works correctly (well, "almost" I think) as you can see:

Now come the problems... and why do I put the function too? Well, I don't know exactly if this is what is giving me the exception or not. At the beginning, it gave me the error "Unparseable Date", and it was because the program tried to convert the string already converted from the TextField of the date to Date (as if it took the short date, converted it to a long date and took the long date again to convert... but of course, it would give an error because it was already converted). What I did was put a condition on it to regulate it (if the TextField string is less than or equal to 10 characters, then it proceeds).

((JTextFieldDateEditor)calendario.getDateEditor()).addPropertyChangeListener(
    new PropertyChangeListener() {
        @Override
        public void propertyChange(PropertyChangeEvent pce) {
            try {
                if(((JTextFieldDateEditor)calendario.getDateEditor()).getText().length() <= 10){                  
                    ((JTextFieldDateEditor)calendario.getDateEditor()).setText(admin.getFechaLarga(((JTextFieldDateEditor)calendario.getDateEditor()).getText()));
                }                                       
            } catch (ParseException ex) {
                Logger.getLogger(NuevaEntrada.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    });

Everything seemed to work correctly, but when I changed to another date, another error was thrown at me... and this time it complained that the JTextField of the date was "empty". I inserted another condition to the if... (If the number of characters in the TextField string is not equal to 0, then it proceeds) This is how the propertyChange event is left at the end:

((JTextFieldDateEditor)calendario.getDateEditor()).addPropertyChangeListener(
    new PropertyChangeListener() {
        @Override
        public void propertyChange(PropertyChangeEvent pce) {
            try {
                if(((JTextFieldDateEditor)calendario.getDateEditor()).getText().length() <= 10 && 
                     ((JTextFieldDateEditor)calendario.getDateEditor()).getText().length() != 0){                  
                    ((JTextFieldDateEditor)calendario.getDateEditor()).setText(admin.getFechaLarga(((JTextFieldDateEditor)calendario.getDateEditor()).getText()));
                }                                       
            } catch (ParseException ex) {
                Logger.getLogger(NuevaEntrada.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    });

Now yes, it's not supposed to throw any more exceptions I think, but it throws one last exception... which is the following:

The line of code where it marks the error, is what is inside the if (when I use that function I wrote, that's why I'm thinking that the error may be there):

 ((JTextFieldDateEditor)calendario.getDateEditor()).setText(admin.getFechaLarga(((JTextFieldDateEditor)calendario.getDateEditor()).getText()));

It could also be that I'm not using the correct event to use my function... maybe there are alternatives to the PropertyChangeListener that I don't know about. I saw there also in the English stackoverflow that this bug disappears using SwingUtilities.invokeLater() but the funniest thing of all is that I'm already using it, and that error doesn't disappear...

public static void main(String[]args){
    SwingUtilities.invokeLater(new Runnable() {
        @Override
        public void run() {
            try {
                NuevaEntrada nv = new NuevaEntrada("M001");
            } catch (ClassNotFoundException | SQLException | IOException | ParseException ex) {
                Logger.getLogger(NuevaEntrada.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    });       
}

I would really appreciate your help...

Well this case had not been presented to me until now, it turns out that I have an acquaintance who bought a domain (from him) and he has separated a space for me (so to speak) on his server. I have my website hosted, I am just going to start developing what has been the entries (the database is already included).

The problem is that I don't know how to connect to that server. I'm not very experienced in web development as you can see.

With what program or how can I connect to that server with this data? I have: IP address of the server, user, password.

I thought about installing wampserver and phpmyadmin, but I see that it only works locally (unless that is the solution and your configuration changes...)

Very good community! I had already experienced the following problem before when I made modifications (UPDATES) to the excel sheet, but I always found a solution... but... not now... and the funniest thing that I am following to the letter the steps that microsoft mentions on its official page (it is in english): https://support.microsoft.com/en-us/kb/316934

With ADO.NET, you can insert and update records in a workbook in one of three ways: Directly run a command to insert or update records one at a time. To do this, you can create an OLEDbCommand object on your connection and set its CommandText property to a valid command to insert records

INSERT INTO [Sheet1$] (F1, F2) values ​​('111', 'ABC')

or a command to update records

UPDATE [Sheet1$] SET F2 = 'XYZ' WHERE F1 = '111'

and then call the ExecuteNonQuery method.

In my program I have functions and methods that collect the sheet depending on the column that is passed as a parameter, and functions that return the exact position of an empty cell or with errors (A1, B2, C15...) I have compared hundreds of Sometimes if the functions are returning what is desired, and well yes... they are all working fine... then the problem would be the substitution function itself...

Protected Friend Sub reemplazarDato(ByVal DColumn As String, ByVal headerCell As String, ByVal cell As String, ByVal dato As String)
    Dim hoja As String = obtenerHojaActual(DColumn)
    Dim comando As New OleDbCommand
    comando.Connection = conexion
    comando.CommandText = "UPDATE [" & hoja & "$] SET [" & cell & "]=@dato WHERE [" & headerCell & "]=@DColumn"
    comando.Parameters.Add("@dato", OleDbType.Date).Value = dato
    comando.Parameters.Add("@DColumn", OleDbType.VarChar).Value = DColumn
    MsgBox(comando.CommandText)
    MsgBox("Dato nuevo: " + comando.Parameters(0).Value + " en la columna: " + comando.Parameters(1).Value)
    conexion.Open()
    Try
        comando.ExecuteNonQuery()
    Catch ex As Exception
        cajaMensaje("Error inesperado", ex.Message, My.Resources._error).ShowDialog()
    End Try
    conexion.Close()
    comando.Dispose()
End Sub

These message boxes are inserted to verify that the data is being inserted correctly and the query is being written correctly. I am going to cite an example that I am trying now... I am trying to change the value of cell C2 of this excel sheet:

The commandText that prints the program's mssgbox...

Note the similarity to the microsoft one: UPDATE [Sheet1$] SET F2 = 'XYZ' WHERE F1 = '111'

Could it be that the parameters are not storing the values? Well, they do.

And before they answer me "you have to remove the brackets from the values ​​that represent columns", well no, I have already removed them and it doesn't work the same (besides, the same page suggests that they be used when marking columns) , I also tried making a regular query with concatenations and the same, nothing (also the same page suggests that queries with parameters be used when writing them)...

What could this strange problem be?

UPDATE

Reading on the web about the problem, I found something else; You need to disable the HDR property to be able to modify a specific cell. Insert a parameter in the String property of the connection to indicate whether it will be activated or deactivated on a certain operation.

Protected Friend Property setConnection(ByVal hdr As String) As String
    Set(value As String)
        Try
            conexion.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & value & ";Extended Properties='Excel 8.0;HDR=" & hdr & ";IMEX=0;TypeGuessRows=0;'"
        Catch ex As Exception
            cajaMensaje("Error inesperado", ex.Message, My.Resources._error).ShowDialog()
        End Try
    End Set
    Get
        Return conexion.ConnectionString
    End Get
End Property

I also found that a range should be indicated to modify that cell. I did the following but it didn't work for me (It throws me the same error...) and honestly I don't get to understand that about the range. The method is then as follows:

   Protected Friend Sub reemplazarDato(ByVal DColumn As String, ByVal cell As String, ByVal dato As String)
    Dim hoja As String = obtenerHojaActual(DColumn)
    Dim comando As New OleDbCommand
    setConnection("NO") = setRuta
    MsgBox(conexion.ConnectionString)
    comando.Connection = conexion
    comando.CommandText = "UPDATE [" & hoja & "$" & cell & ":" & cell & "] SET [" & cell & "]=@dato"
    MsgBox(comando.CommandText)
    comando.Parameters.Add("@dato", OleDbType.VarChar, dato.Length).Value = dato
    conexion.Open()
    Try
        comando.ExecuteNonQuery()
    Catch ex As Exception
        cajaMensaje("Error inesperado", ex.Message, My.Resources._error).ShowDialog()
    End Try
    conexion.Close()
    comando.Dispose()
End Sub

My intention is to know if the data that the user has entered is a date and that it is in the MySQL ( YYYY-MM-DD) format. First I made a query with data type date to an Excel table , but it turns out that when doing a test to see what the query managed, I could notice that the date was captured with numerical values...

Example: A date in my table is "08/16/2005" , but when I do the query, it returns a number ( 38580 in this case).

I do not understand, since it is clear that it is a date, and not a number. I know that in VB.NET we have the function IsDate, or the Date.TryParse... I've already tried to identify them by doing a condition, but it doesn't seem to work. How then could I do to identify if a value is of type date?

         If (Not Date.TryParse(valor(0), fecha)) Then
             MsgBox(valor(0))
             errores += 1
          End If