Chuck W

To troubleshoot, I created and complied a simple Java program to see if I could successfully load the driver and connect to my DB. I was successful so I don't think the issue is with my system. I reviewed the jasperstarter source code and found the exact line where the error occurs in Db.java file, line 198: Class.forName(driver); The variable driver is properly defined as 'org.postgresql.Driver'. I tried a direct java command line to see if I could troubleshoot. No success. I ran java directly from...

jasperstarter verbose output: Command line: -v process test2.jrxml -f pdf -o test -t postgres -n energy2 -H looks_corrrect.rds.amazonaws.com -u xxxxx -p xxxxx Original input file: /home/ec2-user/test2.jrxml Using input file: /home/ec2-user/test2.jrxml Input absolute : /home/ec2-user/test2.jrxml Input canonical: /home/ec2-user/test2.jrxml Input: test2.jrxml Input basename: test2 OutputParam: test Output: /home/ec2-user/test Output canonical: /home/ec2-user/test JDBC driver: org.postgresql.Driver Connectstring:...

I realized that I needed a JDBC 2 driver so I tried postgresql-8.1-415.jdbc2.jar but I got the same result. ls -l jasperstarter/jdbc/ total 368 -rw-r--r-- 1 root root 368749 Jan 19 18:20 postgresql-8.1-415.jdbc2.jar

I have JasperStarter running with a simple report with no DB connection. I have moved on to trying to get a JDBC connection to my Postgres database with a simple query. I am running a clean Amazon Linux EC2 instance for testing. Command line: jasperstarter process test.jrxml -f pdf -o test -t postgres -n energy2 -H aws.rds.instance -u xxxxx -p xxxxx Result: Unable to load driver: org.postgresql.Driver I seems as if it can't even load the JDBC driver. What could be the issue? Any help would be appreciated....

I have JasperSarter running with a simple report with no DB connection. I have moved on to trying to get a JDBC connection to my Postgres database with a simple query. I am running a clean Amazon Linux EC2 instance for testing. Command line: jasperstarter process test.jrxml -f pdf -o test -t postgres -n energy2 -H aws.rds.instance -u xxxxx -p xxxxx Result: Unable to load driver: org.postgresql.Driver I seems as if it can't even load the JDBC driver. What could be the issue? Any help would be appreciated....