I always wondered about one relevant (for me) but not existent feature of all the relational databases I worked with: the impossibility to namespace tables. in MySQL, for example, you can fully qualify the table with the database name, such as dbname.tablename, with the database acting as a "prefix" or "namespace". However, this feature...
Have a task to make votes for photo. Because users can vote only one time for photo, I should save them. I plan do not to make separate table for saving user ids, but save them in photo table in blob field separating by any delimiter. What do you think about such practice? Are there any hidden troubles? I see with such structure, I will ...
I have a form, not unlike the post question/comment on this site that I want to post to a field in a database. However if someone where to put special characters such as @#;"| either fails or does not insert correctly. Is there a way to insert said data into a database without Perl trying to treat certain characters as operators? ...
I am absolutely new in databases and SQL queries. Q1. What are the common problems one generally face in database queries? Probably extremely large queries, performance issues, timeout and connectivity errors, import export and restoration errors Q2. What approach and tools one should be aware of while debugging a sequel ...
NoSQL are an alternative to RDBMS, that work well with simple data models holding vast volumes of data. MongoDB, Google's BigTable, Dojo's Persevere, Amazon's Dynamo, Facebook's Cassandra are some examples. Could you state your favorite application/IDE that can manage (i.e. insert or query data) such databases? ...
I need to access DB2 database in plain standalone Java project. I cannot use datasource from container right? Do I need to write JDBC connection? ...
Hello :) Using MVC 2 I have been trying to make this record store project. Creating records work but updating them doesn't. No exceptions are thrown either. I examined getchangeset() right before submitchanges() it shows all zeros. Thanks for your reading and you help :) The Edit view: <% using (Html.BeginForm("Edit", "Song")) { %> ...
Hi, I'm doing Major Project on my final year and I'm very new to Android plus I;m not good at codings. I need help with my login page. I've created something like a database connection java file which is this: package one.two; import java.util.List; import android.app.ListActivity; import android.content.Context; import android.datab...
Im working in a WebSphere Application Server 7, JDK 1.6 and Oracle 11g. Im always receiving this error when using an ejb. [7/1/10 17:12:28:770 BOT] 00000013 LocalTranCoor W WLTC0033W: Resource jdbc/oraDS11 rolled back in cleanup of LocalTransactionContainment. [7/1/10 17:12:28:773 BOT] 00000013 LocalTranCoor W WLTC0...
If I asked about most popular free relational database I'd expect to get MySQL or PostgreSQL or perhaps SQLite. But what about native XML databases? Which is most popular and stable? Did you use one in some of your projects? Which one? Which one would you advise for personal medium sized project? ...
Say I want to create a database using the Android SDK's sqlite tool. What would the file extension have to be? I would think .db or .sqlite3 or .sqlite? How would I import it in my source code (Is there a method I should call?) and where in my source code? I was thinking in the onCreate method of a class that implements SqliteOpenHelper....
The following code works on insert but on update modifier is never set, any ideas why? The code for pre-update is being run and correctly sets the state and entity values to the desired value. However when viewing the generated sql nhibernate does not include the field in the update query. /// <summary> Updates auditable objects </summ...
I need to know , can I connect to my Sql Azure database as we connect with our general Sql Server 8/9/10 databases, via Silverlight -WCF or ASP.Net or Winform App. My development environment is WinXP with SP3 / VS 2008 Professional. I am asking so while installing Windows Azure SDK and Toolkit i got Platform incompatibility error that i...
I've got a table which has a column named id which is of type Identity. But this column contains duplicate values 1..8 and then again 1..10 How in the world is this possible? ...
Hi Folks, I am developing an application for android phone, In this I need to use at least 400 audio file which can be played for some respective texts, Now my question is which is the optimized way to do this.. One solution is putting all the audio files in the resource folder and referring from there, this will n...
Hi folks, i would like to trigger an event sometime in the future based on an event that is currently happening. I do not expect the volume to be too high, so i care a lot more about simplicity than performance. For example: event A happens. i need event B to happen a day later (not time critical) system stores a record of event in d...
I'm on the process of designing a web application based on Google App Engine (Java) platform. I'm basically from relational database world and I'm trying to understand how to use the persistence that GAE provides. So my questions is, in RDBMS, I can easily access my data without going through my application. i.e, I can use an SQL clien...
Hi, I was wondering if anybody had any recommendations for some good free resources where I could learn about complex database architecture? All suggestions appreciated. ...
Considering that the maximum size of a data type supported by SQLite is 8 bytes, can I store a Decimal.MinValue, Decimal.MaxValue in a NUMERIC column. I am using the ADO.NET provider for SQLite by phxsoftware. Does the driver internally store the value as a string and do the conversion both ways? I do get a System.OverflowException whi...
I have a .sqlite file with one table in it. i want to access this data. Please tell me, where to copy this .sqlite file (in eclipse project) and how to access the data from this .sqlite file. please suggest some code or liniks.. [i am using Android 2.1, dont know the database version..] Thank you.. ...