I want to do the following on a page
1. select spid from sysprocesses, syslogins
where sysprocesses.suid = syslogins.suid
and name = 'trace'
2. get the spid returned above
3. Execute kill spid
Is this possible? How do I do it in java of my page? I am using the
database sybase?
Thanx for your help
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sun, Jan 30, 2000 09:57 PM
To: [EMAIL PROTECTED]
Subject: Re: [ND] Re: Transaction Problems
Please take me out from the news group mailing list. (My email:
[EMAIL PROTECTED])
thanks.
Mark Deng
********************
On Tue, 03 Feb 1998 00:28:37 -0500, Curt Springer wrote:
> The main problem is that the default execution on a CSpMultiSQL is
> 'select', not 'insert'. Plus, you are mixing two sets of commands that
> apply to CSpTransaction.
>
> Try something like this:
>
> transaction.begin("DataSourceName");
> int result = transaction.executeInsert(do1);
> if (result == PROCEED)
> {
> result = transaction.executeInsert(do2);
> } //if (result == PROCEED)
> if (result == PROCEED)
> {
> transaction.commit();
> } //if (result == PROCEED)
> else
> {
> transaction.rollback();
> } //else
>
> -- Curt Springer
> Team NetDynamics
> Equipe NetDynamics
>
>
>
>
> Eje Thorarinsson wrote:
> >
> > Is there someone out there with more experience
> > than me explain what could be wrong with the
> > following code. I have done this "by the book" in
> > ND 4.0 using a SQL Base Databaseserver via ODBC. I
> > have 2
> > separate dataobjects (MultiSQL) and the darn thing
> > always gives me the message "Transaction
> > committed..."
> > without anything being committed.
> >
> > Its getting late here in Sweden, and before I use
> > my laptop as a frizbee, I humbly pass on my
> > problems to the rest of the world ;-). Many thanks
> > for any input!
> >
> > //[[SPIDER_EVENT<btnInsert_onWebEvent>
> > public int btnInsert_onWebEvent(CSpWebEvent
> > event)
> > {
> > int command = PROCEED;
> >
> > // Table tb_Users
> > CSpMultiSQL do1 = (CSpMultiSQL)
> > CSpider.getDataObject("doUsers");
> >
> > // Table Group_Users
> > CSpMultiSQL do2 = (CSpMultiSQL)
> > CSpider.getDataObject("doGroupUser");
> > do2.setValue("dfGroupId",
> > getDisplayField("cbGroups").getValue());
> > do2.setValue("dfUserId",
> > getDisplayField("txtLoginId").getValue());
> >
> > CSpLog.send(this, CSpLog.CRITICAL, "dfGroupId="
> > + getDisplayField("cbGroups").getValue());
> > CSpLog.send(this, CSpLog.CRITICAL, "dfUserId="
> > + getDisplayField("txtLoginId").getValue());
> >
> > CSpTransaction transaction = new
> > CSpTransaction();
> > try
> > {
> > transaction.addDataObject(do1);
> > transaction.addDataObject(do2);
> >
> > command = transaction.execute();
> > if(transaction.succeeded() && (command !=
> > STOP))
> > {
> > // Transaction is commited automatically
> > CSpLog.send(this, CSpLog.CRITICAL,
> > "Transaction Successful! Committing.");
> > }
> > else
> > {
> > // Transaction is rolled back automatically
> > CSpLog.send(this, CSpLog.CRITICAL,
> > "Transaction Failed! Rolling back.");
> > command = STOP;
> >
> > // Show errorpage
> > pgErrorMsg felSida = (pgErrorMsg)
> > CSpider.getPage("pgErrorMsg");
> > felSida.load("Transaction failed! Could
> > not Insert into Tables...","Try again..");
> > }
> > }
> > catch(Exception ex)
> > {
> > command = STOP;
> > transaction.rollback();
> >
> > // Show errorpage
> > pgErrorMsg felSida = (pgErrorMsg)
> > CSpider.getPage("pgErrorMsg");
> > felSida.load("Internal Transaction
> > failure! Could not delete from
> > Tables...","Errormessage: " + ex);
> > }
> > return(command);
> > }
> > //]]SPIDER_EVENT<btnInsert_onWebEvent>
> >
> > ---------------------------------------------------------------
> >
> > Name: vcard.vcf
> > Part 1.2 Type: text/x-vcard
> > Encoding: 7bit
> > Description: Card for Eje Thorarinsson
>
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
>
>
_______________________________________________________
Get 100% FREE Internet Access powered by Excite
Visit http://freeworld.excite.com
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
