[Pljava-dev] Errors running pljava test

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
>
>
>
>
>
>