how to build a New Data Source from SQL

[cuihe]

//your code here
{
   "dataSources":[
      {
         "xid":"DS_64b30a4f-d8c2-4b8a-9978-1b9c085893b6",
         "name":"test_SQL",
         "enabled":false,
         "type":"SQL",
         "alarmLevels":{
            "POLL_ABORTED":"URGENT",
            "STATEMENT_EXCEPTION":"URGENT",
            "DATA_SOURCE_EXCEPTION":"URGENT"
         },
         "purgeType":"YEARS",
         "updatePeriodType":"SECONDS",
         "connectionUrl":"192.168.61.191:3306",
         "driverClassname":"MySQL",
         "password":"1234",
         "rowBasedQuery":false,
         "selectStatement":"select * from biao;",
         "updatePeriods":5,
         "username":"root",
         "editPermission":"",
         "purgeOverride":false,
         "purgePeriod":1
      }
   ]
}

It's not clear what "driverClassname" means.
The database I use is MySQL, what should i type in ? "com.mysql.jdbc.Driver"(same error below)?

when I click "SQL Statement Testing", It shows an error: class java.lang.ClassNotFoundException: MySQL

[phildunlap]

Hi cuihe,

You should see mysql-connector.jar (with a version number) among the JAR files in the Mango/lib/ directory. It appears you have types the driver classpath correctly here, but can you verify that that's what was in the data source's drive input, com.mysql.jdbc.Driver and that your hit save before trying the utility?

The contextual help in the ? in the old UI next to the data source name or in the new UI in the top right corner does provide same.

[cuihe]

I was not so clear with this thing, but it do solved!

here is my solution:
"connectionUrl":"jdbc:mysql://localhost:3306/test",
"driverClassname":"com.mysql.jdbc.Driver",

Note: replace "localhost" "3306" "test" if needed.