org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor )

Pentaho BI Platform Tracking | Carlos Lopez | 3 years ago
  1. 0

    Currently if you attempt to deploy the pentaho.war to a JBoss Application Server using Oracle for the repository the instructions tell you to change the repository.xml to use the Oracle sections in it. The JDBC URL we have included in the repository.xml like this: <param name="url" value="jdbc:oracle:thin:@localhost:1521/XE"/> This works for Tomcat but it does not work for JBoss as it has to use the following format: <param name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/> (use colon instead of dash) otherwise you get the following error: 16:03:13,909 ERROR [org.apache.jackrabbit.core.fs.db.DatabaseFileSystem] (MSC service thread 1-2) failed to initialize file system: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor ) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) [commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) [commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) [commons-dbcp-1.4.jar:1.4] at org.apache.jackrabbit.core.util.db.OracleConnectionHelper.init(OracleConnectionHelper.java:54) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.fs.db.OracleFileSystem.createConnectionHelper(OracleFileSystem.java:151) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:187) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1078) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:916) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:262) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589) [jackrabbit-core-2.4.2.jar:2.4.2] at org.springframework.extensions.jcr.jackrabbit.RepositoryFactoryBean.createRepository(RepositoryFactoryBean.java:68) [se-jcr-0.9.jar:] at org.springframework.extensions.jcr.RepositoryFactoryBean.afterPropertiesSet(RepositoryFactoryBean.java:61) [se-jcr-0.9.jar:] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369) [spring-2.5.6.jar:2.5.6] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) [spring-2.5.6.jar:2.5.6] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) [spring-2.5.6.jar:2.5.6] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) [spring-2.5.6.jar:2.5.6] at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.7.0_40] Ideally we should ship the repository.xml using the JDBC URL that works for both which is: <param name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/>

    Pentaho BI Platform Tracking | 3 years ago | Carlos Lopez
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor )
  2. 0

    Currently if you attempt to deploy the pentaho.war to a JBoss Application Server using Oracle for the repository the instructions tell you to change the repository.xml to use the Oracle sections in it. The JDBC URL we have included in the repository.xml like this: <param name="url" value="jdbc:oracle:thin:@localhost:1521/XE"/> This works for Tomcat but it does not work for JBoss as it has to use the following format: <param name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/> (use colon instead of dash) otherwise you get the following error: 16:03:13,909 ERROR [org.apache.jackrabbit.core.fs.db.DatabaseFileSystem] (MSC service thread 1-2) failed to initialize file system: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor ) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) [commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) [commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) [commons-dbcp-1.4.jar:1.4] at org.apache.jackrabbit.core.util.db.OracleConnectionHelper.init(OracleConnectionHelper.java:54) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.fs.db.OracleFileSystem.createConnectionHelper(OracleFileSystem.java:151) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:187) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1078) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:916) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:262) [jackrabbit-core-2.4.2.jar:2.4.2] at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589) [jackrabbit-core-2.4.2.jar:2.4.2] at org.springframework.extensions.jcr.jackrabbit.RepositoryFactoryBean.createRepository(RepositoryFactoryBean.java:68) [se-jcr-0.9.jar:] at org.springframework.extensions.jcr.RepositoryFactoryBean.afterPropertiesSet(RepositoryFactoryBean.java:61) [se-jcr-0.9.jar:] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369) [spring-2.5.6.jar:2.5.6] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) [spring-2.5.6.jar:2.5.6] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) [spring-2.5.6.jar:2.5.6] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) [spring-2.5.6.jar:2.5.6] at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.7.0_40] Ideally we should ship the repository.xml using the JDBC URL that works for both which is: <param name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/>

    Pentaho BI Platform Tracking | 3 years ago | Carlos Lopez
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor )
  3. 0

    Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

    Stack Overflow | 2 years ago | user2342259
    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Not able to connect to Database with oci8

    Stack Overflow | 3 years ago | SCoder
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-12154: TNS:could not resolve the connect identifier specified
  6. 0

    SonarQube Installation with Oracle DB - Getting user does not exists

    Stack Overflow | 3 years ago | Venkat
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-01435: user does not exist )

  1. Mathias S 1 times, last 11 months ago
8 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.apache.commons.dbcp.SQLNestedException

    Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor )

    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory()
  2. Commons DBCP
    BasicDataSource.getConnection
    1. org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)[commons-dbcp-1.4.jar:1.4]
    2. org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)[commons-dbcp-1.4.jar:1.4]
    3. org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)[commons-dbcp-1.4.jar:1.4]
    3 frames
  3. Jackrabbit Data
    OracleConnectionHelper.init
    1. org.apache.jackrabbit.core.util.db.OracleConnectionHelper.init(OracleConnectionHelper.java:54)[jackrabbit-core-2.4.2.jar:2.4.2]
    1 frame
  4. Jackrabbit Core
    RepositoryImpl.create
    1. org.apache.jackrabbit.core.fs.db.OracleFileSystem.createConnectionHelper(OracleFileSystem.java:151)[jackrabbit-core-2.4.2.jar:2.4.2]
    2. org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:187)[jackrabbit-core-2.4.2.jar:2.4.2]
    3. org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1078)[jackrabbit-core-2.4.2.jar:2.4.2]
    4. org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:916)[jackrabbit-core-2.4.2.jar:2.4.2]
    5. org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:262)[jackrabbit-core-2.4.2.jar:2.4.2]
    6. org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589)[jackrabbit-core-2.4.2.jar:2.4.2]
    6 frames
  5. org.springframework.extensions
    RepositoryFactoryBean.afterPropertiesSet
    1. org.springframework.extensions.jcr.jackrabbit.RepositoryFactoryBean.createRepository(RepositoryFactoryBean.java:68)[se-jcr-0.9.jar:]
    2. org.springframework.extensions.jcr.RepositoryFactoryBean.afterPropertiesSet(RepositoryFactoryBean.java:61)[se-jcr-0.9.jar:]
    2 frames
  6. Spring Beans
    AbstractAutowireCapableBeanFactory$1.run
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)[spring-2.5.6.jar:2.5.6]
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)[spring-2.5.6.jar:2.5.6]
    3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)[spring-2.5.6.jar:2.5.6]
    4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)[spring-2.5.6.jar:2.5.6]
    4 frames
  7. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)[rt.jar:1.7.0_40]
    1 frame