VAST with Oracle 9i
Juergen Bullinger
From IBM-Support I heard that there ist no official support for Oracle
9i, but that they know about customers which already ported their
VA-Apps to 9i.
So if you know someone who already ported a VAST-App to Oracle 9i or
if you did this port yourself, I would be very interested in learning
more about this process (especially about the complexity and
time/costs which are involved). At the moment we are also thinking
about this step.
We are developing in VAST 5.5.2 under WinNT/Win2000 (later also
WinXP), but we would migrate to VAST 6.0 if necessary. Our customer
decided, that their new IT-standard would be Win2000 with Oracle 9i on
the server side and WinXP with Oracle-Client 9.0.1 on the client side.
This decision means that if we can't find a solution to access Oracle
9i or the solution is to expensive or the risk is to high, we might be
forced to drop VAST unfortunately in our project.
Thank you in advance.
Kind regards
-Jürgen Bullinger
T-Systems International GmbH
Competence Center CRM Süd 2
Business Center Marketing & CRM Solution
Fasanenweg 5, 70771 Leinfelden-Echterdingen, Germany
Postfach 100258, 70746 Leinfelden, Germany
Juergen Bullinger
sorry for crossposting this article, but I didn't get any reply on
this subject in ibm.software.vasmalltalk and IBM support couldn't help
me, because they don't support Oracle 9i at the moment and seem to
have no plans to support it in future (at least they can't communicate
their plans).
From IBM support I heard that they know of at least two clients who
use Oracle 9i in their VAST projects. If anybody of these people reads
this message, please reply. I would be very interested about your
solution and about the effort it takes.
Thank you in advance.
Kind regards
-Jürgen Bullinger
T-Systems International GmbH
Competence Center CRM Süd 2
Business Center Marketing & CRM Solution
Fasanenweg 5, 70771 Leinfelden-Echterdingen, Germany
Postfach 100258, 70746 Leinfelden, Germany
j.google.2...@spamgourmet.com (Juergen Bullinger) wrote in message news:<7fd91e52.03071...@posting.google.com>...
Lothar Mischke
We are currently using VAST 4.5 with Oracle8i in one project. As VAST
4.5 does not support Oracle8i we had to change the Oracle DLL name using
AbtOracleDatabaseManager>>libraryName: from ora73.dll to oci.dll. This
works fine, but it meens that we are using the "old" Oracle7 interface
which is still present within the DLL.
We have checked that against an Oracle9i client, and it still works.
Another test consisted of using the new Oracle8 classes from the VAST 6
version and check them against an Oracle9i client. These classes (as the
ones in VAST 5.5) use the "new" Oracle8 interface. This works, too.
Nevertheless we found the Oracle8 classes within VAST are buggy.
Additionally they only implement the basic features just as the old
classes do. No BLOB support, poor support for executing stored
procedures etc.
In my opinion one has to put some amount of work in the current Oracle
interface if one wants to use it in future projects. I took a look at
the OCI documentation (which isn't very good, too) and within two weeks
of work I was able to get some rudimentary BLOB support and managed to
extend the use of stored procedures to support IN/OUT parameters and
return values. But this was just patching and extending existing code.
What if the interface changes in a higher version? Without support by
IBM it is a high risk to maintain an own implementation due to the
complexity of the OCI.
HTH
Lothar
Juergen Bullinger schrieb:
Michael Baker
driver? The classes in the post on comp.lang.smalltalk are the Oracle
driver classes. Is anyone using the ODBC interface w/ the Oracle 9i
ODBC driver? We will probably be upgrading our database soon and are
still using the 8.0.5 ODBC driver, which is not supported by Oracle.
Since Oracle is dropping support for 8i (8.1.7) at the end of the year,
it would be nice for IBM to keep up the pace.
TIA
-MB
Benoit St-Jean
> Me too on the VAST 5.5.2, Win2k, and 9i? Is anyone using the 9i ODBC
> driver? The classes in the post on comp.lang.smalltalk are the Oracle
> driver classes. Is anyone using the ODBC interface w/ the Oracle 9i
> ODBC driver? We will probably be upgrading our database soon and are
> still using the 8.0.5 ODBC driver, which is not supported by Oracle.
> Since Oracle is dropping support for 8i (8.1.7) at the end of the
> year, it would be nice for IBM to keep up the pace.
Yes... VAST 5.5.2, Windows 2000 (and XP) and Oracle 9i and ODBC. We
don't have any problem so far. Since I missed the start of this thread,
what is the problem you have with this setup?
--
-----------------
Benoit St-Jean
Yahoo! Messenger: bstjean
A standpoint is an intellectual horizon of radius zero. -- Albert Einstein
Michael Baker
Look on comp.lang.smalltalk for a post with the subject of "VAST 6.01
and Oracle 9i" by "Shiv Hariharan". He lists some methods that he had
to change. I haven't started the process yet, but want to find any
problems that other people might have had. And I had a small rant on
IBM not having support for 9i yet. My opinion is that if you're going
to support a version of your software, you keep it up to date.
Therefore, providing a 9i update.
Did you have modify anything to be able to use the 9i Oracle ODBC driver?
Thanks,
MB
Alertte Dagorne
Guten Morgen,
Wir sind eine Gruppe von vier Personen und haben beschlossen, jeden finanziell zu unterstützen, der das Recht erworben hat, mit Haustieren (unseren täglichen Begleitern) zu leben.
Unsere Hilfe geht auch an vegetarische Familien und arme Haushalte, die nicht über die finanziellen Mittel verfügen, um ihr Projekt mit einem jährlichen Zinssatz von 3 % durchzuführen. Interessenten sollten sich für weitere Informationen an Herrn Philippe Marie-Vincent wenden.
E-Mail: philippemar...@gmail.com