Java run mysql script file

Add a comment. Active Oldest Votes. Community Bot 1 1 1 silver badge. Pracede Pracede 4, 14 14 gold badges 60 60 silver badges bronze badges. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Through JDBC, no. But you can run it as an Oracle command line through Runtime. Harsha Muthy. Theo Arril - Awesome code. I tried this and it works for me. Thanks a ton, you really saved me. Tom Enders. Your parser does not work on a file that contains transactions. I found this when I tried to run it on a file to create a database which contained triggers.

So, I rewrote the parser. Here is the code, the comments should be enough to explain it. So use this just replace the split line in Theo's solution with the following code. Thanks for the great solution first! I tried using it, but the problem is that my. And so I am setting the values for each table's primary keys however it gives an error. Could you please suggest something here? Wendy L Gibbons. Welcome to the ranch Neo I suspect this means your script is wrong, do you understand the error you are getting?

Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options.

Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Tags: Java. Hi, I have had a lot of work to do to set up some tables for a certain application that we are currently developing.

Been wondering on the following issues 1. TFuda Posted April 13, 0 Comments. Tom F. Mani Kandan Posted April 11, 0 Comments. Java Program used for. Mysql Database. First think. Anonymous Posted April 11, 0 Comments.