1 Reply Latest reply on Jan 20, 2011 3:06 AM by Antoine Brun

    my JDBC Datasource marked as unvailable

    Antoine Brun Newbie

      Hi,

       

      I'm still stuck with this strange behavior with my deployed JDBC datasource.

      My datasource is declare like shoown below:

       

      <?xml version="1.0" encoding="UTF-8"?>

      <datasources>

          <local-tx-datasource>

              <jndi-name>jdbc/customerDS</jndi-name>

              <connection-url>jdbc:oracle:thin:@127.0.0.1:1521:CUSTOMER</connection-url>

              <driver-class>oracle.jdbc.OracleDriver</driver-class>

              <user-name>ncgest</user-name>

              <password>ncgest</password>

          </local-tx-datasource>

      </datasources>

       

      when jboss starts (nothing else is deployed)

      I get this in the console log (see below, I've added more log4j logs):

      no exception, but still in the jboss admin console I still get:

      Status:Unavailable

      and

      Run State:                            UNKNOWN

       

      The strange thing with this is that my application runs well, for some time, then it looses the database connection and has to be restarted.

       

      I know that there is something wrong with my jboss 5 configuration, it derived from the default profile, but how can I troubleshoot this?

      What log4j setting can I use?

       

      Antoine

       

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Creating jboss.jca:service=ManagedConnectionFactory,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Created jboss.jca:service=ManagedConnectionFactory,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Starting jboss.jca:service=ManagedConnectionFactory,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'NewConnectionSQL'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'ValidConnectionCheckerClassName'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'ValidateOnMatch'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'Password'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'QueryTimeout'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'CheckValidConnectionSQL'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'ConnectionProperties'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'ExceptionSorterClassName'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'TrackStatements'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'TransactionIsolation'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'UrlSelectorStrategyClassName'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'StaleConnectionCheckerClassName'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'DriverClass'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'ConnectionURL'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'UseTryLock'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'TransactionQueryTimeout'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'PreparedStatementCacheSize'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'UserName'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'SharePreparedStatements'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'URLDelimiter'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: UserName to value ncgest

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property UserName to value ncgest

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: Password to value ncgest

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property Password to value ncgest

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: PreparedStatementCacheSize to value 0

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property PreparedStatementCacheSize to value 0

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: SharePreparedStatements to value false

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property SharePreparedStatements to value false

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: QueryTimeout to value 0

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property QueryTimeout to value 0

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: UseTryLock to value 0

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: TransactionQueryTimeout to value false

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property TransactionQueryTimeout to value false

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: ValidateOnMatch to value true

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property ValidateOnMatch to value true

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: ConnectionURL to value jdbc:oracle:thin:@127.0.0.1:1521:CUSTOMER

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property ConnectionURL to value jdbc:oracle:thin:@127.0.0.1:1521:CUSTOMER

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] setting property: DriverClass to value oracle.jdbc.OracleDriver

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] set property DriverClass to value oracle.jdbc.OracleDriver

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Not setting config property 'ConnectionProperties'

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ManagedConnectionFactoryDeployment] Started jboss.jca:service=ManagedConnectionFactory,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.JBossManagedConnectionPool] Creating jboss.jca:service=ManagedConnectionPool,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.JBossManagedConnectionPool] Created jboss.jca:service=ManagedConnectionPool,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.JBossManagedConnectionPool] Starting jboss.jca:service=ManagedConnectionPool,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.JBossManagedConnectionPool] Started jboss.jca:service=ManagedConnectionPool,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.TxConnectionManager] Creating jboss.jca:service=LocalTxCM,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.TxConnectionManager] Created jboss.jca:service=LocalTxCM,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.TxConnectionManager] Starting jboss.jca:service=LocalTxCM,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.TxConnectionManager] Started jboss.jca:service=LocalTxCM,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [remote.WrapperDataSourceService] Creating jboss.jca:service=DataSourceBinding,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [remote.WrapperDataSourceService] Created jboss.jca:service=DataSourceBinding,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [remote.WrapperDataSourceService] Starting jboss.jca:service=DataSourceBinding,name=jdbc/customerDS

      18/Jan/2011 18:25:52 DEBUG [connectionmanager.ConnectionFactoryBindingService] Binding object 'org.jboss.resource.adapter.jdbc.WrapperDataSource@1034f8d' into JNDI at 'java:jdbc/customerDS'

      18/Jan/2011 18:25:52 INFO  [connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=jdbc/customerDS' to JNDI name 'java:jdbc/customerDS'

      18/Jan/2011 18:25:52 DEBUG [remote.WrapperDataSourceService] Started jboss.jca:service=DataSourceBinding,name=jdbc/customerDS