Re[2]: Postgresql driver - esql

[Roman Zamorski <ra...@tenbit.pl>]

Hello Jed,

Monday, January 01, 2001, 8:39:11 PM, you wrote:

hm. have you added the postgresql driver to the classpath in
jserv.properties? maybe that's the problem...

JK> Thanks for the ideas: I changed my esql.xml file to point to
JK> org.postgresql.Driver, but it still came up with the following:
JK>  <<org.postgresql.Driverjava.lang.ClassNotFoundException:
JK> org.postgresql.Driver at
JK> java.lang.ClassNotFoundException.<init>(Compiled Code) at
JK> org.apache.cocoon.processor.xsp.language.java.XSPClassLoader.loadClass...>>

JK> Any other ideas? 
JK> Thanks,
JK> Jed Koops
>>>> ramzam@tenbit.pl 12/30/00 07:13 AM >>>
JK> Hello Jed,

JK> Saturday, December 30, 2000, 1:02:42 PM, you wrote:

JK>> Hello, all,

JK>> I'm trying to get the esql sample (samples/esql.xml) working on my
JK>> system (Debian Linux, Apache,Jserv, Cocoon 1.8, Postgresql
JK> database).  I
JK>> edited the sample file to point to my local Postgresql database.
JK> Here
JK>> are the relevant xml lines:
JK>> <esql:execute-query>
JK>> <esql:driver>posgresql.Driver</sql:driver>
JK>> <esql:dburl>jdbc:postgresql://localhost/addresses</esql:dburl>
JK>> etc...

JK>> It complains that it can't find the postgresql driver: 
JK>> <<postgresql.Driverjava.lang.ClassNotFoundException:
JK> postgresql.Driver
JK>> at java.lang.ClassNotFoundException.<init>(Compiled Code) at
JK>>
JK> org.apache.cocoon.processor.xsp.language.java.XSPClassLoader.loadClass

JK> that's an easy mistake and has already been addressed on the list: the
JK> correct name of the driver is "org.postgresql.Driver" not
JK> "postgresql.Driver". change it and it'll [hopefully ;)] work.

JK> on the other hand I have different kind of problem with postgresql
JK> driver which I hope someone has already fixed. in simple terms I
JK> cannot use "table.field" syntax in <esql:get-* column="table.field"/>
JK> as I get an error "unknown field: 'table.field' blah blah".
JK> when I use "table.field AS TF1" and then <esql:get-int column="TF1"/>
JK> it magically works... ideas anyone?




-- 
Best regards,
 Roman                            mailto:ramzam@tenbit.pl