I have a Java SOAP data service which sits on top of a Sybase database which, for reasons out of my control, has unreliable performance. The database is part of a vendor package which has been modified by an internal team and most of the issues are caused by slow response times at certain times of the day. The SOAP service provides dat...
Is there any persistence solution for Common Lisp, such as Elephant, that allows function persistence? Currently my app stores an identifier on the db and later searches in a function table which it is, but this method does not allow dynamically created functions to be stored. ...
can you use ms access as the backend of a asp.net dynamic data project website. Any links or examples? ...
I'm still new to ROR, so pardon the simplicity of the question... So http://www.example.com/controller/:id displays a record in my table, with :id being a number (1,2,3 etc.). Is there a way I can have :id in the URL be the value of a field in the displayed record? Such that I can have http://www.example.com/controller/record_field ??...
Normalization leads to many essential and desirable characteristics, including aesthetic pleasure. Besides it is also theoretically "correct". In this context, denormalization is applied as a compromise, a correction to achieve performance. Is there any reason other than performance that a database could be denormalized? ...
I have a dropdown box and a literal tag inside an Update Panel. On the selection change event of the dropdown up requery the database and repopulate the literal tag and then call UPdatePanel.Update(). below, is there are way i can avoid having to create a new Oledbconnection each time as this seems slow. Can i reuse and store: The D...
I am trying to help a small business that has an application that could benefit from occasional (or temporary) database expertise. The problem is, this company has all their IP in this database, so they are rightfully hesitant to give someone access it. They would typically meet and gain trust in person, but the talent pool within ph...
I have code in an Update Panel and even though on a button click i am inserting data into a db and simply calling Updatepanel.Update() the whole page is reloaded: Gifts.ASPX <table style="width:100%;"> <tr> <td> <asp:Label ID="Label2" runat="server" Text="Gift"></asp:Label> ...
I know postgres has a datatype for storing geographical coordinates. But I'm looking for a RDBMS agnostic solution. Currently I'm using Decimal(25,20) in MySQL. I may be using this data to lookup these locations based on a given distance from a given location later. Which would be the best approach to store this kind of data? ...
The question says it all. Example: I'm planning to shard a database table. The table contains customer orders which are flagged as "active", "done" and "deleted". I also have three shards, one for each flag. As far as I understand a row has to be moved to the right shard, when the flag is changed. Am I right? What's the best way to ...
What methods to use a database from Clojure are there? I know from Clojure you can do anything you can with Java, but that means that I may end up using something overly complicated (like Hybernate) which clashes with Clojure simplicity. Any recommendations or comments? ...
Hello, I am doing analysis on schema evolution and have really fallen short of real world database schemas that have evolved a bit and stored in version control. Mediawiki (http://svn.wikimedia.org/svnroot/mediawiki/trunk/phase3/maintenance/tables.sql) seems to be a very good candidate so far. I've considered Bugzilla, but they don't se...
I am working on an application that will be used as an extensible framework for other applications. One of the fundamental classes is called Node, and Nodes have Content. The SQL tables look like this: TABLE Node ( NodeId int, .... etc ) TABLE NodeContentRelationship ( NodeId int, ContentType string, ContentId int) It will be up to t...
Hi, I was wondering if it is possible to get a large, enterprise-scale sample Sql Server database? I am working with Sql Server 2005, and feel that looking at a large scale database would really improve my database design skills. I'm aware of, and have checked Nortwind and AdventureWorks, but these aren't large enough. Also, when worki...
What Database Abstraction Layer libraries would you recommend for use with C++? I am more interested in solutions for non-Windows platforms, but that is personal preference. Which libraries would you recommend and why? ...
When I left Friday my Enterprise app was working fine, I come in today and restart and now I am getting this error: java.lang.ClassCastException: com.sun.enterprise.naming.SerialContext cannot be cast to javax.sql.DataSource at oracle.toplink.essentials.jndi.JNDIConnector.connect(JNDIConnector.java:129) at oracle.toplin...
I have a single user java program that I would like to have store data in a light weight database such as Derby or Sqlite. I would like to use a data abstraction layer in my program. Hibernate appears to require a lot of configuration and is overkill for what I need. What are light weight alternatives to Hibernate? ...
I wouldn't dare do anything complex in a database without transactions. There is nearly always a simple to use in-built command. But when you start working with other persistent data you just don't get this simple to use transaction support. Some example are file systems web services (none that I've used) Even in non-persistent data ...
I have stored a txt file as string in a database coulum. Now on one of my aspx page I have a link...I want to open a txt file when the user clicks on this link. How can i read a file from database. I know how to do this using streamreader for a file stored on the disk. Thanks ...
I have a databases table with ~50K rows in it, each row represents a job that need to be done. I have a program that extracts a job from the DB, does the job and puts the result back in the db. (this system is running right now) Now I want to allow more than one processing task to do jobs but be sure that no task is done twice (as a per...