ACM Chapter Web Account

You now have four chances to enter the exact verification code you were provided.

ACM Web Account

Here is the security question that you provided to us in order to create your account.

You now have four chances to enter the exact answer you provided.     Case matters: you need to match upper- and lower-case to your original verification code. Four wrong answers will require you to contact annualreport@acm.org for a new verification code.
Case matters: you need to match upper- and lower-case to your original answer. Four wrong answers will force you back to the account creation facility where you will have to start over.
    SELECT to_char(tdstamp,'DD-MON-YYYY HH:MI:SS am') created_at, question,email,attempts,referring_url FROM t1 WHERE client_no = '#client_no#' AND tdstamp = ( SELECT max(tdstamp) FROM t2 WHERE client_no = '#client_no#') SELECT COUNT(*) AS ca_count FROM t3 WHERE client_no = '#client_no#'  
Attempt #GetQuestion.attempts# Of 3!   You have two more tries!
This is your last try.

DELETE FROM temp_account_urls WHERE client_no = '#client_no#'

 

Question: #GetQuestion.question#

Answer:

  This is the error message: "Error","jrpp-47","07/05/06","16:53:23","Public Applications","Data source slick verification failed.The root cause was that: java.sql.SQLException: Datasource names for all the database tags within CFTRANSACTION must be the same. The specific sequence of files included or processed is: D:\wwwroot\Public\Accounts\AskQuestion.cfm, line: 94 " coldfusion.tagext.sql.QueryTag$DataSourceVerificationException: Data source slick verification failed. at coldfusion.tagext.sql.QueryTag.validate(QueryTag.java:349) at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:440) at cfAskQuestion2ecfm1195949409.runPage(D:\wwwroot\Public\Accounts\AskQuestion.cfm: 94) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilt er.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Datasouce definition from config file. - - - - - - - 30.0 - 64000.0 - - RMDbrMuKADg= - - - oracle.jdbc.OracleDriver - - - slick - - - jdbc:oracle:oci:@rac - 64000.0 - - - - - false - - 1000 - - no - - - 30.0 - - - - false - - [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => guccio1 [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 6 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> cftransaction - Coldfusion Database Access

cftransaction - Coldfusion Database Access

I have a question about CFTRANSACTION. We are currently using CF6.0 with various versions of Oracle and SQL Server. In our server settings we do not maintain connections for any of our data sources. I am wondering when wrapping cftransaction around mulitple queries within a single page, does it use the same connection for each query or does is create a new connection for each query. Just curious....

  1. #1

    Default cftransaction

    I have a question about CFTRANSACTION. We are currently using CF6.0 with
    various versions of Oracle and SQL Server. In our server settings we do not
    maintain connections for any of our data sources. I am wondering when wrapping
    cftransaction around mulitple queries within a single page, does it use the
    same connection for each query or does is create a new connection for each
    query.

    Just curious.

    mjwjal Guest

  2. #2

    Default Re: cftransaction

    Upto what I have realised CF creates a new connection for each query unless it is cached.
    surenr Guest

  3. #3

    Default CFTRANSACTION

    I am receiving the following error "The root cause was that:
    java.sql.SQLException: Datasource names for all the database tags within
    CFTRANSACTION must be the same."

    All datasources are the same and I am not using a CFEXIT or CFABORT in the
    code.

    This code worked for years in version 4.5. The error is sporatically popping
    up after moving over to MX 7.

    Any help would be greatly appreciated.



    guccio1 Guest

  4. #4

    Default Re: CFTRANSACTION

    Some code examples would help. Maybe someway that you are creating the
    DSN's is causing them to become incorrect under the new version.

    guccio1 wrote:
    > I am receiving the following error "The root cause was that:
    > java.sql.SQLException: Datasource names for all the database tags within
    > CFTRANSACTION must be the same."
    >
    > All datasources are the same and I am not using a CFEXIT or CFABORT in the
    > code.
    >
    > This code worked for years in version 4.5. The error is sporatically popping
    > up after moving over to MX 7.
    >
    > Any help would be greatly appreciated.
    >
    >
    >
    Ian Skinner Guest

  5. #5

    Default Re: CFTRANSACTION

    You may want to post your code so that others may have the opportunity to possibly spot the problem.

    Phil
    paross1 Guest

  6. #6

    Default Re: CFTRANSACTION

    Her ya go!

    Thanks!

    Here is the code: - you will notice that there is not even a <CFTRANSACTION>
    tag in the code.


    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

    <html>
    <head>
    <title>Ask Question</title>
    </head>

    <body>

    <cfinclude template="put_header.cfm">

    <cfoutput>

    <FORM METHOD="post" ACTION="Generic_Account3.cfm">

    <cfset key = 271202>
    <cftry>
    <cfset client_no = Decrypt(#URL.client_no#,key)>
    <cfcatch type="Any">
    <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" width="90%">

    <TR>
    <td width="10%">&nbsp;</td>
    <TD width="70%"><h2>ACM Web Account</h2><P>
    <p>As a result of an incomplete URL executed in your browser, an error
    has occured. Rather than clicking on the link embedded in the email
    you received from us, please copy and paste the link directly
    into your browser.</p>

    <p>If the URL has wrapped, please ensure that there are no spaces
    when you try executing the link.</p>

    <p>Thank you for your patience.</p>

    <p>For further assistance please contact:
    <a href="mailto:msfadminhq.acm.org">msfadminhq.acm. org</a></p>
    </td>
    <td width="10%">&nbsp;</td>
    </tr>
    </table>
    <cfabort>
    </cfcatch>
    </cftry>
    <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" width="90%">
    <TR>
    <td width="10%">&nbsp;</td>
    <TD width="70%">

    <!--- special for chapter web accounts --->
    <CFIF (IsDefined("URL.c") OR IsDefined("Form.c"))>
    <h2>ACM Chapter Web Account</h2><P>

    You now have four chances to enter the exact verification code you were
    provided.<BR>

    <CFELSE>
    <h2>ACM Web Account</h2><P>

    <b>Here is the security question that you provided to us in order to
    create your account.</b><p>

    You now have four chances to enter the exact answer you provided.
    </CFIF>

    </td>
    <td width="10%">&nbsp;</td>
    </tr>
    <tr>
    <td width="10%">&nbsp;</td>
    <TD width="70%">

    <CFIF (IsDefined("URL.c") OR IsDefined("Form.c"))>
    <b>Case matters:</b> you need to match upper- and lower-case to your
    original verification code.

    Four wrong answers will require you to contact <A
    HREF="mailto:annualreportacm.org">annualreportac m.org</A> for a new
    verification code.<BR>

    <CFELSE>
    <b>Case matters:</b> you need to match upper- and lower-case to your
    original answer.

    Four wrong answers will force you back to the account creation facility
    where you will have to start over.
    </CFIF>
    </td>
    <td width="10%">&nbsp;</td>
    </tr>

    <tr>
    <td width="10%">&nbsp;</td>
    <TD width="70%">
    <CFQUERY name="GetQuestion" datasource="#db#" dbtype="Oracle80">
    SELECT to_char(tdstamp,'DD-MON-YYYY HH:MI:SS am') created_at,
    question,email,attempts,referring_url
    FROM t1
    WHERE client_no = '#client_no#'
    AND tdstamp = (
    SELECT max(tdstamp)
    FROM t2
    WHERE client_no = '#client_no#')
    </CFQUERY>

    <cfif GetQuestion.Recordcount EQ 0>
    <CFIF (IsDefined("URL.c") OR IsDefined("Form.c"))>
    <CFQUERY name="get_web_account_count" datasource="#db#" dbtype="Oracle80">
    SELECT COUNT(*) AS ca_count FROM t3
    WHERE client_no = '#client_no#'
    </CFQUERY>

    <CFIF get_web_account_count.ca_count GT 0>
    <CFSET this_href = "https://" & SERVER_NAME &
    "/public/chapters/chapterprofile/chapteradmin.cfm">
    <CFLOCATION url="#this_href#">
    <CFELSE>
    <CFLOCATION url="chapters_reset_vc.cfm?client_no=#client_no#">
    </CFIF>

    <CFELSE>
    <cflocation url="create.cfm">
    </CFIF>
    </cfif>

    <CFIF GetQuestion.attempts GT 1>
    &nbsp;<br>
    <FONT SIZE="3" FACE="helvetica" color="Navy"><b>Attempt
    #GetQuestion.attempts# Of 3!</b></font>&nbsp;&nbsp;
    <cfif #GetQuestion.attempts# IS 2>
    You have two more tries!<br>
    <cfelse>
    <FONT SIZE="3" FACE="helvetica">This is your last try.
    <ul type="square">
    <CFIF (IsDefined("URL.c") OR IsDefined("Form.c"))>
    <li>A wrong answer will send you back to the beginning of the process
    for creating a chapter web account.</li>
    <CFELSE>
    <li>A wrong answer will send you back to the beginning of the process
    for creating an account.</li>
    </CFIF>

    <li>You will have to start over.</li>
    </ul>
    </font>
    </cfif>


    <CFIF GetQuestion.attempts EQ 4>

    <CFQUERY name="DeleteTempURL" datasource="#db#" dbtype="Oracle80">
    DELETE FROM temp_account_urls
    WHERE client_no = '#client_no#'
    </CFQUERY>

    <CFIF (IsDefined("URL.c") OR IsDefined("Form.c"))>
    <CFLOCATION url="chapters_reset_vc.cfm?client_no=#client_no#">
    <CFELSE>
    <CFLOCATION url="create.cfm">
    </CFIF>
    </cfif>

    </cfif>
    <p>&nbsp;</p>
    <DL>
    <dt><STRONG><font color="Navy">Question:</font>
    #GetQuestion.question#</STRONG>
    </P>

    <DT><STRONG><font color="Navy">Answer:</font></STRONG>
    <DD><INPUT TYPE="text" NAME="TheAnswer" SIZE="80" VALUE="">
    <P>
    </DL>

    <INPUT TYPE="hidden" NAME="client_no" VALUE="#client_no#">
    <INPUT TYPE="hidden" NAME="Email" VALUE="#GetQuestion.email#">

    <CFIF (IsDefined("URL.c") OR IsDefined("Form.c"))>
    <INPUT TYPE="hidden" NAME="c" VALUE="1">
    </CFIF>

    <input type=submit value="Continue">
    <input type=reset Value="Reset Form">
    </FORM>

    </td>
    <td width="10%">&nbsp;</td>
    </tr>
    </TABLE>


    </cfoutput>

    </body>
    </html>



    This is the error message:

    "Error","jrpp-47","07/05/06","16:53:23","Public Applications","Data source
    slick verification failed.The root cause was that: java.sql.SQLException:
    Datasource names for all the database tags within CFTRANSACTION must be the
    same. The specific sequence of files included or processed is:
    D:\wwwroot\Public\Accounts\AskQuestion.cfm, line: 94 "
    coldfusion.tagext.sql.QueryTag$DataSourceVerificat ionException: Data source
    slick verification failed.
    at coldfusion.tagext.sql.QueryTag.validate(QueryTag.j ava:349)
    at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag .java:440)
    at
    cfAskQuestion2ecfm1195949409.runPage(D:\wwwroot\Pu blic\Accounts\AskQuestion.cfm:
    94)
    at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
    at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:349)
    at coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65)
    at coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:210)
    at coldfusion.filter.RequestMonitorFilter.invoke(Requ estMonitorFilter.java:51)
    at coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86)
    at coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:69)
    at coldfusion.filter.BrowserDebugFilter.invoke(Browse rDebugFilter.java:52)
    at
    coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
    er.java:28)
    at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
    at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38)
    at coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22)
    at
    coldfusion.filter.RequestThrottleFilter.invoke(Req uestThrottleFilter.java:115)
    at coldfusion.CfmServlet.service(CfmServlet.java:107)
    at coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:78)
    at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91)
    at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
    at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:257)
    at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:541)
    at
    jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:204)
    at
    jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:426)
    at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

    Datasouce definition from config file.


    - <var name="slick">
    - <struct type="coldfusion.server.ConfigMap">
    - <var name="update">
    <boolean value="true" />
    </var>
    - <var name="alter">
    <boolean value="true" />
    </var>
    - <var name="delete">
    <boolean value="true" />
    </var>
    - <var name="disable_clob">
    <boolean value="true" />
    </var>
    - <var name="login_timeout">
    <number>30.0</number>
    </var>
    - <var name="buffer">
    <number>64000.0</number>
    </var>
    - <var name="storedproc">
    <boolean value="true" />
    </var>
    - <var name="password">
    <string>RMDbrMuKADg=</string>
    </var>
    - <var name="insert">
    <boolean value="true" />
    </var>
    - <var name="drop">
    <boolean value="true" />
    </var>
    - <var name="CLASS">
    <string>oracle.jdbc.OracleDriver</string>
    </var>
    - <var name="description">
    <string />
    </var>
    - <var name="create">
    <boolean value="true" />
    </var>
    - <var name="NAME">
    <string>slick</string>
    </var>
    - <var name="DRIVER">
    <string />
    </var>
    - <var name="select">
    <boolean value="true" />
    </var>
    - <var name="url">
    <string>jdbc:oracle:oci:rac</string>
    </var>
    - <var name="blob_buffer">
    <number>64000.0</number>
    </var>
    - <var name="revoke">
    <boolean value="true" />
    </var>
    - <var name="urlmap">
    - <struct type="coldfusion.server.ConfigMap">
    - <var name="datasource">
    <string />
    </var>
    - <var name="sendStringParametersAsUnicode">
    <string>false</string>
    </var>
    - <var name="pageTimeout">
    <string />
    </var>
    - <var name="MaxPooledStatements">
    <string>1000</string>
    </var>
    - <var name="port">
    <string />
    </var>
    - <var name="TimeStampAsString">
    <string>no</string>
    </var>
    - <var name="systemDatabaseFile">
    <string />
    </var>
    - <var name="defaultpassword">
    <string />
    </var>
    - <var name="_logintimeout">
    <number>30.0</number>
    </var>
    - <var name="informixServer">
    <string />
    </var>
    - <var name="database">
    <string />
    </var>
    - <var name="host">
    <string />
    </var>
    - <var name="UseTrustedConnection">
    <string>false</string>
    </var>
    - <var name="args">
    <string />
    </var>
    -
    guccio1 Guest

  7. #7

    Default Re: CFTRANSACTION

    I'm not an expert as I have never used the DBType parameter in an
    <cfquery ...> tag. But I have a vague memory of it changing or being
    depreciated somewhere along the lines between 4.5 and 7. Check the
    doentation and it should give you an idea if this is an issue for you
    or not.

    guccio1 wrote:
    > Her ya go!
    >
    > Thanks!
    >
    > Here is the code: - you will notice that there is not even a <CFTRANSACTION>
    > tag in the code.
    > ...
    Ian Skinner Guest

  8. #8

    Default Re: CFTRANSACTION

    Interesting, since your code sample does not contain any CFTRANSACTION tags......

    Phil
    paross1 Guest

  9. #9

    Default Re: CFTRANSACTION

    dbtype is alive, well, and the attribute you use for query of queries.

    It still might be guccio1's problem though. I don't actually know.
    Dan Bracuk Guest

  10. #10

    Default Re: CFTRANSACTION

    guccio1 wrote:
    >
    > <cfinclude template="put_header.cfm">
    What is in put_header.cfm? And in your application.cfm/cfc?

    > <CFQUERY name="GetQuestion" datasource="#db#" dbtype="Oracle80">
    > SELECT to_char(tdstamp,'DD-MON-YYYY HH:MI:SS am') created_at,
    > question,email,attempts,referring_url
    > FROM t1
    > WHERE client_no = '#client_no#'
    > AND tdstamp = (
    > SELECT max(tdstamp)
    > FROM t2
    > WHERE client_no = '#client_no#')
    > </CFQUERY>
    Does this datasource validate from the CF Admin?

    > "Error","jrpp-47","07/05/06","16:53:23","Public Applications","Data source
    > slick verification failed.The root cause was that: java.sql.SQLException:
    > Datasource names for all the database tags within CFTRANSACTION must be the
    > same. The specific sequence of files included or processed is:
    > D:\wwwroot\Public\Accounts\AskQuestion.cfm, line: 94 "
    > coldfusion.tagext.sql.QueryTag$DataSourceVerificat ionException: Data source
    > slick verification failed.
    What is in your database log file?

    Jochem


    --
    Jochem van Dieten
    Adobe Community Expert for ColdFusion
    Jochem van Dieten **AdobeCommunityExpert** Guest

  11. #11

    Default Re: CFTRANSACTION

    We have contacted Adobe and they stated that a cfexit in a cftransactions
    anywhere on the server can cause this error. The cfexit causes the server to
    drop its current thread which can effect any number of applications on the
    server and display this incorrect message. The fix is to replace cfexits in
    cftranactions with cfaborts. We are in the process of making these coding
    changes as per their request. Everyone's help was so greatly appreciated.



    guccio1 Guest

  12. #12

    Default CFTRANSACTION

    Can we something like this in CF7
    <cftransaction>
    <cfstoredproc>
    Params for SP 1
    </cfstoredproc>
    <cfstoredproc>
    Params for SP 2
    </cfstoredproc>
    </cftransaction>
    CFRAM Guest

  13. #13

    Default Re: CFTRANSACTION

    I don't think so for a couple of reasons. First, the description for the
    cftransaction tag refers specifically to cfquery tags. Second, since I use
    cfstoredproc for for my Oracle applications, and I control COMMIT and ROLLBACK
    from within PL/SQL, I do not see how cftransaction could possibly override what
    I am doing within my procedure, especially with autonomous transactions.

    Phil

    paross1 Guest

  14. #14

    Default Re: CFTRANSACTION

    > I do not see how cftransaction could possibly override what I am doing within 

    Are you sure about that?
    cf_dev2 Guest

  15. #15

    Default Re: CFTRANSACTION

    I respectfully disagree with paross1. Any SQL related code run within
    cftransaction tags, cfquery or cfstoredproc, is contained with a database
    transaction. If you are using MS SQL Server you can look at the operation of
    cftransaction by using the SQL Server Profiler tool to view the SQL commands
    sent to the database.

    Note that I am using MS SQL Server, not Oracle, but I'm not sure that makes a
    difference.

    JR Guest

  16. #16

    Default Re: CFTRANSACTION

    JR "Bob" Dobbs wrote: 
    is 

    Yes, that was my understanding as well. But I don't have a lot of experience
    with cftransaction so I could be wrong..

    cf_dev2 Guest

  17. #17

    Default Re: CFTRANSACTION

    JR "Bob" Dobbs wrote: 
    cftransaction by using 

    Nice tip. I ran a test on two procedures that contain a BEGIN TRAN .. COMMIT.
    Here is what was sent to the database



    <cftransaction action="begin">
    <cfstoredproc procedure="Proc1" datasource="#dsn#">
    <cfprocparam value="#value1#" type="in" cfsqltype="cf_sql_timestamp">
    </cfstoredproc>
    <cfstoredproc procedure="Proc2" datasource="#dsn#">
    <cfprocparam value="#value1#" type="in" cfsqltype="cf_sql_timestamp">
    </cfstoredproc>
    <cftransaction action="rollback">
    </cftransaction>

    Sql Profiler results:

    SET IMPLICIT_TRANSACTIONS ON
    go
    exec sp_executesql N'EXEC Proc1 P1 ', N'P1 datetime ', 'Nov 6 2007 2:56PM'
    go
    exec sp_executesql N'EXEC Proc2 P1 ', N'P1 datetime ', 'Nov 6 2007 2:56PM'
    go
    IF TRANCOUNT > 0 ROLLBACK TRAN
    go
    IF TRANCOUNT > 0 COMMIT TRAN
    go
    IF TRANCOUNT > 0 COMMIT TRAN SET IMPLICIT_TRANSACTIONS OFF
    go
    SET TRANSACTION ISOLATION LEVEL READ COMMITTED
    go

    <cfstoredproc procedure="Proc1" datasource="#dsn#">
    <cfprocparam value="#value1#" type="in" cfsqltype="cf_sql_timestamp">
    </cfstoredproc>
    <cfstoredproc procedure="Proc2" datasource="#dsn#">
    <cfprocparam value="#value1#" type="in" cfsqltype="cf_sql_timestamp">
    </cfstoredproc>


    Sql Profiler results:

    SET TRANSACTION ISOLATION LEVEL READ COMMITTED
    go
    exec sp_executesql N'EXEC Proc1 P1 ', N'P1 datetime ', 'Nov 6 2007 2:56PM'
    go
    exec sp_executesql N'EXEC Proc2 P1 ', N'P1 datetime ', 'Nov 6 2007 2:56PM'
    go
    SET TRANSACTION ISOLATION LEVEL READ COMMITTED
    go

    cf_dev2 Guest

  18. #18

    Default Re: CFTRANSACTION

    [Q]Note that I am using MS SQL Server, not Oracle, but I'm not sure that makes
    a difference.[/Q]I believe that it does, which is why my remarks referenced
    Oracle specifically. The OP didn't specify database.

    Phil

    paross1 Guest

Similar Threads

  1. Error with cftransaction
    By gusvok in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 6th, 09:10 PM
  2. using cftransaction with queries
    By Mattastic in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: March 21st, 04:32 AM
  3. CFTRANSACTION w/ ROLLBACK
    By akosz in forum Macromedia ColdFusion
    Replies: 6
    Last Post: March 7th, 08:37 PM
  4. is this possible - cftransaction
    By jppa in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: March 1st, 08:51 PM
  5. cftransaction question
    By Netopole in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 22nd, 04:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •