Questions tagged as 'postgresql'

Tagged questions
1
answer

How to create a personalized query using JPA?

I am migrating a Java Swing application to JavaFX and please if someone could help me to the following: Use PostgreSQL database. In native SQL I have this query that works perfect: SELECT count(t.idremision) as entregados, COUNT(*)-cou...
asked by 10.12.2018 / 13:00
0
answers

Passing result of a java program to a database in PostgreSQL [closed]

The result of a token made in Java (Netbeans) to pass it directly to a database generated in PostgreSQL.     
asked by 27.11.2018 / 21:51
0
answers

Update a single selected record with Tkinter y, Psycopg2 [closed]

I already managed to update with (Psycopg2-Tkinter). But he does it on all records, as I do to apply only to the selected record. Button(self.edit_wind, text='Actualizar', command=lambda: self.edit_records(nombre=new_nombre.get(...
asked by 21.12.2018 / 23:01
1
answer

Problems editing a Laravel line

Thank you in advance for reading, and I hope that if you are not bothered, you could guide me to solve this problem. I have a form called a server, in that form I enter the important data, including the server and the version it has....
asked by 23.11.2018 / 18:24
0
answers

Hibernate: @ValueGenerationType within an EmbeddedId does not work when doing INSERT

I am trying to add to my project (use Spring 5.0.2, Spring-data-jpa 2.0.5 and Hibernate 5.2.14) a new annotation that allows me to obtain the date directly from the database (Postgresql) instead of the VM. For this, I have taken as my base th...
asked by 11.11.2018 / 20:31
1
answer

Relationships in my database

I have a doubt as to which 3 tables would do practically the same, Save the urls of where the files are located I have a table called Groups - where you can save files, in general it's just uploading files. And already in their respective gro...
asked by 20.11.2018 / 04:04
1
answer

Get data and insert

Maybe what you ask is very basic, but I'm getting involved in this: I have a list of Ejm products What I need is to know if this product exists in my BDD and if I can enter it, they will tell me that is easy, but my way of inserting is...
asked by 09.11.2018 / 15:47
1
answer

Problems with my Store Procedure, do not insert values with json

I have a problem with an SP, what happens is that when you run it, it receives a json as a parameter, and when it is executed, it returns a false message as an error message, this is my code, I am not Very much in this since I am learning: CRE...
asked by 10.10.2018 / 23:43
3
answers

consult 2 tables to see which records are not in the first table

I have 2 tables of people from 1 system which has 2 versions, each version with a different database, what I want to know is that people from the tabla t_evaluacion_vulnerabilidad are not in the table t_evaluacion_dean , here I shar...
asked by 24.04.2018 / 15:02
0
answers

My trigger does not work

I have a problem with a trigger in postgresql, its function is to perform an update on a field of the same table in which I insert, because that field can have different values, it is understood that this field is a nomenclature of a document, i...
asked by 29.08.2018 / 07:19