What you want to do is quite far out of the ordinary, so I don't think
we're going to build such a feature into H2.
However, you can implement it yourself and expose it to your SQL code
using CREATE ALIAS. See here:
http://www.h2database.com/html/grammar.html#create_alias
e.g.
CREATE ALIAS MATRIX FOR "org.h2.samples.Function.getMatrix"
SELECT * FROM MATRIX(?)
On 2012-02-21 11:48, Dani wrote:
Hey there,
I tried:
- commandline parameters: java "-Dhttp.agent=Mozilla/4.0 (compatible;
MSIE 6.0; Windows NT 5.0)" -jar my.jar
- System.setProperty ("http.agent", "Mozilla/4.0 (compatible;MSIE 6.0;
Windows NT 5.0)");
the only thing that does work for me is:
- not using H2 - FILE_READ but a buffered reader with:
conn.setRequestProperty ( "User-Agent", "Mozilla/4.0 (compatible;
MSIE6.0; Windows NT 5.0)" );
and save the data locally to disc -> then executing a FILE_READ :-(
this does not work (e.g. H2 Console):
DROP TABLE IF EXISTS RAWDATA;
CREATE TABLE RAWDATA (`HTML` CLOB );
INSERT INTO
RAWDATA
(HTML)
VALUES
(SELECT
FILE_READ('http://www.google.de/search?q=H2+database',
NULL));
I do not know if it is only my system!?
But it would be nice to have a FILE_READ / CSV_READ parameter 'User-
Agent' for urls
Thanks again,
Dani
On 13 Feb., 20:05, Thomas Mueller<[email protected]>
wrote:
Hi,
What do you mean:
(start with java -d*http.agent*="myAgent" ....)
commandline? as a param with conn url org:h2 ?
No, command line (terminal, console, shell) or starting a process.
How would I do that on startup with my program?
java -Dhttp.agent="myAgent" -jar yourApplication.jar
Regards,
Thomas
--
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.
