Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML Namespace handling?

843834Jul 18 2001 — edited Jul 25 2001
Hi,
I am having a typical problem here. Is there any way I can set a namespace to an XML string before I convert it into a Document. The problem is I have this XML string and I am trying to parse it, but I get a java.io.Nullpointer Exception because one of the tags in the XML string has a name space and I need to assign a name space to it here.

here's an example...

Following is my XML string say....

<metadata>
<schema>Schema 1</schema>
<schemaversion>DX:MD1.0 S:1.0</schemaversion>
<dlmd:record>Record</dlmd:record>
</metadata>

I need to parse this string, but I can not do it without setting a namespace for dlmd:record! Or is there a way I can do it without the namespace...I tried using the setNamespaceaware() option but it does not seem to work.

It's sort of strange as to why I need to assign a name space to it here...but thats the problem I have to deal with...

any help would be very much appreciated.

Thanks in advance
Prashanth

Comments

285751
Try adding a parameter 0 before your oraParmSessionID parameter. That will give the function someplace to return its result.

OraParameter oraReturn = new OraParameter();
oraReturn.ParameterName = "justaboutanything";
oraReturn.OraDbType = OraDbType.Date;
oraReturn.Direction = ParameterDirection.ReturnValue;
oraCommand.Parameters.Add(oraReturn );




Any ideas as to what's causing the following error:
---
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Oracle.DataAccess.Client.OraException:
/---
I'm simply calling an Oracle function which returns a date. Code snippet:
---
FUNCTION func_get_session_date(v_session_id VARCHAR2, v_session_key VARCHAR2) RETURN DATE IS
...etc
/---
...employing the OraDataReader to extract the value (unnecessary code extracted for clarity):
---
DateTime returnDateTime;
string commandText = "SELECT pkg_css_session_state.func_get_session_date(:v_session_id, :v_session_key) FROM dual";
//string commandText = "SELECT pkg_css_session_state.func_get_session_date('" + this.AspxSessionID + "', '" + sessionKey + "') FROM dual";
OraConnection oraConnection = new OraConnection(connectionString);
OraCommand oraCommand = new OraCommand();
oraCommand.Connection = oraConnection;
oraCommand.CommandText = commandText;
OraParameter oraParmSessionID = new OraParameter();
oraParmSessionID.ParameterName = "v_session_id";
oraParmSessionID.OraDbType = OraDbType.Varchar2;
oraParmSessionID.Value = this.AspxSessionID;
oraParmSessionID.Direction = ParameterDirection.Input;
oraCommand.Parameters.Add(oraParmSessionID);
OraParameter oraParmSessionKey = new OraParameter();
oraParmSessionKey.ParameterName = "v_session_key";
oraParmSessionKey.OraDbType = OraDbType.Varchar2;
oraParmSessionKey.Value = sessionKey;
oraParmSessionKey.Direction = ParameterDirection.Input;
oraCommand.Parameters.Add(oraParmSessionKey);
oraConnection.Open();
OraDataReader oraDataReader = oraCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (oraDataReader.Read())
{
if (! oraDataReader.IsDBNull(0))
{
returnDateTime = oraDataReader.GetDateTime(0);
}
}
/--
Interestingly, it works fine when I don't use input parameters (see commented-out commandText string).
Thanks ahead o' time!
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 22 2001
Added on Jul 18 2001
14 comments
207 views