<!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="http://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;">
Re: Sybase datasource config: New missing/unsatisfied dependencies
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/kagopiee">Gopinath Arumugam</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/644570#644570">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi Dieter,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks a lot for your reply. Yes. The module is started. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>But right now the problem is solved. I did a minimal changes in standalone.xml which made things work. </p><p>But I dont have logical answers to jboss behavior for not working with the above configuration.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Here I post the standalone.xml, module.xml, server logs and jboss-admin console logs.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong style="color: #ff0000; text-decoration: underline;">standalone.xml:</strong></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version="1.0" encoding="UTF-8"?></p><p>        <subsystem xmlns="urn:jboss:domain:datasources:1.0"></p><p>            <datasources></p><p>                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="H2DS" enabled="true"></p><p>                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url></p><p>                    <driver>h2</driver></p><p>                    <security></p><p>                         <user-name>sa</user-name></p><p>                        <password>sa</password></p><p>                    </security></p><p>                </datasource></p><p>                <datasource jndi-name="java:jboss/datasources/SybaseDS" pool-name="SybaseDS" enabled="true"></p><p>                   <strong><em> <connection-url></em></strong></p><p><strong><em>                        jdbc:sybase:Tds:localhost:10553</em></strong></p><p><strong><em>                    </connection-url></em></strong></p><p><strong><em>                    <driver-class></em></strong></p><p><strong><em>                        com.sybase.jdbc4.jdbc.SybDriver</em></strong></p><p><strong><em>                    </driver-class></em></strong></p><p><strong><em>                    <driver></em></strong></p><p><strong><em>                        sybaseDriver</em></strong></p><p><strong><em>                    </driver></em></strong></p><p>                    <transaction-isolation></p><p>                        TRANSACTION_READ_COMMITTED</p><p>                    </transaction-isolation></p><p>                    <pool></p><p>                        <min-pool-size></p><p>                            5</p><p>                        </min-pool-size></p><p>                        <max-pool-size></p><p>                            100</p><p>                        </max-pool-size></p><p>                        <prefill></p><p>                            true</p><p>                        </prefill></p><p>                    </pool></p><p>                    <security></p><p>                        <user-name></p><p>                            chomolungma</p><p>                        </user-name></p><p>                        <password></p><p>                            expedition</p><p>                        </password></p><p>                    </security></p><p>                </datasource></p><p>                <drivers></p><p>                    <driver name="h2" module="com.h2database.h2"></p><p>                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class></p><p>                    </driver></p><p>                   <em><strong> <driver name="sybaseDriver" module="com.sybaseDS.sybaseDriver"/></strong></em></p><p>                </drivers></p><p>            </datasources></p><p>        </subsystem></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000; text-decoration: underline;"><strong>modules.xml:</strong></span></p><p>     </p><p>     Location:     D:\JBOSS\jboss-as-7.1.0.Beta1b\modules\<span style="color: #ff0000;">com\sybaseDS\sybase</span>\main</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><?xml version="1.0" encoding="UTF-8"?></p><p><module xmlns="urn:jboss:module:1.1" name="com.sybaseDS.sybaseDriver"></p><p>  <resources></p><p>    <resource-root path="jconn4.jar"/></p><p>  </resources></p><p>  <dependencies></p><p>    <module name="javax.api"/></p><p>  </dependencies></p><p></module></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000; text-decoration: underline;"><strong>Logs:</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>16:52:02,676 INFO  [org.jboss.as.clustering] (ServerService Thread Pool -- 29) JBAS010300: Activating Infinispan subsystem.</p><p>16:52:02,678 INFO  [org.jboss.as.osgi] (ServerService Thread Pool -- 37) JBAS011910: Activating OSGi Subsystem</p><p>16:52:02,685 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 42) Activating Security Subsystem</p><p>16:52:02,699 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 36) JBAS011800: Activating Naming Subsystem</p><p>16:52:02,701 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 46) JBAS015537: Activating WebServices Extension</p><p>16:52:02,710 INFO  [org.jboss.as.security] (MSC service thread 1-10) Picketbox version=4.0.6.Beta1</p><p>16:52:02,749 INFO  [org.jboss.as.connector] (MSC service thread 1-15) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.5.Final)</p><p>16:52:02,785 INFO  [org.jboss.as.naming] (MSC service thread 1-15) JBAS011802: Starting Naming Service</p><p>16:52:02,811 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-7) JBAS015400: Bound mail session [java:jboss/mail/Default]</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>16:52:02,860 INFO  [org.apache.catalina.core.AprLifecycleListener] (MSC service thread 1-3) The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\glassfish3\jdk7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Drivers\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\SQL Anywhere 10\win32;C:\Program Files\SQL Anywhere 10\Sybase Central 5.0.0\win32;%JAVA_HOME%\bin;%M2_HOME%\bin;D:\Software\tattletale-1.1.2.Final;;.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><strong><em>16:52:02,890 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 25) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)</em></strong></p><p><strong><em>16:52:02,912 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 25) JBAS010404: Deploying non-JDBC-compliant driver class com.sybase.jdbc4.jdbc.SybDriver (version 7.0)</em></strong></p><p>16:52:02,932 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-10) null null</p><p>16:52:02,996 INFO  [org.jboss.as.remoting] (MSC service thread 1-10) Listening on /127.0.0.1:4447</p><p>16:52:02,996 INFO  [org.jboss.as.remoting] (MSC service thread 1-15) Listening on /127.0.0.1:9999</p><p>16:52:03,013 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-7) Starting Coyote HTTP/1.1 on http--127.0.0.1-8080</p><p><strong><em>16:52:03,238 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-15) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]</em></strong></p><p><strong><em>16:52:03,247 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-15) JBAS010400: Bound data source [java:jboss/datasources/SybaseDS]</em></strong></p><p>16:52:03,358 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-5) JBAS015012: Started FileSystemDeploymentService for directory D:\JBOSS\jboss-as-7.1.0.Beta1b\standalone\deployments</p><p>16:52:03,360 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found WebApps.war in deployment directory. To trigger deployment create a file called WebApps.war.dodeploy</p><p>16:52:03,362 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found WebAppsEAR.ear in deployment directory. To trigger deployment create a file called WebAppsEAR.ear.dodeploy</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>16:52:03,380 INFO  [org.jboss.as] (Controller Boot Thread) JBoss AS 7.1.0.Beta1b "Tesla" started in 1675ms - Started 130 of 192 services (60 services are passive or on-demand)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #ff0000; text-decoration: underline;"><strong>Jboss-admin console:</strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>You are disconnected at the moment. Type 'connect' to connect to the server or 'help' for the list of supported commands.</p><p>[disconnected /] connect</p><p>[standalone@localhost:9999 /] /subsystem=datasources:read-operation-names</p><p>{</p><p>    "outcome" => "success",</p><p>    "result" => [</p><p>        "add",</p><p>        "get-installed-driver",</p><p>        "installed-drivers-list",</p><p>        "read-attribute",</p><p>        "read-children-names",</p><p>        "read-children-resources",</p><p>        "read-children-types",</p><p>        "read-operation-description",</p><p>        "read-operation-names",</p><p>        "read-resource",</p><p>        "read-resource-description",</p><p>        "validate-address",</p><p>        "write-attribute"</p><p>    ]</p><p>}</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[standalone@localhost:9999 /] /subsystem=datasources/data-source=java\:jboss\/datasources\/SybaseDS:read-operation-names</p><p>{</p><p>    "outcome" => "success",</p><p>    "result" => [</p><p>        "add",</p><p>        "disable",</p><p>        "enable",</p><p>        "flush-all-connection-in-pool",</p><p>        "flush-idle-connection-in-pool",</p><p>        "read-attribute",</p><p>        "read-children-names",</p><p>        "read-children-resources",</p><p>        "read-children-types",</p><p>        "read-operation-description",</p><p>        "read-operation-names",</p><p>        "read-resource",</p><p>        "read-resource-description",</p><p>        "remove",</p><p>        "test-connection-in-pool",</p><p>        "validate-address",</p><p>        "write-attribute"</p><p>    ]</p><p>}</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[standalone@localhost:9999 /] /subsystem=datasources/data-source=java\:jboss\/datasources\/SybaseDS:test-connection-in-pool</p><p>{</p><p>    "outcome" => "success",</p><p>    "result" => [true]</p><p>}</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[standalone@localhost:9999 /] /subsystem=datasources/data-source=java\:jboss\/datasources\/SybaseDS:validate-address</p><p>{"outcome" => "success"}</p><p><span style="color: #ff0000; text-decoration: underline;"><strong><br/></strong></span></p><p><span style="color: #ff0000; text-decoration: underline;"><strong><br/></strong></span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/644570#644570">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="http://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>