db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: read only db and luceneSupport
Date Fri, 20 Oct 2017 01:26:55 GMT
The stack trace has no line numbers, so I can't tell what is failing. 
Can you try your experiment with a debug version of Derby (e.g., 
db-derby-10.13.1.1-lib-debug.zip)?

Thanks,
-Rick

On 10/18/17 10:34 AM, Tulay Sri wrote:
>
> 1. Query:
> SELECT * FROM TABLE( LUCENESUPPORT.LISTINDEXES() ) T
>
> 2. StackTrace:
>
> java.sql.SQLException: The exception 'java.lang.NullPointerException' 
> was thrown while evaluating an expression.
>     at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
> Source)
>     at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
> Source)
>     at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
> Source)
>     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
> Source)
>     at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
>     at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>     at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown 
> Source)
>    ...
> Caused by: ERROR 38000: The exception 'java.lang.NullPointerException' 
> was thrown while evaluating an expression.
>     at 
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown

> Source)
>     ... 18 more
> Caused by: java.lang.NullPointerException
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI$1.run(Unknown 
> Source)
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI$1.run(Unknown 
> Source)
>     at java.security.AccessController.doPrivileged(Native Method)
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI.listDirectories(Unknown 
> Source)
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI.<init>(Unknown 
> Source)
>     at 
> org.apache.derby.optional.lucene.LuceneSupport.listIndexes(Unknown Source)
>     at 
> org.apache.derby.exe.acf81e0010x015fx305axd8b7x000074ebfc881.g0(Unknown 
> Source)
>     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
>     at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>     at java.lang.reflect.Method.invoke(Method.java:498)
>     at 
> org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown 
> Source)
>     at org.apache.derby.impl.sql.execute.VTIResultSet.openCore(Unknown 
> Source)
>     at 
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown 
> Source)
>     at 
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown 
> Source)
>     at 
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
>     ... 11 more
> java.sql.SQLException: The exception 'java.lang.NullPointerException' 
> was thrown while evaluating an expression.
>     at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
> Source)
>     at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
> Source)
>     at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
> Source)
>     at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
> Source)
>     at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
>     at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>     at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown 
> Source)
>    ....
> Caused by: ERROR 38000: The exception 'java.lang.NullPointerException' 
> was thrown while evaluating an expression.
>     at 
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>     at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown

> Source)
>     ... 18 more
> Caused by: java.lang.NullPointerException
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI$1.run(Unknown 
> Source)
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI$1.run(Unknown 
> Source)
>     at java.security.AccessController.doPrivileged(Native Method)
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI.listDirectories(Unknown 
> Source)
>     at 
> org.apache.derby.optional.lucene.LuceneListIndexesVTI.<init>(Unknown 
> Source)
>     at 
> org.apache.derby.optional.lucene.LuceneSupport.listIndexes(Unknown Source)
>     at 
> org.apache.derby.exe.acf81e0010x015fx305axd8b7x000074ebfc881.g0(Unknown 
> Source)
>     at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
>     at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>     at java.lang.reflect.Method.invoke(Method.java:498)
>     at 
> org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown 
> Source)
>     at org.apache.derby.impl.sql.execute.VTIResultSet.openCore(Unknown 
> Source)
>     at 
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown 
> Source)
>     at 
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown 
> Source)
>     at 
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
>     ... 11 more
>
>
> 3. derby.log
>
> Booting Derby (version The Apache Software Foundation - Apache Derby - 
> 10.11.1.1 - (1616546)) instance a816c00e-015f-3087-b056-000074ebfde8
> on database directory 
> jar:(/sample/institution_name_to_type_db.jar)/institution_name_to_type_db 
> in READ ONLY mode with class loader 
> sun.misc.Launcher$AppClassLoader@18b4aac2.
> Loaded from 
> file:/export/home/foo/.gradle/caches/modules-2/files-2.1/org.apache.derby/derby/10.11.1.1/df4b50061e8e4c348ce243b921f53ee63ba9bbe1/derby-10.11.1.1.jar

> <http://10.11.1.1/df4b50061e8e4c348ce243b921f53ee63ba9bbe1/derby-10.11.1.1.jar>.
> java.vendor=Oracle Corporation
> java.runtime.version=1.8.0_144-b01
> user.dir=/export/home/foo/IdeaProjects/bar
> os.name <http://os.name>=Linux
> os.arch=amd64
> os.version=4.4.0-93-generic
> derby.system.home=null
> derby.stream.error.file=/export/home/foo/IdeaProjects/bar/STREAMERROR.LOG
> Database Class Loader started - derby.database.classpath=''
>
>
> Error file is empty.
>
> Thanks,
> Tulay
>
> On Wed, Oct 18, 2017 at 9:46 AM, Tulay Sri <tulay.sri@gmail.com 
> <mailto:tulay.sri@gmail.com>> wrote:
>
>     On 10/17/17 5:05 PM, Tulay Sri wrote:
>     > Hi,
>     >
>     > Within a java app I created a read-only database db.jar with 
>     > lucenesupport and created a lucene index. I am now trying to use it to 
>     > query within another java code as part of a large ETL job, However, 
>     > when it comes to using the db to query lucene based tools, I get null 
>     > pointer exception even to get the list of lucene indexes. If I simply 
>     > query the base tables or if I unzip this db.jar and run lucene based 
>     > queries, things are fine. Not sure where to start. Can anyone give me 
>     > a hand to figure out what I am missing?
>     >
>     > Thanks,
>     > Tulay
>
>     Can you post the following:
>
>     1) The SQL statement you are issuing which incurs the NPE
>
>     2) The full error message which comes back
>
>     3) The contents of derby.log or the portion of derby.log which records
>     the details of this error
>
>     Thanks,
>
>     -Rick
>
>


Mime
View raw message