Questions tagged as 'sql'

Tagged questions
0
answers

Multiple JDBC connections are thread-safe?

I am creating a very simple project in java and postgresql of clients and contacts between clients. There is the clientes table with id and name, and the contatos table with id1 and id2 that refer to clients. What happens if...
asked by 29.03.2018 / 02:56
3
answers

How to do SELECT on more than one database table?

I have two tables in the database: zip and users. Can I make a single query to get fields from the two tables? Both have idCep. I want to get the address data from the cep table and the name and user of the users table. As I'm working with ph...
asked by 25.04.2016 / 20:31
0
answers

How to give an update determining a sequence to be changed?

Good morning! I have a rather boring situation here at work ... I would like an idea to solve this problem. There is a case that often happens that is basically the following, When a client fails to perform the cash map on the day as in examp...
asked by 18.04.2018 / 15:44
0
answers

System notification being duplicated

function Notifier() { switch (Url::getURL(2)) { case 'notifier': $render = 'dashboard/Notifier/notifier'; $model = 'notifier/Notifier'; break; case 'inbox':...
asked by 11.04.2018 / 14:14
1
answer

How to use SQL instead of JPQL?

This week I had a problem, I was able to build a Java API using JPQL , but my Java API is not yet complete and I can already predict that in the future my project will need reporting, imagine doing in JPQL? It's going to be a hell of a lot!...
asked by 09.03.2018 / 13:37
1
answer

Join two IFs or more

I need to join some if 's and I'm having trouble, I have already tried using union , but to no avail. The query I'm running is: IF (select count(Estado) FROM tbl_1 where Estado != 'WIP' AND Estado !='on hold') > 0...
asked by 20.03.2018 / 16:40
0
answers

LCK_M_IX in SQL Server database

Well, I have two separate client bases in SQL Server 2008, and both are using the same system, which uses BDE to connect. I have an application Scripter to do SQL queries on the databases. Problem On both bases, I run select * from...
asked by 20.02.2018 / 13:56
1
answer

Is organizing laravel migrations in a subfolder bad practice?

I created several migrations that are related to each other, having foreign keys and etc ... but I do not want to mix them with migrations related to auth, permissions and etc. My question is: Can I create a subfolder to organize my migration...
asked by 07.03.2018 / 19:33
1
answer

Blank Query

I'm starting in the programming world and start with a problem when I run the query locally the query shows me the return normally but when I try to query through a simple application: <?php /** * * @var string $dsn : driver de conexão...
asked by 22.03.2018 / 14:54
0
answers

Saving user activity in the database (sql)

I'm creating a chart to analyze the age-appropriate posts access by time on my site. But the site does not yet have this ability to capture user activity and need to do it. My task and change the database so that it is possible, I currently h...
asked by 22.03.2018 / 18:27