<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Timing Issue with Datasource configuration?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/tombrey">Tom Brey</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/784517#784517">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>In our JBOSS environment, we have many services that come up when initially starting up JBOSS.  Most of these are scheduled or on-demand services, but we have one where it comes up and starts on its own.  This service initiates a routine we call our 'InitialCleanupThread', which will attempt to re-queue or complete any entries in our MySQL DB. The problem we are having that the datasource for the MySQL DB is not properly configured at startup time.  If we 'stop' and 'start' the service with the 'InitialCleanupThread', then everything runs fine.  We have a lot of people with some experience with JBOSS, but no one person who really knows it in detail.  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The general consensus here is that it is simply a timing issue when JBOSS is initially started.  Obviously we have a workaround that I mentioned above, and I know I can code around it by requiring a manual intervention to start this process.  I am just wondering if there is a way we can configure our way around this.  I am not the guy who originally created the JBOSS configuration, so I don't know what configuration / XML files to include here.  In truth, I am a developer who needs more information about the JBOSS configuration, but online searches have been fruitless.  Any suggestions or insights will be helpful.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Output from the service is shown below:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>2012-12-21 10:03:54,213 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] Loading the configuration properties.</p><p>2012-12-21 10:03:54,222 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] The configuration properties are successfully loaded.  The number of properties loaded is:57</p><p>2012-12-21 10:03:55,953 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] Query version number = '02.00.00'. Query = select version_num from icsms.reftbl where schema_name = 'smsig' and schema_date IN (select MAX(schema_date) from icsms.reftbl).</p><p>2012-12-21 10:03:55,954 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] SMSIGLoader is ok to run. Starting Initial Clean Up Thread.</p><p>2012-12-21 10:03:55,960 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] Create a control thread to read the load file from the source file directory.</p><p>2012-12-21 10:03:55,968 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] **** FTP directory Monitor - Started with scan rate 60 *****</p><p>2012-12-21 10:03:55,969 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] **** Status 0 Load Control Record Monitor - Started with scan rate 60 *****</p><p>2012-12-21 10:03:55,998 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.ControllerThread] Offset Increment = 3600000</p><p>2012-12-21 10:03:55,996 ERROR [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] ErrorCode[VLD-MGR-4001] AppErrorDesc[Error when looking up the data source of the control table connection pool. Please see tool error detail and verify mysql-ds.xml is deployed in JBoss.] ToolError[MySqlSmsigControlTableDS not boundParameters[DataSourceJNDIName:java:/MySqlSmsigControlTableDS]</p><p>2012-12-21 10:03:56,077 ERROR [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] ErrorCode[VLD-MGR-4001] AppErrorDesc[Error when looking up the data source of the control table connection pool. Please see tool error detail and verify mysql-ds.xml is deployed in JBoss.] ToolError[MySqlSmsigControlTableDS not boundParameters[DataSourceJNDIName:java:/MySqlSmsigControlTableDS]</p><p>2012-12-21 10:03:56,139 ERROR [ - ][com.syniverse.SMSIGLoaderTierOne.SMSIGManager] ErrorCode[VLD-MGR-4001] AppErrorDesc[Error when looking up the data source of the control table connection pool. Please see tool error detail and verify mysql-ds.xml is deployed in JBoss.] ToolError[MySqlSmsigControlTableDS not boundParameters[DataSourceJNDIName:java:/MySqlSmsigControlTableDS]</p><p>2012-12-21 10:03:56,332 ERROR [ - ][com.syniverse.SMSIGLoaderTierOne.InitialCleanUpThread] ErrorCode[VLD-ICU-3003] AppErrorDesc[ICU completed abnormally.] ToolError[Service Stopped.]</p><p>2012-12-21 10:03:56,332 INFO  [ - ][com.syniverse.SMSIGLoaderTierOne.InitialCleanUpThread] ICU Completed.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/784517#784517">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>