From: thhal at mailblocks.com (Thomas Hallgren)
Date: Wed, 20 Apr 2005 12:20:17 +0200
Subject: [Pljava-dev] java.lang.SecurityException
In-Reply-To: <2276557F1C7668499FF59EC75B84624FC7A6B3@salsa.cefriel.it>
References: <2276557F1C7668499FF59EC75B84624FC7A6B3@salsa.cefriel.it>
Message-ID: <42662CE1.4090102@mailblocks.com>

Luca Rasconi wrote:

> I wrote a litlle class test to see pljava in action. This class named 
> test.jar and the jar name used in the install routine is test_luca.
>
> My procedure is very simple:
>
> public class Test {
>
> public static String test() {
>
> String ret = "nu cazz!!!!!!!!";
>
> try {
>
> Class.forName("org.postgresql.Driver");
>
> String url = "jdbc:postgresql://myhost/mydb";
>
> Properties props = new Properties();
>
> props.setProperty("user", "user");
>
> props.setProperty("password", "password");
>
> Connection conn = DriverManager.getConnection(url, props);
>
> Statement s = conn.createStatement();
>
> int uid = 13;
>
> String _url = "some url";
>
> String sql = "insert into request(UID, url) values(" + uid + ", '" + 
> _url + "')";
>
> s.execute(sql);
>
> s.close();
>
> s = conn.createStatement();
>
> sql = "select * from request where uid = 13";
>
> ResultSet rs = s.executeQuery(sql);
>
> rs.first();
>
> ret = rs.getString(?url?);
>
> rs.close();
>
> conn.close();
>
> } catch (ClassNotFoundException e) {
>
> // TODO Auto-generated catch block
>
> ret = "non ho trovato la classe del dirver jdbc!!";
>
> //e.printStackTrace();
>
> } catch (SQLException e1) {
>
> ret = e1.getMessage();
>
> //e1.printStackTrace();
>
> }
>
> return ret;
>
> }
>
> }
>
> when I try to execute this is the result:
>
> SELECT test_luca();
>
> ERROR: java.lang.SecurityException: read on \C:\Program 
> Files\PostgreSQL\8.0\jdbc\postgresql-8.0-310.jdbc3.jar
>
> Some body can help me?
>
1) Don't use the PostgreSQL client jdbc driver inside of PL/Java since 
that will a) create a network connection to another PostgreSQL session 
and b) have a transaction-scope that is decoupled from the 
transaction-scope of the executing function. In order to obtain a 
connection, please do:

Connection conn = DriverManager.getConnection("jdbc.default.connection");

2) Never have anything but the pljava.jar in the postgresql.conf 
variable pljava.classpath or in the CLASSPATH env seen by the postmaster 
process . Jar files *must* be loaded using sqlj.install_jar

Regards,
Thomas Hallgren