Hey everybody,
I am fetching data from a website via FILE_READ('http://...') in my
SQL statement.
The site returns a "403" HTTP error because a check is made to
restrict access to "real" browser!
Is there a way to get a handle on the connection H2 establishes for
the FILE_READ operation in order to pass appropriate user-agent
information?
URL urlObject = new URL(urlString);
URLConnection conn = urlObject.openConnection();
conn.setRequestProperty ( "User-Agent", "Mozilla/4.0 (compatible; MSIE
6.0; Windows NT 5.0)" );
st = conn.createStatement() ;
st.executeUpdate("INSERT INTO RAWDATA (HTML) VALUES ((SELECT
FILE_READ('http://...);
Thanks for any advice...
Dani
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
