very urgent

[2002 JI Open Discussion]

By: Muralidhar bp - pmurli

very urgent

2003-01-21 06:15

Hello,

 

I am getting this error when deploying my war file in weblogic server. Plzzz help me...

 

<Jan 21, 2003 7:51:15 PM IST> <Error> <HTTP> <[WebAppServletContext(4789566,List

OfSwift,/ListOfSwift)] Servlet failed with Exception

java.lang.NullPointerException

at java.util.Hashtable.put(Hashtable.java:375)

at java.util.Properties.setProperty(Properties.java:97)

at java.lang.System.setProperty(System.java:637)

at servlets.ListOfSwiftServlet.service(ListOfSwiftServlet.java:33)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:262)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm

pl.java:198)

at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe

rvletContext.java:2637)

at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm

pl.java:2359)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

>

 

Thanx

Murli

 

 

 

 

By: Chuck Deal - cdeal

RE: very urgent

2003-01-21 08:25

It looks like you are calling System.setProperty inside the ListOfSwiftServlet. Look for this statement and verify that you are not setting a null (or that the variable you are using as the parameter is not null)

 

 

 

 

By: Muralidhar bp - pmurli

RE: very urgent

2003-01-22 00:35

Hello,

 

I have the query, which consists of CLOB data, and want to show this data as a report, and when i create the war file and try to deploy I am getting this error.

Plzz tell me whether the xml file which i have written is correct or wrong. I am using a store procedure called SwiftMessage, to read the CLOB data.

 

The querystring in the xml file is like this...

 

<queryString><![CDATA[exec SwiftMessage $P!{LCNumber}]]></queryString>

 

where SwiftMessage is the procedure name. I am writing the procedure on CLOB column SWIFT_MESSAGE, So please tell me what I should write in field tag and detail tag. Should I have to write the column name or procedure name.

Please help me, thanx in advance.

 

Rgds

Murli

 

 

 

 

By: Teodor Danciu - teodord

RE: very urgent

2003-01-22 03:45

 

Hi,

 

I'm not very familiar with PL/SQL, but as far as

I know, it seems that your stored procedure returns

the CLOB value in an OUT parameter (from the

code you've sent me).

 

And as we already told you, JasperReports cannot

deal with such stored procedures.

It can only use SELECT queries or at least stored

procedures that return result sets and have no OUT

parameters at all.

 

I suggest you give up using the SQL query feature

of JasperReports and read the CLOB value outside

JasperReports, in you own application code.

I assume that you already have an infrastructure

that allows you to read such values using JDBC.

It is your application who stored these values in the

database or not?

 

Anyway, if you read the CLOB before launching the

report, you could supply the value simply as

a large String report parameter.

 

Furthermore, the exception you get has nothing

to do with what we've already talked about.

It is not about the query or the CLOB or anything.

It does not seem to be related to JasperReports,

if that is the entire stack trace you got.

I don't see any JasperReports class mentioned

in the stack trace.

 

I hope this helps.

Teodor

 

 

 

 

 

By: Muralidhar bp - pmurli

RE: very urgent

2003-01-22 06:10

Hello,

 

Thanks for the reply, I want to execute one simple

store procedure program with Jasper report. So can you please show me how to use store procedure in Jasper Reports with example.

Thanks in advance.

 

Rgds

Murli

 

 

 

 

By: Teodor Danciu - teodord

RE: very urgent

2003-01-22 08:43

 

Hi,

 

I do not have such an example.

 

Maybe someone with more hands-on experience

on this could help you.

 

Thank you,

Teodor