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