You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by "Schueller, Henriette" <H....@fgan.de> on 2009/05/20 15:38:25 UTC
FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Hello,
I want to report a bug.
I connect to an empty database; The database has the schema: see attached file "jc3iedm-create.sql".
C:\SyLT>C:\apache\javadb\bin\ij
IJ Version 10.5
ij> connect 'jdbc:derby:C:\SyLT\db\jc3iedm\current\empty';
ij> run 'C:\SyLT\test.sql';
see attached file test.sql
The result is:
FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
This is very strange. The select runs I an oracle database without any problem.
Hope you can help me
Henriette Schüller
*************************************************
Henriette Schüller
Forschungsgesellschaft für
Angewandte Naturwissenschaften e. V. (FGAN)
Neuenahrer Str. 20, 53343 Wachtberg, Germany
Tel.: 0049 (0)228 9435-522
Fax: 0049 (0)228 9435-685
E-Mail: h.schueller@fgan.de
Web: www.fgan.de
************************************************
Sitz der Gesellschaft: Bonn
Registergericht: Amtsgericht Bonn VR 2530
Vorstand: Dr. rer. nat. Ralf Dornhaus (Vors.), Prof. Dr. Joachim Ender (Stellv.)(Stellv.)
Re: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Posted by Kristian Waagan <Kr...@Sun.COM>.
Kristian Waagan wrote:
> Schueller, Henriette wrote:
>>
>>
>> Hello,
>>
>> I want to report a bug.
>
> Hi Henriette,
>
> Thank you for coming to the user list with your Derby problem :)
> Derby uses Jira to track bugs, which you can find at [1].
>
> Also, thanks a lot for providing a repro. I ran it with a debug build,
> and can confirm that it triggers a bug. The rather long stack trace is
> included at the bottom of this mail. Feel free to include it in the
> Jira issue, if you create one. If you don't feel like logging the bug,
> let us know such that a person in the community can do it for you.
I filed a Jira report at https://issues.apache.org/jira/browse/DERBY-4242
I see Mike Segel tried to help you with rewriting the query, and I agree
doing that is the best way to progress. Removing unnecessary aliasing,
self-joins and predicates would be a good start. This will make it
easier to continue with other improvements, as it will be a lot easier
to understand what's going on.
Regards,
--
Kristian
>
>
> Regards
Re: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Posted by Kristian Waagan <Kr...@Sun.COM>.
Schueller, Henriette wrote:
>
>
> Hello,
>
> I want to report a bug.
Hi Henriette,
Thank you for coming to the user list with your Derby problem :)
Derby uses Jira to track bugs, which you can find at [1].
Also, thanks a lot for providing a repro. I ran it with a debug build,
and can confirm that it triggers a bug. The rather long stack trace is
included at the bottom of this mail. Feel free to include it in the Jira
issue, if you create one. If you don't feel like logging the bug, let us
know such that a person in the community can do it for you.
Regards
--
Kristian
[1] https://issues.apache.org/jira/browse/DERBY
ERROR XJ001: Java exception: 'ASSERT FAILED ColumnReference for correct
column (columnPosition = 1, exposed table name = POCSTRUCT12_121) not
found on either side of BinaryRelationalOperator:
org.apache.derby.shared.common.sanity.AssertFailure'.
java.sql.SQLException: Java exception: 'ASSERT FAILED ColumnReference
for correct column (columnPosition = 1, exposed table name =
POCSTRUCT12_121) not found on either side of BinaryRelationalOperator:
org.apache.derby.shared.common.sanity.AssertFailure'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
at org.apache.derby.impl.jdbc.Util.javaException(Util.java:244)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:505)
at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:347)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:245)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:210)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:177)
at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
at org.apache.derby.tools.ij.main(ij.java:59)
Caused by: java.sql.SQLException: Java exception: 'ASSERT FAILED
ColumnReference for correct column (columnPosition = 1, exposed table
name = POCSTRUCT12_121) not found on either side of
BinaryRelationalOperator:
org.apache.derby.shared.common.sanity.AssertFailure'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
... 16 more
Caused by: org.apache.derby.shared.common.sanity.AssertFailure: ASSERT
FAILED ColumnReference for correct column (columnPosition = 1, exposed
table name = POCSTRUCT12_121) not found on either side of
BinaryRelationalOperator
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:162)
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:147)
at
org.apache.derby.impl.sql.compile.BinaryRelationalOperatorNode.generateExpressionOperand(BinaryRelationalOperatorNode.java:488)
at
org.apache.derby.impl.sql.compile.Predicate.generateExpressionOperand(Predicate.java:670)
at
org.apache.derby.impl.sql.compile.PredicateList.generateSetColumn(PredicateList.java:3524)
at
org.apache.derby.impl.sql.compile.PredicateList.generateStartKey(PredicateList.java:3348)
at
org.apache.derby.impl.sql.compile.BaseJoinStrategy.fillInScanArgs1(BaseJoinStrategy.java:109)
at
org.apache.derby.impl.sql.compile.NestedLoopJoinStrategy.getScanArgs(NestedLoopJoinStrategy.java:248)
at
org.apache.derby.impl.sql.compile.FromBaseTable.getScanArguments(FromBaseTable.java:3449)
at
org.apache.derby.impl.sql.compile.FromBaseTable.generateResultSet(FromBaseTable.java:3139)
at
org.apache.derby.impl.sql.compile.FromBaseTable.generate(FromBaseTable.java:3066)
at
org.apache.derby.impl.sql.compile.IndexToBaseRowNode.generate(IndexToBaseRowNode.java:236)
at
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1472)
at
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1336)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1579)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.JoinNode.getJoinArguments(JoinNode.java:1577)
at
org.apache.derby.impl.sql.compile.JoinNode.generateCore(JoinNode.java:1555)
at org.apache.derby.impl.sql.compile.JoinNode.generate(JoinNode.java:1479)
at
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generateMinion(ProjectRestrictNode.java:1472)
at
org.apache.derby.impl.sql.compile.ProjectRestrictNode.generate(ProjectRestrictNode.java:1336)
at
org.apache.derby.impl.sql.compile.ScrollInsensitiveResultSetNode.generate(ScrollInsensitiveResultSetNode.java:109)
at
org.apache.derby.impl.sql.compile.CursorNode.generate(CursorNode.java:606)
at
org.apache.derby.impl.sql.compile.StatementNode.generate(StatementNode.java:347)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:449)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:802)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)
... 9 more
>
>
>
> I connect to an empty database; The database has the schema: see
> attached file “jc3iedm-create.sql”.
>
>
>
>
>
> C:\SyLT>C:\apache\javadb\bin\ij
>
> IJ Version 10.5
>
> ij> connect 'jdbc:derby:C:\SyLT\db\jc3iedm\current\empty';
>
> ij> run 'C:\SyLT\test.sql';
>
>
>
> see attached file test.sql
>
>
>
> The result is:
>
> FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
>
>
>
> This is very strange. The select runs I an oracle database without any
> problem.
>
>
>
> Hope you can help me
>
>
>
> Henriette Schüller
>
>
>
>
>
>
>
> *************************************************
>
> Henriette Schüller
>
>
>
> Forschungsgesellschaft für
>
> Angewandte Naturwissenschaften e. V. (FGAN)
>
> Neuenahrer Str. 20, 53343 Wachtberg, Germany
>
> Tel.: 0049 (0)228 9435-522
>
> Fax: 0049 (0)228 9435-685
>
>
>
> E-Mail: h.schueller@fgan.de
>
> Web: www.fgan.de
>
> ************************************************
>
> Sitz der Gesellschaft: Bonn
>
> Registergericht: Amtsgericht Bonn VR 2530
>
> Vorstand: Dr. rer. nat. Ralf Dornhaus (Vors.), Prof. Dr. Joachim Ender
> (Stellv.)(Stellv.)
>
>
>
>
>
>
>
RE: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Posted by de...@segel.com.
> -----Original Message-----
> From: Kathey Marsden [mailto:kmarsdenderby@sbcglobal.net]
> Sent: Wednesday, May 20, 2009 12:04 PM
> To: Derby Discussion
> Subject: Re: FEHLER XJ001: Java-Ausnahme: ':
> java.lang.NullPointerException'.
>
> derby@segel.com wrote:
> <snip some not very flattering comments about a query and its author>
>
> Please be nice. It is possible suggest improvements without being so
> critical. We welcome the bug report. Too often users work around issues
> and don't report them. We should give a civil response to encourage
> user participation in the community.
>
> Kathey
Kathey, still with IBM? (Sorry, but your name seems familiar...)
Sorry to be a buzz kill, but I just reread my post.
Did I insult the OP, or the query? Not that queries have feelings.
For all I know, the query wasn't written by the OP and that the OP was given
the task to port an application from Oracle to Derby and that they inherited
this garbage.
Do you think that the query is well written?
Do you think that joining 25 tables in a single join is a good idea?
Taking any ego/id or personality out of the equation, I did not just say
that they query was shit, but explained *why* it was shit. I would have gone
further in suggesting ways to rewrite the query, but I don't know the
business rules or what problem that the query was trying to solve. (Which is
why I asked.) The query as written was too convoluted and frankly I'm not
being paid to solve someone else's work.
If you want to play mom, then rather than chastise me for being blunt and to
the point, why don't you offer some assistance to the OP. She did ask for
help and frankly, just telling her that you confirmed the 'defect' and
telling her how to file a JIRA is really no help at all.
Perhaps you would have been less critical if I had said shite instead of
shit?
Frankly, my response to the OP was probably more beneficial than Kristian
telling her on how to file a JIRA report because it gave her some
suggestions about fixing her problem. But then again, I'm biased.
But hey!
My post was an attempt at trying to help the OP.
What's the value of yours?
Re: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Posted by Kathey Marsden <km...@sbcglobal.net>.
derby@segel.com wrote:
<snip some not very flattering comments about a query and its author>
Please be nice. It is possible suggest improvements without being so
critical. We welcome the bug report. Too often users work around issues
and don't report them. We should give a civil response to encourage
user participation in the community.
Kathey
RE: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Posted by de...@segel.com.
First, sorry for the top post.
While Kristian confirmed that you hit a defect, it really doesnt help
you.
I did a quick look at your query that blew up.
Just a comment
In your SQL you have the following:
from POC_CNTNT as pocCntnt1,
PLN_STAT as plnStat,
PLN as pln,
PLN_ORDR as pln_PLN_ORDR,
POC as poc1,
POC_CNTNT as pocCntntB,
POC_CNTNT as pocCntnt12,
CMPNT_HDR_CNTNT as cmpntHdrCntntB,
POC as poc12,
PLN_ORDR_HDR_CNTNT as plnOrdrHdrCntnt,
CMPNT_HDR_CNTNT as cmpntHdrCntnt1,
CMPNT_HDR_CNTNT as cmpntHdrCntnt12,
POC as pocB,
POC_STRUCT as pocStruct1_12,
CMPNT_HDR_CNTNT as cmpntHdrCntnt2,
POC_CNTNT as pocCntnt2,
POC as poc2, CMPNT_HDR_CNTNT as cmpntHdrCntntA,
POC_CNTNT as pocCntntA,
POC as pocA, POC_CNTNT as pocCntnt11,
CMPNT_HDR_CNTNT as cmpntHdrCntnt11,
POC as poc11,
CMPNT_HDR_CNTNT as cmpntHdrCntnt121,
POC_STRUCT as pocStruct12_121,
POC_CNTNT as pocCntnt121,
POC as poc121
I count 25 tables in the join.
Ok, its really less tables although you have them joining against
themselves.
Sure you may have a reproducible bug, however, your query is shit. Sorry, I
dont know of a better way of explaining it.
Look, heres what Im talking about
from
POC as poc1,
POC as poc12,
POC as poc2,
POC as poc11,
POC as pocA,
POC as poc121,
POC as pocB,
POC_CNTNT as pocCntnt1,
POC_CNTNT as pocCntntB,
POC_CNTNT as pocCntnt2,
POC_CNTNT as pocCntntA,
POC_CNTNT as pocCntnt121,
POC_CNTNT as pocCntnt12,
POC_CNTNT as pocCntnt11,
PLN_STAT as plnStat,
PLN as pln,
PLN_ORDR as pln_PLN_ORDR,
PLN_ORDR_HDR_CNTNT as plnOrdrHdrCntnt,
CMPNT_HDR_CNTNT as cmpntHdrCntntB,
CMPNT_HDR_CNTNT as cmpntHdrCntnt11,
CMPNT_HDR_CNTNT as cmpntHdrCntnt121,
CMPNT_HDR_CNTNT as cmpntHdrCntnt1,
CMPNT_HDR_CNTNT as cmpntHdrCntnt12,
CMPNT_HDR_CNTNT as cmpntHdrCntnt2,
CMPNT_HDR_CNTNT as cmpntHdrCntntA,
POC_STRUCT as pocStruct1_12,
POC_STRUCT as pocStruct12_121,
Im sorry but what you have working in Oracle isnt a good idea in the
first place.
Perhaps you may want to think about what you are trying to do and rewrite
this ugly poorly written query in the first place?
Also Id rethink your table design and your constraints.
In your table ACFT_TYPE you check the model type. Thats a hard coded
constraint check. Unless this is a class exercise, Aircraft models are not
static and every year theres a new aircraft model, youll have to upgrade
your constraint check. Not a good design.
I strongly suggest that you look at your query, the business problem you are
trying to solve and consider rewriting the query in to a simpler design.
There are things like temp tables, Unions, inner selects, etc that can make
life a whole lot simpler and easier to run.
You said you tried to run the query on an empty table. How well do you think
it will run when you have 1,000 rows of data? 10,000 rows of data?
Sorry to be a kill joy! It must be the coffee.
-Mike
_____
From: Schueller, Henriette [mailto:H.Schueller@fgan.de]
Sent: Wednesday, May 20, 2009 8:38 AM
To: derby-user@db.apache.org
Subject: FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
Hello,
I want to report a bug.
I connect to an empty database; The database has the schema: see attached
file jc3iedm-create.sql.
C:\SyLT>C:\apache\javadb\bin\ij
IJ Version 10.5
ij> connect 'jdbc:derby:C:\SyLT\db\jc3iedm\current\empty';
ij> run 'C:\SyLT\test.sql';
see attached file test.sql
The result is:
FEHLER XJ001: Java-Ausnahme: ': java.lang.NullPointerException'.
This is very strange. The select runs I an oracle database without any
problem.
Hope you can help me
Henriette Schüller
*************************************************
Henriette Schüller
Forschungsgesellschaft für
Angewandte Naturwissenschaften e. V. (FGAN)
Neuenahrer Str. 20, 53343 Wachtberg, Germany
Tel.: 0049 (0)228 9435-522
Fax: 0049 (0)228 9435-685
E-Mail: h.schueller@fgan.de
Web: www.fgan.de
************************************************
Sitz der Gesellschaft: Bonn
Registergericht: Amtsgericht Bonn VR 2530
Vorstand: Dr. rer. nat. Ralf Dornhaus (Vors.), Prof. Dr. Joachim Ender
(Stellv.)(Stellv.)