java.sql.SQLWarning

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • startup error
    via by Ashok Nair,
  • Runtime errors
    via by Mathew Benson,
  • resetsStalePooledConnection[0] Mensaje de error Expected: is null but: was <org.mule.message.DefaultExceptionPayload@650ea0b3> Traza java.lang.AssertionError: Expected: is null but: was <org.mule.message.DefaultExceptionPayload@650ea0b3> at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:8) at org.mule.module.db.integration.config.StalePooledConnectionResetTestCase.resetsStalePooledConnection(StalePooledConnectionResetTestCase.java:62) Salida estandard WARN 2017-03-28 12:03:25,016 [main] org.mule.tck.junit4.AbstractMuleTestCase: -------------------------------------------------------------------------------- Hung threads count: 4. Test case: org.mule.module.db.integration.config.DatasourcePoolingTestCase. Thread names: -> Abandoned connection cleanup thread - 12 -> Log4j2-TF-1-AsyncLoggerConfig-159 - 1222 -> Timer-0 - 282 -> derby.rawStoreDaemon - 283 -------------------------------------------------------------------------------- ================================================================================ = Testing: resetsStalePooledConnection[0] = ================================================================================ WARN 2017-03-28 12:03:25,258 [Time-limited test] org.mule.expression.DefaultExpressionManager: Expression string is not an expression. Use isExpression(String) to validate first WARN 2017-03-28 12:03:25,258 [Time-limited test] org.mule.expression.DefaultExpressionManager: Expression string is not an expression. Use isExpression(String) to validate first WARN 2017-03-28 12:03:25,259 [Time-limited test] org.mule.expression.DefaultExpressionManager: Expression string is not an expression. Use isExpression(String) to validate first WARN 2017-03-28 12:03:25,259 [Time-limited test] org.mule.expression.DefaultExpressionManager: Expression string is not an expression. Use isExpression(String) to validate first INFO 2017-03-28 12:03:25,409 [Time-limited test] com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@b297525 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@5e41114b [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 1000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> z8kflt9n609onak9qyv4|6538bb01, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 1, maxStatements -> 0, maxStatementsPerConnection -> 5, minPoolSize -> 1, nestedDataSource -> StandardDataSource: driver=<null> url=<jdbc:derby:muleEmbeddedDB;create=true> user=<null> CoreDataSource : debug =<false> description =<null> login time out =<0> user =<null> verbose =<false> , preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> z8kflt9n609onak9qyv4|44edfbe5, numHelperThreads -> 3 ] INFO 2017-03-28 12:03:25,413 [C3P0PooledConnectionPoolManager[identityToken->z8kflt9n609onak9qyv4|44edfbe5]-HelperThread-#1] com.mchange.v2.c3p0.SQLWarnings: Database 'muleEmbeddedDB' not created, connection made to existing database instead. java.sql.SQLWarning: Database 'muleEmbeddedDB' not created, connection made to existing database instead. at org.apache.derby.iapi.error.SQLWarningFactory.newSQLWarning(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) ~[derby-10.11.1.1.jar:?] at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[?:1.7.0_80] at java.sql.DriverManager.getConnection(DriverManager.java:187) ~[?:1.7.0_80] at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:206) ~[xapool-1.5.0.jar:"1.5.0"] at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:144) ~[xapool-1.5.0.jar:"1.5.0"] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) [mchange-commons-java-0.2.11.jar:0.2.11] INFO 2017-03-28 12:03:26,452 [C3P0PooledConnectionPoolManager[identityToken->z8kflt9n609onak9qyv4|44edfbe5]-HelperThread-#1] com.mchange.v2.c3p0.SQLWarnings: Database 'muleEmbeddedDB' not created, connection made to existing database instead. java.sql.SQLWarning: Database 'muleEmbeddedDB' not created, connection made to existing database instead. at org.apache.derby.iapi.error.SQLWarningFactory.newSQLWarning(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby-10.11.1.1.jar:?] at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) ~[derby-10.11.1.1.jar:?] at java.sql.DriverManager.getConnection(DriverManager.java:571) ~[?:1.7.0_80] at java.sql.DriverManager.getConnection(DriverManager.java:187) ~[?:1.7.0_80] at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:206) ~[xapool-1.5.0.jar:"1.5.0"] at org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:144) ~[xapool-1.5.0.jar:"1.5.0"] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147) ~[c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) [c3p0-0.9.5.2.jar:0.9.5.2] at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) [mchange-commons-java-0.2.11.jar:0.2.11] ERROR 2017-03-28 12:03:26,460 [Time-limited test] org.mule.exception.DefaultMessagingExceptionStrategy: ******************************************************************************** Message : org.mule.module.db.internal.domain.connection.ConnectionCreationException: An attempt by a client to checkout a Connection has timed out. (java.sql.SQLException) Element : /pooledDbConfig @ app:derby-db-pool-reset-config.xml:8 -------------------------------------------------------------------------------- Exception stack is: org.mule.module.db.internal.domain.connection.ConnectionCreationException: An attempt by a client to checkout a Connection has timed out. (java.sql.SQLException) (org.mule.module.db.internal.processor.DbConnectionException) com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1467) com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644) com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758) com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685) com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) org.mule.module.db.internal.domain.connection.SimpleConnectionFactory.doCreateConnection(SimpleConnectionFactory.java:30) org.mule.module.db.internal.domain.connection.AbstractConnectionFactory.create(AbstractConnectionFactory.java:23) org.mule.module.db.internal.domain.connection.TransactionalDbConnectionFactory.createDataSourceConnection(TransactionalDbConnectionFactory.java:84) (156 more...) (set debug level logging or '-Dmule.verbose.exceptions=true' for everything) ********************************************************************************
    via by Manuel Porto,
    • java.sql.SQLWarning: Database 'directory:C:\fredhopper\bin\..\data\instances\SmartTargetIdx\data\bizman\db\default' not created, connection made to existing database instead. at org.apache.derby.iapi.error.SQLWarningFactory.newSQLWarning(Unknown Source) at org.apache.derby.iapi.error.SQLWarningFactory.newSQLWarning(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
    No Bugmate found.