Background: I have an application with athletes, each of these athletes (Athlete model) can be assigned workouts (Workout model, workout_assignment through model). Problem: At first I thought that using a through connection with athletes having many workouts through workout_assignment and workouts having many athletes through workout_as...
Dear Sir, I wrote code to insert textbox data into sql database, my code working properly but when I open the table no data was added, my code given below, help me... Private Sub save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles save.Click Dim connetionString As String Dim connection As SqlConnecti...
I put my database field in "assets" folder. And use the code from this blog to copy the database to "/data/data/my_packname/databases/", (This copy code i run it in the onCreate() method when i run this app) then use select * from ... to get data. But it gives me the exception: no such table. Someone told me that if i am attempting to ...
My database server is using 100% of the processing all of a sudden and it doesn't seem like I have any more traffic on my sites. What can I do to look where the increased traffic is coming from inside of SQL Server Management Studio? ...
If you have a set of tables in the database that strictly consist of a string description and an ID, what is the best way to load these via NHibernate? So suppose I have a Sandwich class, and a sandwich has a meat, a cheese, and a vegetable, where those three things are lookup tables in the DB. It seems to be the most conformant to NHi...
Hi All, is there any tool that would read a something like a hibernate mapping file and would then create some stubs of java code for a java Swing client ? Thanks, ...
We need to perform the following operation in our database : There is a table A which has column B_ID that is a foreign key to the table B. There are many rows in the table A that have the same value of B_ID and we want to fix this by cloning the corresponding rows in B and redirecting the rows from A to them. All this is relatively si...
I have a web based (perl/MySQL) CRM system, and I need a section for HR to add details about disciplinary actions and salary. All this information that we store in the database needs to be encrypted so that we developers can't see it. I was thinking about using AES encryption, but what do I use as the key? If I use the HR Manager's pas...
Hello, I am wondering if wordpress' insert function also adds slashes to data. If it doesn't it would seem that the prepare query method would be better to prevent against SQL injection. I tried looking the issue up in there codex/api; however, it seems undocumented. Thanks! ...
I am developing an ASP.NET-app which uses an SQL2005-DB - and from time to time I need to copy the db from the dev-environment to test or production - or vice-versa. With SQL2000, I had written some batches to do that, but haven't had the time yet to find out how to do that under 2005, and did it manually. In SQL Mgmnt Studio, I would de...
Hello, I wanted to ask whether it is possible to compare the complete database structure of two huge databases. We have two databases, the one is a development database, the other a production database. I've sometimes forgotten to make changes in to the production database, before we released some parts of our code, which results that t...
I'm pretty new to database development in general and I've never used ORM before. I'm interested in the benefits of using one, specifically saving time writing boilerplate SQL queries. I'd like to use ORM for a project that I'm working on right now, but I'm not sure it's applicable. This project is more akin to change tracking for very ...
I'm using JPA but I'm not sure how to use it for relation between two classes. I need to connect them @OneToMany. I have done this before but forgot. Is there any good tutorial for this or an example that is easy to understand. By the way this is a Flex application where I'm using BlazeDS for connection between Java and Flex. ...
We are expanding our hosting capabilities and want to provide MySQL database access in a large shared environment (think cloud services) - our goal is to charge per transaction per user similar to Amazon's EC2 services. What mechanisms are available for this type of DB accounting in MySQL? ...
I m contributing to a project that s been developed for over a year and I jumped into it in lately. There are performance problems with the application. I m aware of several profiling tools, approaches for optimization such as find out the bottlenecks and optimize them. I m comfortable with algorithms, running times of iterations etc....
I am building a C# app which will need to talk to a database - I have written a module which checks whether users are permissioned appropriately and then uses a shared username to run the query This means that permissioning is done in C#. I am now wondering whether this is a good idea and whether permissions should be applied a the dat...
Can mysql handle a dataset of 50gb (only text) efficiently ? If not, what database technologies should I use ? thanks ...
I process a lot of text/data that I exchange between Python, R, and sometimes Matlab. My go-to is the flat text file, but also use SQLite occasionally to store the data and access from each program (not Matlab yet though). I don't use GROUPBY, AVG, etc. in SQL as much as I do these operations in R, so I don't necessarily require the dat...
I want to convert Date & time value into varchar and then store in database I am fetching the Current Date & time using NOW() in mysql and now want to convert it in string because i have to merge this value with String value ...
You can also write hibernate hql or criteria queries. I have Teacher entity and Student entity like this : class Teacher { public Long id ; public Set<Student> students; } class Student { public Long id ; public Teacher teacher ; public Boolean passedSemester1; public Boolean passedSemester2; } You can ...