Hi gsquared,

My question is I am reading the excel name from the user and according to that excel, i need to generate DB Table with same number of columns and...

Hi,

I am inserting the data through Java Source file, which calls the Inserting Function.

thanks

Hi,

you are absolutely right.

Previously i have some values in DB Table, so when new values are updated in Excel Sheet, will that new value will be populated in DB...

Hi,

It works fine if i use this query DBCC CHECKIDENT ( <table_name>,RESEED,<value>)

Thanks for all for your repsonse.

sathish.

Hi Dev,

But i want the ID column should start from 1 and counts till there is no Record in Excel sheet. Since i am using Server Management Studio Express, by...

Hi Dev,

Should i write this Query inside Java Source or in SQL query pane when i execure the query ???

Thanks

Hi,

For the first time when i run the query it is counting from 1 to n..

Next time when i run the console once again and execute the query, my id...

Thank u so much Gsquared.. Appreciate that..

Thanks Ninja's_RGR'us and Dev for your prompt Response.

Hi Dev,

Actually My loop will run until some data is present in the column and if no data is available it breaks the loop...

So in that case, there is no...

Hi,

I dont want that to be present in my DB... Is there any way to avoid that Default Row in DB ??

Thanks

Hi Dev,

Can you pls suggest some good JAVA Forum sites..

thanks

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 ???

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;

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...