Questions tagged as 'mysql'

Tagged questions
0
answers

Charset Error - MySQL, PHP

I have a MySQL database with standard UTF8 charset (Hostinger VSP, Debian 8, MySQL View 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3), the data is inserted into the database by a app through a NodeJS REST API, and throu...
asked by 21.11.2018 / 04:33
0
answers

Problem when logging in to android with AsyncTask

I am using MySQL as a database hosted on an Amazon server (AWS). I am using the AsyncTask class to perform the search in the bank, but when I run on the mobile phone it enters the Exceptions, it seems to cut the connection to the bank. May...
asked by 21.11.2018 / 00:50
0
answers

I can not import all xml subfields with PHP

I have a function to import the xml file: $xml = new SimpleXMLElement($arquivoxml); foreach($xml->Imoveis->Imovel AS $itens) { $ref=$itens->Id; $atributospai = $itens->Atributos; foreach ($atributospai->children() as $atr)...
asked by 13.11.2018 / 21:34
1
answer

SELECT TO REDUCE VARIOUS INPUTS SEEN IN MYSQL

Good morning, I have searched and found nothing very useful. I have an inventory database of my Network Stations. The agent installed on each station sends the names of installed programs to the softwares.name table. When I make a select...
asked by 14.11.2018 / 14:33
1
answer

Do not register in JavaWeb Bank PrimeFaces

ProductDao: public class ProdutoDao implements IDao<Produto> { @Override public List<Produto> listar() { Session session = null; try { session = HibernateUtil.getSessionFactory().openSession()...
asked by 14.11.2018 / 16:01
0
answers

Search via GET does not return results correctly

I'm having a problem with a GET search. I have the following code: <?php //envio o charset para evitar problemas com acentos header("Content-Type: text/html; charset=UTF-8"); include_once ('bd/bd.php'); $cnpj = filter_input(INP...
asked by 21.11.2018 / 18:23
0
answers

How to use the result of a procedure in another procedure?

I have the following procedure: DELIMITER $$ CREATE PROCEDURE retornaArvoresFeedback() BEGIN SELECT id, flagFeedback, prazoFeedback FROM arvore_classificacao WHERE flagFeedback <> 'null' AND prazoFeedback <> '...
asked by 13.11.2018 / 13:10
1
answer

Use Hibernate to record two equal classes

Good afternoon, I would like to relate the Partida class to the Time class, where I would get the PK (Id) of the home team and the visiting team. I'm wondering how to relate in both classes, since use in class Partida , as...
asked by 19.11.2018 / 21:40
0
answers

MySQL - default-file path mysql does not match the path of the file my.cnf

When I access the database mysql -u userAdmin -p --help I get the following client variable data: Asyoucanseemostofthevariableshavenodefaultvalue.Ialsohaveaccesstothefilesthatarebeingusedtoreadthevaluesofsuchvariables. Sincemymy.cnffile...
asked by 20.11.2018 / 08:06
1
answer

How to insert the PK value of one table in the FK of another table

I created a usuario table using: CREATE TABLE usuario( usuario_id int NOT NULL auto_increment PRIMARY KEY, nome varchar(200)); Then another table using: CREATE TABLE image( id int NOT NULL auto_increment PRIMARY KEY,...
asked by 11.11.2018 / 18:33