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.