Long datatype in OracleSessionStateProvider sql table script

Long datatype in OracleSessionStateProvider sql table script

Postby CTartaglia » Wed 14 Jan 2009 15:34

In the database table script that is provided with the OracleSessionStateProvider, one of the columns has a LONG datatype. Is there any way to change this to a LOB type (BLOB or CLOB) or similiar type? The DBAs at my organization will not run the script with the LONG type since it is basically depricated by Oracle.

Thanks in advance.
-Chris
CTartaglia
 
Posts: 6
Joined: Wed 14 Jan 2009 15:28

Postby Shalex » Wed 14 Jan 2009 17:41

Hello Chris,

We have checked our InstallWebTables script (Program Files\Devart\dotConnect\Oracle\InstallWebTables.sql). There are two columns with the LONG type: the sessionitems column from the aspnet_sessions table and the details column from the aspnet_webevent_events table.

We will try to modify our provider to make it possible to work with these two columns in 2 cases:
1) if they are of the LONG type;
2) and if they are of LOB type (BLOB or CLOB) - you will need just change the type before executing the InstallWebTables script.

You will be notified about the results as soon as possible.
Shalex
Devart Team
 
Posts: 7705
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Fri 16 Jan 2009 12:16

The issue is fixed. Look forward to the next build of dotConnect for Oracle. I will notify you when it is released.
Shalex
Devart Team
 
Posts: 7705
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Fri 20 Feb 2009 14:34

The new build (5.00.22) of dotConnect for Oracle is available now.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=14185
Shalex
Devart Team
 
Posts: 7705
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle