I'm working on a web application that is globalized. The development process is agile style, with several sprints already completed. Our globalization framework is good and localization efforts have been successful so far. However, we continue to run into questions during requirements development, particularly in data storage and vali...
This question are part of a quiz. I've finished already but some questions were answered incorrectly. However, the teacher don't upload the solution for those questions. Would you please help me for the solution of such questions? I need to know exactly the answer in order to start revise for the final exam This question related to DTD...
Since I took the basic undergrad course in databases design and SQL I haven't really touched anything like this. So my question is - how would the database schema for a site like this one would usually look like? What are you generally expected to find? For instance, how are questions and answers stored? Are there some tools which allow ...
Hello, I'm trying to create an element in a schema where its sub-types can appear in any order and as many times as necessary: <xs:element name="workflowNodes"> <xs:complexType> <xs:sequence minOccurs="0" maxPO> <xs:element ref="nodeType1" /> <xs:element ref="nodeType2" /> <xs:element ref="nodeType3" /> <xs:element r...
I am experiencing an issue with WSDL schema validation failing when my web service response contains an MTOM attachment. After searching the web I see I'm not the only one with this problem but have not found any solutions. It seems to fail because the web service response contains an xop:Include element similar to the following, which ...
Hello everyone, I want to do XML validation to validate whether an input XML file conforming to a schema file (.xsd). My question is when do we need to specify the target namespace parameter and what is the function of the target namespace parameter? I got this question from the following MSDN pages, http://msdn.microsoft.com/en-us/li...
SQL Server 2005. Is there a sql query that will return a text field containing the same type of schema info as you would find in doing a right click table -> Script Table As -> Create To (or Alter To) from SQL Server Management Studio ? I'm looking for a single/flat format that describes the entire table, including constraints, indices...
Hello everyone, I am using the following schema to check the following XML file. And I find when there is more than one Information elements inside People elements, the schema check will fail. Why and how to fix it (I want to allow People element to be able to nest more than one Information items)? XML Schema file: <xs:element name=...
Hi there, I've just started using Subsonic 2.2 and so far very impressed - think it'll save me some serious coding time. Before I dive into using it full time though there is something bugging me that I'd like to sort out. In my current database (a SQL2008 db) I have split the tables, views, sps etc. up into separate chunks by schem...
Hello everyone, Suppose I have the following XML schema file and the following XML document file. I have two questions, Since there is no target name space specified in XML Schema file, what namespace will Information element in? In the XML document file, when using Information, which namespace does it belong to? Please notice in this...
I've been looking at this issue for too long. I suspect I'm missing something obvious because I'm overfamiliar with it. I have a schema that suffers from a unique particle violation error. I can see why but I've spent too long fiddling with it to be able to step back and solve the problem. How do I phrase this schema so that it can va...
I've just designed a large database by playing around in MS Access. Now that I'm happy with the design, I need to be able to generate this same database (tables, relationships, etc.) from code. Rather than hand-writing the SQL CREATE statements (which will be long, tedious, and error-prone process), I was wondering whether there was a s...
Hi, I'm using MySQL fulltext indexes in a Rails 2.3.2 App. I added the index via native SQL in my migration. But there is a known issue causing problems with the schema.rb. Rails doesn't understand fulltext indexes and tries to create a normal index. This will cause an error when creating the database from schema.rb (eg testing, specs, ...
I would like to do a query like next: SELECT table_name, column_name, data_type, is_nullable, ... FROM information_schema.columns on a sqlite database. I checked PRAGMA table_info(table_name); but doesn't suit my needs, just check fields for one table. I checked select * from sqlite_master where type = 'table'; But this jus...
Hello, i'm executing PRAGMA table_info over a sqlite db PRAGMA table_info(my_table); And these are the columns retrieved: name type notnull dflt_value pk I noted there is no column width in case of (n)(var)char data types, ¿is there any easy way to get this info? NOTE: I know there is no problem inserting large values in these co...
Hello, I have a local server where I do all my testing and work. Once I am done, I simply upload the db schema along with the relevant code. However the problem arises when I make some changes to the schema. I have to manually type the "alter table" query on my live server. Is there a way to get the incremental changes that took place...
Hello everyone, Suppose I have the following XML document, which has no default namespace defined, and "Information" element is not prefixed with any namespace prefix. My questions are, 1. what is the namespace element "Information" belong to? 2. is there any way to apply XML schema check against "Information" element (for example, I wa...
Hello, Every year our company holds a conference/stand where participants can show their products. We have a web-application which let the participants sign up for the conference. They can enter information such as the name of their company, billing information, and so on. It seems as if the requirements for what information the ...
I have a fairly typical JavaEE application, composed using EJB3, seam components, spring beans and JSF, all packaged into several jar and war files inside an ear file. Naturally for JavaEE, we have many XML files as part of the application. Some of these XML files are validated using DTD (seam) and some using schema. As most files where...
Hi All, I need to mark some elements as non required in the XSD schema that some one else created. How do I go about figuring out which elements are marked as required, is there a particular flag I could search for. Currently all of my elements are marked with minOccurs="0" is this what needs to be changed? Thanks! ...