jdbc connection on tomcat server
I will try to formulate as best as I can.

First, web application(Spring MVC with Spring Jdbc) worked well until I started messing out with versions of STS(Spring Tool Suite based on Eclipse) and JDK+JRE7 to get features of Java 7.

Second, the current problem is that Apache Tomcat 6 or 7(I have both which I reinstalled for reason I don't remember) seems to be affecting the connection to the database. Saying directly: it fails to get jdbc connection

     org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for jdbc:postgresql:postgres

and it happens whenever I try to do any operation on database from my web application.

The line jdbc:postgresql:postgres is OK just in case, because it worked before and it effectively says to connect to local database with name postgres(and also because of the point below).

Another important point to mention is that under vFabric tc Server everything works flawlessly without any problems whatsoever.


Third, the database is PostgreSql along with Apache DBCP pooling.

Fourth, the maven jdbc driver dependencies seems to work well, as again if they didn't vFabric tc Server would also fail same as Apache Tomcat which leads to me to an idea that Apache Tomcat is itself the culprit.

Some of the information produced during server start-up:

         Dec 14, 2011 4:54:32 PM org.apache.catalina.core.AprLifecycleListener init
         INFO: The APR based Apache Tomcat Native library which allows optimal                       performance in production environments was not found on the java.library.path:           C:\ProgramFiles\Java\jdk1.7.0_02\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\MiKTeX 2.9\miktex\bin;C:\Program Files\Apache Software Foundation\apache-maven-3.0.3\bin;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\WIDCOMM\Bluetooth Software\;C:\Program Files\WIDCOMM\Bluetooth Software\syswow64;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\QuickTime\QTSystem\;.
         Dec 14, 2011 4:54:32 PM org.apache.coyote.AbstractProtocol init
         INFO: Initializing ProtocolHandler ["http-bio-8080"]
         Dec 14, 2011 4:54:32 PM org.apache.coyote.AbstractProtocol init
         INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
         Dec 14, 2011 4:54:32 PM org.apache.catalina.startup.Catalina load
         INFO: Initialization processed in 849 ms
         Dec 14, 2011 4:54:32 PM org.apache.catalina.core.StandardServicestartInternal
         INFO: Starting service Catalina
         Dec 14, 2011 4:54:32 PM org.apache.catalina.core.StandardEngine startInternal
         INFO: Starting Servlet Engine: Apache Tomcat/7.0.23
         Dec 14, 2011 4:54:33 PM org.apache.catalina.startup.HostConfig deployDescriptor
         INFO: Deploying configuration descriptor C:\Users\User\Documents\workspace-sts\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\conf\Catalina\localhost\project.xml
         Dec 14, 2011 4:54:33 PM org.apache.catalina.startup.SetContextPropertiesRule begin
         WARNING: [SetContextPropertiesRule]{Context} Setting property 'source' to 'org.eclipse.jst.jee.server:project' did not find a matching property.
         Dec 14, 2011 4:54:34 PM org.apache.catalina.core.ApplicationContext log
         INFO: Initializing Spring root WebApplicationContext

         Dec 14, 2011 4:54:37 PM org.apache.coyote.AbstractProtocol start
         INFO: Starting ProtocolHandler ["http-bio-8080"]
         Dec 14, 2011 4:54:37 PM org.apache.coyote.AbstractProtocol start
         INFO: Starting ProtocolHandler ["ajp-bio-8009"]
         Dec 14, 2011 4:54:37 PM org.apache.catalina.startup.Catalina start
         INFO: Server startup in 4664 ms


I am really desperate please help.
jdbc connection on tomcat server
===

I will try to formulate as best as I can.

First, web application(Spring MVC with Spring Jdbc) worked well until I started messing out with versions of STS(Spring Tool Suite based on Eclipse) and JDK+JRE7 to get features of Java 7.

Second, the current problem is that Apache Tomcat 6 or 7(I have both which I reinstalled for reason I don't remember) seems to be affecting the connection to the database. Saying directly: it fails to get jdbc connection

     org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: No suitable driver found for jdbc:postgresql:postgres

and it happens whenever I try to do any operation on database from my web application.

The line jdbc:postgresql:postgres is OK just in case, because it worked before and it effectively says to connect to local database with name postgres(and also because of the point below).

Another important point to mention is that under vFabric tc Server everything works flawlessly without any problems whatsoever.


Third, the database is PostgreSql along with Apache DBCP pooling.

Fourth, the maven jdbc driver dependencies seems to work well, as again if they didn't vFabric tc Server would also fail same as Apache Tomcat which leads to me to an idea that Apache Tomcat is itself the culprit.

Some of the information produced during server start-up:

         Dec 14, 2011 4:54:32 PM org.apache.catalina.core.AprLifecycleListener init
         INFO: The APR based Apache Tomcat Native library which allows optimal                       performance in production environments was not found on the java.library.path:           C:\ProgramFiles\Java\jdk1.7.0_02\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\MiKTeX 2.9\miktex\bin;C:\Program Files\Apache Software Foundation\apache-maven-3.0.3\bin;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\WIDCOMM\Bluetooth Software\;C:\Program Files\WIDCOMM\Bluetooth Software\syswow64;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\QuickTime\QTSystem\;.
         Dec 14, 2011 4:54:32 PM org.apache.coyote.AbstractProtocol init
         INFO: Initializing ProtocolHandler ["http-bio-8080"]
         Dec 14, 2011 4:54:32 PM org.apache.coyote.AbstractProtocol init
         INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
         Dec 14, 2011 4:54:32 PM org.apache.catalina.startup.Catalina load
         INFO: Initialization processed in 849 ms
         Dec 14, 2011 4:54:32 PM org.apache.catalina.core.StandardServicestartInternal
         INFO: Starting service Catalina
         Dec 14, 2011 4:54:32 PM org.apache.catalina.core.StandardEngine startInternal
         INFO: Starting Servlet Engine: Apache Tomcat/7.0.23
         Dec 14, 2011 4:54:33 PM org.apache.catalina.startup.HostConfig deployDescriptor
         INFO: Deploying configuration descriptor C:\Users\User\Documents\workspace-sts\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\conf\Catalina\localhost\project.xml
         Dec 14, 2011 4:54:33 PM org.apache.catalina.startup.SetContextPropertiesRule begin
         WARNING: [SetContextPropertiesRule]{Context} Setting property 'source' to 'org.eclipse.jst.jee.server:project' did not find a matching property.
         Dec 14, 2011 4:54:34 PM org.apache.catalina.core.ApplicationContext log
         INFO: Initializing Spring root WebApplicationContext

         Dec 14, 2011 4:54:37 PM org.apache.coyote.AbstractProtocol start
         INFO: Starting ProtocolHandler ["http-bio-8080"]
         Dec 14, 2011 4:54:37 PM org.apache.coyote.AbstractProtocol start
         INFO: Starting ProtocolHandler ["ajp-bio-8009"]
         Dec 14, 2011 4:54:37 PM org.apache.catalina.startup.Catalina start
         INFO: Server startup in 4664 ms


I am really desperate please help.