Gopinath Arumugam [http://community.jboss.org/people/kagopiee] created the discussion
"Re: Sybase datasource config: New missing/unsatisfied dependencies" To view the discussion, visit: http://community.jboss.org/message/644570#644570 -------------------------------------------------------------- Hi Dieter, Thanks a lot for your reply. Yes. The module is started. But right now the problem is solved. I did a minimal changes in standalone.xml which made things work. But I dont have logical answers to jboss behavior for not working with the above configuration. Here I post the standalone.xml, module.xml, server logs and jboss-admin console logs. *standalone.xml:* <?xml version="1.0" encoding="UTF-8"?> <subsystem xmlns="urn:jboss:domain:datasources:1.0"> <datasources> <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="H2DS" enabled="true"> <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url> <driver>h2</driver> <security> <user-name>sa</user-name> <password>sa</password> </security> </datasource> <datasource jndi-name="java:jboss/datasources/SybaseDS" pool-name="SybaseDS" enabled="true"> *+<connection-url>+* *+ jdbc:sybase:Tds:localhost:10553+* *+ </connection-url>+* *+ <driver-class>+* *+ com.sybase.jdbc4.jdbc.SybDriver+* *+ </driver-class>+* *+ <driver>+* *+ sybaseDriver+* *+ </driver>+* <transaction-isolation> TRANSACTION_READ_COMMITTED </transaction-isolation> <pool> <min-pool-size> 5 </min-pool-size> <max-pool-size> 100 </max-pool-size> <prefill> true </prefill> </pool> <security> <user-name> chomolungma </user-name> <password> expedition </password> </security> </datasource> <drivers> <driver name="h2" module="com.h2database.h2"> <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> </driver> +*<driver name="sybaseDriver" module="com.sybaseDS.sybaseDriver"/>*+ </drivers> </datasources> </subsystem> *modules.xml:* Location: D:\JBOSS\jboss-as-7.1.0.Beta1b\modules\com\sybaseDS\sybase\main <?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.1" name="com.sybaseDS.sybaseDriver"> <resources> <resource-root path="jconn4.jar"/> </resources> <dependencies> <module name="javax.api"/> </dependencies> </module> *Logs:* 16:52:02,676 INFO [org.jboss.as.clustering] (ServerService Thread Pool -- 29) JBAS010300: Activating Infinispan subsystem. 16:52:02,678 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 37) JBAS011910: Activating OSGi Subsystem 16:52:02,685 INFO [org.jboss.as.security] (ServerService Thread Pool -- 42) Activating Security Subsystem 16:52:02,699 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 36) JBAS011800: Activating Naming Subsystem 16:52:02,701 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 46) JBAS015537: Activating WebServices Extension 16:52:02,710 INFO [org.jboss.as.security] (MSC service thread 1-10) Picketbox version=4.0.6.Beta1 16:52:02,749 INFO [org.jboss.as.connector] (MSC service thread 1-15) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.5.Final) 16:52:02,785 INFO [org.jboss.as.naming] (MSC service thread 1-15) JBAS011802: Starting Naming Service 16:52:02,811 INFO [org.jboss.as.mail.extension] (MSC service thread 1-7) JBAS015400: Bound mail session [java:jboss/mail/Default] 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;;. *+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)+* *+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)+* 16:52:02,932 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-10) null null 16:52:02,996 INFO [org.jboss.as.remoting] (MSC service thread 1-10) Listening on /127.0.0.1:4447 16:52:02,996 INFO [org.jboss.as.remoting] (MSC service thread 1-15) Listening on /127.0.0.1:9999 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 *+16:52:03,238 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-15) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]+* *+16:52:03,247 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-15) JBAS010400: Bound data source [java:jboss/datasources/SybaseDS]+* 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 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 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 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) *Jboss-admin console:* You are disconnected at the moment. Type 'connect' to connect to the server or 'help' for the list of supported commands. [disconnected /] connect [standalone@localhost:9999 /] /subsystem=datasources:read-operation-names { "outcome" => "success", "result" => [ "add", "get-installed-driver", "installed-drivers-list", "read-attribute", "read-children-names", "read-children-resources", "read-children-types", "read-operation-description", "read-operation-names", "read-resource", "read-resource-description", "validate-address", "write-attribute" ] } [standalone@localhost:9999 /] /subsystem=datasources/data-source=java\:jboss\/datasources\/SybaseDS:read-operation-names { "outcome" => "success", "result" => [ "add", "disable", "enable", "flush-all-connection-in-pool", "flush-idle-connection-in-pool", "read-attribute", "read-children-names", "read-children-resources", "read-children-types", "read-operation-description", "read-operation-names", "read-resource", "read-resource-description", "remove", "test-connection-in-pool", "validate-address", "write-attribute" ] } [standalone@localhost:9999 /] /subsystem=datasources/data-source=java\:jboss\/datasources\/SybaseDS:test-connection-in-pool { "outcome" => "success", "result" => [true] } [standalone@localhost:9999 /] /subsystem=datasources/data-source=java\:jboss\/datasources\/SybaseDS:validate-address {"outcome" => "success"} * * * * -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/644570#644570] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
