From: dgaethofs at yahoo.com (Danny Gaethofs)
Date: Thu, 16 Jun 2005 08:39:12 -0700 (PDT)
Subject: [Pljava-dev] PL/JAVA on Windows
In-Reply-To: <thhal-0KiGNA8vSzjY3Kvc0n05U2XaqRBorvC@mailblocks.com>
Message-ID: <20050616153912.82077.qmail@web54701.mail.yahoo.com>

Thomas,

Thanks, I was not aware of the fact that errors in the
postgresql.conf file could cause this.

Found two errors and corrected these. Changed the
classpath.

Problem is over solved. Thanks a lot for your support
Thomas. I managed to get it working and can see 3
languages now in pgadminiii for my database.

I will write down my steps and send them to you later.
Hopefully others can benefit from them.

regards,
Danny



--- Thomas Hallgren <thhal at mailblocks.com> wrote:

> Danny,
> My only recommendation is that you take a look in
> the server log. 
> Perhaps there's some indication on what's going
> wrong. A syntax error 
> somewhere in the postgresql.conf doesn't seem too
> far fetched.
> 
> One thing that I can see right away looking more
> closely is that you now 
> have single backslashes in your pljava.classpath.
> PostgreSQL uses 
> backslash as an escape character so all windows
> paths must use double 
> backslash. You did have that earlier in the
> dynamic_library_path. 
> Samething goes for the pljava.classpath.
> 
> Regards,
> Thomas Hallgren
> 
> Danny Gaethofs wrote:
> 
> >Dear Thomas,
> >
> >Definitely these lines of code are causing the
> >problem. Last day when I was working on getting
> pljava
> >installed I did not stop the server when making the
> >changes to the postgresql.conf file.
> >
> >Later the evening when I rebooted my machine I got
> the
> >same error which I could not explain. So I
> completely
> >reinstalled postgresql and the problem was over. 
> >
> >Today I restarted the installation of pljava and
> there
> >it was again the strange error.
> >
> >When I stop the server, change my postgresql.conf
> and
> >remove these lines of code, start the server, start
> >pgadminiii, I can access my database.
> >
> >When I stop the server, put lines of code in the
> >postgresql.conf, start the server, it is no longer
> >possible to open the connection in pgadminiii.
> >
> >With the error message mentioned. 
> >
> >After your reply I did shut down the server and
> added
> >the lines of code. Then I rebooted my machine, and
> did
> >the same test. It is giving me the same results.
> >
> >So please help me out identifying what the problem
> is.
> >
> >
> >Regards,
> >Danny
> >
> >--- Thomas Hallgren <thhal at mailblocks.com> wrote:
> >
> >  
> >
> >>Danny,
> >>I'm sorry, but there's just no way there can be a
> >>correlation between 
> >>the error you get and the lines you claim you
> >>remove. There must be 
> >>something else that you overlook. My guess is that
> >>the port is busy due 
> >>to TCP/IP lingering a while after the old server
> >>closed down.
> >>
> >>And yes, lots of people use PL/Java succesfully on
> >>Windows XP.
> >>
> >>Regards,
> >>Thomas Hallgren
> >>
> >>Danny Gaethofs wrote:
> >>
> >>    
> >>
> >>>Dear Thomas,
> >>>
> >>>After stopping the postgresql server and
> restarting
> >>>it, I am no longer able to open the server
> >>>      
> >>>
> >>connection
> >>    
> >>
> >>>in pgadminiii. The message I get is:
> >>>could not connect to server: Connection refused
> >>>(0x0000274D/10061)
> >>>Is the server running on host "127.0.0.1" and
> >>>accepting TCP/IP connections on port 5432?
> >>>
> >>>When I remove these lines from my postgresql.conf
> >>>      
> >>>
> >>it
> >>    
> >>
> >>>works again.
> >>>
> >>>      
> >>>
>
>>---------------------------------------------------------------------------
> >>    
> >>
> >>># PLJAVA - 13-05-06
> >>>      
> >>>
>
>>#---------------------------------------------------------------------------
> >>    
> >>
> >>># define "pljava" as a custom variable class.
> This
> >>>      
> >>>
> >>is
> >>    
> >>
> >>>a comma separated
> >>># list of names.
> >>>#
> >>>custom_variable_classes = 'pljava'
> >>>
> >>># define the class path that the JVM will use
> when
> >>>loading the
> >>># initial library. Only meaningful for non GJC
> >>>installations
> >>>#
> >>>#old pljava.classpath =
> >>>'/home/Tada/pljava/build/pljava.jar'
> >>>pljava.classpath =
>
>>>'C:\ProgramFiles\PostgreSQL\8.0\pljava\pljava.jar'
> >>>
> >>># Set the size of the prepared statement MRU
> cache
> >>>#
> >>>pljava.statement_cache_size = 10
> >>>
> >>># If true, lingering savepoints will be released
> on
> >>>function exit. If false,
> >>># the will be rolled back
> >>>#
> >>>pljava.release_lingering_savepoints = true
> >>>
> >>># Define startup options for the Java VM.
> >>>#
> >>>pljava.vmoptions = '-Xmx64M'
> >>>
> >>># Setting debug to true will cause the postgres
> >>>process to go
> >>># into a sleep(1) loop on its first call to java.
> >>>      
> >>>
> >>This
> >>    
> >>
> >>>is
> >>># only useful if you want to debug the PL/Java
> >>>internal C code.
> >>>#
> >>>pljava.debug = false
> >>>
> >>>
> >>>I thought installing pljava would be easy?
> >>>Has anyone succeeded doing it on windows xp?
> >>>
> >>>regards,
> >>>Danny
> >>>
> >>>--- Thomas Hallgren <thhal at mailblocks.com> wrote:
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >>>>Danny Gaethofs wrote:
> >>>>
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>>>After defining the CLASSPATH as an user
> >>>>>          
> >>>>>
> >>environment
> >>    
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com