No of Inserted Row "COUNT" Varies

Question

No of Inserted Row "COUNT" Varies

ns22boss

Mr or Mrs. 500

Points: 563
More actions
December 6, 2011 at 4:31 am

#149765

Hi All,
I am using SQL Server Management Studio Express, and i am getting weired output when i execute the query..
In java console i am getting the current count of number of records inserted in SQL DB, But when i execute the query in DB, it showing different counts for No of record inserted.
Eg. In java console i am getting as : Total Number of Records Inserted: 71730
But in SQL DB i am getting 68766 for first time..
and when i delete all rows and execute for the second time, i am getting different count like 67077..
Pls somebody help on this ???

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

Are you sure you are pointing to right Server & Database. Please verify your database connection in Java Console.

Easy test (assuming DEV environment): Delete all rows from Table (DB Connection) and query from Java Console. If you get any rows, you are certainly hitting wrong database.

ns22boss Mr or Mrs. 500 Points: 563 More actions · Answer 2

Hi,

I am using correct server and DB connections only...

How to check that we are using Correct DB connections and DB server.

Thanks

SqlSpider... Ten Centuries Points: 1254 More actions · Answer 3

First Try to fetch single Records from java console

and execute the same in the DB..

See ur getting the same results or not...

Then we will check with the Db Connections and which database ur using......

ns22boss Mr or Mrs. 500 Points: 563 More actions · Answer 4

Hi,

Yes , i am getting the same result in both Java console and DB..

But if the record goes larger i am not getting the correct results while Updating the values in SQL DB.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

ns22boss (12/6/2011)
Hi,
I am using correct server and DB connections only...
How to check that we are using Correct DB connections and DB server.
Thanks

Please post your Java Connection String here.

ns22boss Mr or Mrs. 500 Points: 563 More actions · Answer 6

Here is the connection details

Connection con = new Connection();

con.setDbHost("10.60.1.50");

con.setDriverName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

con.setDbName("QATESTDB");

con.setDbUser("sa");

con.setDbPassword("pa$$word");

con.setDbPort(1433);

con.setConnString(ConnectionAction.formConnectionString(con

.getDriverName(), con.getDbHost() + ":" + con.getDbPort(),

con.getDbName()));

ConnectionDetails conAlias = new ConnectionDetails(con

.getDriverName(), con.getConnString(), con.getDbUser(), con

.getDbPassword());

return conAlias;

Divine Flame SSCoach Points: 15943 More actions · Answer 7

ns22boss (12/6/2011)
Hi,
How to check that we are using Correct DB connections and DB server.
Thanks

1. Verify your connection string properties for Java Console again.

OR

2. In the above post, Dev has already given you the idea to delete all the data in the target table (if it a test server & don't forget to make a backup of that table prior doing this ). Then check from Java Console, if you still get the data there, you are absolutely connecting to wrong server.

OR

3. If you don't want to delete the data, insert one dummy record in target table & check from Java console. If you get this dummy record there, you are pointing to correct server otherwise not.

Sujeet Singh

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 8

ns22boss (12/6/2011)
Here is the connection details
Connection con = new Connection();
con.setDbHost("10.60.1.50");
con.setDriverName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con.setDbName("QATESTDB");
con.setDbUser("sa");
con.setDbPassword("pa$$word");
con.setDbPort(1433);
con.setConnString(ConnectionAction.formConnectionString(con
.getDriverName(), con.getDbHost() + ":" + con.getDbPort(),
con.getDbName()));
ConnectionDetails conAlias = new ConnectionDetails(con
.getDriverName(), con.getConnString(), con.getDbUser(), con
.getDbPassword());
return conAlias;

Please verify the bold items.

Divine Flame SSCoach Points: 15943 More actions · Answer 9

ns22boss (12/6/2011)
Here is the connection details
Connection con = new Connection();
con.setDbHost("10.60.1.50");
con.setDriverName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con.setDbName("QATESTDB");
con.setDbUser("sa");
con.setDbPassword("pa$$word");
con.setDbPort(1433);
con.setConnString(ConnectionAction.formConnectionString(con
.getDriverName(), con.getDbHost() + ":" + con.getDbPort(),
con.getDbName()));
ConnectionDetails conAlias = new ConnectionDetails(con
.getDriverName(), con.getConnString(), con.getDbUser(), con
.getDbPassword());
return conAlias;

You should never post the login credentials on this/any forum. I hope the password you provided here is not the actual one or is it :w00t:?Also, you should never use 'sa' to connect to application even if it is a test server.

Sujeet Singh

ns22boss Mr or Mrs. 500 Points: 563 More actions · Answer 10

Hi All,

Everything what you all said above, i did it and still i am getting different value only...

Is it related to performance Tuning and Data overloaded error ???

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 11

Is it related to performance Tuning and Data overloaded error ???

It comes at last, when you are certain that you are pointing to right database & server.

One thing for sure, if you are getting different results from your Java Console & DB Connection you are certainly not on same Database / Server.