From: kongsen.tian at tokuii.com (kstian) Date: Thu, 08 Sep 2005 14:57:47 +0800 Subject: [Pljava-dev] Errors running pljava test In-Reply-To: References: <431FBC71.5060803@tokuii.com> <431FD8ED.9050502@mailblocks.com> Message-ID: <431FE0EB.5070601@tokuii.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.(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.(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.(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.(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.(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.(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.(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.(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.(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.(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.(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.(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 > > > > > >