How can I use hibernate with MS Access?
I want to use hibernate with MS Access. Which dialect should I use and can you give me a sample hibernate configuration file with MS Access? ...
database
Persisting a GWT Visualization API DataTable
What's the correct way to go about persisting a GWT Visualization API DataTable? Should I find a way to serialize the DataTable object or should I write the table cell by cell to a relational database? I'm trying to build a RIA using the GWT-MVP pattern described here http://blog.hivedevelopment.co.uk/2009/08/google-web-toolkit-gwt-mvp...
How can I make my mysql database records visible to search engines?
I am creating a classifieds website called 'mySite', and I want whoever searches for honda +mySite in google, to find all ads with the description 'honda' or headline 'honda' from my database. How is this done? (a htm page for every ad? which then loads the 'ad data' when user clicks to open the htm page?) I have an example for yo...
can a berkeley database be opened and accessed from multiple programs at the same time?
Hi, according to the Berkeley documentation the Transactional (TS) and the Concurrent Datastore version of the Database, multiple threads may access (and change) the database. Does this also mean that I can have 2 programs linked to the berkely 'client' and have them access the same database file without any problems? (I ask, since f...
Working with multiple databases in php/mysql
I am working on a project needing me to work with multiple database connections. From what I have read, I should be able to switch between connections in the query itself, something like: mysql_query("SELECT * FROM user_types", $db_core)or die(mysql_error()); But I receive the error: Table 'db_company.user_types' doesn't exist So I...
Save Image to application Path
I am using access database as backend and vb.net with DevExpress as Frontend and i want to save image at Application path and retrive it.so for this can u giv me some idea... ...
Looking for a good HBase tutorial
I'm looking for a good and tested HBase tutorial, where I can find one? ...
phpMyAdmin for SQLite 3
Is there a good PHP client for SQLite 3 databases? I'm looking for something like phpMyAdmin of SQLBuddy that allows me to manage SQLite 3 databases, preferably one that uses the PDO (pdo_sqlite) driver. ...
What's the best way to create a 'history' type model in django?
I'd like to create a feature for my Django app similar to Django admin's 'Recent Actions', in order to store history information on my other models. For example say I have two models called Book and Author. I want to have a third model that stores information such as what action was performed on a given object in a model (add, modify, d...
What is the easiest way to import some CSV files with relation to a DB?
I have multiple CSVs. they are all export from a relation DB. Now each CSV contains thousands of entries, and references to other tables represented by other CSVs file. how can i import those file in a new Database ? Shoul i create a fresh model ? Thanks John ...
How to handle "order" of a list of items in DB (php)
I would like my client to be able to order items in the backend. I figured the easiest way to do it is to have the database table for an item have a field called "order" which gets a value. This is a value the client puts in. Then I can just run SQL queries ordering by the "order" field. Right now I have it very simple.. there is no ...
How do I build a domain-specific query language?
I have a biology database that I would like to query. There is also a given terminology bank I have access to that has formalizable predicates. I would like to build a query language for this DB using the predicates mentioned. How would you go about it? My solution is the following: formalize the predicates translate into a query lang...
setting default datacolumn values, good practice?
Is is good pratice to have the db set the default value of some columns when a new row is created or should the application set all values? Im not sure of the reasons for or against, but in non-null columns, it makes life easier. ...
how to design this mysql database
there are 2 million users each user has 4 tables . the data in 4 tables is not going to be appended and will remain fix. the structure of each users tables will be same. To store the data of these users in mysql i have to design a database. do i need to create 2 million databases each with 4 tables ? any help appreciated the 4 tab...
how to dynamically specify data type while creating the table in MS access using Java
My application is extracting the data from excel sheet. I am storing the value and type of the data from the sheet into the ArrayList. ie., If my excel sheet consists of employee data, i will retrive [ Employee name, String] [ Employee id, number] and so on.. So i have to create a table with these names and with their respective data typ...
Graph Database in Java (other than Neo4J)
Greetings, Is there any open source graph database available other than Neo4J?? NOTE: Why not Neo4J? Neo4J is opensource, but counts primitives (number of nodes,relationships & properties). If you are using it for commercial use. And does not have any straight forward information of pricing on official website. so there can be potenti...
How do i merge two or more rows based on their foreign key?
I have three tables which are: A(a1, a2, a3) //This tbl (Table) can have multiple instances of a1, but cause of its dependence on b1, //we have a unique record each time B(b1, a1, b2) //tbl C has a relationship with tbl B through b1. b1 can also have multiple instances, but //sometimes a number of unique records in this table can ti...
Local and remote data synchronisation.
Hello there, We have a local server with an access database which feeds data to clients in the same domain. Now we also have a website which is hosted externally, and working on a bridge system to provided upload/downloaded functionality of products, categories and orders etc. Products, categories and customers etc. can only be added l...
SQL Syntax: Create a single table with column names created from data stored over multiple tables
I have created the SQL script below that creates four tables and inserts data into the tables to demonstrate my question (I hope this helps!). This problem arose because originally this data was stored in a single table of 400 columns and it got very unmanageable so I wanted to find a better way to store the parameters: use master G...
Reload column names in ActiveRecord model class
I have a script using ActiveRecord that creates column names dynamically based on values read from a CSV file, something like this: FasterCSV.foreach('votes.csv', :headers => true) do |row| column_name = "roll_call_id_#{row['roll_call_id']}" if !Legislator.columns.map(&:name).include?(column_name) connection_pool.connection.add...