ORA driver version | Uniface 9 | Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

—  Results per page  —








— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters
For a group of consecutive words like 'end of support' use Match phrase

sp_Feed Topic RSS sp_TopicIcon
ORA driver version
27 Nov 2017
9:30 pm
Avatar
Knut
Member
Forum Posts: 179
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi all,

In 9.7.x – there are 4 different Oracle drivers, U63, U70, U71 and U72.

I’ve looked though the documentation – and I cannot find any matrix / comparisons between the different driver versions –
apart from u4_compatibility which seems to be only available for the U63 driver.

We’re running against Oracle 12c – and our main production databases are 2.2 tb / 700gb / 5.2tb and 52tb….

Given the sizes of these databases, and using u4_compatibility, my fear is that the U63 driver will be dropped –
and we have no way of converting our data from long to clob/blob (or the other way around).

Does anyone have any experience(s) with these size databases and in particular the u4_compatibility switch?

Knut

27 Nov 2017
10:52 pm
Avatar
gianni
Member
Forum Posts: 264
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi Knut,

with such massive amount of data everything it’s same time a problem and an opportunity!

In your context moving away from LONG* cannot be done in a single shot.
Are those prod databases all daily alive or can somehow be splitted to manage them by chunks (application models?) ?

Gianni

28 Nov 2017
2:18 pm
Avatar
Knut
Member
Forum Posts: 179
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi Gianni,

They’re all realtime…

To add further complications and complexity;
We’ve got old COBOL programs, new .NET programs and several hundred stored procedures, all making use of LONG*
in order to access these databases…. Cry

Knut

29 Nov 2017
11:17 am
Avatar
Adrian Gosbell
Amsterdam, seat 77a of a Boeing 747
Admin
Forum Posts: 286
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

A few points here.. 

Looking at some of the statements from Oracle, they view LONG as depreciated, and advise not to use it, and for customers to plan to move to alternatives. But apparently they still make use it themselves..But the statement from Oracle  is there. 

In regards to the Uniface connectors, our policy is that the major version number changes when there are source code changes to the driver, these could be to add functionality (pagination or unicode for example) or to support a newer version. (I don’t recall the last time we’ve had to do this).  An example of a major version change would be u6 to u7. 

Minor version number changes usually reflect that we have rebuild the driver with newer client libraries, usually released when the database vendor releases a new database server. Functionality wise, its the same as the previous driver, just the client libraries are different (newer). 

There have been exceptions to this in the past, I assume to speed up delivery. 

Our Oracle connector is the only one of our ‘mainstream connectors’, which has not been rebuilt to use our ‘UDT’ architecture, where we try to have as much ‘common functionality’ as possible in one layer, and keep the database specific code in a separate layer. It makes changes more efficient (we found this when we did the SQL/print and the pagination enhancements). 

From a product management perspective, I would really like to rebuild the Oracle driver to follow the UDT architecture. If we did, I’d be in favor or removing all of the backwards compatibility stuff and making it as ‘clean’ as possible. (the number of USYS$ORA_PARAMS settings gives an indication of how complicated the driver is). We would have to maintain the old driver for ‘compatibility purposes’. Note this is something I’d like to do, it’s not in the roadmap and I don’t see it coming up anytime soon. 

29 Nov 2017
4:59 pm
Avatar
Arjen van Vliet
Member
Forum Posts: 170
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Knut said

(…) I’ve looked though the documentation – and I cannot find any matrix / comparisons between the different driver versions – (…)

..that would mean going through various older PAM’s to find out which driver belongs to which Uniface version and subsequently dig up the (sometimes offline) documentation of that particular Uniface version, to look up the driver functionality, as there has never been (AFAIK) any direct comparison documents on various driver versions like U63, U70, U71, U72.

Knut said

(…) and we have no way of converting our data from long to clob/blob (or the other way around).(…)

This migration seems a pretty common (unavoidable) thing in the Oracle world. This is what Oracle says about it. Please note that ‘he other way around’ (Converting LOB datatypes back to LONG datatypes) is not supported according to this page.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online: Amarildo Ribeiro, Henk van der Veer
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1710

Iain Sharp: 623

Theo Neeskens: 345

gianni: 264

rogerw: 232

istiller: 201

lalitpct: 197

Knut: 179

-GHAN-: 171

Arjen van Vliet: 170

Member Stats:

Guest Posters: 3

Members: 7038

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2058

Posts: 8862

Newest Members:

Arabellaquife, ArthurEffit, RubenKip, MarinaGOVunse, Olpbtsj, Richardglums, Hellbladequife, RobertCab, Kcrdhlq, Kennethsherm

Administrators: admin: 23, Adrian Gosbell: 286, diseli: 836, Bob Maier: 3, Nico Peereboom: 65, Michael Rabone: 4, richiet: 406, JanCees: 28