Hi,
Even i am getting trouble in installing jdbc driver.I
installed jdk1.4 successfully,no problem with that. I
installed ant also and set the path to jdk/bin and
ant/bin.i set ant_home and java_home as well.I
installed postgresql with no option first.Than i went
to src/interfaces/jdbc directory and tried to run
ant,it gives me the error which is attached below at
the end. I even tried to configure postgre with-java
option but it gives me the same error. I got advive to
go in interfaces/jdbc directory and run ant clean and
ant jar first.Ant jar gives me the same error.Does
that mean i have problem with ant.i even set the
classpath to crimson.jar,jaxp.jar and ant.jar in
ant/lib dir.
i run ant with -Dmajor=7 -Dminor=2.1
-Dfullversion=7.21 and portno.5432 as suggested but it
gives me the same error as follows:
Buildfile: ./build.xml
all:
prepare:
check_versions:
driver: [echo] Configured build for the JDBC2 Enterprise
edition driver
compile: [javac] Compiling 53 source files to
/usr/local/postgresql-7.2.1/src/interfaces/jdbc/build [javac]
/usr/local/postgresql-7.2.1/src/interfaces/jdbc/org/postgresql/Driver.java:234:
';' expected [javac] return ${major}; [javac] ^ [javac]
/usr/local/postgresql-7.2.1/src/interfaces/jdbc/org/postgresql/Driver.java:244:
';' expected
and BUILD FAILED at the end
Later, i want to transfer one table from oracle to
this database.Both databases are on diff. machines but
same network.For that i need jdbc working. Is there
any other way also i can transfer my table.I mean any
graphical interface or tool which does that?
For jdbc driver i even downloaded from
jdbc.postgresql.com (pgjdbc2.jar) and put it into
pgsql/share/java dir and tried to run a sample program
but it tells me to run postmaster with -i -S option in
pg_hba.conf file.Where is taht file and what to i
change.do i need to rerun everything after that?
PLease advice as i am new to postgresql and struggling
from last week on this.
I have some problem with pgaccess also but i think
it's too much for one mail.
Thanks,
Amit
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com