G georgelbs Member Licensed User Longtime User Mar 20, 2018 #1 I use JRDC2 to connect an Oracle database 11G express, with the latest ojdbc6,jar , all the "select" commands works but when send an "Update" command don't receive an error but nothing is updated in the database and the table get a status of ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired, exception is java.sql.SQLException until kill the B4J Java process Appears like the reqManager.ExecuteBatch(comandos, "Series") tha I use, is not making a commit Any ideas?
I use JRDC2 to connect an Oracle database 11G express, with the latest ojdbc6,jar , all the "select" commands works but when send an "Update" command don't receive an error but nothing is updated in the database and the table get a status of ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired, exception is java.sql.SQLException until kill the B4J Java process Appears like the reqManager.ExecuteBatch(comandos, "Series") tha I use, is not making a commit Any ideas?
Erel B4X founder Staff member Licensed User Longtime User Mar 20, 2018 #2 You need to debug it. It will be simpler to do it with B4J and SQL library. Try to find what causes it to get stuck. Upvote 0
You need to debug it. It will be simpler to do it with B4J and SQL library. Try to find what causes it to get stuck.
G georgelbs Member Licensed User Longtime User Mar 21, 2018 #4 I solve it using the latest ojdbc8 instead of ojdbc6 Upvote 0
B beelze69 Active Member Licensed User Longtime User Feb 4, 2021 #5 georgelbs said: I solve it using the latest ojdbc8 instead of ojdbc6 Click to expand... Hi ! Saw your above post. I am having a similar problem. I want to connect to live Oracle database using JRDC2.. Here, I have the following doubts: 1) In B4J program , for connecting to MYSQL , the driver to be taken is mysql-connector-java-5.1.27.jar file; relevant entry in the code is #AdditionalJar: mysql-connector-java-5.1.27 (which is to be kept in C:\Program Files (x86)\Anywhere Software\B4J\Libraries) My doubt: 1) For Oracle, what is the relevant .jar file ? 2) What is the #AdditionalJar: entry to be made ? 2) In the Config file in the JRDC2 folder .. for MYSQL Database, a typical entry would be JdbcUrl=jdbc:mysql://localhost/mydb_store?characterEncoding=utf8 User=root Password= #Java server port ServerPort=17178 where : mydb_store is the name of the database root is the user with NULL as password. My doubt: Now, for an Oracle database with: TNSNAMES="MYTNS" localhost=127.0.0.1 port: 1521 (listener runs on default port 1521) SCHEMA NAME="MYSCHEMA" PASSWORD="mypassword" How will the entries appear in the 'config' file under the JRDC2 folder ? (NOTE: The ServerPort 17178 will not change since it is where the JRDC2 server will run on ) ... Please help. Thanks in advance. Upvote 0
georgelbs said: I solve it using the latest ojdbc8 instead of ojdbc6 Click to expand... Hi ! Saw your above post. I am having a similar problem. I want to connect to live Oracle database using JRDC2.. Here, I have the following doubts: 1) In B4J program , for connecting to MYSQL , the driver to be taken is mysql-connector-java-5.1.27.jar file; relevant entry in the code is #AdditionalJar: mysql-connector-java-5.1.27 (which is to be kept in C:\Program Files (x86)\Anywhere Software\B4J\Libraries) My doubt: 1) For Oracle, what is the relevant .jar file ? 2) What is the #AdditionalJar: entry to be made ? 2) In the Config file in the JRDC2 folder .. for MYSQL Database, a typical entry would be JdbcUrl=jdbc:mysql://localhost/mydb_store?characterEncoding=utf8 User=root Password= #Java server port ServerPort=17178 where : mydb_store is the name of the database root is the user with NULL as password. My doubt: Now, for an Oracle database with: TNSNAMES="MYTNS" localhost=127.0.0.1 port: 1521 (listener runs on default port 1521) SCHEMA NAME="MYSCHEMA" PASSWORD="mypassword" How will the entries appear in the 'config' file under the JRDC2 folder ? (NOTE: The ServerPort 17178 will not change since it is where the JRDC2 server will run on ) ... Please help. Thanks in advance.
