Recent content by thrybergh

Hi We recently migrated our 7.3.4 database to version 9.2 but we have several Forms 3 apps running which reference ROWID. Because of the different ROWID format from 7 to 8, we had errors with the PL/SQL in the triggers (V2), e.g. WHERE A.ROWID = :BLK003.ROWID I have used calls along the...

Hi I have created a Java web application to allow users to reset their Active Directory passwords. The application connects via SSL on port 636 as recommended and works fine on my development PC. When I deployed the app (using Tomcat) onto the production server it reports an error aying it...

That's exactly what I need. It's worked a treat. Many thanks! :-)

Hi. I have a servlet running and normally I would map it so that when the URL is http://localhost:8080/athensda/servlet/UniSXAP it runs the servlet to process the form posted to it. For convenience, we would like is so that the URL only needs to be: http://localhost:8080/athensda I have...

In the end, I used the "ISO-8859-1" charset instead of UTF-8, setting this in my XML and stylesheets.

Hi I would like to define a role within Tomcat to allow a special user access to stop/start one named application. Is this possible, or is such a "fine tuning" of the access not allowed? I would be concerned that they may stop/remove the wrong application by accident if they were given full...

Thanks for the advice. I think I will ask the users who update the database to restart the application via the Tomcat manager after their changes.

Hi I have a web app which uses an Access 2003 database. It works well enough and I can query it via a form with supplied parameters. However, the actual .mdb file is stored on a file server and I have setup and ODBC data source for my servlet. The .mdb file is edited independently (from the...

Hello I have a problem which I think is related to UTF-8 encoding and my browser (IE6). I am outputting XML data via a Java servlet and transforming it with an XSLT stylesheet using Xalan. Do I need to use a call such as: baos.toString("UTF-8") in my Java code to encode the XML data...

Thank you both very much for your help, it has helped me to solve my problem! :)

Hello. I have 2 tables. One table (called ITAS_USER) contains one column (EMPLID) and this table holds 600+ EMPLID numbers. These are all the people who should be entering data in a survey. The other table (TIME_RECORD) contains the hours they record, with the principal columns being EMPLID...

Thanks for your trouble sedj. I checked the code and it was returning a new RequestHandler for each user, but I had some static variables in an abstract servlet that were being overwritten during the execution of the servlet. I made these non-static and it's OK now.

Thanks sedj. I think in my case it will be OK? : The main servlet is "ShowPredictions" which creates a (currently static) "ShowPredictionsRequestHandler" object that runs the SQL queries and creates XML, calls Xalan and outputs the HTML to the browser. I think I need to...

Thanks for the advice. It sounds like I need to make a new instance of each request handler servlet.

Hello. I have written a web app which requires the users to login with a username and password. I have noticed that if another user is logged in already then a new user will be shown the first user's screen. I think this is because my servlets use STATIC "request handler" objects to...