Sorry, I copy postgresql-9.1-901-1.jdbcja4.jar into storm/lib folder and it starts working now. thank you all for helping!! Jim
On Thu, Sep 17, 2015 at 12:35 PM, jim Zhou <[email protected]> wrote: > the original doesn't have this and I have the same error. Someone asked > me to add it but it is not working neither. <scope>provided</scope> > I also added systemPath and it wasn't working neither. > > 1. <scope>system</scope> > 2. <systemPath>${java.home}/../lib/postgresql-9.1-901-1.jdbcja4.jar > </systemPath> > > > > On Thu, Sep 17, 2015 at 11:50 AM, Grant Overby (groverby) < > [email protected]> wrote: > >> Try removing <scope>provided</scope> from the postgres dependency >> >> *Grant Overby* >> Software Engineer >> Cisco.com <http://www.cisco.com/> >> [email protected] >> Mobile: *865 724 4910 <865%20724%204910>* >> >> >> >> 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]> >> Reply-To: "[email protected]" <[email protected]> >> Date: Thursday, September 17, 2015 at 2:38 PM >> To: "[email protected]" <[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 >> 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</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 >> >> >
