Hi, I came across an interesting article which shows how we can transparently encrypt jdbc connections using java thin client. http://javasight.wordpress.com/2008/08/29/network-data-encryption-and-integrity-for-thin-jdbc-clients/ However I want to know how this can be achieved for application servers (like oc4j) datasources. ...
I've been trying to find a free database creator for mac os, and i'm not being able to find any. Anyone know of a free one i could download? EDIT: I need that the application generate the sql (mysql in this case) also :) ty ...
As usual, some background information first: Database A (Access database) - Holds a table that has information I need from only two columns. The information from these two columns is needed for an application that will be used by people that cannot access database A. Database B (Access database) - Holds a table that contains only two c...
In a corporate development environment writing mostly administrative software, should every developer use their own database instance, or should they use a central database instance during development? What are the advantages and disadvantages of each approach? What about other environments and other products? ...
Hi, I am porting an existing windows based C++ application to 64 bit environment and this is one of those weird errors. In the code snippet you can that I am using openforwardonly and it used to work fine with our old setup but in the 64 bit environment it gives the problem of fetching only ONE recordset. Or it could be a problem with th...
We put common prefixes on related tables to assure they display next to each other in our DB management software (Toad, Enterprise Manager, etc). So for example, all user tables start with the word User: User UserEvent UserPurchase Ideally, in honor of the three great virtues of a programmer these tables should be named User, Eve...
I am trying to connect to 2 databases on the same instance of MySQL from 1 PHP script. At the moment the only way I've figured out is to connect to both databases with a different user for each. I am using this in a migration script where I am grabbing data from the original database and inserting it into the new one, so I am looping t...
Hello! Where I can download sample database which can be used for data warehouse creation? It should't be sample from Microsoft (Northwind etc.). Thanks in advance EDIT: Sorry for not clarifying my question. At my university we have class where we must create some data warehouse and since Northwind is so popular over net then professo...
Hi, I created the setup project for the application and I can see that the later modifications of the configuration file (Application.exe.config) don't affect the application execution. I am developing an application with the database file included and I want to enable users to move the database file and modify connection strings. Doe...
I have a table named Info of this schema: int objectId; int time; int x, y; There is a lot of redundant data in the system - that is, objectId is not UNIQUE. For each objectId there can be multiple entries of time, x, y. I want to retrieve a list of the latest position of each object. I started out with this query: SELECT * FROM Inf...
Background I am working on a legacy small-business automation system (inventory, sales, procurement, etc.) that has a single database hosted by SQL Server 2005 and a bunch of client applications. The main client (used by all users) is an MS Access 2003 application (ADP), and other clients include various VB/VBA applications like Excel a...
When there are one of more columns that reference another, I'm struggling for the best way to update that column while maintaining referential integrity. For example, if I have a table of labels and descriptions and two entries: Label | Description ------------------------------------ read | This item has been read READ | You read thi...
Are there any third party enterprisey data grid controls out there, alla JIDE Data Grid? Is there a website like torry.net that lists third party java controls? Google doesn't turn up much for and I thought there would be a lot of both considering how popular java seems to be. TIA ...
Let's say I have the following table: CustomerID ParentID Name ========== ======== ==== 1 null John 2 1 James 3 2 Jenna 4 3 Jennifer 5 3 Peter 6 5 Alice 7 5 Steve 8 1 Larry I want to retrieve in one query all th...
HI i have database with many tables. In the first table i have a field called status. table 1 idno name status 111 hjghf yes 225 hjgjj no 345 hgj yes other tables could have same idno with different fields. I want to check the status for each id no and if it is yes then for that id number in all ta...
How would you model booked hotel room to guests relationship (in PostgreSQL, if it matters)? A room can have several guests, but at least one. Sure, one can relate guests to bookings with a foreign key booking_id. But how do you enforce on the DBMS level that a room must have at least one guest? May be it's just impossible? ...
I would like to change the "Row Source" values in an Access table through code. This way I can filter what a user can choose in a column's combo box. ...
Lets say on MySQL database (if it matters). ...
What is people's prefered method of storing application configuration data in a database. From having done this in the past myself, I've utilised two ways of doing it. You can create a table where you store key/value pairs, where key is the name of the config option and value is its value. Pro's of this is adding new values is easy and...
Can I call a stored procedure in Oracle via a database link? The database link is functional so that syntax such as... SELECT * FROM myTable@myRemoteDB is functioning. But is there a syntax for... EXECUTE mySchema.myPackage.myProcedure('someParameter')@myRemoteDB ...