This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

not insering all the records (please help!!)

 
catherine matthews
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

i am creating a tableA with a few records in one connection.
With another connection i am inserting all the records from tableB into tableA

In short i append the tableA with tableB using the execute statement below.

st2.executeUpdate("insert into FormulaQ1Q2 select * from FormulaQ1")

The prblem is not all the records are being inserted. After appen i should have 2000records. I am only having 1923 records. Please let me know what is the problem?
[ April 23, 2008: Message edited by: catherine matthews ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Lost" records are very unlikely, and if there were an error the whole insert would fail. Are you sure 2000 is what you should get?
 
catherine matthews
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using Jackess to copy the tables. As i copy The first tableA i have the correct amount of records. After i copy the second Table. The records in the first table gets changed. I loose 4 records. And the number of records in tableA becomes lesser. This is my method to copy the table.
I am using the same method. Changing the variable for the Connection.
Please let me know why this wierd thing is happening


[ April 24, 2008: Message edited by: catherine matthews ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic