Questions tagged as 'mysql'

Tagged questions
1
answer

Why a Stored Procedure generates different results if executed in Workbench and Java with JDBC

I have a Stored Procedure in MySQL that is working normally when I run from the Workbench, but when I execute this same procedure in Java / JBDC I am getting erroneous values different from those obtained in the Workbench. My Stored Procedure...
asked by 07.10.2015 / 21:07
1
answer

Order By Hibernate in JSF

Hello, good afternoon, I'm a beginner in this web world and I need to order establishments by punctuation (the best rated in the beginning, LOGIC) The error is An Error Occurred: java.lang.NullPointerException Here is my entity, any...
asked by 05.11.2015 / 15:31
0
answers

Work in the same modal bootstrap after submitting a form

I'm working on a project with Bootstrap Modals. I have already done the modals to create the content, delete, etc. But, I need to have one for editing ... And I have a few problems. MODAL UPDATE: In this mode, the user will enter the ope...
asked by 09.11.2015 / 15:28
0
answers

MySQL: Find errors using WHERE IN

I have the following situation with the tables below. I need to do some checks on "serial" (if the serial exists, if it is valid, etc, and other validations next to other tables) from several serial (up to thousands at a time) and, if not valid,...
asked by 22.10.2015 / 14:48
1
answer

Undefined index JSON Android

Hello, I have the following error: I am developing an application that checks a table from an external mysql database by sending the device IMEI returning an equipment id, but debugging the code in the AsyncHttpResponseHandler response line show...
asked by 14.10.2015 / 19:36
2
answers

Print results in a feed merging with spaces (blank line) horizontally

I've set up a news feed that reads the information in a bank, but I need instead of each line being printed one after the other, I need an interval between each impression with a blank line to be able to have something like this: printed new...
asked by 04.10.2015 / 23:40
0
answers

Persist blob field with file extension - JPA, Hibernate

I need to persist an attachment like a pdf, xls, etc. (type blob field). I need to recover this file after persisting it and I do not want the user to enter the file extension. I was guided in another question to create a table only...
asked by 02.10.2015 / 19:17
1
answer

How to block the login on 2 devices?

I'm developing an application in PHP where the user can stay logged in even after logging off using cookies. However, the user can not stay connected on 2 devices simultaneously. Being more specific, what I would like to know is: How do I mak...
asked by 03.10.2015 / 20:35
0
answers

Schedule patient time every 30 minutes and save to mysql database

Good evening I need to make a appointment book for a medical clinic at C# . I need to list the business hours every 30 minutes, and only save the appointment time marked in the MySQL database. But I can not do that.     
asked by 04.10.2015 / 05:08
1
answer

Result with repeated records

Good afternoon! I'm making an appointment, but the result is bringing repeated occurrences. is there a command for the query to just bring a record of each column? follow script: SELECT * FROM HIS_LOTPES A, his_afasta c, FERIAS D, PESSOAL P...
asked by 01.03.2016 / 20:55