Re: Using XML to Create schema/database

2009-12-10 Thread Steve Bryant
Tom, Usually the detail portion of the error will include more information - usually the error returned from the database. Make sure that the database exists and has CREATE and ALTER permissions (if you want DataMgr to create tables and columns). If you have any more trouble, you can check

Re: Using XML to Create schema/database

2009-12-09 Thread Steve Bryant
Tom, As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure about DataFaucet): http://www.bryantwebconsulting.com/docs/datamgr/synchronize-database-structure-activeschema.cfm

Re: Using XML to Create schema/database

2009-12-09 Thread Dave Watts
I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. This isn't exactly what you asked for, but the bundled Hibernate

Re: Using XML to Create schema/database

2009-12-09 Thread s. isaac dealey
Ahh cool. I hadn't seen that before. DataFaucet doesn't currently have any seed-data feature in the XML, so you'd have to write your own code for doing that part of it with the current version of DF. As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and

Re: Using XML to Create schema/database

2009-12-09 Thread Tom Jones
Wow, the DataMgr project is very cool. I can use it right away for other parts of my application. thanks, tom Tom, As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure

Re: Using XML to Create schema/database

2009-12-09 Thread Tom Jones
I do have one question on the loadXml function. I'm getting a error that says LoadXML Failed(verify datasource MySQLDS is correct). The DSN is valid, where/ how can I trouble shoot this? Thanks, tom ~| Want to reach the

Using XML to Create schema/database

2009-12-08 Thread Tom Jones
Hello, I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. Thanks, tom

Re: Using XML to Create schema/database

2009-12-08 Thread s. isaac dealey
Hello, I was wondering if there were any libraries or functions which can be used to create database tables on the fly based on XML data and then insert the data. So all I had to worry about was formatting the xml data. I've not done anything for performing the inserts/updates using XML,