Hi,
Unquoted column names are converted to uppercase. So you could use:
brs.addColumn("Group_Number", Types.INTEGER, 10, 0);
... SELECT "Group_Number"
or
brs.addColumn("GROUP_NUMBER", Types.INTEGER, 10, 0);
... SELECT Group_Number
or
brs.addColumn("GROUP_NUMBER", Types.INTEGER, 10, 0);
... SELECT GROUP_NUMBER
Regards,
Thomas
On Mon, Jun 15, 2009 at 5:30 PM, bob mcgee<[email protected]> wrote:
>
> Whenever I try to use the columns from a callable stored procedure
> (returns a SimpleResultSet), I get a "Column $COLUMN_NAME not found"
> error (where $ColumnName is a column defined in the stored
> procedure). I *know* that column name is valid for the
> SimpleResultSet, and the query works if I just use a SELECT * instead
> of naming columns. In the H2 web GUI, the displayed column name
> matches the column name I am using.
>
> How can I fix this or find a work-around? I *must* use regexes and
> capturing group to extract my info (scraping from webpages), and I
> don't want to hardcode the analysis of returned groups into my stored
> procedure.
>
> Sample procedure code (gets all capturing groups from a string and a
> regex):
>
> public static ResultSet getRegexMatchedGroups(String source, String
> regex) throws SQLException {
> SimpleResultSet brs = new SimpleResultSet();
> brs.addColumn("Match_Number", Types.INTEGER, 10, 0);
> brs.addColumn("Group_Number", Types.INTEGER, 10, 0);
> brs.addColumn("Captured_Group",Types.VARCHAR, 65536, 0);
> Pattern p = Pattern.compile(regex, Pattern.MULTILINE |
> Pattern.DOTALL);
> Matcher m = p.matcher(source);
> final int groupCount = m.groupCount();
> Integer[] groupNumber = new Integer[groupCount]; //Saves on
> object overhead by re-using objs
> for(int i=0; i<groupCount; i++){
> groupNumber[i]=new Integer(i+1);
> }
> int matchNumber = 0;
> Object[] row = new Object[3];
> while(m.find()){
> row[0]=new Integer(matchNumber);
> for(int i=0; i<groupCount; i++){
> row[1]=groupNumber[i];
> row[2]=m.group(i+1);
> brs.addRow(java.util.Arrays.copyOf(row, 3));
> }
> matchNumber++;
> }
> return brs;
> }
>
> ** SAMPLE SQL (for the above as stored procedure with alias
> regex_groups **
> ** WORKS: **
> FROM regex_groups('<entry><key>Cheese</key><value>Delicious</value></
> entry><entry><key>Blood Sausage</key><value>Disgusting</value></
> entry>', '<key>([^<]*)</key><value>([^<]*)</value>') AS basicmetadata
> SELECT *;
>
> ** DOES NOT WORK **
> FROM regex_groups('<entry><key>Cheese</key><value>Delicious</value></
> entry><entry><key>Blood Sausage</key><value>Disgusting</value></
> entry>', '<key>([^<]*)</key><value>([^<]*)</value>') AS basicmetadata
> SELECT Group_Number;
>
> ** ERROR CODE: **
> "Column GROUP_NUMBER not found; SQL statement:" -- followed by the
> statement above, and error code 42122-114 42S22/42122
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
