❌

Normal view

There are new articles available, click to refresh the page.
Before yesterdayMain stream

Error Encountered an issue when uploading and creating pre-authenticated URLs. process is holding on

We are using OCI Java SDK to integrate Object Storage with our services and facing issues of thread holding. Each call is holding one thread. For example, if we make a call to a pre-authenticated URL with five files, it holds five threads. This continuous increase in thread count results in the holding of system-native threads.

Problematic methods : • createPreauthenticatedRequest.getPreauthenticatedRequest(); • getObjectStorage().putObject(putObjectRequest);

Any suggestions where i may be going wrong

Tried the latest SDKs and Java versions but the problem exists

Oracle Free Cloud

tengo creadas 3 VPS en oracle free cloud, 2 pequeñas de 1gb de ram y 1 grande de 24gb de ram, no se que paso con las VPS pequeñas que no me deja conectarme mediante bitvise cabe resaltar que todo funcionaba bien hasta el dia de ayer, en el panel de oracle cloud me sale que la VPS estan funcionando pero al tratar de conectarme no me deja.

Probe con apagar y prender la vps pequeñas pero siguen con el mismo problema, revise si era problemas de todo el servicio en OCI Status pero me sale que todo esta funcionando.

What is difference between Oracle cloud infrastructure and Oracle Mobile Services?

I need to know what is difference between Oracle cloud infrastructure and Oracle Mobile Services? I need to develop an application that involves both web and mobile platforms with native languages in apps. So, I would be using storage to upload media. I wanted to know, if there are sdks available for android, ios and javascript web in oracle cloud infrastructure or Oracle Mobile Services? Which would be the best solution to choose?

Error when Inserting Data in PostgreSQL 15.3 from OCI Instance using Java: Returning Autogenerated Keys Issue

I have transferred my PostgreSQL database from an old server to an OCI (Oracle Cloud Infrastructure) instance. The old server was running PostgreSQL version 8.4, and the OCI instance has been upgraded to PostgreSQL 15.3. I'm currently using Java 8 and want to connect to the database using Java.

When I try to connect to the PostgreSQL database from my local machine, the connection is successful, and I can perform all operations. However, when I try to connect to the PostgreSQL database from the OCI instance, the connection works, and I can fetch and update data, but I encounter an error when trying to insert data. The error message is as follows:

Error updating database. Cause: org.postgresql.util.PSQLException: Returning autogenerated keys is only supported for 8.2 and later servers.

SQL: insert into t_buyer_cart (visitorno, chartno, lineno, thingno, flag, added_by, added_on, updated_by, updated_on, del_flag) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Cause: org.postgresql.util.PSQLException: Returning autogenerated keys is only supported for 8.2 and later servers.; uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Returning autogenerated keys is only supported for 8.2 and later servers.; nested exception is org.postgresql.util.PSQLException: Returning autogenerated keys is only supported for 8.2 and later servers.

To resolve this issue, I have tried the following steps:

  1. Upgrading the JDBC version to the latest version (42.6.0).
  2. Downgrading the JDBC version.
  3. Checking the local machine connection.
  4. Checking detailed logs (confirming correct PostgreSQL and JDBC versions).
  5. Commenting out the return method (only trying to inserting data).
  6. Checking the API load balancer logs.
  7. Checking the PostgreSQL database logs.
  8. Allowing ingress and egress on port 5432 in the VCN (Virtual Cloud Network) settings.
  9. Checking the PostgreSQL configuration file for maximum connections and remote connection settings.
  10. Verifying that the telnet connection is working.
  11. Checking with the root user (postgres user).
  12. Verifying table rights for all users.
  13. Checking permissions for the JAR file and pom.xml file (both set to 777).

Despite trying these steps, the issue remains unresolved. Anyone have an idea behind the occurrence of this type of issue and how to resolve it?
Thanks in advance.

❌
❌