I have two users Bob and Alice in Oracle, both created by running the following commands as sysdba from sqlplus: create user $blah identified by $password; grant resource, connect, create view to $blah; I want Bob to have complete access to Alice's schema (that is, all tables), but I'm not sure what grant to run, and whether to...
I have an XML Schema which I am parsing in JavaScript and then packing that as an object to pass to one of my backend servers. The schema is like <complexType name='Test'> <sequence> <element name='testField' type='string'/> <element name='typeSpecificSetting' type='tns:TypeSpecific'/> </sequence> </complexT...
I have a flat-file schema that has a header and detail records. It looks something like this: HDR**2401*XX0062484*22750***20081006000000*000******* LIN**001*788-0538-001*4891-788538010*20000*EA**0000*** I need to append two blank lines at the end of the message. Right now, if I have multiple records I get the following output: HDR*...
As part of our build process we run a database update script as we deploy code to 4 different environments (due to crazy business rules, but that's another post). Further, since the same query will get added to until we drop a release into production (yet a few more domains to add to... frustrating); it HAS to be able to run multiple ti...
Hi all, I am just learning about app.config in respect of creating custom sections. I have that part working, it compiles and gets the information out as required but I get warnings about it could not find the schema information. I have done a bit of googling and could not find a simple explanation of this situation. The approach (th...
How can I convert a DTD to a Schema as part of a Maven build? Specifically, I am looking for a Maven plugin to which I can give the URL to a DTD and it will generate an XML Schema Definition file. Failing a good Maven plugin, perhaps I can embed an ANT task into my Maven build ...
Does anyone know of any specific DSL implementations used to import legacy Oracle database schemas. I have tried to just run db:schema:dump on my existing db I want to port to a new ruby app. However, the rake dies about halfway through with out any error. It kinda just locks up. I started looking for the best way to tackle this and foun...
Which XML validation tools can you recommend for both performance and accuracy, each of which is a critical issue on our system? We have the following requirements: It is not not xmllint (see below) Supports RelaxNG Can easily integrate with Perl (this is optional, but it would be nice) Why not xmllint? (This is background and you ...
I've been trying to design a database schema for a side project but I havent been able to produce anything that I'm comfortable with. I'm using ASP.Net with LINQ for my data access: I'm going to allow users to specify up to 10 "items" each with 2 numeric properties, and 1 referential property, the item name. If I were to put this entry...
I am having trouble defining the content-type of an element ("phonenumber") whilst at the same time defining a property ("location") with enumeration restrictions. Here's where I'm stuck: <xs:element name="phonenumbers"> <xs:complexType> <xs:sequence maxOccurs="unbounded"> <xs:element name="phonenumber"> ...
I've been spoiled by ActiveRecords. So I'm on the lookout for migration system that can be applied to SQL Server, and either is executed as Java application, or a Win32 Executable. (Of course further compatibility with other DB's and host OS's is welcome.) The real desire is having a clear schema change application with roll back, ide...
When I use wsdl.exe to create a client from my wsdl, it finishes O.K., but inserts the following comment in the file: // CODEGEN: Parameter 'VerificationData' requires additional schema information that cannot be captured using the parameter mode. The specific attribute is 'System.Xml.Serialization.XmlArrayItemAttribute'. I can't figu...
I have an XML schema that represents a product in a DB, and I am trying to figure out the best way to store the product image references as XML nodes. There will be a primary image, and then alternate images, each of them with sequences (display order). Would this be an appropriate format, or are there better approaches: <item> <id>...
Hello, I have a bit of a problem. I wrote an API a long time ago for our production system, and it used Apache XML Beans. The schema was homogeneous (ie no imports, everything was from within the same schema), and everything worked just fine, even if the code for API handling was incredibly verbose. I've since written a far simpler a...
Hi all, is there a way to change an oracle user's default schema? I found it in the FAQ that I can alter it in the session, but it's not what I want. E.G. the user at log on always sees another schema as default. Thanks in advance. ...
Given the following, how could I insert rows in my db? (Or what should I correct in my schema?) Models: class Item < ActiveRecord::Base has_many :tran_items has_many :transactions, :through => :tran_items end class TranItem < ActiveRecord::Base belongs_to :item belongs_to :transaction end clas...
Hello, I am doing analysis on schema evolution and have really fallen short of real world database schemas that have evolved a bit and stored in version control. Mediawiki (http://svn.wikimedia.org/svnroot/mediawiki/trunk/phase3/maintenance/tables.sql) seems to be a very good candidate so far. I've considered Bugzilla, but they don't se...
This is probably a n00blike (or worse) question. But I've always viewed a schema as a table definition in a database. This is wrong or not entirely correct. I don't remember much from my database courses. ...
I'm working with some schema which defines an abstract complex type, eg. <xs:complexType name="MyComplexType" abstract="true"> This type is then referenced by another complex type in the schema: <xs:complexType name="AnotherType"> <xs:sequence> <xs:element name="Data" type="MyComplexType" maxOccurs="unbounded"/> </xs:sequence...
Is it a best practice to validate JSON? With both a JSON schema proposal and a JavaScript implementation of a JSON Schema validator, this practice would seem relatively frictionless to implement. So, is it a no-brainer that should be part of any robust application? Or do you employ other preferred strategies to handle bad JSON? ...