tag:blogger.com,1999:blog-5215551487816981140.post3458970037469007812..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Thoth Gateway: mod_plsql replacement for Microsoft IISMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5215551487816981140.post-87533774690802844602012-06-19T09:59:02.479-07:002012-06-19T09:59:02.479-07:00@Prabahar: Set the Log4Net log level to "DEBU...@Prabahar: Set the Log4Net log level to "DEBUG" and inspect the log file, and/or set the "ErrorStyle" DAD parameter to "DebugStyle" and see what happens.<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-55655307371920030902012-06-18T06:19:29.112-07:002012-06-18T06:19:29.112-07:00Hi Morton
I am trying to configure Thoth Gateway ...Hi Morton<br /> I am trying to configure Thoth Gateway in windows 2003 II2 6... I am having problem connecting to APEX screen..It seems gateway is generating the session but getting error in IE 8 (Page can't be found)..<br />URL generated (http://golfrorat1/ThothGateway/apex/f?p=4550:1:87578369594101)<br /><br />Would you plz able to throgh some ideas how to proceed further<br /><br />Thanks<br />PrabaharPrabaharhttps://www.blogger.com/profile/16124656852154184013noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-78618856243256016452009-08-21T08:10:27.839-07:002009-08-21T08:10:27.839-07:00@Patrick: Yes, in ASP.NET terms the (full) "S...@Patrick: Yes, in ASP.NET terms the (full) "ServerVariables" collection is passed to the OWA toolkit, which means that owa_util.get_cgi_env can return the value of various headers such as HTTP_ACCEPT, HTTP_ACCEPT_CHARSET, HTTP_ACCEPT_ENCODING, HTTP_REFERER, HTTP_USER_AGENT, etc.Morten Bratenhttps://www.blogger.com/profile/16506692325808919895noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-49315725745213822982009-08-21T06:54:10.944-07:002009-08-21T06:54:10.944-07:00Hi Morten,
really cool!
Just a quick question. D...Hi Morten,<br /><br />really cool!<br /><br />Just a quick question. Does your gateway also map some of the CGI environment variables? For example if-modified-since to <br />HTTP_IF_MODIFIED_SINCE and all the other HTTP_*. That's done by mod_plsql and we use the mapped ones in the APEX engine/OWA toolkit.<br /><br />Regards<br />PatrickPatrick Wolfhttps://www.blogger.com/profile/16652802762749621200noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-31121925209024823912009-08-18T23:01:28.970-07:002009-08-18T23:01:28.970-07:00@Todd: I believe DBMS_EPG is the slowest of the fo...@Todd: I believe DBMS_EPG is the slowest of the four, since it must serve images and other static files from the database rather than from the filesystem, thus resulting in more work for the database.<br /><br />The Thoth Gateway implements many of the same performance-improving techniques as mod_plsql, including procedure metadata caching, configurable fetch buffer size and bind bucket lengths/widths, and connection pooling (via ODP.NET).<br /><br />I might run some tests with JMeter to get some statistics for the different alternatives.Morten Bratenhttps://www.blogger.com/profile/16506692325808919895noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-66046134133211914742009-08-18T16:36:33.057-07:002009-08-18T16:36:33.057-07:00There is also an Open Source replacement for mod_p...There is also an Open Source replacement for mod_plsql for Apache called modowa.<br />http://www.sharemation.com/~dmcmahon/modowa.htm<br /><br />Doesn't run Apex though.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-52374768327520189492009-08-18T12:17:59.214-07:002009-08-18T12:17:59.214-07:00Hi Morton,
Do you have any thoughts on which conf...Hi Morton,<br /><br />Do you have any thoughts on which configuration of the 4 listed has the best performance? <br /><br />ToddAravehttps://www.blogger.com/profile/10050725129064532069noreply@blogger.com