agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Problem with PL/Java installation
9+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Problem with PL/Java installation
@ 2006-01-24 08:50
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-01-24 08:50 UTC (permalink / raw)
Hi,
The settings in my postgresql.conf is as follows :
pljava.classpath='C:\\PostgreSQL\\share\\pljava\\pljava.jar'
dynamic_library_path = '$libdir;C:\\PostgreSQL\\lib'
Here is the error that I got at DOS command prompt :
C:\>java org.postgresql.pljava.deploy.Deployer -install -database
metaphysics -u
ser postgres -password pncs6601
org.postgresql.util.PSQLException: ERROR: could not load library
"C:/PostgreSQL/
lib/libpljava.dll": Access is denied.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:332)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:324)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
432)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
C:\>echo %CLASSPATH%
C:\PostgreSQL\share\pljava\deploy.jar;C:\PostgreSQL\jdbc\postgresql-8.1-
404.jdbc
2.jar;C:\PostgreSQL\share\pljava\pljava.jar
C:\>echo %PATH%
D:\Oracle\product\10.1.0\Client_1\bin;D:\Oracle\product\10.1.0\Client_1\
jre\1.4.
2\bin\client;D:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin;C:\WINDOWS\
system32
;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
Files\Java\jre1.5.0_06\bin\clien
t;C:\Program Files\Java\jre1.5.0_06\bin;C:\PostgreSQL\bin
Could you advise what went wrong ?
Best regards
Patrick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060124/66f76d99/attachment.html;
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-01-24 09:49
parent:
0 siblings, 0 replies; 9+ messages in thread
From: @ 2006-01-24 09:49 UTC (permalink / raw)
Patrick,
There are normally two accounts involved, your client account that
executes the command at the DOS prompt and the account that runs the
PostgreSQL postmaster service (or standalone process depending on your
configuration).
The two accounts need different settings. I guess the settings that you
echo are only related to the first account (client).
The client account should not have a CLASSPATH that includes pljava.jar
since the classes contained therein are solely for execution in the
server. The PATH of the client account should not include the <jre
home>\bin\client and <jre home>\bin paths. Those are only used by the
server.
The server account should normally not have a CLASSPATH at all besides
the one noted in your postgresql.conf file.
The PATH setting of the server account is the one that must include <jre
home>\bin\client and <jre home>\bin paths.
I would strongly advice you to remove any references to the Oracle jre
from both PATH's.
Finally, verify that your server account have permission to execute the
libpljava.dll.
Regards,
Thomas Hallgren
Patrick Ng wrote:
>
> Hi,
>
>
>
> The settings in my postgresql.conf is as follows :
>
>
>
> pljava.classpath='C:\\PostgreSQL\\share\\pljava\\pljava.jar'
>
>
>
> dynamic_library_path = '$libdir;C:\\PostgreSQL\\lib'
>
>
>
> Here is the error that I got at DOS command prompt :
>
>
>
> C:\>java org.postgresql.pljava.deploy.Deployer -install -database
> metaphysics -u
>
> ser postgres -password pncs6601
>
> org.postgresql.util.PSQLException: ERROR: could not load library
> "C:/PostgreSQL/
>
> lib/libpljava.dll": Access is denied.
>
>
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
>
> ecutorImpl.java:1512)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
>
> Impl.java:1297)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>
> va:188)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>
> ement.java:430)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
>
> Jdbc2Statement.java:332)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>
> ement.java:324)
>
> at
> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
>
> 432)
>
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
>
>
> C:\>echo %CLASSPATH%
>
> C:\PostgreSQL\share\pljava\deploy.jar;C:\PostgreSQL\jdbc\postgresql-8.1-404.jdbc
>
> 2.jar;C:\PostgreSQL\share\pljava\pljava.jar
>
>
>
> C:\>echo %PATH%
>
> D:\Oracle\product\10.1.0\Client_1\bin;D:\Oracle\product\10.1.0\Client_1\jre\1.4.
>
> 2\bin\client;D:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin;C:\WINDOWS\system32
>
> ;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
> Files\Java\jre1.5.0_06\bin\clien
>
> t;C:\Program Files\Java\jre1.5.0_06\bin;C:\PostgreSQL\bin
>
>
>
>
>
> Could you advise what went wrong ?
>
>
>
> Best regards
>
>
>
> Patrick
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-01-25 02:25
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-01-25 02:25 UTC (permalink / raw)
Hey,
Thanks a lot for the explanation. It sure out things in very clear
perspective.
Anyway, I was running the client and server within the same PC so the
settings for CLASSPATH and PATH didn't really matter (but still, the
explanation above makes me see things in a different light)
I took all the ORACLE stuff out from the PATH setting. It worked.
Thanks a lot.
Btw : I am new to PL/Java. Can you point me to some site /book where
there are examples that show PL/Java in PostgreSQL in action.
Thanks alot
-----Original Message-----
From: Thomas Hallgren [mailto:thomas at tada.se]
Sent: Tuesday, January 24, 2006 5:50 PM
To: Patrick Ng
Cc: pljava-dev at gborg.postgresql.org
Subject: Re: [Pljava-dev] Problem with PL/Java installation
Patrick,
There are normally two accounts involved, your client account that
executes the command at the DOS prompt and the account that runs the
PostgreSQL postmaster service (or standalone process depending on your
configuration).
The two accounts need different settings. I guess the settings that you
echo are only related to the first account (client).
The client account should not have a CLASSPATH that includes pljava.jar
since the classes contained therein are solely for execution in the
server. The PATH of the client account should not include the <jre
home>\bin\client and <jre home>\bin paths. Those are only used by the
server.
The server account should normally not have a CLASSPATH at all besides
the one noted in your postgresql.conf file.
The PATH setting of the server account is the one that must include <jre
home>\bin\client and <jre home>\bin paths.
I would strongly advice you to remove any references to the Oracle jre
from both PATH's.
Finally, verify that your server account have permission to execute the
libpljava.dll.
Regards,
Thomas Hallgren
Patrick Ng wrote:
>
> Hi,
>
>
>
> The settings in my postgresql.conf is as follows :
>
>
>
> pljava.classpath='C:\\PostgreSQL\\share\\pljava\\pljava.jar'
>
>
>
> dynamic_library_path = '$libdir;C:\\PostgreSQL\\lib'
>
>
>
> Here is the error that I got at DOS command prompt :
>
>
>
> C:\>java org.postgresql.pljava.deploy.Deployer -install -database
> metaphysics -u
>
> ser postgres -password pncs6601
>
> org.postgresql.util.PSQLException: ERROR: could not load library
> "C:/PostgreSQL/
>
> lib/libpljava.dll": Access is denied.
>
>
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
>
> ecutorImpl.java:1512)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
>
> Impl.java:1297)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>
> va:188)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>
> ement.java:430)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
>
> Jdbc2Statement.java:332)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>
> ement.java:324)
>
> at
> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
>
> 432)
>
> at
org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
>
>
> C:\>echo %CLASSPATH%
>
>
C:\PostgreSQL\share\pljava\deploy.jar;C:\PostgreSQL\jdbc\postgresql-8.1-
404.jdbc
>
> 2.jar;C:\PostgreSQL\share\pljava\pljava.jar
>
>
>
> C:\>echo %PATH%
>
>
D:\Oracle\product\10.1.0\Client_1\bin;D:\Oracle\product\10.1.0\Client_1\
jre\1.4.
>
>
2\bin\client;D:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin;C:\WINDOWS\
system32
>
> ;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
> Files\Java\jre1.5.0_06\bin\clien
>
> t;C:\Program Files\Java\jre1.5.0_06\bin;C:\PostgreSQL\bin
>
>
>
>
>
> Could you advise what went wrong ?
>
>
>
> Best regards
>
>
>
> Patrick
>
>
>
>
------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System.
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-01-25 07:11
parent:
0 siblings, 0 replies; 9+ messages in thread
From: @ 2006-01-25 07:11 UTC (permalink / raw)
Patrick,
Download the source bundle. You'll find some examples there that you can
try out. There's a special make target 'test_all' that will create the
tests. Also read the secion "Run the example tests" in
http://gborg.postgresql.org/project/pljava/genpage.php?readme
The user guide
http://gborg.postgresql.org/project/pljava/genpage.php?userguide is of
course also a good source for information.
Regards,
Thomas Hallgren
Patrick Ng wrote:
> Hey,
>
> Thanks a lot for the explanation. It sure out things in very clear
> perspective.
>
> Anyway, I was running the client and server within the same PC so the
> settings for CLASSPATH and PATH didn't really matter (but still, the
> explanation above makes me see things in a different light)
>
> I took all the ORACLE stuff out from the PATH setting. It worked.
>
> Thanks a lot.
>
> Btw : I am new to PL/Java. Can you point me to some site /book where
> there are examples that show PL/Java in PostgreSQL in action.
>
> Thanks alot
>
> -----Original Message-----
> From: Thomas Hallgren [mailto:thomas at tada.se]
> Sent: Tuesday, January 24, 2006 5:50 PM
> To: Patrick Ng
> Cc: pljava-dev at gborg.postgresql.org
> Subject: Re: [Pljava-dev] Problem with PL/Java installation
>
> Patrick,
> There are normally two accounts involved, your client account that
> executes the command at the DOS prompt and the account that runs the
> PostgreSQL postmaster service (or standalone process depending on your
> configuration).
>
> The two accounts need different settings. I guess the settings that you
> echo are only related to the first account (client).
>
> The client account should not have a CLASSPATH that includes pljava.jar
> since the classes contained therein are solely for execution in the
> server. The PATH of the client account should not include the <jre
> home>\bin\client and <jre home>\bin paths. Those are only used by the
> server.
>
> The server account should normally not have a CLASSPATH at all besides
> the one noted in your postgresql.conf file.
> The PATH setting of the server account is the one that must include <jre
>
> home>\bin\client and <jre home>\bin paths.
>
> I would strongly advice you to remove any references to the Oracle jre
> from both PATH's.
>
> Finally, verify that your server account have permission to execute the
> libpljava.dll.
>
> Regards,
> Thomas Hallgren
>
>
> Patrick Ng wrote:
>
>> Hi,
>>
>>
>>
>> The settings in my postgresql.conf is as follows :
>>
>>
>>
>> pljava.classpath='C:\\PostgreSQL\\share\\pljava\\pljava.jar'
>>
>>
>>
>> dynamic_library_path = '$libdir;C:\\PostgreSQL\\lib'
>>
>>
>>
>> Here is the error that I got at DOS command prompt :
>>
>>
>>
>> C:\>java org.postgresql.pljava.deploy.Deployer -install -database
>> metaphysics -u
>>
>> ser postgres -password pncs6601
>>
>> org.postgresql.util.PSQLException: ERROR: could not load library
>> "C:/PostgreSQL/
>>
>> lib/libpljava.dll": Access is denied.
>>
>>
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
>>
>> ecutorImpl.java:1512)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
>>
>> Impl.java:1297)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>>
>> va:188)
>>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>>
>> ement.java:430)
>>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
>>
>> Jdbc2Statement.java:332)
>>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
>>
>> ement.java:324)
>>
>> at
>> org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
>>
>> 432)
>>
>> at
>>
> org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
>
>>
>>
>> C:\>echo %CLASSPATH%
>>
>>
>>
> C:\PostgreSQL\share\pljava\deploy.jar;C:\PostgreSQL\jdbc\postgresql-8.1-
> 404.jdbc
>
>> 2.jar;C:\PostgreSQL\share\pljava\pljava.jar
>>
>>
>>
>> C:\>echo %PATH%
>>
>>
>>
> D:\Oracle\product\10.1.0\Client_1\bin;D:\Oracle\product\10.1.0\Client_1\
> jre\1.4.
>
>>
> 2\bin\client;D:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin;C:\WINDOWS\
> system32
>
>> ;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
>> Files\Java\jre1.5.0_06\bin\clien
>>
>> t;C:\Program Files\Java\jre1.5.0_06\bin;C:\PostgreSQL\bin
>>
>>
>>
>>
>>
>> Could you advise what went wrong ?
>>
>>
>>
>> Best regards
>>
>>
>>
>> Patrick
>>
>>
>>
>>
>>
> ------------------------------------------------------------------------
>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>>
>>
>
>
> ________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email
> Security System.
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-02-06 03:06
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-02-06 03:06 UTC (permalink / raw)
Hi,
I have encountered a very strange problem with running PL/Java on
Windows.
I wrote a Java class :
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.security.*;
public class plj_miscellaneous
{
private static String jdbc_url = "jdbc:default:connection";
// use loopback jdbc driver
public static boolean chkDupRecordExistsErrorsTable( String
p_program_name,
String p_record_info,
String p_error_code,
String p_error_description,
String p_status,
String p_created_by ) throws
SQLException
{
Connection conn = DriverManager.getConnection( jdbc_url );
String query = "SELECT COUNT(*) FROM METAHSIA.ERRORS WHERE
PROGRAM_NAME = ? AND RECORD_INFO = ? AND ERROR_CODE = ? AND
ERROR_DESCRIPTION = ? AND (STATUS = ? OR STATUS = 'MAILED') AND
CREATED_BY = ?";
PreparedStatement stmt = conn.prepareStatement( query );
stmt.setString( 1, p_program_name );
stmt.setString( 2, p_record_info );
stmt.setString( 3, p_error_code );
stmt.setString( 4, p_error_description );
stmt.setString( 5, p_status );
stmt.setString( 6, p_created_by );
ResultSet rs = stmt.executeQuery();
rs.next();
int count = rs.getInt( "count" );
stmt.close();
conn.close();
if (count > 0)
return( true );
else
return( false );
}
public static int updateBatchTotals( String p_program_name,
String p_processed_status,
Integer p_number_processed ) throws
SQLException
{
Connection conn = DriverManager.getConnection( jdbc_url );
int v_status = 0;
try {
Statement st = conn.createStatement();
String v_passed = "P";
String v_errors = "E";
if (p_processed_status.equals(v_passed)) {
st.executeUpdate("INSERT INTO METAHSIA.BATCH_TOTALS
(PROGRAM_NAME, TOTAL_PROCESSED, STATUS, CREATED_BY, CREATED_ON) " +
"VALUES ('" + p_program_name +
"', " + p_number_processed +
", 'CREATED', '" + p_program_name +
"', CURRENT_DATE)");
} else if (p_processed_status.equals(v_errors)) {
st.executeUpdate("INSERT INTO METAHSIA.BATCH_TOTALS
(PROGRAM_NAME, TOTAL_ERRORS, STATUS, CREATED_BY, CREATED_ON) " +
"VALUES ('" + p_program_name +
"', " + p_number_processed +
", 'CREATED', '" + p_program_name +
"', CURRENT_DATE)");
}
} catch (Exception e) {
System.err.println("updateBatchTotals Catch : ");
System.err.println(e.getMessage());
v_status = -1;
} finally {
if (conn != null) {
conn.close();
}
else {
System.out.println( "finally : DB connection not opened, no
closing done" );
}
return( v_status );
}
}
public static String checkTableColumnDataType( String p_owner_name,
String p_schema_name,
String p_table_name,
String p_column_name )
throws SQLException
{
Connection conn = DriverManager.getConnection( jdbc_url );
String query = "SELECT D.TYPNAME FROM PG_TABLES A, PG_CLASS B,
PG_ATTRIBUTE C, PG_TYPE D WHERE A.TABLEOWNER = ? AND A.SCHEMANAME = ?
AND A.TABLENAME = ? AND C.ATTNAME = ? AND A.TABLENAME = B.RELNAME AND
B.OID = C.ATTRELID AND C.ATTTYPID = D.OID ORDER BY A.TABLENAME,
C.ATTNAME";
PreparedStatement stmt = conn.prepareStatement( query );
String v_ret_string = null;
try {
stmt.setString( 1, p_owner_name.toLowerCase() );
stmt.setString( 2, p_schema_name.toLowerCase() );
stmt.setString( 3, p_table_name.toLowerCase() );
stmt.setString( 4, p_column_name.toLowerCase() );
ResultSet rs = stmt.executeQuery();
rs.next();
v_ret_string = rs.getString(1);
stmt.close();
conn.close();
} catch (Exception e) {
v_ret_string = "checkTableColumnDataType Catch : " +
e.getMessage();
} finally {
if (conn != null) {
conn.close();
}
else {
System.out.println( "finally : DB connection not opened, no
closing done" );
}
if (stmt != null) {
stmt.close();
}
else {
System.out.println( "finally : PreparedStatement not opened, no
closing done" );
}
return( v_ret_string );
}
}
}
which compiles beautifully and generates the jar file in
D:\FengShui\Project-LightSabre\PL-Java\plj_miscellaneous.jar
I then run this :
select
sqlj.install_jar('file:///D:/FengShui/Project-LightSabre/PL-Java/plj_mis
cellaneous.jar', 'plj_miscellaneous', true);
select sqlj.set_classpath('metahsia', 'plj_miscellaneous');
CREATE OR REPLACE FUNCTION metahsia.chkDupRecordExistsErrorsTable(
TEXT,TEXT,TEXT,TEXT,TEXT,TEXT ) RETURNS BOOLEAN AS
'plj_miscellaneous.chkDupRecordExistsErrorsTable(
java.lang.String,java.lang.String,java.lang.String,java.lang.String,java
.lang.String,java.lang.String )'
LANGUAGE java;
CREATE OR REPLACE FUNCTION metahsia.updateBatchTotals( TEXT,TEXT,INTEGER
) RETURNS INTEGER AS
'plj_miscellaneous.updateBatchTotals(
java.lang.String,java.lang.String,java.lang.Integer )'
LANGUAGE java;
CREATE OR REPLACE FUNCTION metahsia.checkTableColumnDataType(
TEXT,TEXT,TEXT,TEXT ) RETURNS TEXT AS
'plj_miscellaneous.checkTableColumnDataType(
java.lang.String,java.lang.String,java.lang.String,java.lang.String )'
LANGUAGE java;
while login using psql.
In sqlj schema, I can find the following tables :
classpath_entry - which contains the values
jar_entry - which contains the values
jar_repository - which contains the values
At psql prompt, when I do a :
select metahsia.checktablecolumndatatype('hsia', 'metahsia', 'usr',
'password');
I keep getting
ERROR: java.lang.ClassNotFoundException: plj_miscellaneous
However, these 3 tables' values seem correct.
Do u have any idea why this is so? Is it a bug with PostgreSQL?
Best regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060206/0403ad46/attachment.html;
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 9911 bytes
Desc: image001.jpg
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060206/0403ad46/attachment.jpg;
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 9887 bytes
Desc: image002.jpg
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060206/0403ad46/attachment-0001.jpg;
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 11409 bytes
Desc: image003.jpg
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060206/0403ad46/attachment-0002.jpg;
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-02-06 07:30
parent:
0 siblings, 0 replies; 9+ messages in thread
From: @ 2006-02-06 07:30 UTC (permalink / raw)
Patrick,
At present, PL/Java will not allow use of default package. You must put
your class in a named package.
Regards,
Thomas Hallgren
Patrick Ng wrote:
>
> Hi,
>
> I have encountered a very strange problem with running PL/Java on Windows.
>
> I wrote a Java class
>
> ...
>
>
> I keep getting
>
> ERROR: java.lang.ClassNotFoundException: plj_miscellaneous
>
> However, these 3 tables? values seem correct.
>
> Do u have any idea why this is so? Is it a bug with PostgreSQL?
>
> Best regards
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-02-07 03:34
0 siblings, 1 reply; 9+ messages in thread
From: @ 2006-02-07 03:34 UTC (permalink / raw)
Er....
Sorrie. What's a named package? Any examples on this?
I can't find any mention of this in the user guide for PL/Java.
Best regards
-----Original Message-----
From: Thomas Hallgren [mailto:thomas at tada.se]
Sent: Monday, February 06, 2006 3:31 PM
To: Patrick Ng
Cc: PL/Java Development
Subject: Re: [Pljava-dev] Problem with PL/Java installation
Patrick,
At present, PL/Java will not allow use of default package. You must put
your class in a named package.
Regards,
Thomas Hallgren
Patrick Ng wrote:
>
> Hi,
>
> I have encountered a very strange problem with running PL/Java on
Windows.
>
> I wrote a Java class
>
> ...
>
>
> I keep getting
>
> ERROR: java.lang.ClassNotFoundException: plj_miscellaneous
>
> However, these 3 tables' values seem correct.
>
> Do u have any idea why this is so? Is it a bug with PostgreSQL?
>
> Best regards
>
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System.
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-02-07 07:34
parent:
0 siblings, 0 replies; 9+ messages in thread
From: @ 2006-02-07 07:34 UTC (permalink / raw)
Patrick,
I think I expressed myself a bit cryptic. I mean that you start your
java source file with:
package x.y;
and you let it reside in directory x/y/. The full name of your class
will now be 'x.y.plj_miscellaneous'. Using the default package (i.e.
omitting the package directive) is considered bad practice.
Regards,
Thomas Hallgren
Patrick Ng wrote:
> Er....
>
> Sorrie. What's a named package? Any examples on this?
>
> I can't find any mention of this in the user guide for PL/Java.
>
> Best regards
>
> -----Original Message-----
> From: Thomas Hallgren [mailto:thomas at tada.se]
> Sent: Monday, February 06, 2006 3:31 PM
> To: Patrick Ng
> Cc: PL/Java Development
> Subject: Re: [Pljava-dev] Problem with PL/Java installation
>
> Patrick,
> At present, PL/Java will not allow use of default package. You must put
> your class in a named package.
>
> Regards,
> Thomas Hallgren
>
> Patrick Ng wrote:
>
>> Hi,
>>
>> I have encountered a very strange problem with running PL/Java on
>>
> Windows.
>
>> I wrote a Java class
>>
>> ...
>>
>>
>> I keep getting
>>
>> ERROR: java.lang.ClassNotFoundException: plj_miscellaneous
>>
>> However, these 3 tables' values seem correct.
>>
>> Do u have any idea why this is so? Is it a bug with PostgreSQL?
>>
>> Best regards
>>
>>
>
>
> ________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email
> Security System.
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* [Pljava-dev] Problem with PL/Java installation
@ 2006-02-07 07:56
0 siblings, 0 replies; 9+ messages in thread
From: @ 2006-02-07 07:56 UTC (permalink / raw)
Hi Thomas,
Oh I see. The java package.
Thanks & best regards
-----Original Message-----
From: Thomas Hallgren [mailto:thomas at tada.se]
Sent: Tuesday, February 07, 2006 3:34 PM
To: Patrick Ng
Cc: PL/Java Development
Subject: Re: [Pljava-dev] Problem with PL/Java installation
Patrick,
I think I expressed myself a bit cryptic. I mean that you start your
java source file with:
package x.y;
and you let it reside in directory x/y/. The full name of your class
will now be 'x.y.plj_miscellaneous'. Using the default package (i.e.
omitting the package directive) is considered bad practice.
Regards,
Thomas Hallgren
Patrick Ng wrote:
> Er....
>
> Sorrie. What's a named package? Any examples on this?
>
> I can't find any mention of this in the user guide for PL/Java.
>
> Best regards
>
> -----Original Message-----
> From: Thomas Hallgren [mailto:thomas at tada.se]
> Sent: Monday, February 06, 2006 3:31 PM
> To: Patrick Ng
> Cc: PL/Java Development
> Subject: Re: [Pljava-dev] Problem with PL/Java installation
>
> Patrick,
> At present, PL/Java will not allow use of default package. You must
put
> your class in a named package.
>
> Regards,
> Thomas Hallgren
>
> Patrick Ng wrote:
>
>> Hi,
>>
>> I have encountered a very strange problem with running PL/Java on
>>
> Windows.
>
>> I wrote a Java class
>>
>> ...
>>
>>
>> I keep getting
>>
>> ERROR: java.lang.ClassNotFoundException: plj_miscellaneous
>>
>> However, these 3 tables' values seem correct.
>>
>> Do u have any idea why this is so? Is it a bug with PostgreSQL?
>>
>> Best regards
>>
>>
>
>
>
________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email
> Security System.
>
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System.
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-02-07 07:56 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-24 08:50 [Pljava-dev] Problem with PL/Java installation
2006-01-24 09:49 `
2006-01-25 02:25 [Pljava-dev] Problem with PL/Java installation
2006-01-25 07:11 `
2006-02-06 03:06 [Pljava-dev] Problem with PL/Java installation
2006-02-06 07:30 `
2006-02-07 03:34 [Pljava-dev] Problem with PL/Java installation
2006-02-07 07:34 `
2006-02-07 07:56 [Pljava-dev] Problem with PL/Java installation
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox