Jdbc Static Loader Schedule Giving Error


(Marium Hassan) #1

Hi,

I am getting an error when I try to add loader_schedule setting in my configuration file. The script works fine without this setting but adding this gives me an error shown below:

Following is my configuration:

    if [jdbcFlag]
    {
      jdbc_static 
       {
        loaders => 
        [
          {
            id => "remote-customers"
            query => "some query here"
            local_table => "customers"
          }
        ]
        local_db_objects => 
        [
          {
            name => "customers"
            index_columns => ["ID"]
            columns => 
            [
              ["ID", "varchar(10)"]
            ]
          }
        ]
        local_lookups => 
        [
          {
            id => "local-customers"
            query => "some query here"
            target => "customer"
          }
        ]
        remove_field => ["customer"]
        remove_field => ["jdbcFlag"]
		
	    loader_schedule => "* */2 * * *" # run loaders every 2 hours
        jdbc_user => "user"
        jdbc_password => "password"
        jdbc_driver_class => "com.ibm.db2.jcc.DB2Driver"
        jdbc_connection_string => "db connection url here"
      }
    } 

I could not seem to understand how am I giving the wrong value?

Any help will be appreciated.
Thanks in anticipation!


(system) #2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.