Guillermo, AR System form names standards are not required to be compliant with SQL object name standards.
You likely are trying to search on an DB object that does not exists. I think the ARODBC driver uses the views that exist in the AR System DB and that you need to use the DB names of those views. Maybe a few examples will help you guess what the name should be: _assuming Sybase or MS SQL_ values will be different based on your RDBMS rules. ARS Form name = "This is my form" RDBMS View name = "this_is_my_form" ARS Form name = "User" RDBMS View name = "User_x" ARS Form name = "form/with(special characters)" RDBMS View name = "form_with_special_characters_" Note: I did not test each of these names, but I think my estimations of what the view names would be is fair. There is documentation about how these names are created somewhere in the pdf's. But I do not have an exact page number at the moment. Oh.. and there is a setting in the ODBC client setup that tells the driver to "use underscores". You likely want to use that option. Hope that helps. Merry Christmas to you too. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Dec 23, 2008 at 8:35 PM, Guillermo Alfredo Torres Barron <[email protected]> wrote: > Hi dear listers > We have a next Project, we need obtain information via JSP from our AR > Server by AR System ODBC drivers, anybody have an example that you can > provide me?, when try execute a query to a remedy form appear the next > error > > java.sql.SQLException: The result set type is not supported. > > The query is: select (*) from form1, where "form1" is my remedy form > Thanks in advance > Greeting from Mexico City > > Merry Christmas and happy new year ;) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
