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
>
>
