Romano Londt

Originally posted by adeeb alexander:
Hi,
I have data in Excel and i want that to be loaded in oracle table, i am using oracle 10g XE, i have tried by sql loader but its quite lengthy process. I tried to load with the internal utility of oracle XE i.e to upload a file but i am facing great difficulties can any body help me please.
Thanks and
Regards.

I struggled to with some Excell-sheets...
I modified all the collumns of the new import table table to varchar2(30000) and modified them after the initial load.

Hi,

I want to configure a subversion 1.5 repository in combination with the apache httpserver which is installed during the Oracle Application Server 10.1.3.

When starting the configuration the following error is thrown:

/oracle/product/as10gr3/Apache/Apache/bin/apachectl startssl: execing httpd Syntax error on line 246 of /oracle/product/as10gr3/Apache/Apache/conf/httpd.conf: Cannot load /opt/CollabNet_Subversion/modules/mod_dav_svn.so into server: /opt/CollabNet_Subversion/modules/mod_dav_svn.so: undefined symbol: ap_filter_flush

The ldd command shows the folowing output;
[oracle@ls53 CollabNet_Subversion]$ ldd -r /opt/CollabNet_Subversion/modules/mod_dav_svn.so libsvn_repos-1.so.0 => //opt/CollabNet_Subversion/lib/libsvn_repos-1.so.0 (0x00e8e000) libsvn_fs-1.so.0 => //opt/CollabNet_Subversion/lib/libsvn_fs-1.so.0 (0x00ce6000) libsvn_delta-1.so.0 => //opt/CollabNet_Subversion/lib/libsvn_delta-1.so.0 (0x00fca000) libsvn_subr-1.so.0 => //opt/CollabNet_Subversion/lib/libsvn_subr-1.so.0 (0x00111000) libpthread.so.0 => /lib/tls/libpthread.so.0 (0x0076e000) libc.so.6 => /lib/tls/libc.so.6 (0x005e5000) libaprutil-1.so.0 => //opt/CollabNet_Subversion/lib/libaprutil-1.so.0 (0x0099c000) libldap-2.3.so.0 => //opt/CollabNet_Subversion/lib/libldap-2.3.so.0 (0x00c4a000) libresolv.so.2 => /lib/libresolv.so.2 (0x00828000) libnsl.so.1 => /lib/libnsl.so.1 (0x00b10000) libexpat.so.0 => //opt/CollabNet_Subversion/lib/libexpat.so.0 (0x00155000) libapr-1.so.0 => //opt/CollabNet_Subversion/lib/libapr-1.so.0 (0x002cb000) libuuid.so.1 => /lib/libuuid.so.1 (0x00b74000) librt.so.1 => /lib/tls/librt.so.1 (0x008e2000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x00d05000) libdl.so.2 => /lib/libdl.so.2 (0x00c2d000) libsvn_fs_fs-1.so.0 => //opt/CollabNet_Subversion/lib/libsvn_fs_fs-1.so.0 (0x00df8000) libsvn_fs_util-1.so.0 => //opt/CollabNet_Subversion/lib/libsvn_fs_util-1.so.0 (0x00abb000) libz.so.1 => //opt/CollabNet_Subversion/lib/libz.so.1 (0x00141000) /lib/ld-linux.so.2 (0x00b38000) libapriconv-1.so.0 => //opt/CollabNet_Subversion/lib/libapriconv-1.so.0 (0x00e58000) liblber-2.3.so.0 => //opt/CollabNet_Subversion/lib/liblber-2.3.so.0 (0x00ed7000) libssl.so.0.9.8 => //opt/CollabNet_Subversion/lib/libssl.so.0.9.8 (0x00173000) libcrypto.so.0.9.8 => //opt/CollabNet_Subversion/lib/libcrypto.so.0.9.8 (0x002eb000) undefined symbol: ap_filter_flush (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_get_token (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_log_rerror (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_hook_post_config (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_str_tolower (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_xml_get_cdata (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_get_brigade (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_update_mtime (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_register_output_filter (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_hook_gather_propsets (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_stripprefix (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_getparents (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_push_error (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_set_content_type (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_new_error (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_fprintf (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_register_liveprop_group (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_destroy_sub_req (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_log_perror (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_pass_brigade (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_add_input_filter (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_no2slash (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_hook_find_liveprop (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_do_find_liveprop (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_xmlns_add (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_add_output_filter (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_set_content_length (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_register_provider (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_os_escape_path (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_sub_req_method_uri (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_register_input_filter (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_default_type (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_fputstrs (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_get_liveprop_info (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_hook_insert_all_liveprops (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_hook_pre_config (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_get_locktoken_list (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_remove_output_filter (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_add_version_component (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_lookup_provider (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_hook_insert_filter (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_hook_fixups (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: dav_new_error_tag (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_remove_input_filter (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_construct_url (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_set_last_modified (/opt/CollabNet_Subversion/modules/mod_dav_svn.so) undefined symbol: ap_fflush (/opt/CollabNet_Subversion/modules/mod_dav_svn.so)

Does anyone have an idea how to solve this issue?

Regards,

Romano

You could use the JDBC-driver instead of the JDBC-ODBC-bridge.

Originally posted by Sekhar Choudary:
Hi All,

When i am trying to connect to oracle 10g using JdbcOdbcDriver, i am getting Message like "Oracle(tm) client software doest not exist..", this is at the time of running my program.

While installing 10g i have choosen Oracle 10g Enterprise Edition , but still i am getting this error.
Also i have setted the DSN as "ora"

Can any one let me know what should i do now?

Thank you.
Sekhar.

Hi,

I want to deploy a JAX-WS client on a Oracle Application Server (OC4J 10.1.3.3). When I deploy and run the client I have to deal with some class-loader issues.

Do you have any idea which classes I have to adjust and how to configure OC4J?

Regards,

Romano

Hi,

I solved this issue by putting the xercesImpl.jar and xml-apis.jar from wss4j into the JDeveloper project.

Regards,

Romano

Originally posted by Romano Londt:
Hi,

I am trying to develop a webservice client in Axis 1.4 with Oracle JDeveloper 10.1.3.

When I run my a test-class in plain java I am able to recieve the expected outcome.

However when I pack the webservice client in a web-application I recieve the folowing error

08/05/06 14:50:23 AxisFault
faultCode: {http://xml.apache.org/axis/}HTTP
faultSubcode:
faultString: (400)Bad Request
faultActor:
faultNode:
faultDetail:
{}:return code: 400

{http://xml.apache.org/axis/}HttpErrorCode:400


Do you have any idea how to solve this issue or what to look for?


Regards,

Romano

Venkatesh,

You can wrap java classes in a java stored procedures.

When you google you should find some information. At otn.oracle.com you can find some examples also.

Regards,

Romano

New INFO:

I tested the webapp in Tomcat (6).

The webservice is being called successfully. Does anyone know how to overcome the differences?

Regards,

Romano

Hi,

I am trying to develop a webservice client in Axis 1.4 with Oracle JDeveloper 10.1.3.

When I run my a test-class in plain java I am able to recieve the expected outcome.

However when I pack the webservice client in a web-application I recieve the folowing error

08/05/06 14:50:23 AxisFault
faultCode: {http://xml.apache.org/axis/}HTTP
faultSubcode:
faultString: (400)Bad Request
faultActor:
faultNode:
faultDetail:
{}:return code: 400

{http://xml.apache.org/axis/}HttpErrorCode:400


Do you have any idea how to solve this issue or what to look for?


Regards,

Romano

Originally posted by Ulf Dittmer:

Please don't: UseTheForumNotEmail

My Bad.

The wsdl :


<?xml version="1.0" encoding="UTF-8"?> <definitions targetNamespace="http://tempuri.org/" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://tempuri.org/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:s="http://www.w3.org/2001/XMLSchema"> <types> <s:schema elementFormDefault="qualified" targetNamespace="http://tempuri.org/"> <s:element name="InkomensToets"> <s:complexType> <s:sequence> <s:element minOccurs="0" maxOccurs="1" name="nhgInkToetsInAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="InkomensToetsResponse"> <s:complexType> <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="InkomensToetsResult" type="s:int" /> <s:element minOccurs="0" maxOccurs="1" name="nhgInkToetsOutAsXml" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="foutenAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="VolledigheidsToets"> <s:complexType> <s:sequence> <s:element minOccurs="0" maxOccurs="1" name="volledigheidInAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="VolledigheidsToetsResponse"> <s:complexType> <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="VolledigheidsToetsResult" type="s:int" /> <s:element minOccurs="0" maxOccurs="1" name="volledigheidOutAsXml" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="foutenAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="HdnBericht"> <s:complexType> <s:sequence> <s:element minOccurs="0" maxOccurs="1" name="volledigheidInAsXml" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="nhgHdnHeaderAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="HdnBerichtResponse"> <s:complexType> <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="HdnBerichtResult" type="s:int" /> <s:element minOccurs="0" maxOccurs="1" name="hdnBerichtAsXml" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="foutenAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="Meldingsformulier"> <s:complexType> <s:sequence> <s:element minOccurs="0" maxOccurs="1" name="volledigheidInAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="MeldingsformulierResponse"> <s:complexType> <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="MeldingsformulierResult" type="s:int" /> <s:element minOccurs="0" maxOccurs="1" name="meldingsformulierAsXml" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="foutenAsXml" type="s:string" /> </s:sequence> </s:complexType> </s:element> <s:element name="EersteJaar"> <s:complexType /> </s:element> <s:element name="EersteJaarResponse"> <s:complexType> <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="EersteJaarResult" type="s:int" /> </s:sequence> </s:complexType> </s:element> <s:element name="LaatsteJaar"> <s:complexType /> </s:element> <s:element name="LaatsteJaarResponse"> <s:complexType> <s:sequence> <s:element minOccurs="1" maxOccurs="1" name="LaatsteJaarResult" type="s:int" /> </s:sequence> </s:complexType> </s:element> </s:schema> </types> <message name="InkomensToetsSoapIn"> <part name="parameters" element="tns:InkomensToets" /> </message> <message name="InkomensToetsSoapOut"> <part name="parameters" element="tns:InkomensToetsResponse" /> </message> <message name="VolledigheidsToetsSoapIn"> <part name="parameters" element="tns:VolledigheidsToets" /> </message> <message name="VolledigheidsToetsSoapOut"> <part name="parameters" element="tns:VolledigheidsToetsResponse" /> </message> <message name="HdnBerichtSoapIn"> <part name="parameters" element="tns:HdnBericht" /> </message> <message name="HdnBerichtSoapOut"> <part name="parameters" element="tns:HdnBerichtResponse" /> </message> <message name="MeldingsformulierSoapIn"> <part name="parameters" element="tns:Meldingsformulier" /> </message> <message name="MeldingsformulierSoapOut"> <part name="parameters" element="tns:MeldingsformulierResponse" /> </message> <message name="EersteJaarSoapIn"> <part name="parameters" element="tns:EersteJaar" /> </message> <message name="EersteJaarSoapOut"> <part name="parameters" element="tns:EersteJaarResponse" /> </message> <message name="LaatsteJaarSoapIn"> <part name="parameters" element="tns:LaatsteJaar" /> </message> <message name="LaatsteJaarSoapOut"> <part name="parameters" element="tns:LaatsteJaarResponse" /> </message> <portType name="NhgToetsSoap"> <operation name="InkomensToets"> <input message="tns:InkomensToetsSoapIn" /> <output message="tns:InkomensToetsSoapOut" /> </operation> <operation name="VolledigheidsToets"> <input message="tns:VolledigheidsToetsSoapIn" /> <output message="tns:VolledigheidsToetsSoapOut" /> </operation> <operation name="HdnBericht"> <input message="tns:HdnBerichtSoapIn" /> <output message="tns:HdnBerichtSoapOut" /> </operation> <operation name="Meldingsformulier"> <input message="tns:MeldingsformulierSoapIn" /> <output message="tns:MeldingsformulierSoapOut" /> </operation> <operation name="EersteJaar"> <input message="tns:EersteJaarSoapIn" /> <output message="tns:EersteJaarSoapOut" /> </operation> <operation name="LaatsteJaar"> <input message="tns:LaatsteJaarSoapIn" /> <output message="tns:LaatsteJaarSoapOut" /> </operation> </portType> <binding name="NhgToetsSoap12" type="tns:NhgToetsSoap"> <soap12:binding transport="http://schemas.xmlsoap.org/soap/http" /> <operation name="InkomensToets"> <soap12 :-o peration style="document" soapAction="http://tempuri.org/InkomensToets" soapActionRequired="false" /> <input> <soap12:body use="literal" /> </input> <output> <soap12:body use="literal" /> </output> </operation> <operation name="VolledigheidsToets"> <soap12 :-o peration style="document" soapAction="http://tempuri.org/VolledigheidsToets" soapActionRequired="false" /> <input> <soap12:body use="literal" /> </input> <output> <soap12:body use="literal" /> </output> </operation> <operation name="HdnBericht"> <soap12 :-o peration style="document" soapAction="http://tempuri.org/HdnBericht" soapActionRequired="false" /> <input> <soap12:body use="literal" /> </input> <output> <soap12:body use="literal" /> </output> </operation> <operation name="Meldingsformulier"> <soap12 :-o peration style="document" soapAction="http://tempuri.org/Meldingsformulier" soapActionRequired="false" /> <input> <soap12:body use="literal" /> </input> <output> <soap12:body use="literal" /> </output> </operation> <operation name="EersteJaar"> <soap12 :-o peration style="document" soapAction="http://tempuri.org/EersteJaar" soapActionRequired="false" /> <input> <soap12:body use="literal" /> </input> <output> <soap12:body use="literal" /> </output> </operation> <operation name="LaatsteJaar"> <soap12 :-o peration style="document" soapAction="http://tempuri.org/LaatsteJaar" soapActionRequired="false" /> <input> <soap12:body use="literal" /> </input> <output> <soap12:body use="literal" /> </output> </operation> </binding> <binding name="NhgToetsSoap" type="tns:NhgToetsSoap"> <soap:binding transport="http://schemas.xmlsoap.org/soap/http" /> <operation name="InkomensToets"> <soap :-o peration style="document" soapAction="http://tempuri.org/InkomensToets" /> <input> <soap:body use="literal" /> </input> <output> <soap:body use="literal" /> </output> </operation> <operation name="VolledigheidsToets"> <soap :-o peration style="document" soapAction="http://tempuri.org/VolledigheidsToets" /> <input> <soap:body use="literal" /> </input> <output> <soap:body use="literal" /> </output> </operation> <operation name="HdnBericht"> <soap :-o peration style="document" soapAction="http://tempuri.org/HdnBericht" /> <input> <soap:body use="literal" /> </input> <output> <soap:body use="literal" /> </output> </operation> <operation name="Meldingsformulier"> <soap :-o peration style="document" soapAction="http://tempuri.org/Meldingsformulier" /> <input> <soap:body use="literal" /> </input> <output> <soap:body use="literal" /> </output> </operation> <operation name="EersteJaar"> <soap :-o peration style="document" soapAction="http://tempuri.org/EersteJaar" /> <input> <soap:body use="literal" /> </input> <output> <soap:body use="literal" /> </output> </operation> <operation name="LaatsteJaar"> <soap :-o peration style="document" soapAction="http://tempuri.org/LaatsteJaar" /> <input> <soap:body use="literal" /> </input> <output> <soap:body use="literal" /> </output> </operation> </binding> <service name="NhgToets"> <port name="NhgToetsSoap12" binding="tns:NhgToetsSoap12"> <soap12:address location="https://onlinetoets.nhg.nl/nhgtoets/NhgToets.asmx" /> </port> <port name="NhgToetsSoap" binding="tns:NhgToetsSoap"> <soap:address location="https://onlinetoets.nhg.nl/nhgtoets/NhgToets.asmx" /> </port> </service> </definitions>

Originally posted by Ulf Dittmer:
In that case I would start with the WSDL description of the service. It'll tell you what the service expects, and you can use it to let your WS stack tools create Java stubs for accessing it.

Also, make sure the WS doesn't do anything that prevents non-DotNet clients from accessing it.

Ok,

I will mail you the wsdl.

I am not sure about yout last statement. I my knowledge doesn't reach that far.

regards,

Romano

Originally posted by Ulf Dittmer:
The code looks like you use both username/password and a signature. Is that what you want to do? In other words, is "context.Security.Elements.Add(new MessageSignature(userToken))" necessary?

Hi Ulf,

Thanks for the response.

I am only building the WS-proxy. The example is taken from a "manual" of the service provider. Therefore I do not have any influence on the serverside.

Regards,

Romano

Originally posted by Jeanne Boyarsky:
Ankur,
You can view/start/stop services through the control panel. Select the admin folder and then services.

Ankur,

Assuming that Oracle is installed on the same machine as where you want to run JAVA.

You could also execute tnsping "DB_SID" from a command prompt. The result should be "OK".

If this was succesful try to connect using sqplus "username"/"password"@"DB_SID" from a command prompt.

If you get connected, you are sure the DB is up and running.

regards,

Romano

Hi,

I am building a WS-client in JAVA for a .Net WS.

I have got an example for a .Net client:

SoapContext context = toets.RequestSoapContext; UsernameToken userToken = new UsernameToken(username, password, PasswordOption.SendHashed); context.Security.Tokens.Add(userToken); context.Security.Elements.Add(new MessageSignature(userToken));

I tried to build a JAVA-client with Apache Axis and Oracle JDeveloper and secured it with a Username Password. Appereantly this is unsufficient. When invoking the client the result is:

Server was unable to process request. ---> The request is not signed using an acceptable signature. at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222) at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)

I thought the solution was in signing the message but the webservice-supplier told me that I did not need a key store or something like that.

Do you have any suggestions?


Regards,


Romano

Hi,
I am using eclipse 2.1. I tried to install the Hibernate Synchronizer but the folowing message appears:
Requested operation cannot be performed because it would invalidate the current configuration. See details for more information.
Hibernate Synchronizer (2.1.60): Feature requires plug-in "org.eclipse.osgi".
Hibernate Synchronizer (2.1.60): Feature requires plug-in "org.eclipse.ui.ide".
Can anyone tell me how to get the required plugins?
Regards,
Romano