[GENERAL] JDBC

[Jackson Ching]

Hi,

I've installed PostgreSQL 7.02 RPM Version with it's JDBC package RPM, now i'm 
trying to run my java application that connects to postgresql.   driver:   
postgresql.Driverand connection:   jdbc:postgresql:mydb

I got errors saying class not found.   i tried to check for the file 
postgresql.jar and finder.jar  ... i can't find them... 
what i found from the rpm of jdbc is jdbc7.0-1.2.jar and jdbc7.0-1.1.jar and 
the previous version jdbc6.5-1.2.jar and jdbc6.5-1.2.jar

What should i do? please help me. Thanks

jack

[GENERAL] No Suitable Driver

[Jackson Ching]

Hi,

I got my servlet work but i'm getting error saying No Suitable Driver in my 
JDBCConnectionPool. why is that so? what could be wrong? I had tested it on oracle 
under windows it works fine, now in Redhat linux with postgres, i got that error.

jackson

[GENERAL] Still No Suitable Driver

[Jackson Ching]

Hi,

Thanks for the answers before.

But i still have the same problem. i don't know why. i have put 
jdbc7.0-1.2.jar in /opt/IBMJava2-13/jre/ext and /opt/IBMJava2-13/jre/lib already and 
put them in the CLASSPATH=$CLASSPATH:/opt/IBMJava2-13/jre/ext/jdbc7.0-1.2.jar  

I also have put PATH=$PATH:/opt/IBMJava2-13/bin

I find it very strange, i was able to create the tables using the same 
JDBCObjectPool during installation of my application, but in my servlet, when 
accessing the DB, i got an No Suitable Driver. very strange behavior.  

what could be the problem?

jackson

[GENERAL] Number of Tables

[Jackson Ching]

Hi,

Is there a limit in PostgreSQL 7.0.2 on how many number of tables can be 
created?

Jack