Thread: JDBC with XML files.

I am not sure if this will help you at all... but this is how I loaded my XML file.

I created this method:

	public static FileInputStream getFis() throws Exception {
 
		FileInputStream fis = null;
 
		// Use file input stream to connect to the properties XML file.
		try {
			fis = new FileInputStream("META-INF/test-config.xml");
			System.out.println("XML file was loaded successfully.");
			// FileInputStream error handling
			} catch (FileNotFoundException e1) {
				System.err.println("FileInputStream failed to " +
						"load XML file. SQLException: " + e1.getMessage());
				e1.printStackTrace();
				}
		DaoFactory.setConfigSource(fis);
 
		System.out.println("Data loaded: " + fis);
 
		return fis;
 
	}

And then in my main method I called it like so:

public static void main(String args[]){
 
		// Call method to load XML file
		try {
			System.out.println("Trying to load the XML file.");
			getFis();
		} catch (Exception e) {
			System.out.println("Failure to successfully load the XML file.");
			e.printStackTrace();
		}
 
		DriverManager.getConnection(fis);
}

Not entirely sure if this is what you meant, and if not I apologize You might not have a DaoFactory class.. but I imagine you could tweak the above code to work for you.

As for the rest of the stuff you mentioned in your post (using SQl statements for your database, etc.. I cannot help but hopefully someone else will come along quickly )

That post lost me entirely.

Why opt for this XML idea when it is an ideal situation to use an Embedded database?
You don't really "load" your XML file in that code segment, but rather connect to it.

Assuming the code format inside the XML file is syntactically correct, then you would need to use a DOM or SAX parser to extract the data in an orderly manner.
But why not use an Embedded DB?