Hi,
When trying to define an example table function given in the docs inline
CREATE ALIAS IP_ADDRESS AS $$
import org.h2.tools.SimpleResultSet;
@CODE
ResultSet simpleResultSet() throws SQLException {
SimpleResultSet rs = new SimpleResultSet();
rs.addColumn("ID", Types.INTEGER, 10, 0);
rs.addColumn("NAME", Types.VARCHAR, 255, 0);
rs.addRow(0, "Hello");
rs.addRow(1, "World");
return rs;
}
$$;
I get an error
Syntax error in SQL statement "/org/h2/dynamic/IP_ADDRESS.java:3:
package org.h2.tools does not exist
import org.h2.tools.SimpleResultSet;
<http://localhost:8082/query.do?jsessionid=9861cb6b1bf47c7fb3bd2b2bb241d398#>
Why can't h2 find the tools package?
- rami
--
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.
