Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 69627 invoked from network); 29 Aug 2002 19:25:02 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 29 Aug 2002 19:25:02 -0000 Received: (qmail 7734 invoked by uid 97); 29 Aug 2002 19:21:07 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 7666 invoked by uid 97); 29 Aug 2002 19:21:06 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 7598 invoked by uid 98); 29 Aug 2002 19:21:05 -0000 X-Antivirus: nagoya (v4218 created Aug 14 2002) Reply-To: From: "Jim Urban" To: "'Tomcat Users List'" Subject: RE: Open source ODBC driver for SQL Server 7 Date: Thu, 29 Aug 2002 14:20:05 -0500 Message-ID: <042301c24f91$15258d70$4673f540@nsdom01> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 In-Reply-To: <0839DE213D36D6119B9300805FBB9CBD22D891@admin120181.rgs.uci.edu> Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N We could run stored procs that took input parameters and updated/inserted/deleted records and returned output parameters. The problem was this: turn off autocommit. run proc 1 insert a record and returned an ident field. run proc 2 insert a record using the ident field from the record inserted in proc 1 as a foreign key. Get sqlexception for RI violation (foreign key does not exist). This should work as long as you maintain the connection. Jim Urban - jurban@parkcitysolutions.com Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -----Original Message----- From: Jeffrey Polaski [mailto:jpolaski@rgs.uci.edu] Sent: Thursday, August 29, 2002 2:05 PM To: 'Tomcat Users List' Subject: RE: Open source ODBC driver for SQL Server 7 Sorry--I wasn't clear. You had problems feeding the results of one stored procedure call back in to another stored procedure call. But you could run a call to a stored procedure and then display the results without any problem, right? Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine -----Original Message----- From: Jim Urban [mailto:jurban@parkcitysolutions.com] Sent: Thursday, August 29, 2002 11:24 AM To: 'Tomcat Users List' Subject: RE: Open source ODBC driver for SQL Server 7 The problems were with stored procs. Jim Urban - jurban@parkcitysolutions.com Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -----Original Message----- From: Jeffrey Polaski [mailto:jpolaski@rgs.uci.edu] Sent: Thursday, August 29, 2002 1:14 PM To: 'Tomcat Users List' Subject: RE: Open source ODBC driver for SQL Server 7 Thanks in advance for your help! Jeff Polaski Webmaster Research & Graduate Studies University California, Irvine -- To unsubscribe, e-mail: For additional commands, e-mail: -- To unsubscribe, e-mail: For additional commands, e-mail: -- To unsubscribe, e-mail: For additional commands, e-mail: -- To unsubscribe, e-mail: For additional commands, e-mail: