I need to figure out how you store a XML file (and its data) down in a
Access database, by the help of SQL.
I have tried looking through the net, but havent been very lucky (only found
a course on how to do it, which was in america somewhere i think).
I work in Java, so would be very happy if someone had some code example from
that or a link. But anything is acceptable really.
Hope to get some response
Regards,
Stefan
2  3840 
"Stefan Garde" <st*********@ho tmail.com> wrote in message news:<3f******* *************** *@dread11.news. tele.dk>... I need to figure out how you store a XML file (and its data) down in a
Access database, by the help of SQL.
Do you need to just store the XML string or convert it into its
constituent parts and store it?
If you need to break it into its parts you should first figure out how
the XML file maps to the database. With any luck you should have some
level of entity/table mapping.
After loading your document into a XML-DOM parser with JAXP
( http://java.sun.com/xml/jaxp/index.html) or Xerces
( http://xml.apache.org/xerces2-j/index.html), you should be able to
recursively traverse your document. Once you are at the leaf nodes you
should be able to begin to enter the data into the database with
simple SQL statements.
I hope that is enough to get you started.
mypetrock
If you know how to write XPath expressions, we have a small shareware tool
that can read XML and store different element and attribute values to a
database. It is a Win32 executable, and can store into Access via ODBC. http://www.intsysr.com/xml2odbc.htm
"Stefan Garde" <st*********@ho tmail.com> wrote in message
news:3f******** *************** @dread11.news.t ele.dk... I need to figure out how you store a XML file (and its data) down in a
Access database, by the help of SQL.
I have tried looking through the net, but havent been very lucky (only
found a course on how to do it, which was in america somewhere i think).
I work in Java, so would be very happy if someone had some code example
from that or a link. But anything is acceptable really.
Hope to get some response
Regards,
Stefan
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: cover |
last post by:
The question is,
we have two options to store images, either in a Database (MySQL,
Postgres, ...) like blob data, or in the hard disk the file and the path in database.
Which option is better? When? Why?
Thanks you for your answers.
|
by: Pat A |
last post by:
We have a dilemma. We are storing our database password in an include
file that resides outside of the web root. The password is in plain
text. So, no one can get that password because it can't be served up
by the web server. So far, so good.
The customer wants all of our passwords encrypted. So, how do I go
about securely encrypting that password? If I use mcrypt, I have to
store a key and an IV somewhere...and if those are in...
|
by: Senthil Kannan |
last post by:
Hi all,
Currently i have a FORM_BASED Authentication of tomcat5.0 to
store and retrieve passwords in my homepage.Now when i try to Store my
password in a encrypted form i am having some problems,i am listing
the problems here.do help me to fix this.
when a new user signup to my homepage his datas are to be stored in
database.while storing this i need to store the password in encrypted
manner,when i insert it manually in comman line it...
|
by: Rudy |
last post by:
Hello all!
I am amazed how many posts I have read to store an image in SQL, and just as
many against it. So I learned how to store an image in a SQL db and retrieve
the image. A little tricky, but not too bad. But then I thought I wanted to
try the other way, by putting the file location in SQL and storing the actual
image in another directory.
I plan to have many images on my web application, up to as many as 5000.
Not to mention the...
|
by: matvdl |
last post by:
I have a system that was originally developed in asp - the pages are saved in
SQL (there are over 10,000 pages) and saved to a temp directory in the server
when requested by a client.
I have updated this system and changed the pages that are saved to the
server as aspx - everything works fine and pages can be served - but
Its not impossible for a single client to request 100 plus pages in one
session - as each page is requested it is...
| | |
by: Imry |
last post by:
I have an application that enables the user to change the color of the form
(pretty simple). I want that color to be saved to a DB when the form is
closed. Then, when the form is opened again, I want it to get that color from
the DB, and have its background with that color.
The problem is that VB.net stores the colors as a COLOR type, and to store
it in a DB I need to have it as string or integer. And after that, I need to
be able to...
|
by: Solution Seeker |
last post by:
I want to Store the String value with Single Quotes in the Field of
Database where if i try to Store the String value with Single Quotes
(as it is) then it is throwing the error as SQL String Truncated.
so we need a solution to store and retrieve user Entered value along
with single quotes into the Database.
i am using the String variable to frame the Qry(that is then passed
to Database for execution) which is as follows
|
by: rxding |
last post by:
Hello,
Performance reason we need to move some of our code into database. Java Store Procedure is given the first choice. However, while investigating some sample code of Java store procedure, PreparedStatement seems to be a must, such as PreparedStatement pstmt = conn.prepareStatement(sql); ..., pstmt.close() in the end.
My question is that if the prepareStatement(sql) is called each time when the Java Store Procedure is called, will...
|
by: Alfred |
last post by:
I want to post text field data from these HTML TEXTAREA tags to a
PostgreSQL database and have it reappear back on another page exactly
as I had typed it. Over the years I have done this but only did it
with simple text. This time around, I want to handle much more complex
text. I need to preserve some kinds of features.
(Yes, I have turned off magic quotes.)
- Need to strip diacritics. I learned I could use htmlentities to
catch...
|
by: eggie5 |
last post by:
I'm looking for the best place to store a general password I use on
my website. Short of hard coding it into one of my aspx.cs files, I'm
trying to find a good place to store it. The only place I can think of
is the web.config file. Can somebody give me some pointers on elegent
ways to do this with asp.net?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
