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

Reply via email to