Thread: ongoing holy grail thread

I hope that I have the correct e-mail address configured now..

--

In my quest to connect Dreamweaver Ultradev to postgresql I have changed
my application server in order to have easier access to the .conf files.
Now running Tomcat/Apache.

Ultradev connects to the application server but the JDBC connection
times out. I am running 7.0.3 and have
/usr/java/jdk1.3/jre/lib/ext/jdbc7.0-1.2.jar

TIA for any usefull tips

Cheers

Tony Grant


--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html

On 09 Apr 2001 12:58:55 -0400, Dave Smith wrote:

> Did you start the database server with the -i option?

Redhat scripts started the database. From vague memory there was an -i
in there.

I am now using this as an excuse to move up to 7.1RC4. So startup is on
the list of things to do. I'm tired, I've been working on this all day
so I think I'll go home soon.

I am very happy it is the first time I have managed to compile postgres
for years. With ant and java support no less!! Good word developpers!

Cheers

Tony Grant


--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html

Tony Grant wrote:

> I hope that I have the correct e-mail address configured now..
>
> --
>
> In my quest to connect Dreamweaver Ultradev to postgresql I have changed
> my application server in order to have easier access to the .conf files.
> Now running Tomcat/Apache.
>
> Ultradev connects to the application server but the JDBC connection
> times out. I am running 7.0.3 and have
> /usr/java/jdk1.3/jre/lib/ext/jdbc7.0-1.2.jar
>
> TIA for any usefull tips
>
> Cheers
>
> Tony Grant

Did you start the database server with the -i option?

Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
JDK1.3

I just don't have the patience to figure out what is going wrong here.

/usr/share/ant

Ant install made a /usr/share/java withe the jar files in it.

Java is installed on the machine as /usr/java/jdk1.3

    [javac] Note: Some input files use or override a deprecated API.
    [javac] Note: Recompile with -deprecation for details.
    [javac] 4 errors

is all that this gives me.

Hey guys it has to be easier than this the rest of the compile went
really well...


Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html

Tony Grant wrote:

> Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
> JDK1.3
>
> I just don't have the patience to figure out what is going wrong here.
>
> /usr/share/ant
>
> Ant install made a /usr/share/java withe the jar files in it.
>
> Java is installed on the machine as /usr/java/jdk1.3
>
>     [javac] Note: Some input files use or override a deprecated API.
>     [javac] Note: Recompile with -deprecation for details.
>     [javac] 4 errors
>
> is all that this gives me.
>
> Hey guys it has to be easier than this the rest of the compile went
> really well...

 From what you are describing, you should have warnings
rather than errors. You may actually be OK.

You need to copy the file
postgresql.jar to JAVA_HOME/jre/lib/ext/ if it has
been created. Simply ignore the deprecation msg's
and see whether you can connect to a sample database
using the driver.

Check the content of the jar file w/ jar tvf postgresql.jar
if the driver file is there but the connection fails.

Thanks,
HY

> In my quest to connect Dreamweaver Ultradev to postgresql I have changed
> my application server in order to have easier access to the .conf files.
> Now running Tomcat/Apache.

Update:

    - I have managed to compile my very own JDBC!!! I don't have a clue
    what I did right this time... Maybe the fact that I rebooted the
    server has something to do with it???

    - Ultradev sees and recognizes the org.postgresql.Driver in the
    local Macromedia folder but is still refusing to connect to the one
    on the application server. Running "test" locks up the Ultradev
    application.

Todays questions:

    - what should I be looking for to see if the Tomcat application
    server is correctly loading the jdbc driver?

    - how do I know that I have all the correct permissions set in order
    to connect to the database (pg_hba.conf is set to "trust"
    "everybody" on local network.

    - Ultradev is running on NT and connecting via "LAN" thus is using
    SMB and not TCP/IP is this an issue?

I am persisting as you see here. Next week I'll have to move on to other
things because this problem must be solved.

Cheers

Tony Grant


--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html