Re: T24 Access to Multiple Instance of ORACLE

Thu, 09 Apr 2009 11:04:07 -0700

Hi,

Not an easy, but very good requirement. In my opinion this possible (or at least should be).

jcompile 4.1 jBASE compiler (not T24 EB.COMPILE wrapper of jcompile) has ability to compile jBASIC code with SQL embedded statements. In such a way you should be able to connect to different Oracle database / instance. Perhaps not only Oracle database, but any other SQL-like and jBASE supported, eg. IBM DB2, SQL server. I can also imagine that you would need to have db client libraries installed. I belive that in your T24 Oracle installation you already has them installed.

I think that it is time to keep smiling to Jim to get some more detailed hints :)

Kind regards
Pawel

Dnia 9-04-2009 o godz. 18:58 Mujtaba Khan napisał(a):
Hi,

 in my view NO way ..

as in jedi_config you can use only single SID

1.  List current setting.
2.  Set database.
3.  Set data tablespace.
4.  Set index tablespace.
5.  Set prefetch count.
6.  Set prefetch memory.

9.  Back to main menu.

Select option: 1

    Database TNS: 'TEST'
 Data tablespace: 'TESTDATAXML'
Index tablespace: 'TESTINDEXXML'
  Prefetch count: '1000'
 Prefetch memory: ''





On Thu, Apr 9, 2009 at 6:17 PM, Shiva S <[email protected]> wrote:
Hello Everybody,
 
I am in a client place now where Model Bank Implementation is going on. DataBase is ORACLE.
 
There is a requirement here which is stated below.
 
As you all know data in jBASE is stored in the form of FILES where as in ORACLE it is stored in the form of TABLES.
 
We have T24 - jBASE - XMLORACLE Driver - ORACLE DataBase Instance
 
XMLORACLE Driver will take care of storing the data in ORACLE in the form of Tables.
 
There is an Environmental Variable by name ORACLE_SID which is used to indicate the  ORACLE Instance on which to update the data. I may be wrong on this. Please correct me on this point if i am wrong.
 
Say suppose in a single server we have 2 ORACLE Instances. Say for example:
 
* ORACLE Instance 1 - Exclusively for T24. All T24 data by default comes and stores here. This is the Instance specified in ORACLE_SID
* ORACLE Instance 2 - For an External System
 
Say that i have a requirement where i have to create a Local Template, the data of which has to be stored in ORACLE Instance 2.
 
So the requirement is as below:
 
Can T24 have access to multiple Instances of ORACLE at the same time? (Programatically speaking in a Single Classic Mode Session)
 
Best Regards
Shiva Shankaran S








Kind regards
Pawel



----------------------------------------------------
Wyślij kurczaka na święta - Kliknij:
http://klik.wp.pl/?adr=http://corto.www.wp.pl/as/wielkanocnykurczak.html&sid=690




--~--~---------~--~----~------------~-------~--~----~

Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines
 
 
IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24
 
 
To post, send email to [email protected]
 
 To unsubscribe, send email to [email protected]
 
 For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

-~----------~----~----~----~------~----~------~--~---