creating files with "outfile..." (file can't found!)

Expand Post »

I did this ..

Java Syntax (Toggle Plain Text)
 
 String filename = "tempoutfile.txt";
 String tablename = "table1";
 
	try{
 
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Test","root","");
			Statement s=con.createStatement();
			ResultSet r=s.executeQuery("SELECT * INTO OUTFILE '"+ filename + "' FROM " + tablename);
 
			}catch(SQLException se){System.out.println(se.getMessage());}
		                         
 String filename = "tempoutfile.txt";
 String tablename = "table1";

	try{
			
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Test","root","");
			Statement s=con.createStatement();
			ResultSet r=s.executeQuery("SELECT * INTO OUTFILE '"+ filename + "' FROM " + tablename);

			}catch(SQLException se){System.out.println(se.getMessage());}

But I can't find the file that is created!!

When I run the query in WAMP mysql console , it creates the out file in wamp\mysql\data . But not in previous case.

Where is this file created?

Last edited by jrosh; Nov 4th, 2009 at 1:14 am.

Similar Threads

VB6 - dll file not found error 53 in Visual Basic 4 / 5 / 6
Rundll32 file not found!! in Viruses, Spyware and other Nasties
Rundll32 file not found!! in Viruses, Spyware and other Nasties
"Dangerous viruses detected in your system" popup when opening files and folders in Viruses, Spyware and other Nasties
Write binary files without "c style" in C++

jrosh

Reputation Points: 10

Solved Threads: 0

Junior Poster

Offline

141 posts
since Sep 2009

Permalink

Nov 4th, 2009

Re: creating files with "outfile..." (file can't found!)

Add a System.out.println(System.getProperty("user.dir")) in there.

Otherwise use the search function for the OS.

But, the best way is to provide the full path to the file from the beginning. Why simply deal with defaults that can change due to configuration and/or operating parameters when you can control the operation.

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: scroll text with many link

Next Thread in Java Forum Timeline: Java Software Help

DaniWeb Message

Cancel Changes

User Name
Password