DBA Tools

The logical database layer and physical database layer

    Usually our application are bound to one physical database, for example, we always read our data from specific Oracle database or MySQL database, or write business data to specific Oracle database or MySQL database. The physical database is...

Posted on January 27, 2010 6:14 PM

Specify multiple lines value in WebChart defination

    WebChart plays more and more important role in my team, now all of the production DBAs are able to create pages on it. And they gave some good suggestions to make it better. It's easier to specify multiple...

Posted on April 22, 2009 3:47 PM

Customize all the chart colors of WebChart utility

    You can customize almost all the colors of the chart generated by WebChart platform now. In previous release, it's not possible to define the line color or bar color, it can only use the pre-defined colors. In latest...

Posted on April 1, 2009 3:33 PM

WebChart Sample Pages on MySQL Database

    With Java JDBC technology, WebChart can connect to many different types of database system, such as MySQL. Now I will show you some examples pages on MySQL. First, create the demo table with the following script in MySQL....

Posted on March 21, 2009 1:27 AM

Improved crosstab feature and formula columns in WebChart

    The format we dispaly the data is always different from the format we store the data. For example, we store the monthly trade summary in row based format, one row for each month, but when we display it,...

Posted on March 10, 2009 2:43 PM

WebChart Installation on Windows or Linux/Unix?

    After introduce of the WebChart features and the the WebChart framwork, somebody told me that they need to test WebChart, but don't know how to install it after download. After reading this article, you should know how to...

Posted on January 14, 2009 8:06 PM

How AnySQL connect to Oracle database?

    AnySQL is a command line database interface tools wrote in Java, just like Oracle's SQL*Plus, but connect to the database via JDBC. There are 3 connect methods available.     The default method is Oracle JDBC Thin driver,...

Posted on December 13, 2007 10:11 AM

Oracle JDBC Asia language support of US7ASCII or WE8ISO8859P1 database

    A lot of earlier created Oracle database did not configure the character set correctly in Asia, they choose US7ASCII, WE8DEC, WE8ISO8859P1 as the database character set. By default they just keep the NLS_LANG the same as database setting,...

Posted on October 19, 2007 8:36 PM