Win a copy of Pipeline as Code this week in the Cloud/Virtualization forum!

Will Reilly

Greenhorn
+ Follow
since May 09, 2003
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Will Reilly

Hi Ranchers,
I have to connect to a ms access db from a jsp on tomcat(for free without paying for a driver) and after a bit of reading here is where I am at.
After realising that drivers were not for free I discovered that JSK (JDKs) has a free JDBC DBC brige driver bundled with it. Problem is I cant find it and don't know what to do with it when I do. There seems to be a few tutoirals on how to use the JDBC API but not how to set up this free driver. Can anyone point me in the direction of a good tutorial/instructions.
Any help would be great
Williey
Cheers guys,
thats what exactly what I needed
Williery
17 years ago
Hi Ranchers
Can anyone if Java can do the following with an XML file
1)locate a node/element(nested or not) based on element name or an attribute value
2)edit the contents of an element/node body, ie whats between the opening and closing tags.
3)retreive the contents of an element/node body, ie whats between the opening and closing tags.
4)add a node/element with nested node and put body data into them.

I know XSLT can do all of this but it may not be an option for a few reasons(long story)
Any insights would be great
Cheers inadvance
Williery
17 years ago
Me thinks I should flesh this out a bit, bare with me...
Heres the basic summary of the site
1)User fills form to register his cv, the data is stored in an xml file containing all the data for all candidates on the web server. Specific data is retreived from this file depending on client request and presented to him/her where he/she can edit it and save it (web server writes it out to the appropriate entry in the xml file or creates a new entry in the xml file).
2)my boss clicks opens up a stand alone application on his machine which automatically downloads the xml file, extracts any new data and updates his db on his machine.
So for the second part I have to extract data and update it to a db independent of the webserver.
So I need to:
1)add new entries to an xml file: user enter in form: name: will nationality: irish
entry in xml file
i.e. <candidate> <name>will</name><nationality>irish</nationality></candidte>
2)locate this entry
3) edit it in a form and update same entry in xml file:user enter name: bill
i.e. <name>bill</name> is changed
This can all be done with xsl, which is good for the webserver part but on the standalone machine I need to find the new candidate(ie put in an attribute that says whether it is new or not, no problem). Extract the data bewteen the brackets of the elements for each candidate and put them in the db without using xslt. Can this be done? I was hoping to make a standalone Java application that would do this but looking at the Sun site i can't see if it can be or not.
Any suggestions would be greatly appreciated
Williery
That looks good but the thing is we can't put/install a db on the webserver coz the hosting company will charge a lot more for it. Thats why I was thinking of using a single xml file and just program in the updates using sax. This is my first time doing something like this (usually use a relational db) so have no idea if it is correct.
Any insights are most welcome
Willie
Cheers for that,
Well basically I would have to update these files on line. A user/client fills in a form and this data is stored to the xml file. This data can later be viewed on line by the same client, edited and then be updated to the approriate entry in the xml file. Is this very difficult? Another requirement is that I have to be able to download this data(xml file) to another machine so that new entries can be read and updated to a db. So I was thinking about writing a small application that reads the file and updates the db. So I couldn't use xsl as it is not an internet application. Could I use java to extract this data and update the db appropriately.
Summary
User fills form, data stored in db on the web server, my boss clicks opens up an application on his machine which automatically downloads the file, extracts the data and updates his db on his machine.
Any thoughts would be great
Cheers inadvance
Williery
Hi Ranchers,
I have a project where the server cannot have a db but must have dynamic content so I was thinking about using XML rather than text files but am unsure about a few things. I have used XSL in the past for the presentation of the XML on the web. Is it possible to use Java in JSPs/Servlets to access and present the content in the XML file. If so is it advisable to use Java? Can I use Jsps to update the XML file? Should I?
Any thoughts would be great
Williery (novice)
Hi guys,
its actually for MSAccess XP. Have to connect to it using Tomcat Web Server.
Cheers in advance
Will
Can anyone recommend a driver for Windows 98 and a comprehensive tutorial for working with JDBC. Am a total novice to this
Cheers in advance
Will
Thats pretty much what I did in previous projects that where not in Java, thought that I would look into these build in methods but it looks like i would have to combine the two method which would make things too complicated. Will go for your method
Cheers
Williery
17 years ago
JSP
Hi Ranchers,
have been looking at using the Form Auth method for securing some of my pages and it looks good but I would like to be able store the fact that they have already logged. Then I would be able to check it when they try to access certail pages and grant acces if they already have. Is there something build into the API to do this?
Cheers in advance
Williery
17 years ago
JSP
Had a good look at these and they look great.
Cheers
Williery
17 years ago
Hi Ranchers,
can anyone recommend a good IDE for tomcat that is easy to use, install and is free.
Cheers in advance
Williery
17 years ago
Cheers for that guys, will have to do some more reading on this to familiarise myself with the patterns so as to identify them as the project requirements become clearer.
Cheers again
Williery
17 years ago
Hi ranchers,
have just got my first J2ee job, and realised I gotta apply all this stuff I learned. Problem is I am the only J2EE developer and I ain't got no experience at except certification for WEB components. Anyway have been looking at patterns which have been a great help for consolidating language and application of needs but have got a doubt. If I want to use MVC pattern, can I also add in a DAO layer pattern and an VO pattern or does this go against something I did read. I think it should be possible but the material I have found just shows how to apply them individually and says nothing about applying them to the same application.
Any thoughts would be great
Williery
17 years ago