Query Regarding csv file size problem

[swathi123]

hi all
here im trying to create .csv file.
my code is

public class CSVFile {

public static void main(String[] args) {

String record=null;
try {
Class.forName(" org.sqlite.JDBC ");


Connection conn=DriverMana ger.getConnecti on("jdbc:sqlite :"+"C:\\Sqlite\ \retriver.db");
Statement stmt = conn.createStat ement(); ResultSet rs = stmt.executeQue ry("select * from fileSystem");
ResultSetMetaDa ta meta=rs.getMeta Data();
int colCount=meta.g etColumnCount() ;
int j=0;
File fileStore = new File(fileStore. csv");
FileOutputStrea m fos=new FileOutputStrea m(fileStore);
long i=0;
while(rs.next() )
{

record=rs.getSt ring(1)+","rs.g etString(2)","r s.getString(3)" ,"rs.getString( 4)","rs.getStri ng(5)","rs.getS tring(6)","rs.g etString(7)","r s.getString(8)" ,"rs.getString( 9)"\n";
fos.write(recor d.getBytes());
System.out.prin tln("counter"+( j++));

}
This is my code
my problem is in my database i have 2,00,000 records
but here i will get upto 65,000 records only

i want to get all records
is there any solution

[dmjpro]

hi all
here im trying to create .csv file.
my code is

public class CSVFile {

public static void main(String[] args) {

String record=null;
try {
Class.forName(" org.sqlite.JDBC ");

Connection conn=DriverManager.getConnection("jdbc:sqlite:"+"C:\\Sqlite\\retriver.db");
Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from fileSystem");
ResultSetMetaData meta=rs.getMetaData();
int colCount=meta.getColumnCount();
int j=0;
File fileStore = new File(fileStore.csv");
FileOutputStream fos=new FileOutputStream(fileStore); 
long i=0; 
while(rs.next())
{
 
record=rs.getString(1)+","rs.getString(2)","rs.getString(3)","rs.getString(4)","rs.getString(5)","rs.getString(6)","rs.getString(7)","rs.getString(8)","rs.getString(9)"\n";
fos.write(record.getBytes()); 
System.out.println("counter"+(j++));
 
}
 

This is my code
my problem is in my database i have 2,00,000 records
but here i will get upto 65,000 records only

i want to get all records
is there any solution

Use code tags while you do Post.
Read the posting guidelines before posting :-)
Are you getting 65,000 records out of 2,00,000 or you want to get 65,000 out of 2,00,000?
I think you are getting 65,000 out of 2,00,000 :-)

Actually you forgot to close the file o/p stream.

fos.close();
 

Just close it after writing finishes.
Good Luck :-)

Kind regards,
Dmjpro.