Also view names cannot be more than 30 characters in length and if that means that you get two forms that might generate a duplicate view, the second form will get post fixed with its schemaid.
Also recently I got to know through one of the members on the list on a similar thread that if there is a database keyword in the form name, that keyword is replaced with X. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Carey Matthew Black Sent: Wednesday, December 24, 2008 8:25 AM To: [email protected] Subject: Re: JSP and ARS 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 ;) No virus found in this outgoing message. Checked by AVG. Version: 7.5.552 / Virus Database: 270.10.0/1862 - Release Date: 12/23/2008 12:08 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
