T24 Access to Multiple Instance of ORACLE

[Shiva S]

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

[Shiva S]

[Mujtaba Khan]

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: ''

[Pawel (privately)]

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

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

[Mujtaba Khan]

Hi,

  Very Please to hear this that it should be possible if we could have such option to Call any Database Source in a lib as mention by Pawel  jcompile but pawel please if u define a little brief it would be help full for all of US :-)

2009/4/9 Pawel (privately) <ppriv...@wp.pl>

[Pawel (privately)]

Hi,

I did not say any database, but jBASE supported :-)
I have never tried what I have written :-) and (at the moment) I only think that it should be possible. There is jBASIC example in /usr/jbc/src, which uses embedded SQL to connect to database if I recall well. I also think that XML ORAdriver is written in such a way. That is why you need to install Oracle client libraries.

I am pretty convinced that it should work with some jBASE team support / Temenos help.

Second idea to populate your external database is to write some code in different language (Perl, Java, Python). You can call Java classes by CALLJ in jBASIC code. I would not however recommend "external programs/languages" to do it. Give jcompile a try and ask Temenos/jBASE for services. I think that they will not ignore your request.

Kind regards
Pawel

----------------------------------------------------
Poznaj prawdę o swojej rodzinie. Wejdź na Bliscy.pl
Kliknij: http://klik.wp.pl/?adr=http://corto.www.wp.pl/as/bliscy.html&sid=684

[Lior-TIS]

Hello,

As per you original question "Can T24 have access to multiple

Instances of ORACLE at the same time?"

As for as I know - NO.
Meaning, the XML Oracle driver works with only 1 SID.

regards,
Lior