Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > J2EE
|
J2EE General J2EE (Java 2 Enterprise Edition) discussions. Questions not specific to EE will be redirected elsewhere.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the J2EE section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 13th, 2004, 05:04 AM
Registered User
 
Join Date: Jul 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help regarding Batch Execution of Queries.

Dear All,
I tried to insert 1,50,000 records from the Text file to MS-SQL Server through my Java Application.I am using Prepared statement to form the query and executing in the batch of 5,000 records at one time.
but is giving "com.ibm.websphere.jdbc.base.BaseBatchUpdateExcept ion: [IBM][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated" after 1,15000 records being inserted.Please help me if you have any idea about it.

Last edited by amitbattu; June 24th, 2009 at 09:11 PM..
 
Old April 30th, 2005, 04:04 AM
Registered User
 
Join Date: Apr 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Mallik8
Default

dear amit,
          i think ur problem is , fields of ur data base tables are not matching properly. for example a long value is not setted to int value, i.e long is 8 bytes and int is 4 bytes so even thoug data is numeric, data gets truncated.
                               bye , goodluck.

P.Mallikharjuna Rao





Similar Threads
Thread Thread Starter Forum Replies Last Post
Batch problem Fr3c Other Programming Languages 0 January 16th, 2008 10:58 AM
Batch File Allan320 Access 10 June 8th, 2006 06:46 AM
BATCH scapermoya Other Programming Languages 0 May 1st, 2006 08:47 PM
Combining Queries or results from 2 queries Ford SQL Server 2000 24 November 7th, 2005 08:54 PM
How to interprete Execution plans for queries pallavijyo SQL Server 2000 1 December 17th, 2004 06:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.