tracker issue : CF-3795648

select a category, or use search below
(searches all categories and all time range)
Title:

CF Application Oracle clientstorage crash

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Mario Schnötzinger / Mario Schnötzinger (Schnoetz)

Created: 07/28/2014

Components: Database

Versions: 11.0

Failure Type: Crash

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Linux

Vote Count: 0

Problem Description:
CF Application closes the Oracle database connection when calling a Application when the clientstorage(cdata,cglobal) is generated over the CF Administrator.


Steps to Reproduce:
Configure a Oracle 11.2.0.3 database and cofigure it as storage mechanism for Client Sessions and call a cfapplication with it as clientstorage.

Actual Result:
See attachment bug1.JPG

Expected Result:
the application

Any Workarounds:
Change the cdata table to:
	"CFID" CHAR(70 BYTE), 
	"DATA" CLOB, 
	"LVISIT" DATE
Change cglobal to:
"CFID" CHAR(70 BYTE), 
	"DATA" CLOB, 
	"LVISIT" DATE

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3795648

External Customer Info:
External Company:  
External Customer Name: Schnoetz
External Customer Email:  
External Test Config: My Hardware and Environment details:

Coldfusion Server Details

Server Product 	ColdFusion

Version 	11,0,0,289974

Tomcat Version 	7.0.52.0

Operating System 	UNIX  

OS Version 	2.6.32-431.20.3.el6.x86_64  

Adobe Driver Version 	5.1.1 (Build 0001)   



Oracle Details:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Attachments:

  1. July 28, 2014 00:00:00: 1_bug1.JPG

Comments:

Hi, Are you able to execute any query against this datasource without any issue? Regards, Nimit
Comment by Nimit S.
11513 | August 18, 2014 07:57:24 AM GMT
We have not heard anything back on this issue. Hence, closing this bug. If you are still facing this issue please let us know so that we can re-open this bug.
Comment by Nimit S.
11514 | December 03, 2014 03:47:57 AM GMT