[Pljava-dev] PL/JAVA on Windows

[Danny Gaethofs]

Eric,

I left out the spaces between program files because I
have all my programs installed in the directory
c:\programfiles\.

I created the environment variable CLASSPATH:
C:\ProgramFiles\PostgreSQL\8.0\jdbc\postgresql-8.0-310.jdbc2.jar;C:\ProgramFiles\PostgreSQL\8.0\pljava\deploy.jar

Now the deployer works, but I get another error. The
deployer needs a password to access the server. How
can I issue the password?

java org.postgresql.pljava.deploy.Deployer -install
postgresql.util.PSQLException: The server requested
password-based authentic
n, but no password was provided.
    at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Connect
actoryImpl.java:325)
    at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
nFactoryImpl.java:94)
    at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor
va:65)
    at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Conn
on.java:117)
    at
org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.java:24)
    at org.postgresql.Driver.connect(Driver.java:235)
    at java.sql.DriverManager.getConnection(Unknown
Source)
    at java.sql.DriverManager.getConnection(Unknown
Source)
    at
org.postgresql.pljava.deploy.Deployer.main(Deployer.java:259)



regards,
Danny

--- Eric E <whalesuit at bonbon.net> wrote:

> Hi Danny,  
>     A couple questions:
>     1) When you invoke java by itself in your
> command prompt, does it 
> run?  java should give you its list of options.
>     2) Did you make modifications to your user path,
> or to the system 
> path?  Changes need to be to the system path, so
> that the postgres 
> service is aware of them when it starts.
>     3) Have you defined CLASSPATH in your install
> environment?  For 
> installation, CLASSPATH needs to contain deploy.jar,
> as well as the jdbc 
> driver of your choice, found in C:\Program
> Files\PostgreSQL\8.0\jdbc. 
> 
> Once you've done that, running:
> 
> java org.postgresql.pljava.deploy.Deployer
> 
> should give the list of options as specified in the
> deployment instructions.
> 
> Also, it looks like you removed spaces from "Program
> Files" in a couple places - check that this is not
> the cause of your problem:
> C:\ProgramFiles\PostgreSQL\8.0\pljava
> 
> 
> Hope some of that helps.
> 
> Cheers,
> 
> Eric
> 
> Danny Gaethofs wrote:
> 
> >Dear all,
> >
> >I have been reading the different mails about
> >installing PL/Java on Postgres under Windows Xp.
> >
> >It is still not clear what exactly needs to be
> done.
> >Let me explain the steps I took till I got
> stranded.
> >
> >I am running java 1.5 with JAVA_HOME at C:\Program
> >Files\Java\jre1.5.0_02.
> >
> >My path is defined as follows:
>
>%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\ProgramFiles\apache-ant-1.6.5\bin
> >
> >Step 1: Download and install PostgreSQL
> >Install the data directory on e:
> >Install the software on c:
> >Do not forget to Install Procedural Language
> >(pl/pgsql)
> >
> >
> >Step 2: Download and install PLJAVA
> >- Download pljava from the website 
> >
> >- Create a directory PLJAVA under
> >C:\ProgramFiles\PostgreSQL\8.0\pljava
> >
> >- Extract the content of the file into this
> directory.
> >
> >- Edit the contents of the postgresql.conf file
> which
> >can be found in the \data directory.
> >
> >Added the following lines:
> >custom_variable_classes = 'pljava'
> >pljava.classpath =
> >'C:\ProgramFiles\PostgreSQL\8.0\pljava\pljava.jar'
> >
> >pljava.statement_cache_size = 10
> >
> >pljava.release_lingering_savepoints = true
> >
> >pljava.vmoptions = '-Xmx64M'
> >
> >pljava.debug = false
> >
> >dynamic_library_path =
> >'$libdir:C:\\ProgramFiles\\PostgreSQL\\8.0\\pljava'
> >
> >log_min_messages = info
> >
> >Step 3:  Deploy the PL/JAVA
> >Now I should deploy the PL/Java but it is not clear
> to
> >me how this should be done. I read something about
> >executing this command: 
> >java org.postgresql.pljava.deploy.Deployer
> >
> >But when I do so nothing happens.
> >Can anyone help me out here, what steps am I
> missing.
> >
> >regards,
> >Danny
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> >http://mail.yahoo.com 
> >_______________________________________________
> >Pljava-dev mailing list
> >Pljava-dev at gborg.postgresql.org
>
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >
> >
> >  
> >
> 
> 
> 
> 



		
__________________________________ 
Discover Yahoo! 
Stay in touch with email, IM, photo sharing and more. Check it out! 
http://discover.yahoo.com/stayintouch.html