Stack Overflow
Stack Overflow

Questions tagged [data-access-object]

A Data Access Object (DAO), is a design pattern in object-oriented software design, creating an object that provides an abstract interface to some type of database or other persistence mechanism.

A data access object (DAO) is an object that provides an abstract interface to some type of database or persistence mechanism, providing some specific operations without exposing details of the database. It provides a mapping from application calls to the persistence layer.

Source: Wikipedia (retrieved version)

More details: - Core J2EE Patterns - Data Access Object

31 questions
0
votes
2 answers

How do I open an Access recordset using a value from another recordset

This should be obvious, but I am stumped. I am in Access 2007, and I am looping through records. I want to filter the second recordset on the first. The code is as follows: Dim db as Database Dim rst1 as DAO.Recordset, rst2 as DAO.Recordset Set…
jon
  • 92
  • 3
  • 11
0
votes
1 answer

EasyMock and Ibatis

In my DAO layer I am doing all my database work by calling stored procedures. I was wondering has anyone been successful in testing their DAO layer using EasyMock? Thanks Damien
Damien
  • 4,081
  • 12
  • 75
  • 126
0
votes
1 answer

Consume Python DAO from cocoa/objective c front end

My plan is to develop a multi-tier, multi-platform database application. I would like to consume the data from cocoa/objective c apps, .net apps, and web browsers. I don’t really know where to start and have been looking a Python, but can’t find if…
Phillip Andrews
  • 49
  • 9
0
votes
0 answers

Visual Studio 2010 issue with new oracle client installed

On my development computer I uninstalled oracle client 11.2.0.1 and installed 11.2.0.4. I did this without taking into account that my visual studio references the Oracle.DataAccess object with the old version. When I ran one of my projects I…
Jerry Warra
  • 304
  • 1
  • 4
  • 20
0
votes
0 answers

How to Cache some objects during a request in .Net

we're working on a project which developed with ASP.net MVC technology and based on the layered architecture; in addition, we use ADO.Net to fetching data by SQL Store Procedures and generating object models in "DataAccess" Layer (I know this is an…
Azad Soleimani
  • 31
  • 6
0
votes
1 answer

Using DAO classes for data call in Cron Job

Hi this is my Cron Scheduler public class CronListener implements ServletContextListener { Scheduler scheduler = null; @Override public void contextInitialized(ServletContextEvent servletContext) { System.out.println("Context Initialized"); …
user3288833
0
votes
1 answer

errors importing CSV (delimited) into DAO database using vba and SQL from

I am stymied by an SQL mediated import of a CSV file using VBA code. I am using a Third EXCEL macro/spreadsheet, to analyze a LEFT JOIN of 2 files, one as an XLXS and the other as a CSV. I suspect that part of the problem may be how the SQL command…
John
  • 207
  • 3
  • 12
0
votes
1 answer

create and persits BDMs using DAOs in Bonita

How do i make use of the Bonita Provided Data Access Objects (DAOs) variables to create new instance of the Business Data Models (BDMs) Object and persist it.
Boyapati Ravi Kumar
  • 41
  • 4
0
votes
1 answer

@Inject of multiple DAO

I would inject two DAO in the same service class and I did it as follows: @Transactional public class TestData { private final UserDao userDao; private final ExerciseDao exerciseDao; @Inject public TestData(final UserDao…
Selma BA
  • 149
  • 3
  • 18
0
votes
1 answer

What's the most efficient way of enumerating the fields of an Access RecordSource?

The RecordSource for an Access Form or Report can be a table or a query. A table can be local or linked (and might contain calculated fields), and a query can refer to other queries and other tables. Furthermore, a query can use "*" selections,…
ThunderFrame
  • 9,352
  • 2
  • 29
  • 60
0
votes
1 answer

Findfirst matching long integers incorrectly

Objective: Set a recordset using a query string, then perform FindFirst = number to find a specific ID, and therefore record, in the recordset. Problem: The recordset is generated correctly but FindFirst consistently, incorrectly matches IDs below a…
usncahill
  • 469
  • 6
  • 16
0
votes
1 answer

Writing large number of record in Access with DAO on C#

My question follows this one: Writing large number of records (bulk insert) to Access in .NET/C# I've tried the method indicated with DAO. At first, it did not work, getting this error: Retrieving the COM class factory for component with CLSID…
Eradash
  • 402
  • 7
  • 16
0
votes
1 answer

Scala Play Future Interdependancy

I am using play-slick for my scala Play! dummy rest API. So, I have to fetch records from multiple tables. But, they are interdependent, i.e. Table_1 Table_2 id1 id2 id2 To fetch a record from Table_2 I have to fetch a record from Table_1…
mlemboy
  • 387
  • 2
  • 3
  • 15
0
votes
3 answers

Hibernate multi level of transaction

I have some hibernate code and I want my code run in 1 transaction let me explain in code public void changeBranch(Branch branch) throws DatabaseException { //some code humanDao.update(he); superBranchUsername =…
Am1rr3zA
  • 7,115
  • 18
  • 83
  • 125
0
votes
2 answers

Change DAO DBEngine DataTable's column from DataType dbInteger to dbLong in VB6

I've inherited a legacy VB6 app to maintain, and my vb6 is more than a little rusty... I've got a DAO Table that had a field of type DAO.DataTypeEnum.dbInteger that needs to be altered to type DAO.DataTypeEnum.dbLong. Is there a shortcut vb6 way of…
BrianH
  • 1,082
  • 1
  • 16
  • 23
1
2
3