I'm still trying to learn SQL as of this writing, so I'm a bit shakey at the moment. My situation is like this: I have a table called 'Tasks' with an auto-incrementing primary key ID and a text field (and a few others that aren't relevant to this problem, too). I have another table called 'Locations' with a foreign key referring to a ...
I have an application using Fluent NHibernate on the server side to configure the database. Fluent uses Lazyloading as default, but I explicitly disabled this as this gave me problems when sending the objects to the client side. Obviously the client can't load the objects lazily as it doesn't have access to the database. Now I try reen...
I'm using transactions for managing data across several MySQL InnoDB tables in a reasonably complex web application. Briefly, a given transaction works as follows: Data is read from a row in a "user_point_totals" table Various machinations calculate what the user's new point total should be A new entry is created in the "user_point_to...
Hi, We have a system that tracks the allocation of a unit of work, from receiving that unit of work till completing that unit of work. A unit of work has a number of attributes, it's source, it's type etc. These I'm fairly ok with modelling, likely to be either dimensions of the fact or just attributes depending on the nature of them a...
i have a class that extends the PDO class. it's called Database. but in a particular function, the commit() function, it gets an memory overflow error. Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 261900 bytes) in C:\wamp\www\igadgets\application\includes\base\classes\database.php on line 130 the fu...
Hey! Can anyone please tell me the disadvantages of storing images in a MySQL database? Is it not as efficient as storing the images on the server? Like, will it take longer for the images to load and perhaps slow download the database? Appreciate the help! ...
Hi Guys, I'm still new to SQL (Oracle).. Basically on a table I'm selecting from, there is a time stamp, and some are valid stamps and some are not (stored on a time stamp table).. I have a function I can use in 'where' clauses to return only the valid or invalid ones. But sometimes I need to see all the records with an additional colu...
I am coming back to Java from Ruby and ActiveRecord and want to use something as easy as ActiveRecord in Ruby. What options do I have? ...
Possible Duplicate: Embedded java databases I want to embed a java relational database in my web application which I can just use by dropping a JAR file in the libs directory. What choices do I have? ...
I have heard that when developing application which uses a database you should do database unit testing. What are the best practices in database unit testing? What are the primary concerns when doing db unit testing and how to do it "right"? ...
I am recently back in Javaland from Ruby and Activerecord and was wondering if there were any database solutions that do not require me to set up XML files to use them, and if possible supply any configuration in pure Java? ...
I have the following db-schema . FILE, GROUP and BLOCK represent the object structure of the XML file. FILE is the root. GROUP has FK to FILE. BLOCK has the one FK to GROUP and the another one FK to UNIT. UNIT groups "similar" BLOCKs from diffrent GROUPs in the context of FILE. The data base is currently in 3NF. Yet I would like ...
Hi all, Environment: 11g db server The "SQLNET.ENCRYPTION_SERVER" value is not taking from the configuration file it is taking the default value "ACCEPTED" instaead of "REQUIRED". After the changes done through net manager I have restarted the listener. Please advise where I need to make the changes. Trace file: 2010-09-22 19:11:13...
I am coming from the ruby world and want to be able to use Java to interactively create objects and query the database like with IRB. Which Java database APIs work with beanshell? ...
In the application development there is a concept of defensive programming. How to implement defensive programming techniques and writing robust code using Transact-SQL? ...
I'm not a database admin or architect, so I have to ask those who do it 24/7. How established is the concept of an ORM (object relational mapping) in the world of database administration and architecture? Is it still happening, widely approved but still in its early stages, or is generally disapproved? I'm learning this area and would li...
How do find duplicate rows? If last_name is the duplicate field, I want to have to display last_name frst_name frst_name1 frst_name2 .... Any database will do, prefer oracle. ...
hi friends, http://pastebin.ca/1946913 When i write "IN(1,2,4,5,6,7,8,9,10)" inside of the procedure, i get correct result but when i add the id variable in the "IN", the results are incorrect. I made a function on mysql but its still not working, what can i do? ...
I am storing a list of links to resources such as documents to be opened by Windows applications as well as web pages in a database and need to know how to open them in Windows. For some webpages it will be achieved by passing parameters to a web browser process or executing the document and letting Windows decide what is the best appli...
I want to fetch all the column names for specific table.. I am using msaccess and C# .net 2008. ...