Try removing <scope>provided</scope> from the postgres dependency [http://www.cisco.com/web/europe/images/email/signature/est2014/logo_06.png?ct=1398192119726]
Grant Overby Software Engineer Cisco.com<http://www.cisco.com/> [email protected]<mailto:[email protected]> Mobile: 865 724 4910 [http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif] Think before you print. This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message. Please click here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for Company Registration Information. From: jim Zhou <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thursday, September 17, 2015 at 2:38 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: SQL exception when using Maven Hi, I am pulling data from a Postgresql database. It is working fine when I run it from IntellijIDEA. However, then I install from Maven and run it. I got the java.sql.SQLExeption error. 14417 [Thread-9-postgres-spout] INFO backtype.storm.daemon.executor - Opening spout postgres-spout:(2) java.sql.SQLException: No suitable driver found for jdbc:postgresql://dewey-db.transvoyant.com:5432/event_sys<http://dewey-db.transvoyant.com:5432/event_sys> at java.sql.DriverManager.getConnection(DriverManager.java:596) at java.sql.DriverManager.getConnection(DriverManager.java:215) at PostgreSpout.open(PostgreSpout.java:53) at backtype.storm.daemon.executor$fn__6579$fn__6594.invoke(executor.clj:522) at backtype.storm.util$async_loop$fn__459.invoke(util.clj:461) at clojure.lang.AFn.run(AFn.java:24) at java.lang.Thread.run(Thread.java:745) 14421 [Thread-9-postgres-spout] INFO backtype.storm.daemon.executor - Opened spout postgres-spout:(2) 14423 [Thread-9-postgres-spout] INFO backtype.storm.daemon.executor - Activating spout postgres-spout:(2) 14439 [Thread-11-test-bolt] INFO backtype.storm.daemon.executor - Preparing bolt test-bolt:(3) 14440 [Thread-11-test-bolt] INFO backtype.storm.daemon.executor - Prepared bolt test-bolt:(3) 310739 [main] INFO backtype.storm.daemon.nimbus - Delaying event :remove for 30 secs for connect-postgres-1-1442513931 310750 [main] INFO backtype.storm.daemon.nimbus - Updated connect-postgres-1-1442513931 with status {:type :killed, :kill-time-secs 30} this is my POM file. Please help <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd";> <modelVersion>4.0.0</modelVersion> <groupId>edu.nps.cs</groupId> <artifactId>storm1</artifactId> <version>1.0-SNAPSHOT</version> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>2.3.2</version> <configuration> <source>1.6</source> <target>1.6</target> </configuration> </plugin> </plugins> </build> <repositories> <repository> <id>clojars.org<http://clojars.org></id> <url>http://clojars.org/repo</url> </repository> </repositories> <dependencies> <dependency> <groupId>storm</groupId> <artifactId>storm</artifactId> <version>0.9.0.1</version> <scope>provided</scope> </dependency> <dependency> <groupId>postgresql</groupId> <artifactId>postgresql</artifactId> <version>9.1-901-1.jdbcja4</version> <scope>provided</scope> </dependency> </dependencies> </project> thank you, Jim
