schema

JPA - EclipseLink - How to change default schema

I'm programming a web application using weblogic and oracle. the datasource is configured through JNDI, with a restricted database user who can DML into tables, but can't DDL. As you may guess, that user isn't the owner of those tables, but he's granted access. Let's say he is GUEST_USER The application is using JPA + EclipseLink, and ...

Is this a common database design / OO Mapping technique?

I've recently been asked to rewrite a booking system that was not performing as well as a client would like. I've found the database schema / object mapping technique used to be quite unusual and was wondering if anyone else has come across anything similar. The old system used about 25 classes for things like customers, appointments ...

Database/Schema design question regarding updates to items_for_sale over time

I understand the obvious answer to my question is: "it depends". With that out of the way, I'm hoping one (or more) of you will help me see common ways to approach this... I'm designing a database of widgets for sale. Over time the prices for each item will inevitably change. My question is should we be tracking these changes and if so,...

Will this Post/Tag DB schema cause problems later?

I'm planning a new service for my ASP.NET MVC app and want to use tags. I've never really been too fond of tags, but SO delivers so I'll give it a shot. Here's the simplified schema I'm thinking about: Post Table ------------------ PK PostId BigInt (or perhaps uniqueidentifier) ...more post related fields... Tags nvarchar(200) Then I...

Catalyst: How do I make DBIx::Class::Schema::Loader::make_schema_at() static preserve case?

I'd like to be able to force the PACKAGE->add_columns() to not lc everything. I know there's a preserve_case option, but I can't figure out where to put it though. is there a 'myproj_schema.pl' file I can create in /conf ? -Joe ...

VS2010 Unable to do a database schema comparison.

I have a VS 2010 solution I've been doing schema comparisons with a DB 2008 project.. It's been working against my local SQL as well as a dev/staging database. i checked out the project on another computer, and now when trying to compare down to the local express db I get the following error. "You cannot write updates to the target whe...

should i implement my key/value system in memory or in MS SQL or 3rd party?

i think i've done enough research to know that i want to go with a NOsql key/value route. i've read up as much as i can and have the following questions still: should i go with something like amazon simpledb, google big table or microsoft azure's solution? (note i'm a .NET site) why not just simply create an in memory hashtable of ke...

Model changes to widgets (price/description) over time in Rails

I recently asked this question and the answer makes alot of sense to me. Now I ponder how those answers hold up in an environment like Rails where there are plugins/gems available like, say, vestal_versions? If I'm selling widgets and the price and/or description of the item will change over time and Rails is my framework. How would you...

database schema for timesheet

Could someone help me with a rough database schema for a timesheet application where the i would be able to Store hours per day for a time period ( 2 weeks ) for different projects. Ex person A can put 3 hours for projectA and 4 hours for projectB on the same day Make it so that its is easy to get a reports on total hours put for a pro...

Possible to set default schema from connection string?

With SQL Server 2005 and 2008 is it possible to set the default schema from the connection string? It'd be a lot easier if we didn't have to manually set the schema with SQL code. ...

Schema generation for maps in Hibernate

Hi there, I have a class Folder and a class File with a one-to-many relationship between them, implemented with a Map. Here is the hibernate mapping file: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3...

Same model being loaded twice though controller specifies 2 different models

Rails 3... I have a controller.. class OrdersController < ApplicationController def index @os_orders = OrlandoOrder.all @ct_orders = ChicagoOrder.all end end And then I have the two models defined... class ChicagoOrder < Order Order::ActiveRecord::Base.table_name_prefix = 'ct_schema.' end class OrlandoOrder < Order ...

View is not schema bound ?

Hi All, I have a select query to retrieve data from tables. It is working fine, but when i give some where condition to select some 3 values, it is not giving me the result. it says, "Query processor ran out of Internal resources". I thought through INDEX, it may work fine, then i created view with that select statement. But i couldn'...

VS2010 Schema Compare bug

I'm using VS2010 Schema Compare to compare two databases - let's call them 'PerfectDB' and 'DodgyDB'. I want DodgyDB to have its schema altered to match PerfectDB. I select PerfectDB as the source and DodgyDB as the target, and compare. When I hit the Write Updates button, I am getting the following error: SQL01268: .Net SqlClient...

Rails schema not updating for a table.

I have a development env and a beta env for the app that i am building. Yesterday i came across a strange error. I wrote a migration to change one of the tables and it worked fine on my dev env. Once i deployed the changes to the beta env it ran and but when i access the page it started giving me trouble. The new columns that i added w...

How to visualize database tables schema in VS

How do I display that schema of tables in my database and foreign keys that links them in VS ? Example of such schema is used in this question mattlant's answer. ...

EtherPad Database Schema?

Does anyone have an EtherPad Database Schema? I googled for it, see tons of requests, but can't seem to find one. I'm interested in taking a look. I'm also curious how EtherPad handler revisions/timeline. Do they create new records for each save in a main pad table? ...

Why doesn't JAXB want to validate

I wrote some Java classes and annotated them with the JAXB annotations. After that I used schemagen to generate an xsd. Then I build an object graph and marshalled it to a xml file. I modified the xml file so that it was not valid anymore. I wanted to use the xsd in the hope the JAXB unmarshalling fails. But it doesn't. Why? JAXB is ...

Doctrine schema changes while keeping data?

We're developing a Doctrine backed website using YAML to define our schema. Our schema changes regularly (including fk relations) so we need to do a lot of: Doctrine::generateModelsFromYaml(APPPATH . 'models/yaml', APPPATH . 'models', array('generateTableClasses' => true)); Doctrine::dropDatabases(); Doctrine::createDatabase...

DataReader, DataColumn - Can These Show Me Columns In Schema Such as SomeSchema.SomeColumn?

I have a database table where columns are in multiple schemas. Example: SomeTable SomeSchema.Column1 SomeSchema.Column2 AnotherSchema.ColumnA AnotherSchema.ColumnB I have code using a DataTable.Rows[r][c].ToString() syntax and it looks like only the Column1 or ColumnA part is being returned. I need to get the full name SomeSchema.Co...