This post has been moved to blogspot. No further posts will be made to this location.
One of my biggest problems so far has been that I always seem to be using the wrong version of things. Nothing seems like it wants to work together nicely and everything is a fight. Grrrr.... but the thing that is driving me the most mad is that as soon as everything is set up correctly, it will work like butter. (Mmmm... butter...) But in the mean time I feel like I make only little progress.
btw, does anyone have a good / easy way to run sql scripts (*.sql) from junit so that it's easy to get the db into a known state? It's easy to do with WSAD by right clicking on it and then doing it that way, but I wanted to know if there was a better way. My hacky work around will be to just read in the whole file as a string and execute that string. Any better ideas?
Sounds like a good workaround to me.
Another thing you can do is if you're on the same machine as the SQL server, run the SQL file. You can use Java's Runtime.exec() method. But watch out! Runtime.exec() is NOT portable.
Posted by: Ryan at March 2, 2004 01:17 PM