agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Errors running pljava test
Date: Thu, 08 Sep 2005 14:57:47 +0800
Message-ID: <431FE0EB.5070601@tokuii.com> (raw)
In-Reply-To: <thhal-0cHH7A5PG8LQxk2Nv1nWW2ejTEXji1F@mailblocks.com>
References: <431FBC71.5060803@tokuii.com>
<431FD8ED.9050502@mailblocks.com>
<thhal-0cHH7A5PG8LQxk2Nv1nWW2ejTEXji1F@mailblocks.com>
Hi Thomas,
Thanks a lot for clarifying. The previous problem was indeed due to
JDBC driver. I downloaded jdbc3 and I also needed to add an overloaded
sqlj.replace_jar (CREATE FUNCTION sqlj.replace_jar(BYTEA, VARCHAR,
BOOLEAN) RETURNS void")) in Deployer.java in order to build the test.
There is one other thing I observed while running pljava test:
- Before running pljava test, postgresql \z command listed all tables in
my DB: username_test, mdt, employees1, and employees2.
- After running pljava test, postgresql \z command DID NOT list any of
these tables, and I could not access to these tables.
pljava test did hang. I had been waiting for 10 minutes. The following
is the on-screeen output while running pljava test:
=============================================================
java org.postgresql.pljava.test.Tester -database kstiandb -user postgres
*** testTimestamp()
Timestamp = 2005-09-08 14:51:41.226, Timestamptz = 2005-09-08 14:51:41.226
*** testInt()
54 + 2 = 56
nullOnEven(1) = 1
nullOnEven(2) = null
*** testInsertUsernameTrigger()
Name = "nothing", username = "thomas"
Name = "null", username = "postgres"
Name = "empty string", username = ""
Name = "space", username = " "
Name = "tab", username = " "
Name = "name", username = "name"
*** testModdatetimeTrigger()
Id = "1", idesc = "first", moddate = "2005-09-08 14:51:40.852818"
Id = "2", idesc = "second", moddate = "2005-09-08 14:51:40.854792"
Id = "3", idesc = "third", moddate = "2005-09-08 14:51:40.856547"
Id = "4", idesc = "first", moddate = "2005-09-08 14:51:41.724"
Id = "5", idesc = "second", moddate = "2005-09-08 14:51:41.78"
Id = "6", idesc = "third", moddate = "2005-09-08 14:51:41.788"
*** testSPIActions()
Id = "3", name = "Rebecka Shawn", salary = "30000"
Id = "4", name = "Priscilla Johnson", salary = "25000"
*** testComplexReturn()
Base = "1", incbase = "6", ctime = "2005-09-08 14:51:41.1"
*** testSetReturn()
Base = "1", incbase = "1", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "6", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "11", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "16", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "21", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "26", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "31", ctime = "2005-09-08 14:51:41.158"
Base = "1", incbase = "36", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "41", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "46", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "51", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "56", ctime = "2005-09-08 14:51:41.16"
*** testCallInCall()
Max = "10"
*** testCurrentDir()
Server directory = /var/lib/postgresql/data/base/102676
*** testUsingProperties()
Name = "first.example.property", value = "1"
Name = "third.example.property", value = ""Hmm, take a guess. Could it
be three?""
Name = "second.example.property", value = "two"
*** testUsingScalarProperties()
first.example.property = 1
third.example.property = "Hmm, take a guess. Could it be three?"
second.example.property = two
*** testUsingResultSetProperties()
Name = "first.example.property", value = "1"
Name = "third.example.property", value = ""Hmm, take a guess. Could it
be three?""
Name = "second.example.property", value = "two"
*** testSavepointSanity()
Savepoint sanity = 1
*** testTrustedSecurity()
OK, creation of temp file was *unsuccessful* as it should be
*** testUntrustedSecurity()
Name of created temp file = /tmp/pljava23491.test
*** testBinaryColumns()
============================================================
There was no more printout after "*** testBinaryColumns()".
Thank yo so much for help to resolve this.
Regards,
Kong
Thomas Hallgren wrote:
> The first test you run tests the security. The error you get is proof
> that the security works. Other tests are jogging the meta-data feature
> and some features are not yet implemented. The output you see is to be
> expected when running the tests. It shouldn't hang though. Are you
> sure it does? Some tests take a long time to run.
>
> I see you got past the previous problem? Was it a problem with the
> JDBC driver?
>
> Regards,
> Thomas Hallgren
>
> kstian wrote:
>
>> Hi,
>>
>> I was running pljava test. The test hung in the middle and I found
>> the following errors in postgresql.log file.
>>
>> What else have I missed?
>>
>> Thank you so much for help.
>>
>> Regards,
>> Kong
>>
>>
>> ==================================================================
>> LOG: Exception
>> LOG: in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25013.test
>> at
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
>>
>> at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>> at java.io.File.checkAndCreate(File.java:1306)
>> at java.io.File.createTempFile(File.java:1402)
>> at java.io.File.createTempFile(File.java:1439)
>> at
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR: java.lang.SecurityException: write on /tmp/pljava25013.test
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> LOG: Exception
>> LOG: in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25015.test
>> at
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
>>
>> at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>> at java.io.File.checkAndCreate(File.java:1306)
>> at java.io.File.createTempFile(File.java:1402)
>> at java.io.File.createTempFile(File.java:1439)
>> at
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR: java.lang.SecurityException: write on /tmp/pljava25015.test
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> LOG: Exception
>> LOG: in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25017.test
>> at
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
>>
>> at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>> at java.io.File.checkAndCreate(File.java:1306)
>> at java.io.File.createTempFile(File.java:1402)
>> at java.io.File.createTempFile(File.java:1439)
>> at
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR: java.lang.SecurityException: write on /tmp/pljava25017.test
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> LOG: Exception
>> LOG: in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25019.test
>> at
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
>>
>> at
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
>>
>> at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>> at java.io.File.checkAndCreate(File.java:1306)
>> at java.io.File.createTempFile(File.java:1402)
>> at java.io.File.createTempFile(File.java:1439)
>> at
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR: java.lang.SecurityException: write on /tmp/pljava25019.test
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: getAttributes
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTables
>> LOG: Exception
>> LOG: in thread "main"
>> java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> at
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>> at
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
>>
>> ERROR: java.sql.SQLException:
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not
>> supported: DatabaseMetaData.getSuperTypes
>> ERROR: invalid regular expression: quantifier operand invalid
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
>
>
>
view thread (8+ messages) latest in thread
Message-ID: <431FE0EB.5070601@tokuii.com>
Permalink: ../431FE0EB.5070601@tokuii.com/
Also on: postgresql.org/message-id/431FE0EB.5070601@tokuii.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Errors running pljava test
In-Reply-To: <431FE0EB.5070601@tokuii.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox