Java

Java RSS

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

Thread Solved

•

Join Date: Sep 2009

Posts: 102

Reputation: jrosh is an unknown quantity at this point

Solved Threads: 0

jrosh

Offline

Junior Poster

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

20 Days Ago

I did this ..

 Help with Code Tags 
 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; 20 Days Ago at 1:14 am.

•

Join Date: Feb 2006

Posts: 2,341

Reputation: masijade has much to be proud of

Solved Threads: 250

masijade

Offline

Nearly a Posting Maven

20 Days Ago

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.

Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan