Hi, I´m busy converting an existing project from an Ant build to one using Maven. Part of this build includes using the hibernate hbm2java tool to convert a collection of .hbm.xml files into Java. Here's a snippet of the Ant script used to do this: <target name="dbcodegen" depends="cleangen" description="Generate Java source from ...
Im on to design my Data Access for a new solution i create. That solution though contains Compact Framework Device Application and libraries besides Desktop. All .NET 3.5. Desktop will handle all Data Access basically. I need the Data Objects to have in CF too, Desktop will communicate with SQL and then with Mobile and give the appropria...
Hello, what is the best practice to handle multiple EARs and the same transaction, as far as we know we need to apply XA concepts in order transaction works correctly. but apparently in currents project that we've been working on, this is not strictly necessary for creates and updates; however if we try to retrieve any collection from an...
I don't really have groked how to translate GROUP BY and HAVING to Django's QuerySet.annotate and QuerySet.aggregate. I'm trying to translate this SQL query into ORM speak SELECT EXTRACT(year FROM pub_date) as year, EXTRACT(month from pub_date) as month, COUNT(*) as article_count FROM articles_article GROUP BY year,month; which output...
Hello Stack Overflow! I have a problem in one of my projects, where I'm using Doctrine as an ORM. For some reason, when rebuilding the models and database structure, Doctrine ignores the behaviors and relations, I define in one of the table definitions. The YAML table definition looks like this: ... User: actAs: Timestampable...
I am writing a project where I need to implement a stripped down version of an ORM solution in C++. I am struck in implementing 1-n relationships for the same. For instance, if the following are the classes: class A { ... } class B { ... std::list<A> _a_list; ... } I have provided load/save methods for loading/saving...
We generate a lot of SQL procedurally and SQL Server is killing us. Because of some issues documented elsewhere we basically do SELECT TOP 2 ** 32 instead of TOP 100 PERCENT. Note: we must use the subqueries. Here's our query: SELECT * FROM ( SELECT [me].*, ROW_NUMBER() OVER( ORDER BY (SELECT(1)) ) AS rno__row__index FROM ( ...
What Python frameworks/libraries you would use to create a data centric REST application. The application will have the following traits: read-biased in terms of number of individual ad-hoc requests write-biased in number of records added in batch feeds scalable (think virtual appliance, cloud) variety of data formats such as csv files...
I'm writing a homework for my RDBMS class, I need to perform CRUD operations on quite simple domain, which is cyber sport championship. Students are required to use ADO.NET. My question is how can I solve bidirectional relationship, for example 1:m (every championship has many matches, but every match belongs to only one exact championsh...
I'm trying to update a record using the ORM library built in to Kohana 2.3.4. I'm basically modifying the script I use to insert the record in the first place. My problem is the record is getting inserted again, not updated. Here's my script: public function edit($id) { // Find the selected blog entry $blog = ORM::factory('...
Hi there I am using the ORM features in CF9 and am just a bit stuck on how to replicate a left outer join query.. I have a TaskList CFC component output="false" persistent="true"{ property name="iTaskListID" fieldtype="id" generator="native"; property name="sTitle" ormtype="string" length="50"; property name="task" fieldtype="one-to-...
I am having trouble understanding ORM in Ruby on Rails. From what I understand there is a 1:1 relationship between tables/columns and objects/attributes. So every record is an object. Also what exactly is a Model? I know it maps to a table. What I'm really after is a deeper understanding of the above. Thank you in advance for your help ...
I am toying with RDF, and in particular how to access information stored in a rdf storage. The huge difference from a traditional relational database is the lack of a predefined schema: in a relational database, you know that table has those columns, and you can technically map each row to an instance of a class. The class has well defin...
Hi! Recently I was busy implementing paging functionality with NHibernate and things went smoothly with simple entities, but I hit a performance problem with those ones where multiple joins are required to acquire the requested page. Besides that, implementation would be much simpler if the queries could be performed by convention witho...
According to this question, the most popular ORM tool for .Net is NHibernate. However, zero explanations are given. What are the compelling advantages of NHibernate over the other frameworks? ...
(See this related question for LINQ-to-SQL) I'd like to map a class that has a URI member to a string column using NHibernate. How exactly might I accomplish that? I don't think the solution given to the related question works here - I can't declare a private field and map it, because the mapping needs to reference that field. ...
I am trying to figure out how to setup a revisions system for posts and other content. I figured that would mean it would need to work with a basic belongs_to/has_one/has_many/has_many_though ORM (any good ORM should support this). I was thinking a that I could have some tables like (with matching models) [[POST]] (has_many (text) thro...
Hi, Can anyone recommend an Sqlite C# ORM code generation tool. I have found the Habanero framework, any comments on that? Thanks UPDATE I have gone with Subsonic in this instance. To help anyone else out, here is a 'basic' example of creating a class and using Subsonic and Sqlite together. using System; using System.Collections.Ge...
After I've filled with data the query object, should there be an object that executes the query (filled query object as method parameter) or should the object execute the query by itself ? ...
I started my app very simply following the documentation videos for Codeigniter. I have the following tables: Account account_id name details Contact contact_id account_id name address Order order_id account_id contact_id date description Item item_id order_id description ...