Hello, I have a problem with. Xml file to connect to external database. mine. xml is like this: <application Name="Baependi" rootSystem="Baependi/Baependi"> <DataSource Name = "jdbc / Main" driverClassName = "org.postgresql.Driver" username = "tersus" password = "tersus" url = "jdbc: postgresql: / / localhost: 5432/baependi" validationQuery = "select 1" / > </ Application> And this showing this log: 04/08/2010 11:16:36,531 INFO [Worker-26] Initializing WebContext # 1 04/08/2010 11:16:36,531 INFO [Worker-26] # 1 WebContext initialized in 0 ms. ERROR 08/04/2010 11:16:36,539 [Worker-26] Request ID :20100804-11: 16:36:531 [Worker-26] Base Model Id: Baependi / Baependi java.lang.RuntimeException: Failed to create connection to DataSource jdbc / Main at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 137) at tersus.runtime.SQLUtils.tableExists (SQLUtils.java: 43) at tersus.runtime.RuntimeContext.cacheUpdateTableExits (RuntimeContext.java: 381) at tersus.runtime.RuntimeContext.permissionCacheExists (RuntimeContext.java: 371) at tersus.runtime.RuntimeContext.clearPermissionCacheIfNeeded (RuntimeContext.java: 358) at tersus.runtime.ContextPool.getContext (ContextPool.java: 408) at tersus.webapp.ContextPool.getContext (ContextPool.java: 629) at tersus.runtime.ContextPool.startUp (ContextPool.java: 203) at tersus.webapp.ContextPool.contextInitialized (ContextPool.java: 210) org.apache.catalina.core.StandardContext.listenerStart at (StandardContext.java: 3843) at org.apache.catalina.core.StandardContext.start (StandardContext.java: 4350) org.apache.catalina.core.ContainerBase.addChildInternal at (ContainerBase.java: 791) at org.apache.catalina.core.ContainerBase.addChild (ContainerBase.java: 771) at org.apache.catalina.core.StandardHost.addChild (StandardHost.java: 525) at tersus.appserver.ApplicationServer.start (ApplicationServer.java: 370) tersus.appserver.ui.LaunchApplicationActionDelegate at $ 1.run (LaunchApplicationActionDelegate.java: 108) at org.eclipse.core.internal.jobs.Worker.run (Worker.java: 55) Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Can not create PoolableConnectionFactory (FATAL: type the password authenticates the users failed to river "tersus) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1225) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection (BasicDataSource.java: 880) at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 133) ... 16 more Caused by: org.postgresql.util.PSQLException: FATAL: password authenticates the type failed to river users "tersus" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication (ConnectionFactoryImpl.java: 275) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl (ConnectionFactoryImpl.java: 94) at org.postgresql.core.ConnectionFactory.openConnection (ConnectionFactory.java: 65) at org.postgresql.jdbc2.AbstractJdbc2Connection. <init> (AbstractJdbc2Connection.java: 116) at org.postgresql.jdbc3.AbstractJdbc3Connection. <init> (AbstractJdbc3Connection.java: 30) at org.postgresql.jdbc3.Jdbc3Connection. <init> (Jdbc3Connection.java: 24) at org.postgresql.Driver.makeConnection (driver.jar: 369) at org.postgresql.Driver.connect (driver.jar: 245) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java: 38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java: 294) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory (BasicDataSource.java: 1247) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1221) ... 18 more ERROR 08/04/2010 11:16:36,539 [Worker-26] Startup failed java.lang.RuntimeException: Failed to create connection to DataSource jdbc / Main at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 137) at tersus.runtime.SQLUtils.tableExists (SQLUtils.java: 43) at tersus.runtime.RuntimeContext.cacheUpdateTableExits (RuntimeContext.java: 381) at tersus.runtime.RuntimeContext.permissionCacheExists (RuntimeContext.java: 371) at tersus.runtime.RuntimeContext.clearPermissionCacheIfNeeded (RuntimeContext.java: 358) at tersus.runtime.ContextPool.getContext (ContextPool.java: 408) at tersus.webapp.ContextPool.getContext (ContextPool.java: 629) at tersus.runtime.ContextPool.startUp (ContextPool.java: 203) at tersus.webapp.ContextPool.contextInitialized (ContextPool.java: 210) org.apache.catalina.core.StandardContext.listenerStart at (StandardContext.java: 3843) at org.apache.catalina.core.StandardContext.start (StandardContext.java: 4350) org.apache.catalina.core.ContainerBase.addChildInternal at (ContainerBase.java: 791) at org.apache.catalina.core.ContainerBase.addChild (ContainerBase.java: 771) at org.apache.catalina.core.StandardHost.addChild (StandardHost.java: 525) at tersus.appserver.ApplicationServer.start (ApplicationServer.java: 370) tersus.appserver.ui.LaunchApplicationActionDelegate at $ 1.run (LaunchApplicationActionDelegate.java: 108) at org.eclipse.core.internal.jobs.Worker.run (Worker.java: 55) Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Can not create PoolableConnectionFactory (FATAL: type the password authenticates the users failed to river "tersus) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1225) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection (BasicDataSource.java: 880) at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 133) ... 16 more Caused by: org.postgresql.util.PSQLException: FATAL: password authenticates the type failed to river users "tersus" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication (ConnectionFactoryImpl.java: 275) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl (ConnectionFactoryImpl.java: 94) at org.postgresql.core.ConnectionFactory.openConnection (ConnectionFactory.java: 65) at org.postgresql.jdbc2.AbstractJdbc2Connection. <init> (AbstractJdbc2Connection.java: 116) at org.postgresql.jdbc3.AbstractJdbc3Connection. <init> (AbstractJdbc3Connection.java: 30) at org.postgresql.jdbc3.Jdbc3Connection. <init> (Jdbc3Connection.java: 24) at org.postgresql.Driver.makeConnection (driver.jar: 369) at org.postgresql.Driver.connect (driver.jar: 245) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java: 38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java: 294) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory (BasicDataSource.java: 1247) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1221) ... 18 more ERROR 08/04/2010 11:16:36,540 [Worker-26] Startup failed java.lang.RuntimeException: Failed to create connection to DataSource jdbc / Main at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 137) at tersus.runtime.SQLUtils.tableExists (SQLUtils.java: 43) at tersus.runtime.RuntimeContext.cacheUpdateTableExits (RuntimeContext.java: 381) at tersus.runtime.RuntimeContext.permissionCacheExists (RuntimeContext.java: 371) at tersus.runtime.RuntimeContext.clearPermissionCacheIfNeeded (RuntimeContext.java: 358) at tersus.runtime.ContextPool.getContext (ContextPool.java: 408) at tersus.webapp.ContextPool.getContext (ContextPool.java: 629) at tersus.runtime.ContextPool.startUp (ContextPool.java: 203) at tersus.webapp.ContextPool.contextInitialized (ContextPool.java: 210) org.apache.catalina.core.StandardContext.listenerStart at (StandardContext.java: 3843) at org.apache.catalina.core.StandardContext.start (StandardContext.java: 4350) org.apache.catalina.core.ContainerBase.addChildInternal at (ContainerBase.java: 791) at org.apache.catalina.core.ContainerBase.addChild (ContainerBase.java: 771) at org.apache.catalina.core.StandardHost.addChild (StandardHost.java: 525) at tersus.appserver.ApplicationServer.start (ApplicationServer.java: 370) tersus.appserver.ui.LaunchApplicationActionDelegate at $ 1.run (LaunchApplicationActionDelegate.java: 108) at org.eclipse.core.internal.jobs.Worker.run (Worker.java: 55) Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Can not create PoolableConnectionFactory (FATAL: type the password authenticates the users failed to river "tersus) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1225) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection (BasicDataSource.java: 880) at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 133) ... 16 more Caused by: org.postgresql.util.PSQLException: FATAL: password authenticates the type failed to river users "tersus" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication (ConnectionFactoryImpl.java: 275) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl (ConnectionFactoryImpl.java: 94) at org.postgresql.core.ConnectionFactory.openConnection (ConnectionFactory.java: 65) at org.postgresql.jdbc2.AbstractJdbc2Connection. <init> (AbstractJdbc2Connection.java: 116) at org.postgresql.jdbc3.AbstractJdbc3Connection. <init> (AbstractJdbc3Connection.java: 30) at org.postgresql.jdbc3.Jdbc3Connection. <init> (Jdbc3Connection.java: 24) at org.postgresql.Driver.makeConnection (driver.jar: 369) at org.postgresql.Driver.connect (driver.jar: 245) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java: 38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java: 294) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory (BasicDataSource.java: 1247) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1221) ... 18 more 04/08/2010 11:16:36,543 INFO [Worker-26] Initializing WebContext # 2 04/08/2010 11:16:36,543 INFO [Worker-26] # 2 WebContext initialized in 0 ms. ERROR 08/04/2010 11:16:36,548 [Worker-26] Shutdown failed java.lang.RuntimeException: Failed to create connection to DataSource jdbc / Main at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 137) at tersus.runtime.SQLUtils.tableExists (SQLUtils.java: 43) at tersus.runtime.RuntimeContext.cacheUpdateTableExits (RuntimeContext.java: 381) at tersus.runtime.RuntimeContext.permissionCacheExists (RuntimeContext.java: 371) at tersus.runtime.RuntimeContext.clearPermissionCacheIfNeeded (RuntimeContext.java: 358) at tersus.runtime.ContextPool.getContext (ContextPool.java: 408) at tersus.webapp.ContextPool.getContext (ContextPool.java: 629) at tersus.runtime.ContextPool.shutdown (ContextPool.java: 710) at tersus.webapp.ContextPool.contextDestroyed (ContextPool.java: 605) org.apache.catalina.core.StandardContext.listenerStop at (StandardContext.java: 3882) org.apache.catalina.core.StandardContext.stop at (StandardContext.java: 4516) at org.apache.catalina.core.StandardContext.start (StandardContext.java: 4380) org.apache.catalina.core.ContainerBase.addChildInternal at (ContainerBase.java: 791) at org.apache.catalina.core.ContainerBase.addChild (ContainerBase.java: 771) at org.apache.catalina.core.StandardHost.addChild (StandardHost.java: 525) at tersus.appserver.ApplicationServer.start (ApplicationServer.java: 370) tersus.appserver.ui.LaunchApplicationActionDelegate at $ 1.run (LaunchApplicationActionDelegate.java: 108) at org.eclipse.core.internal.jobs.Worker.run (Worker.java: 55) Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Can not create PoolableConnectionFactory (FATAL: type the password authenticates the users failed to river "tersus) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1225) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection (BasicDataSource.java: 880) at tersus.runtime.SQLUtils.connectToDataSource (SQLUtils.java: 133) ... 17 more Caused by: org.postgresql.util.PSQLException: FATAL: password authenticates the type failed to river users "tersus" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication (ConnectionFactoryImpl.java: 275) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl (ConnectionFactoryImpl.java: 94) at org.postgresql.core.ConnectionFactory.openConnection (ConnectionFactory.java: 65) at org.postgresql.jdbc2.AbstractJdbc2Connection. <init> (AbstractJdbc2Connection.java: 116) at org.postgresql.jdbc3.AbstractJdbc3Connection. <init> (AbstractJdbc3Connection.java: 30) at org.postgresql.jdbc3.Jdbc3Connection. <init> (Jdbc3Connection.java: 24) at org.postgresql.Driver.makeConnection (driver.jar: 369) at org.postgresql.Driver.connect (driver.jar: 245) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection (DriverConnectionFactory.java: 38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject (PoolableConnectionFactory.java: 294) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory (BasicDataSource.java: 1247) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource (BasicDataSource.java: 1221) ... 19 more The strange thing is that if I change the name of DATA SOURCE not of this problem, I login in the application and when I ask the question says that the table was not found. Does anyone know what would be the problem? Thanks, Danilo.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign