Thread: newb: Howto tell if jdbc is compiled-in?
Hello List... I installed postgresql 7.1.1 some months ago as the backend to a php webmail. As it worked as expected, I haven't done anymore with postgres since (and have forgotten what little I learnt). Now how can I tell if I had compiled in JDBC support when I first installed postgres? BTW, I tried the archives but the search function doesn't seem to be working? thanks /j-p. ----------------------- JUSTATEST Art Online www.justatest.com
I'm novice at this list but I just build only JDBC 'jar'. Here is no support of JDBC on server side. 'postgresql.jar' is all what you need for JDBC. Pavel john-paul delaney wrote: > >Hello List... > >I installed postgresql 7.1.1 some months ago as the backend to a php webmail. As it worked as expected, I haven't doneany more with postgres since (and have forgotten what little I learnt). > >Now how can I tell if I had compiled in JDBC support when I first installed postgres? > >BTW, I tried the archives but the search function doesn't seem to be working? > >thanks >/j-p. > >----------------------- > JUSTATEST Art Online > www.justatest.com > > > > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > >http://archives.postgresql.org >
There is no backend support requirement only a java driver and postgres open and listing on a port. If you are wondering if you built the driver when you compiled source, you probably didn't. You would have probably needed to install Ant aswell as use the configure flag "--with-java". To look anyway, go to your postgres source build directory and try "head config.status". You should see the exact command you used to run configure. Ie. something like this... tom> head config.status ... # ./configure --prefix=/usr/local/pgsql-cvs --enable-multibyte --enable-locale --with-java Also if you built the jar files, try looking for them under src/interfaces/jdbc/jars Lastly you can always download the latest stable driver from the web site which is at http://jdbc.postgresql.org This is probably your best option. Cheers, Tom. On Tue, Feb 12, 2002 at 11:03:17AM -0100, john-paul delaney wrote: > > > Hello List... > > I installed postgresql 7.1.1 some months ago as the backend to a php webmail. As it worked as expected, I haven't doneany more with postgres since (and have forgotten what little I learnt). > > Now how can I tell if I had compiled in JDBC support when I first installed postgres? > > BTW, I tried the archives but the search function doesn't seem to be working? > > thanks > /j-p. > > ----------------------- > JUSTATEST Art Online > www.justatest.com > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Thomas O'Dowd. - Nooping - http://nooper.com tom@nooper.com - Testing - http://nooper.co.jp/labs
Thanks Pavel... I'll try the jar file as you suggest. However, I do seem to remember a "--jdbc" parameter on compiling the postgresql source, or am I wrong? If I'm not wrong,can someone tell me what's it for? rgds /j-p. On Tue, 12 Feb 2002, Pavel Tavoda wrote: > Here is no support of JDBC on server side. > 'postgresql.jar' is all what you need for JDBC. > > > > >Now how can I tell if I had compiled in JDBC support when I first installed postgres? ----------------------- JUSTATEST Art Online www.justatest.com
----------------------- JUSTATEST Art Online www.justatest.com
./configure --help ....... --with-java build JDBC interface and Java tools .......... but it's only prepare Makefile in directory 'src/interfaces/jdbc' to run 'ant' tool which is using build.xml in this directory for building jar file. Ant is similar to 'make' tool except reason that it's suited better for making java projects. You can do same just go to 'src/interfaces/jdbc' and run 'ant' by hand. I guess still best way is 'jdbc.postgresql.org'. Pavel john-paul delaney wrote: >Thanks Pavel... I'll try the jar file as you suggest. > >However, I do seem to remember a "--jdbc" parameter on compiling the postgresql source, or am I wrong? If I'm not wrong,can someone tell me what's it for? > >rgds > >/j-p. > > >On Tue, 12 Feb 2002, Pavel Tavoda wrote: > >>Here is no support of JDBC on server side. >>'postgresql.jar' is all what you need for JDBC. >> > > >>>Now how can I tell if I had compiled in JDBC support when I first installed postgres? >>> > > >----------------------- > JUSTATEST Art Online > www.justatest.com > > > > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >