× Discuss on any other topics

Unable to create table from Jbase to ORACLE using CREATE-FILE command

  • ankitsinghvi
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 1 month ago #21000 by ankitsinghvi
I am in the process of doing a RDBMS conversion from R14 tafc to Oracle.

i have configured required variables in the .profile and the connection b/w jbase and oracle is sucessfull (tested using "config-XMLORACLE" utility).

However when I execute “CREATE.FILE TEST12 TYPE=XMLORACLE” command from jshell prompt i get the below error:

** Error [ JEDI_FILEOP_ILLEGAL_CMD ] **
Illegal file operation command passed to jedi

can some one guide me and help me to identify what could be the reason?

Please Log in or Create an account to join the conversation.

More
7 years 1 month ago #21001 by nataraj.natz
Have u run the db scripts under TAFC_HOME/XMLORACLE/sql according to the installation instructions?
If yes, what is the error message in DCD logs (TAFC_HOME/log?)

Please Log in or Create an account to join the conversation.

  • rsreddy464@gmail.com
  • rsreddy464@gmail.com's Avatar
  • Offline
  • New Member
  • New Member
More
7 years 1 month ago - 7 years 1 month ago #21005 by rsreddy464@gmail.com
hi,

JBASE can’t find the driver
TYPE=XMLORACLE is not specified correctly
The environmental variable JBCOBJECTLIST doesn’t include the location of the driver.

please check JBCOBJECTLIST variable once again, give right driver path.

check the below variables once again.

set DRIVER_HOME=%TAFC_HOME%\XMLORACLE
set JBCOBJECTLIST=%DRIVER_HOME%\lib;%JBCOBJECTLIST%
set PATH=%PATH%;%DRIVER_HOME%\bin

and once again check database & user settings in config-XMLORACLE
Main menu
**********************************************
1. Database settings.
2. User settings.
3. Run installation script against database.
4. Test connection.
5. Save only.
6. Save and exit.

Check option 3 & 4 once again.

Regards,
Rajasekar Reddy
Last edit: 7 years 1 month ago by rsreddy464@gmail.com. Reason: some more information added
The following user(s) said Thank You: ankitsinghvi

Please Log in or Create an account to join the conversation.

  • ankitsinghvi
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 1 month ago #21008 by ankitsinghvi
Thank you so much Mr. Reddy...u are absolutely right..the issue was with the JBCOBJECTLIST..the lib for ORACLE_HOME was not poined correctly..

Thank u sooo soo much once again..

Please Log in or Create an account to join the conversation.

Time to create page: 0.111 seconds