samit majumdar

Can a abstract method have a static qualifier?

I am trying to display 4 columns of a particular table. The browser

is displaying 50 records per page. 'Next' and 'Previous' buttons are

there for navigating through all the records. It may have even 1

million or more records. The table may have n number of records. I am

not getting any problem if the record size is approximately 50,000.

But for large number of records say, 1 lac or more, the browser is

taking too much time...roughly, for 1 lac record it is taking 35

seconds and for 2.5 lac record it is taking 4 minutes...as the no of

records fetched increases...page loading time also increases

exponentially. So, my aim is to collect partial data from the table

and display it. In oracle I can manage it using rownum and minus

clause, efficiently. But in SQL Server I am not able to handle it,

using those technique. My application runs both on Oracle and SQL

Server. Can anybody help me?

For more clarity :::: I want to collect 1 to 50 records from the

table. next time I want to collect records from 51th. position to

100th. position. And then from 101th. position to 15oth. and so on.
Of course in SQL Server.

I am writing my code in JSP.

Thanks -

Samit
[ July 21, 2005: Message edited by: samit majumdar ]

I want to populate a table, i.e insert images in a table in SQL Server. I am using Java(JSP/Servlet). Can any one suggest me how to populate the image and text fields in SQL Server...of course, using Java. If possible, could you please give me a piece of code?
Regards -
Samit

I want to populate a table, i.e insert images in a table in SQL Server. I am using Java(JSP/Servlet). Can any one suggest me how to populate the image and text fields in SQL Server...of course, using Java. If possible, could you please give me a piece of code?
Regards -
Samit

My application collects data from oracle and stores it in xml files and again it can read the contents of xml files and store it back to the oracle. My programme is running fine. But now I want to handle BLOB and CLOB datatypes for storing the data from oracle to xml and again from xml to oracle. But I am in complete dark on handling CLOB and BLOB. Can anyone guide me in this matter? Or, how to proceed, at least.
Thanks -
Samit

My application collects data from oracle and stores it in xml files and again it can read the contents of xml files and store it back to the oracle. My programme is running fine. But now I want to handle BLOB and CLOB datatypes for storing the data from oracle to xml and again from xml to oracle. But I am in complete dark on handling CLOB and BLOB. Can anyone guide me in this matter? Or, how to proceed, at least.
Thanks -
Samit

Could anybody tell me if there is an API in java that supports Xquery.
Regards-
Samit

Hi Everybody!,
Thanks for your guidance...I solved the problem by storing the data in multiple xml files(each containing 50,000 records) and viewing or restoring from those files...definitely, by using SAX.
thanks again,
Regards-
SAMIT

HI!,
I tried it out with pure SAX....but still it is giving java.lang.OutOfMemoryError. Do u have alternate ways...if so...please give it ...I am extremely in need of it.
Regards-
Samit

My java program parses an xml file, collects data from there and inserts data to rdbms or it can even display the data in tabular format in a browser. I have written two versions of my program... one using DOM and other one is using JDOM. Both are working fine for handling 15,000 to 20,000 of records. But in reality my program have to handle millions of records... may be 15 to 20 million..or you may consider the amount as unlimited. Here comes the problem... I am getting java.lang.OutOfMemory error. How to handle that? If anybody has any solution, please give it to me as soon as possible...i am in urgent need of it...3

Thanks-
Samit Kumar Majumdar

Hi friends!
I am facing a problem while using an applet to access the database through browser only. It is working fine while running through appletviewer. The error message is :

java.sql.AccessDeniedException:No connection found(java.lang.RuntimePermission error)

I am using Tomcat as a web server and using JDBC-ODBC bridge.

It is not that the security permissions are not set properly. I claim so as the same applet is doing the file input and output operations quite efficiently. It is creating problems only while accessing the database(that too while accessing through browser only, not through appletviewer). Is it due to the JDBC-ODBC bridge? Should I use type 3 or 4 pure Java Drivers for accessing the database? Is it must to use type 3 or 4 pure java drivers?

I tried to run an evaluation version of type 4 pure java driver. But I failed to use it successfully, although I went through the manual thoroughly. Could you suggest some FREE type 3 or 4 pure java drivers? Where from I can download those FREE drivers?

Awaiting for your suggestions....

Thanks and Regards-

SAMIT KUMAR MAJUMDAR.