• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Oracle Global Temporary Tables and Connection Pooling

Guest
Feb 24, 2010 Feb 24, 2010

Copy link to clipboard

Copied

When connection pooling, (“Maintain Connections” in cfadmin) is enabled.  Oracle Global Temporary tables get messed up.  Data bleeds from one page request to the next because CF is reusing the same Oracle session over and over again.

Is there a JDBC driver that will allow the use of Global Temp Tables while having connection pooling enabled? 

Other application servers, like Oracle Application Server, somehow allow the pooling and GTT work together harmoniously.

Views

1.7K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

LEGEND , Feb 25, 2010 Feb 25, 2010

If your temporary tables were created with the default setting of on commit delete rows, the cftransaction tag will help you.  This code:

<!---
<cfquery name="x" datasource="burns">
create global temporary table t_dan_test (id integer)
</cfquery>

--->

<cftransaction>
<cfquery name="i" datasource="burns">
insert into t_dan_test values(1)
</cfquery>
<cfquery  name="x1" datasource="burns">
select * from t_dan_test
</cfquery>
</cftransaction>
<cfquery  name="x2" datasource="burns">
select * from t_dan_test
</cf

...

Votes

Translate

Translate
LEGEND ,
Feb 25, 2010 Feb 25, 2010

Copy link to clipboard

Copied

LATEST

If your temporary tables were created with the default setting of on commit delete rows, the cftransaction tag will help you.  This code:

<!---
<cfquery name="x" datasource="burns">
create global temporary table t_dan_test (id integer)
</cfquery>

--->

<cftransaction>
<cfquery name="i" datasource="burns">
insert into t_dan_test values(1)
</cfquery>
<cfquery  name="x1" datasource="burns">
select * from t_dan_test
</cfquery>
</cftransaction>
<cfquery  name="x2" datasource="burns">
select * from t_dan_test
</cfquery>
<cfdump var="#x1#">
<cfdump var="#x2#">

resulted in x1 dumping 1 record and x2 dumping 0.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation