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...

Thanks for your help Mufasa!!

Hi Mufasa, Thanks for your feedback. Does this mean you suggest that the database entirely should handle possible exceptional behaviours instead of going down the route of writing test select queries prior to inserts in order to find out if I'm trying to insert duplicate values. I'm tempted to...

Hi Thargtheslayer, Yeah you are probably quite right for the example I mentioned in the previous post. I'm also curious to know principles/ best practices applied by others in large-scale development projects and on larger data sets than I described. In the small scale projects I have taken...

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...

Thanks for your tips It took me a little while to understand the logic but now it's working perfectly well. Thanks Erik

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...

Thanks Carp, I also found this example that does what I'm looking for. DECLARE i NUMBER; BEGIN select count(*) into i from emptable where employee_id =206; if i < 1 THEN -- throw user defined exception END IF; END;

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, Thanks for your replies. After a few attempt installing Oracle on Win Home edition I realized that it's not supported. I've also been looking at the BETA version of Oracle 10g Express Edition. Still haven't had any luck with this version. According to Oracle the 10G Express edition is...

Hi Sedj, How would I proceed if I return a query given some data from one table and data from another table (where Im using join to two or more tables)? Do I need to build a seperate Object with corresponding attributes that the query output? I guess in the end there must be ALOT of various...

Hi again and thanks for your replies. I'll try to clarify my previous posting a little bit. Using the Recordsets to get the data from the database I guess is OK and the best way of doing it. I'm more concerned in HOW to pass this data around within the application (Java beans, servlets etc). If...

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