Archive for the ‘Programming’ Category
Wednesday, September 16th, 2009
SQL Server JDBC Driver provides misleading error messages and sometimes even locks down processing SQL Query request.
In one of my application tests that used Hibernate framework to abstract database access, SQL Server JDBC Driver went into infinite loop trying to process a simple query on a view such as :
...
Posted in Databases, Programming | No Comments »
Tuesday, September 15th, 2009
Most of the server side applications use database back-end. Being used to Test-Driven Development practices, it is desirable to be able to write a test for numerous stored procedures we put in our code. Building Java code to launch a simple stored procedure, flush database and setting to a predefined ...
Posted in Databases, Java, Programming | No Comments »
Wednesday, September 9th, 2009
Points Of Interest or simply POIs are the feature of tomorrow. GPS and compass enabled smartphones will guide our every step and habits. We will enjoy, go shopping, rest choose place to invest basing on the local suggestion of our little friends. Here are some services that enable this future:
http://www.geocode.ca/
http://foodpages.ca/
Enjoy
Posted in Mobile Development, Web | No Comments »
Tuesday, August 25th, 2009
A new waves of apps is on the smartphone app stores and market places. Those are the bar code scanners that allow you to link real world of products with the huge internet database. Instead of trying to use words to provide a vague description of the product, its bar ...
Posted in Mobile Development | 2 Comments »
Monday, August 24th, 2009
Query number of records in each partition of the table:
SET SERVEROUTPUT ON SIZE 100000;
DECLARE
CURSOR c1
IS
SELECT table_name,
partition_name
FROM all_tab_partitions
WHERE table_name = 'MCP_CDR_HIST' order by partition_name asc;
v_sql VARCHAR2(2000);
temp_var NUMBER:=0;
BEGIN
dbms_output.put_line('Start');
FOR rec IN c1
LOOP
EXECUTE immediate 'select count(*) from '||rec.table_name||' partition('||rec.partition_name||')' INTO temp_var;
dbms_output.put_line('The Partition '||rec.partition_name||' of table '||rec.table_name||' has '||temp_var||' rows');
END ...
Posted in Databases | 1 Comment »
Tuesday, August 18th, 2009
Sliding window is a classical solution for the most historical databases. A partition is switched in and out. The scenario is supported by majority of database providers.
The following article describes partition switching in or partition exchange for Oracle: http://www.oracle-base.com/articles/misc/PartitioningAnExistingTableUsingExchangePartition.php
Posted in Databases, Programming | No Comments »
Monday, August 17th, 2009
Here is a nice tutorial on XML and parsing methodes:
http://www.cafeconleche.org/books/xmljava/
Posted in Java | No Comments »
Wednesday, August 5th, 2009
Don't understand why getting Facebook API gotta be so complicated. Here is a video tutorial that would save an hour of your precious time:
[youtube]http://www.youtube.com/watch?v=jYqx-RtmkeU[/youtube]
If you are looking for a Java Facebook client, look no further then Facebook Java API. That's a well maintained open source project hosted by Google. Java ...
Posted in Java, Programming | No Comments »
Tuesday, August 4th, 2009
Another application in a series of new popular augmented reality (AR) application called: Traffic Views
Application is available for Google Android platform only. It provides lot's of useful features that would help you to navigate wisely basing on the traffic conditions in your area. You can see a demo in the ...
Posted in Gadgets, Mobile Development | No Comments »
Friday, July 24th, 2009
The following script reports space allocated for every index in the Database.
Script is taken from http://stackoverflow.com/questions/316831/table-and-index-size-in-sql-server:
SELECT
i.name AS IndexName,
s.used_page_count * 8 AS IndexSizeKB
FROM sys.dm_db_partition_stats AS s
JOIN sys.indexes ...
Posted in Databases, Programming | No Comments »