Hi all, this is probably a non mysql question, but jdbc question.

Im trying to insert files into a row using preparedStatement specifically setBinaryStream method; everything works fine but my problem is that this method requires the length of inputstream. If use a File instance i can read local files and get the size, but i would like to use URL class an openstream method to access remote files and there is no way to convert an inputstream to file; another way is to read all bytes and count them; anyone have done this ??, what is the best solution ??.

thanks a lot.