tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./budget_send.sh -d 4 -a 17 -U 335
2011-07-17 20:56:22.340 (3) [main]: Debug Level set to 4
2011-07-17 20:56:22.463 (3) [main]: ----------------Campaign Budget Updater Factory starting
2011-07-17 20:56:22.488 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2011-07-17 20:56:24.143 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-07-17 20:56:24.535 (4) [main]: spike: SQL->[select * from `searchEngineUsers` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineUsers`.`accountID`)) where ((`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`id` in ("335")) and (`tsacommon`.`searchEngineUsers`.`accountID` in (17))) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc]
2011-07-17 20:56:24.755 (4) [main]: time=0.163
2011-07-17 20:56:24.799 (4) [main]: Query executed in 0.163s
2011-07-17 20:56:24.958 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup...
2011-07-17 20:56:24.970 (3) [P1T1]: DatabasePool with a limit of 80 created
2011-07-17 20:56:24.978 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread
2011-07-17 20:56:25.143 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-07-17 20:56:25.144 (4) [P1T1]: Created new Object
2011-07-17 20:56:25.147 (4) [P1T1]: spike: SQL->[select @@version]
2011-07-17 20:56:25.154 (4) [P1T1]: time=0.0050
2011-07-17 20:56:25.154 (4) [P1T1]: Query executed in 0.005s
2011-07-17 20:56:25.155 (4) [P1T1]: test query succeeded, returned "5.0.30-enterprise-gpl"
2011-07-17 20:56:25.159 (4) [P1T1]: preparing SQL statement [select sea.searchEngineIdentifier, bu.budgetTotal from searchEngineAccounts sea join searchEngineUsers as seu on seu.id=sea.searchengineUserId join budgetUpdates as bu on bu.searchEngineAccountId=sea.id where bu.status = 'pending'and sea.searchEngineStatus not in ('unknown', 'deleted') and seu.ID = 335]
2011-07-17 20:56:25.406 (3) [P1T1]: No updates for SEUser 335, skipping API call.
2011-07-17 20:56:25.426 (4) [P1T1]: Returning Object to Pool
2011-07-17 20:56:25.494 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]
2011-07-17 20:56:25.502 (3) [main]: ------------Campaign Budget Updater Factory done


tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./budget_send.sh -d 4 -U 335
2011-07-17 20:56:37.747 (3) [main]: Debug Level set to 4
2011-07-17 20:56:38.491 INFO [YellDAO]: Entered getYellAccounts()!
2011-07-17 20:56:38.720 INFO [Version]: Hibernate Annotations 3.3.1.GA
2011-07-17 20:56:38.800 INFO [Environment]: Hibernate 3.2.6
2011-07-17 20:56:38.813 INFO [Environment]: hibernate.properties not found
2011-07-17 20:56:38.857 INFO [Environment]: Bytecode provider name : cglib
2011-07-17 20:56:38.873 INFO [Environment]: using JDK 1.4 java.sql.Timestamp handling
2011-07-17 20:56:40.083 INFO [Configuration]: configuring from resource: yell_service_hibernate.cfg.xml
2011-07-17 20:56:40.085 INFO [Configuration]: Configuration resource: yell_service_hibernate.cfg.xml
2011-07-17 20:56:41.424 INFO [Configuration]: Configured SessionFactory: YellBudgetServiceSessionFactory
2011-07-17 20:56:41.981 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.YellAccounts
2011-07-17 20:56:42.385 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.YellAccounts on table yellAccounts
2011-07-17 20:56:42.585 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.BudgetNode
2011-07-17 20:56:42.589 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.BudgetNode on table BudgetNode
2011-07-17 20:56:43.033 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.Budget
2011-07-17 20:56:43.048 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.Budget on table Budget
2011-07-17 20:56:43.121 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.CurrentMonth
2011-07-17 20:56:43.124 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.CurrentMonth on table CurrentMonth
2011-07-17 20:56:43.180 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.PerformanceData
2011-07-17 20:56:43.184 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.PerformanceData on table PerformanceData
2011-07-17 20:56:43.220 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.NextMonth
2011-07-17 20:56:43.221 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.NextMonth on table NextMonth
2011-07-17 20:56:43.240 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.PreviousMonth
2011-07-17 20:56:43.244 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.PreviousMonth on table PreviousMonth
2011-07-17 20:56:43.260 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.Children
2011-07-17 20:56:43.261 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.Children on table Children
2011-07-17 20:56:43.492 INFO [AnnotationBinder]: Binding entity from annotated class: com.thesearchagency.yell.model.recurse.YellError
2011-07-17 20:56:43.528 INFO [EntityBinder]: Bind entity com.thesearchagency.yell.model.recurse.YellError on table YellError
2011-07-17 20:56:43.877 INFO [AnnotationConfiguration]: Hibernate Validator not found: ignoring
2011-07-17 20:56:43.909 INFO [ConnectionProviderFactory]: Initializing connection provider: org.hibernate.connection.C3P0ConnectionProvider
2011-07-17 20:56:43.993 INFO [C3P0ConnectionProvider]: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://yell-01-write:3306/yell
2011-07-17 20:56:43.993 INFO [C3P0ConnectionProvider]: Connection properties: {is-connection-validation-required=true, autoReconnect=true, user=spike, password=****, autocommit=false, autoReconnectForPools=true}
2011-07-17 20:56:43.996 INFO [C3P0ConnectionProvider]: autocommit mode: false
2011-07-17 20:56:44.468 INFO [MLog]: MLog clients using log4j logging.
2011-07-17 20:56:45.389 INFO [C3P0Registry]: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
2011-07-17 20:56:45.641 INFO [C3P0ConnectionProvider]: JDBC isolation level: READ_COMMITTED
2011-07-17 20:56:45.833 INFO [AbstractPoolBackedDataSource]: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@f9e08f72 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@a1124ca4 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge6tn8hgh7vdoxsbazt|59c208b0, idleConnectionTestPeriod -> 100, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 100, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 200, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@50b04755 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1hge6tn8hgh7vdoxsbazt|1a0fced4, jdbcUrl -> jdbc:mysql://yell-01-write:3306/yell, properties -> {is-connection-validation-required=true, autoReconnect=true, user=******, password=******, autocommit=false, autoReconnectForPools=true} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1hge6tn8hgh7vdoxsbazt|f855562, numHelperThreads -> 3 ]
2011-07-17 20:56:47.089 INFO [SettingsFactory]: RDBMS: MySQL, version: 5.0.30-enterprise-gpl
2011-07-17 20:56:47.092 INFO [SettingsFactory]: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
2011-07-17 20:56:47.161 INFO [Dialect]: Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
2011-07-17 20:56:47.181 INFO [TransactionFactoryFactory]: Using default transaction strategy (direct JDBC transactions)
2011-07-17 20:56:47.189 INFO [TransactionManagerLookupFactory]: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2011-07-17 20:56:47.192 INFO [SettingsFactory]: Automatic flush during beforeCompletion(): disabled
2011-07-17 20:56:47.192 INFO [SettingsFactory]: Automatic session close at end of transaction: disabled
2011-07-17 20:56:47.193 INFO [SettingsFactory]: JDBC batch size: 15
2011-07-17 20:56:47.193 INFO [SettingsFactory]: JDBC batch updates for versioned data: disabled
2011-07-17 20:56:47.196 INFO [SettingsFactory]: Scrollable result sets: enabled
2011-07-17 20:56:47.197 INFO [SettingsFactory]: JDBC3 getGeneratedKeys(): enabled
2011-07-17 20:56:47.197 INFO [SettingsFactory]: Connection release mode: auto
2011-07-17 20:56:47.201 INFO [SettingsFactory]: Maximum outer join fetch depth: 2
2011-07-17 20:56:47.201 INFO [SettingsFactory]: Default batch fetch size: 1
2011-07-17 20:56:47.201 INFO [SettingsFactory]: Generate SQL with comments: disabled
2011-07-17 20:56:47.201 INFO [SettingsFactory]: Order SQL updates by primary key: disabled
2011-07-17 20:56:47.204 INFO [SettingsFactory]: Order SQL inserts for batching: disabled
2011-07-17 20:56:47.204 INFO [SettingsFactory]: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2011-07-17 20:56:47.212 INFO [ASTQueryTranslatorFactory]: Using ASTQueryTranslatorFactory
2011-07-17 20:56:47.213 INFO [SettingsFactory]: Query language substitutions: {}
2011-07-17 20:56:47.213 INFO [SettingsFactory]: JPA-QL strict compliance: disabled
2011-07-17 20:56:47.213 INFO [SettingsFactory]: Second-level cache: enabled
2011-07-17 20:56:47.213 INFO [SettingsFactory]: Query cache: disabled
2011-07-17 20:56:47.216 INFO [SettingsFactory]: Cache provider: org.hibernate.cache.NoCacheProvider
2011-07-17 20:56:47.216 INFO [SettingsFactory]: Optimize cache for minimal puts: disabled
2011-07-17 20:56:47.217 INFO [SettingsFactory]: Structured second-level cache entries: disabled
2011-07-17 20:56:47.260 INFO [SettingsFactory]: Statistics: disabled
2011-07-17 20:56:47.268 INFO [SettingsFactory]: Deleted entity synthetic identifier rollback: disabled
2011-07-17 20:56:47.308 INFO [SettingsFactory]: Default entity-mode: pojo
2011-07-17 20:56:47.316 INFO [SettingsFactory]: Named query checking : enabled
2011-07-17 20:56:47.784 INFO [Version]: Hibernate Search 3.0.0.GA
java.lang.NoClassDefFoundError: javax/transaction/Synchronization
        at org.hibernate.search.backend.WorkerFactory.createWorker(WorkerFactory.java:38)
        at org.hibernate.search.impl.SearchFactoryImpl.<init>(SearchFactoryImpl.java:100)
        at org.hibernate.search.impl.SearchFactoryImpl.getSearchFactory(SearchFactoryImpl.java:172)
        at org.hibernate.search.event.FullTextIndexEventListener.initialize(FullTextIndexEventListener.java:44)
        at org.hibernate.event.EventListeners.initializeListeners(EventListeners.java:417)
        at org.hibernate.cfg.Configuration.getInitializedEventListeners(Configuration.java:1310)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
        at com.thesearchagency.yell.dao.util.YellServiceHibernateUtil.<init>(YellServiceHibernateUtil.java:32)
        at com.thesearchagency.yell.dao.util.YellServiceHibernateUtil.getInstance(YellServiceHibernateUtil.java:49)
        at com.thesearchagency.yell.dao.util.YellServiceHibernateUtil.getSessionFactory(YellServiceHibernateUtil.java:62)
        at com.thesearchagency.yell.dao.YellDAO.beginPrivateTransaction(YellDAO.java:681)
        at com.thesearchagency.yell.dao.YellDAO.getYellAccounts(YellDAO.java:373)
        at com.thesearchagency.searchengines.budget.update.BudgetUpdateRunner.init(BudgetUpdateRunner.java:93)
        at com.thesearchagency.searchengines.budget.update.BudgetUpdateRunner.main(BudgetUpdateRunner.java:45)
2011-07-17 20:56:47.896 ERROR [YellServiceHibernateUtil]: Initializing the Yell Service Hibernate Configuration...
Exception in thread "main" java.lang.NullPointerException
        at com.thesearchagency.yell.dao.YellDAO.beginPrivateTransaction(YellDAO.java:681)
        at com.thesearchagency.yell.dao.YellDAO.getYellAccounts(YellDAO.java:373)
        at com.thesearchagency.searchengines.budget.update.BudgetUpdateRunner.init(BudgetUpdateRunner.java:93)
        at com.thesearchagency.searchengines.budget.update.BudgetUpdateRunner.main(BudgetUpdateRunner.java:45)