Android Question Jrdc2 update Oracle

[georgelbs]

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]

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.

 

[georgelbs]

Thanks Erel I will try

 

[georgelbs]

I solve it using the latest ojdbc8 instead of ojdbc6

 

[beelze69]

I solve it using the latest ojdbc8 instead of ojdbc6

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.