Insert or update query executed successfully but data are not persistent

reevolt

I'm trying to insert or update elements in an existing firebird database using JDBC. I access to the database with the default credentials (SYSDBA and masterkey).

The request are done successfully according JDBC but database are not modified (when I execute a select my data does not appear). I also tried to modify the database content using a software as RazorSQL, the result is the same (the database are modified during the session but if I disconnect and reconnect to the database my modifications are lost).

I anybody has an idea how to solve this problem?

Thanks in advance

Mark Rotteveel

Most likely you are running with autoCommit disabled. In that case you need to explicitly call commit() on the Connection. Also be aware that a transaction can only see changes from transactions that were committed before it started.

See also the Jaybird JDBC Driver Java Programmer's Manual, chapter "Using transactions".

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

MySql workbench query history ( last executed query / queries ) i.e. create / alter table, select, insert update queries

分類Dev

UPDATE, INSERT and ON DUPLICATE KEY UPDATE in one query

分類Dev

The appendchild function cannot be executed successfully

分類Dev

MySQL LOAD DATA INFILE Query running successfully but no output

分類Dev

Insert content from a temporary table into an update query

分類Dev

Logical query processing phase of INSERT, DELETE, and UPDATE in SQL queries

分類Dev

Laravel query not executed

分類Dev

String Query cannot be executed

分類Dev

Kubernetes PVC data persistent

分類Dev

In Core Data, how to do `if exists update else insert` in swift 4?

分類Dev

Insert or update data using cte_results in SQL Server

分類Dev

Update Temp table to Insert node in XML data using SQL

分類Dev

MVC5, insert or update a list of data with just one submit

分類Dev

how to insert and update data into postgresql from node js using if condition

分類Dev

Execute Powershell Script from powershell indicate it executed successfully

分類Dev

MYSQL data insert query doesn't work in Python

分類Dev

How to use sql simple query to insert data from different table

分類Dev

Make sure query is executed or not with Anorm

分類Dev

PDO pagination query not executed correctly?

分類Dev

Data in ksql table not being persistent

分類Dev

Persistent Data Container not saving to the block

分類Dev

Getting the updated record after a Persistent update

分類Dev

if query is not update

分類Dev

Realm order of insert or update

分類Dev

Spring Hibernate @Data update vs raw UPDATE query: Optimistic Lock Exception despite @Transactional?

分類Dev

How to overcome a persistent oracle 'invalid identifier' error on a basic insert?

分類Dev

A raw PostgreSQL query hangs when executed with TypeOrm

分類Dev

Data not persistent in scikit-learn transformers

分類Dev

Get consul Docker image to be persistent with Vault data

Related 関連記事

  1. 1

    MySql workbench query history ( last executed query / queries ) i.e. create / alter table, select, insert update queries

  2. 2

    UPDATE, INSERT and ON DUPLICATE KEY UPDATE in one query

  3. 3

    The appendchild function cannot be executed successfully

  4. 4

    MySQL LOAD DATA INFILE Query running successfully but no output

  5. 5

    Insert content from a temporary table into an update query

  6. 6

    Logical query processing phase of INSERT, DELETE, and UPDATE in SQL queries

  7. 7

    Laravel query not executed

  8. 8

    String Query cannot be executed

  9. 9

    Kubernetes PVC data persistent

  10. 10

    In Core Data, how to do `if exists update else insert` in swift 4?

  11. 11

    Insert or update data using cte_results in SQL Server

  12. 12

    Update Temp table to Insert node in XML data using SQL

  13. 13

    MVC5, insert or update a list of data with just one submit

  14. 14

    how to insert and update data into postgresql from node js using if condition

  15. 15

    Execute Powershell Script from powershell indicate it executed successfully

  16. 16

    MYSQL data insert query doesn't work in Python

  17. 17

    How to use sql simple query to insert data from different table

  18. 18

    Make sure query is executed or not with Anorm

  19. 19

    PDO pagination query not executed correctly?

  20. 20

    Data in ksql table not being persistent

  21. 21

    Persistent Data Container not saving to the block

  22. 22

    Getting the updated record after a Persistent update

  23. 23

    if query is not update

  24. 24

    Realm order of insert or update

  25. 25

    Spring Hibernate @Data update vs raw UPDATE query: Optimistic Lock Exception despite @Transactional?

  26. 26

    How to overcome a persistent oracle 'invalid identifier' error on a basic insert?

  27. 27

    A raw PostgreSQL query hangs when executed with TypeOrm

  28. 28

    Data not persistent in scikit-learn transformers

  29. 29

    Get consul Docker image to be persistent with Vault data

ホットタグ

アーカイブ