Stack Overflow
Stack Overflow

Questions tagged [database-independent]

9 questions
5
votes
3 answers

How to convert from java.util.HashMap to android.content.ContentValues?

Is there a simple way to convert from a java Map to android.content.ContentValues ? android.content.ContentValues is used in android database programming to keep the data of a database-row as name-value-pairs. Background: I try to…
k3b
  • 14,517
  • 7
  • 53
  • 85
4
votes
8 answers

Should I store logging information in main database table?

For example, say I have a table of products. Should I store logging information such as who it was created by, last edited by, last updated date, ... Or should I separate the logging information in say an auditing table if the logging information is…
thisisit
  • 59
  • 1
  • 5
1
vote
2 answers

SQL query for day of week in Java EE - HSQLDB vs Postgres

I've got JavaEE app, the main one is working on docker with PostgreSQL, tests are working with HSQLDB, In a query I want to check day of the week (to exclude weekends from gathered data) In Postgres the following works: extract(dow from date) != 0…
pearinthemountains
  • 115
  • 2
  • 11
1
vote
1 answer

how to call stored procedure from database independent application c# , codefirst

i created procedure for each db types that supported by my application. and added into their migration files. i can call stored procedure MSSQL like this two type in my code first…
Semih YILDIZ
  • 21
  • 7
1
vote
1 answer

NoSQL independent application architecture

How would one create a web application (using Java, C# or JavaScript), which would use NoSQL database as a backend, but with some flexibility to change the backend (for example from couchDB to mongoDB), without rewriting a lot of code. I assume that…
Ben
  • 2,435
  • 6
  • 43
  • 57
1
vote
1 answer

how can I make Spring JDBC queries independent of database?

I'm using Spring Jdbc 3.0.5 RELEASE, and we are using DB2 database as per our client's requirement. We want to run our tests against HSQL DB bcz we dont want to disturb the DB2 primary keys(which are implemented by creating sequences) with our…
Varun Tamiri
  • 11
  • 2
0
votes
1 answer

EF Code First Independent database multiple context

I created a software that is database independent with code first entity framework every models can work on mysq, mssql,oracle etc. program decide automaticaly connection string while starting. mssql and mysql were working well befor i add…
Semih YILDIZ
  • 21
  • 7
0
votes
2 answers

Ways to generate database full structure based on Fluent NHibernate mappings

I'm looking for ways to generate the application database full structure based on the NHibernate mapping data. The idea is to give the user an option to supply a database-connection string and then to build their a database with the structure that…
Fitzchak Yitzchaki
  • 9,095
  • 12
  • 56
  • 96
0
votes
2 answers

Database engine independent analog of SqlBulkCopy

What is the best database engine independent way to load a huge amount of data. While I'm using SQL Server I use SqlBulkCopy but want to untie from SQL Server
abatishchev
  • 98,240
  • 88
  • 296
  • 433