Posts by Anderson Ribeiro • 21 points
4 posts
-
1
votes0
answers75
viewsQ: String field in Mysql returns as bytearray type using Python
When performing a query in Mysql using Python, I get a return of type bytearray, being that the column is of type String. import mysql.connector as myc # conexão MySQL conMySQL = myc.connect (host =…
-
1
votes1
answer49
viewsQ: Wrong update on Trigger on Oracle
I have the following problem at Trigger, When there is an INSERT in table TB_DJE_PREPUBLICACAO, it has to be checked if the column DT_DISPONIBILIZACAO is null, if it is and if the column…
-
0
votes1
answer44
viewsA: Failed to update field of all records with the file path using JDBC
Solved, just replaced that line int id = rs.findColumn("id"); by that other int id = rs.getInt("id");
-
0
votes1
answer44
viewsQ: Failed to update field of all records with the file path using JDBC
I am migrating pdf files stored in the database to file systems. In the code as can be seen below, I use an algorithm that generates the name of the files and saves them in a directory generated…