MyEclipse Forums
This thread has been locked & this forum has been archived.
Please post new topics to Java EE Development (EJB, JSP, Struts, XDoclet, etc.)
View previous topic Printable version Log in to check your private messages View next topic
Author Message
P0rridge
Post subject: Running SQL txt files from SQL tool  PostPosted: Nov 25, 2011 - 09:50 AM
Registered Member
Registered Member


Joined: Jun 20, 2010
Posts: 143

How do you run SQL script files from the MyEclispe SQL tool?

I have a number of SQL scripts in text files. I would like to mix and match native SQL in the SQL tool with my batch files.

But commands like "import" and "source", which I found on the mySQL site, are failed by the SQL tool

Thanks
 
 View user's profile Send private message  
Reply with quote Back to top
support-swapna
Post subject:   PostPosted: Nov 25, 2011 - 11:00 AM



Joined: Nov 11, 2010
Posts: 2491

P0rridge ,

You can copy paste the contents of the script file into the MyEclipse MySQL Editor and run them. Alternatively you can copy the script files into the project , right click on the file > Open With > MySQL Editor and execute it.

If you are looking for something else, then please elaborate on what exactly you are looking for.

_________________
Swapna
MyEclipse Support
 
 View user's profile Send private message  
Reply with quote Back to top
P0rridge
Post subject: running external sql files in sequence  PostPosted: Nov 25, 2011 - 11:14 AM
Registered Member
Registered Member


Joined: Jun 20, 2010
Posts: 143

I understand the copy and paste option.

I am generating SQL scripts from elsewhere, say to rebuild the database and to import fixed data from different sources.

I also want to write ad-hoc sql. So within MySql tool I would like to have the following lines

run script to re-build database;
run script to import data;
hand written sql statement/s here;
run script to export data;

Then I want to highlight the ones I want and ctrl F9 to run as usual.
 
 View user's profile Send private message  
Reply with quote Back to top
support-swapna
Post subject:   PostPosted: Nov 28, 2011 - 05:51 AM



Joined: Nov 11, 2010
Posts: 2491

P0rridge ,

1) Can you share your Build ID from Help > About MyEclipse Enterprise Edition > Build ID? Also share your Operating System and version details.

2) What are the errors you are seeing ? Clear the contents of the .log file which is located at <workspace dir>/.metadata/.log , replicate the issue and paste the errors logged here.

3) Also attach a screenshot of the SQL editor to help us get a visual.

_________________
Swapna
MyEclipse Support
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits