Problem solved. Thank you!
On Jun 18, 3:29 pm, Thomas Mueller <[email protected]>
wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
