<?xml version="1.0" encoding="UTF-8"?>











<rss version="2.0" xmlns:jf="http://www.jivesoftware.com/xmlns/jiveforums/rss">



<channel>
    <title>Support Forums: Message List - JDBC Batch Updates vs Stored Procedures</title>
    <link>http://www.theserverside.com</link>
    <description>Most recent forum messages</description>
    <language>en</language>
    
        <generator>Jive Forums Silver 5.5.30 (www.jivesoftware.com)</generator>
    
    <pubDate>Thu, 23 May 2013 13:43:45 -0400</pubDate>


    <item>

        <title>JDBC Batch Updates vs Stored Procedures</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[<blockquote>1. In a given transaction, if I need to insert/update few records (say around 5 records) in different tables (say around 5 tables), can someone tell me which is the best approach to follow: JDBC batch updates or stored procedures?2. We are...]]></description>
        

        <pubDate>Thu, 09 Feb 2006 17:41:08 -0500</pubDate>

        

        <jf:creationDate>Thu, 09 Feb 2006 17:41:08 -0500</jf:creationDate>
        <jf:modificationDate>Thu, 09 Feb 2006 17:41:08 -0500</jf:modificationDate>
        <jf:date>Feb 9, 2006</jf:date>
        <jf:author>George Coller</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>JDBC Batch Updates vs Stored Procedures</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[1. I think that stored procedures would be faster since stored procedures are precompiled at the database end whereas queries need to be compiled if they are not being cached. Also stored procedures are helpful when your INSERT queries depends upon other...]]></description>
        

        <pubDate>Mon, 09 Jan 2006 13:13:32 -0500</pubDate>

        

        <jf:creationDate>Mon, 09 Jan 2006 13:13:32 -0500</jf:creationDate>
        <jf:modificationDate>Mon, 09 Jan 2006 13:13:32 -0500</jf:modificationDate>
        <jf:date>Jan 9, 2006</jf:date>
        <jf:author>abhishek bhargava</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>Complex SPs and loose-coupling to DB</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[We too have Hibernate 3.0 an Oracle 9i Database and many (fairly complex) Stored Procedures.  We need the stored procedures for performance reasons but we also want to reduce our dependecies on the database (or at least confine required changes from a...]]></description>
        

        <pubDate>Wed, 04 Jan 2006 07:59:08 -0500</pubDate>

        

        <jf:creationDate>Wed, 04 Jan 2006 07:59:08 -0500</jf:creationDate>
        <jf:modificationDate>Wed, 04 Jan 2006 07:59:08 -0500</jf:modificationDate>
        <jf:date>Jan 4, 2006</jf:date>
        <jf:author>Brian Nulty</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>JDBC Batch Updates vs Stored Procedures</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[In my current project i use hibernate 3.0. But I use stored procedures in ORacle for certain data intense tasks. For example a certain use case requires making copies of existing data and this would involve potentially thousands of records. Perfect for...]]></description>
        

        <pubDate>Fri, 30 Dec 2005 15:23:16 -0500</pubDate>

        

        <jf:creationDate>Fri, 30 Dec 2005 15:23:16 -0500</jf:creationDate>
        <jf:modificationDate>Fri, 30 Dec 2005 15:23:16 -0500</jf:modificationDate>
        <jf:date>Dec 30, 2005</jf:date>
        <jf:author>Mathew Thomas</jf:author>
        <jf:replyCount>1</jf:replyCount>
    </item>


    <item>

        <title>JDBC Batch Updates vs Stored Procedures</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[I'll prefer JDBC updates 'cos stored procedures have different syntaxes for different databases. Also, some databases do not support SPs at all.]]></description>
        

        <pubDate>Fri, 30 Dec 2005 10:20:06 -0500</pubDate>

        

        <jf:creationDate>Fri, 30 Dec 2005 10:20:06 -0500</jf:creationDate>
        <jf:modificationDate>Fri, 30 Dec 2005 10:20:06 -0500</jf:modificationDate>
        <jf:date>Dec 30, 2005</jf:date>
        <jf:author>umar ali</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>JDBC Batch Updates vs Stored Procedures</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[ok. Thanks for your suggestion. Can you please tell what is the advantage in using stored procedures?  Won't JDBC Batch updates give the same/equivalent performance as Stored procedures?]]></description>
        

        <pubDate>Fri, 30 Dec 2005 00:07:11 -0500</pubDate>

        

        <jf:creationDate>Fri, 30 Dec 2005 00:07:11 -0500</jf:creationDate>
        <jf:modificationDate>Fri, 30 Dec 2005 00:07:11 -0500</jf:modificationDate>
        <jf:date>Dec 30, 2005</jf:date>
        <jf:author>siva raman</jf:author>
        <jf:replyCount>0</jf:replyCount>
    </item>


    <item>

        <title>JDBC Batch Updates vs Stored Procedures</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[Stored Procs.......!!!!!!]]></description>
        

        <pubDate>Wed, 28 Dec 2005 06:49:49 -0500</pubDate>

        

        <jf:creationDate>Wed, 28 Dec 2005 06:49:49 -0500</jf:creationDate>
        <jf:modificationDate>Wed, 28 Dec 2005 06:49:49 -0500</jf:modificationDate>
        <jf:date>Dec 28, 2005</jf:date>
        <jf:author>Jyothish John</jf:author>
        <jf:replyCount>1</jf:replyCount>
    </item>


    <item>

        <title>JDBC Batch Updates vs Stored Procedures</title>
        <link>http://www.theserverside.com/discussions/thread.tss?thread_id=38264</link>

        

        
            <description><![CDATA[1. In a given transaction, if I need to insert/update few records (say around 5 records) in different tables (say around 5 tables), can someone tell me which is the best approach to follow: JDBC batch updates or stored procedures?<br><br>2. We are going...]]></description>
        

        <pubDate>Tue, 27 Dec 2005 08:12:38 -0500</pubDate>

        

        <jf:creationDate>Tue, 27 Dec 2005 08:12:38 -0500</jf:creationDate>
        <jf:modificationDate>Tue, 27 Dec 2005 08:12:38 -0500</jf:modificationDate>
        <jf:date>Dec 27, 2005</jf:date>
        <jf:author>siva raman</jf:author>
        <jf:replyCount>7</jf:replyCount>
    </item>



</channel>
</rss>

