Search results for query: *

Hi, I've playing around with JAAS and Tomcat 5.5 for a little while and got a simple login mechanism working using Tomcat JAASRealm and my own implementation of LoginModule together with protected resources specified in web.xml. I'm now trying a slightly different approach where I have created...

Hi, I need suggestions in how to deal with the following scenario. Currently I've got a user registration form (html) with the following fields:username, firstname, lastname and email address. Usernames and email addresses are unique within the system and my database tables are checking for...

Hi all I am running a server (windows 2000 Oracle 8.1.7) but is now testing on Oracle 9.2 here in the UK where I have installed UTF8 as characterset (also as national charset). The registry settings are ENGLISH_UNITED KINGDOM.WE8MSWIN1252 which correspond to the servers locale. However the...

Hi all I am running a server (windows 2000 Oracle 8.1.7) here in the UK where I have installed UTF8 as characterset (also as national charset). The registry settings are ENGLISH_UNITED KINGDOM.WE8MSWIN1252 which correspond to the servers locale. However the database itself using American...

Hi all, I've got a dynamic HTML form driven by a database with a group of checkboxes. I haven't got any problems taking the values from the checkboxes and inserting them in the database or populating the checkboxes with corresponding values from the database. My problem is that if a user...

Hi all, I want to use a user defined exception if my SELECT INTO statement return no data found. I'm not how to achieve this since Oracle automatically seems to throw a NO_DATA exception. Thanks E

Hi all, I'm currently looking at technical solutions for a system that will present a number of training-courses to various employees. The courses itself are currently written in standard HTML and are independent of each other. When a user login they will be given a set of courses they signed...

Hi all, I'm looking at buying a cheap computer P3, 256MB and a couple of Gig HD to use as a development machine (private use) for my Oracle 9i database(maybe 10G), Win XP pro, Eclipse, Tomcat etc. There won't be a huge amount of data stored on this machine maybe a couple of thousands of...

Hi all, I'm wondering what is best practice for dealing with data retrieved via JDBC as Recordsets without involving third part products such as Hibernate etc. I've been told to NOT use RecordSets throughout in my applications since they are taking up resources and are expensive. I'm wondering...

Hi all, I'm having the following problem when I'm trying to access an array from a bean using JSTL. Can anyone explain for me why this doesn't work. The error Tomcat(5) using JSTL1.0 output is Unable to find a value for "myList" in object of class "PhoneList" using operator "." (null) These...

Hi, I'm trying to learn how to deploy webapps for Tomcat using ANT. I've been unable to find simple example scripts in how to deploy jsp, servlets etc for Tomcat.. Anyone having any links or could provide me with a simple example. Many thanks Erik

Hi all Does anyone know if I can install Oracle 9i on a Windows Home Edition machine. I actually gave it a try yesterday but the machine hang after 10min. Thanks

Hi all, I've been recently looking at using ANT to deploy my webapps. I haven't been able to find any good examples or readings covering the basics of it. Could anyone provide me with a very simple and basic example of how to build and deploy a simple web app for Tomcat? Many thanks Erik

Hi I'm quite new to Oracle development and especially in how to master scripting and SQL *Plus. To be able to better understand the PROMPT, ACCEPT, VARIABLE, DEFINE commands etc. I have setup the following scenario. I want to create a script that enables the user to choose an option from a...

Hi, I'm building a simple form in HTML for users to use to query the database (ora 9i).The initial version of the HTML form has got 4 input fields. City (default value is all cities) Category (such as OLD or NEW vehicles. Default value is BOTH) minimum_price (default value is no preference)...

Hi all, I've been told that inserting data into a table using a cursor (see example below) is very inefficient and will take long time to process. I think this is the example that was given. If this is true, why? and what is a better way of doing it? Thanks E Example DECLARE CURSOR testCur...

Hi all, I'm preparing for the 1Z0-147 exam and have encountered the following question. Which three are true statements about dependent objects? (Choose three) A. Invalid objects cannot be described. B. An object with status of invalid cannot be a referenced object. C. The Oracle server...

Hi all, I'm preparing for the 1Z0-147 exam and have encountered the following question. Which three are true statements about dependent objects? (Choose three) A. Invalid objects cannot be described. B. An object with status of invalid cannot be a referenced object. C. The Oracle server...

Hi all, I'm preparing for the Introduction to SQL exam and I came accross the following question. Which two statements complete a transaction? (Choose two.) A. DELETE employees; B. DESCRIBE employees; C. ROLLBACK TO SAVEPOINT C; D. GRANT SELECT ON employees TO SCOTT; E. ALTER TABLE...

I'm writing an application where I want to track and display active users (users that are logged in). My though is to be able to do this by using the HttpSessionListener or any other of the Listener interfaces (if needed) from the servlet API. I've written a piece of code that counts number...