I want to upload file using restful service This is my code to send file to rest service
MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);
[code]...
But how can i retrive at server side in restful service using plsql?
How to integrate Google geocoding as RESTful service introduced by APEX 4.2? my supervisor wanted to use RESTful service for geocoding function. While I am using Google geocoding through simple HTTP request. I even do not know whether I am using SOAP or RESTful with PL/SQL utl_http.request.
View 0 Replies View Relatedi am running the following configuration:
Oracle Database 11.2.0.3
Application Express 4.2.1
apex_listener.2.0.1.64.14.25 on Glassfish 3.01
Everything works fine except the restful webservices. In SQL-WorkShop when i create a simple GET webservice and klick on "Test"" 404 not found" comes up in the browser.In the log i can see:
Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
Not processed as PL/SQL Gateway request
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path has one path segment, continuing processing
No Tenant Principal established yet, continuing processing
APEX_LISTENER pool exists, continuing processing
No matching tenant found for: ifc, cannot dispatch
No candidate found for: GET ifc/certification in context: URL....
I'm trying to setup a dev machine to run APEX with RESTful services ahead of using Oracle's Cloud Database. Using Personal Edition, APEX 4.2.1 and the 2.0 Listener is up and running in standalone more. The problem is when hitting 'Test' on a selected REST Resource Handler, it comes up with an APEX 404 not found error, such as on the example HR REST handlers and a new test one setup.
I've followed all of the APEX and Listener instructions, run apex_rest_config.sql, ensured the various users are unlocked and tried both http and https (even though I've added the no SSL flag in the Listener config per standalone instructions.
I am trying to upload big files to individual table with BLOB column. During upload process after long time approx. 2h I get the following error message:
[#|2012-08-01T19:03:01.667+0200|WARNING|sun-appserver2.1|java.lang.Class|_ThreadID=27;_ThreadName=httpSSLWorkerThread-8082-2;_Reques
tID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;|oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:236)
java.io.IOException: ORA-01013: user requested cancel of current operation
[code]....
I am using Glassfish Server v2.1.1 with APEX Listener v1.1.3.243.11.40...The Timeout parameters for JDBC settings in APEX Listener are default. Thus I would expect to abort earlier to be an issue of JDBC Connection?
After Upgrading to Apex 4.2
When uploading a static text/javascript file (i.e. filename = 'thisFile.js') the file Mime Type defaults to 'application/octet-stream' (instead of 'text/javascript'). This issue occurs in I.E. 8 but not in Firefox.
I needed to create a page on my existing APEX application that would allow the user to upload a file, I followed an online tutorial where the user had created a dummy table and inserted CSV File inserted through APEX into the table. Following that simple example I am able to load the simple CSV file (from tutorial) into a dummy table (from tutorial) but when I attempt to insert actual/dummy data into my actual database (which has a lot more fields of different types), using the exact same process, I am unable to do so.
Ironically, I am unable to insert even dummy values despite the fact that I have been able to insert the same dummy values using SQL Developer. Icing on the cake is that APEX does not produce any error, this lack of debugging feature (especially line by line debugging) is such a pain. Just to add, I can load the values into an Array and can successfully print the delimited values off the array but am still unable to insert the same values into my table. Here is the table that I am attempting to insert into (actual names replaced by Dummyxx):
CREATE TABLE "TABLE"."STG" (
"DUMMY01" NUMBER,
"DUMMY02" NUMBER,
"DUMMY03" NUMBER,
"DUMMY04" DATE,
"DUMMY05" CHAR(3 BYTE),
[code].........
And here's the insertion process:
DECLARE
v_blob_data BLOB;
v_blob_len NUMBER;
v_position NUMBER;
v_raw_chunk RAW(10000);
v_char CHAR(1);
[code]..........
If I run a process to produce the output of the data array onto the screen, the values displayed are in the pattern desired.
Inserting Dummy values instead of values from the Array (v_data_array) to test
EXECUTE IMMEDIATE 'insert into TABLE.STG (DUMMY01, DUMMY02 ..... DUMMY65)
VALUES (
60040,
5,
TO_DATE("14-Dec-12","DD-MON-RRRR HH:MI:SS"),
"ABC",
"ABC",
60,
"11DEC1201",
"331",
"SCOTT TIGER",
"MARKETING",
[code].......
Note that all the the CSV does not contain all the fields, the CSV files that are expected to be entered into the system contain 65 Fields whereas the Table has 73 Fields. Also note that the process runs fine through SQL loader that is invoked through a different server which I need to release and hence the attempt to load the table this way. Also, the procedure on the SQL Loader server is quite complex and involved JAVA+Unix Shell Scripts etc. which I would prefer to avoid.
I want my application to provide an end-user with ability to upload the files from their machine to SFTP server directly. So far, I have managed to write the function which uses java source and allows to upload files from the database. It works just fine.
The function looks as follows:
FUNCTION SFTP_CMD (
V_USER IN VARCHAR2,
V_PASS IN VARCHAR2,
V_HOST IN VARCHAR2,
[code]..
where V_FILE_SRC represents location of the file to be uploaded. The thing is that the FILE BROWSE apex item does not allow to specify the file location, it identifies it somehow automatically, when you press the button 'Choose file'. The question is how can I catch file's path, so that I can pass it to V_FILE_SRC parameter in my function? Should I write my own plugin? or hack FILE BROWSE item? =)
In my project, I implement file's upload and download function by "BLOB Support in Forms and Reports" of official development document Advanced Programming Techniques When user click the BLOB column to download file, I want to trigger an action to update one table for counting this file is downloaded one more times. But I can not find any "dynamic action" about this Blob column of Report.
View 1 Replies View Relatedi need to consume web services within my apex Apps, i tried sample app from here: URL....it worked, but response time is about 15 seconds, then i tried another with Google Geocode APIURL.... and again time is 15-16 seconds. It's normal response time from Apex Web Services or is there something to do.
View 0 Replies View RelatedWhen I call a classic report that is exported throuh restful webservice, result depends on whether I also send cookie or not. In the first case, access is enabled, in the latter case, HTTP 404 is returned.
Restful access is enabled in the instance. Having an app with ID=101, page 9901 that is public, a classic report called MYREPORT on the restful side, the following call is issued:
/apex/apex_rest.getReport?app=101&page=9901&reportid=MYREPORT_ID&parmvalues=123445&output=json
If my browser send the cookie below with the request, I get back the result. If I delete the cookie from my browser, the result for the exact same apex_rest call is HTTP 404: Not found.
Cookie: ORA_WWV_USER_64731425336707=04893186A373057F5F1E1FCCD33113FA; PUBLIC_ORA_WWV_USER_64731425336707=-1; ORA_WWV_REMEMBER_UN=MYNAME:myworkspace
Details on my configuration is as follows:
Database: Oracle XE 11g, 11.2.0.2.0
Apex version: 4.1.1.00.23_en
Platform: Linux x64
HTTP is handles by XEXDB as folows from lsnrctl status:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kivi.omikk.bme.hu)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
I get an ERR-7621 from Apex whenever I do anything in an application the tries to read a file. For example importing images, css files, themes, or applications. Even the data loader app will get the error if you choose to load a "csv" file. The following appears in my Apex Listener Log (version 2 early adopter). I am running 4.1.1 of Apex and also have another server running the same where the problem does not exist. Following is the log output whenever the load occurs:
Sep 28, 2012 11:21:18 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
[Code].....
My configuration is
APEX 4.2 on Windows XP with APEX Listnere on Glassfish 3.1.2 Open Source Server Edition.
The database is 11G XE
Let me explain the scenario which is not working.A Modal region which is having a file browse item based on WWV_FLOW_FILES and a button called add file.
When I click on add file it display a blank page and in the URL I could see [URL]...But actually it inserted file in the table.
I have put wwv_flow* in Listener Configuration for allowed procedures.I have another page where I have a page item which is based on BLOB column specified in item source attribute. And that is inserting file and displaying the pages correctly.
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin
myschema.rest(:p_out);
end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
We are using APEX 4.1. When we try to upload data to a table through upload wizard, even if the record is an update , it still shows "Insert" and then fails with "Primary Key violation" error. We have defined the correct Primary key at table and APEX interface.
View 3 Replies View RelatedIs there any way to upload a file to APEX as BFILE instead of BLOB? I need it to be BFILE since I will be only using XE which means I have limited data storage and unfortunately the system will allow users to upload and download files of different formats (.exe,.bat ) etc. which can be as big as 10MB. Also, how to download these files considering the authentication of the application.
View 3 Replies View RelatedI am new to the Upload data from excel to Table..... how to implement on this.....I need code for UpLoad CSV/XLS Files to the Table ....Table name T_UPLOAD have contains 40 columns....
View 3 Replies View RelatedPretty new to APEX and was hoping to accomplish with native functionality.
Using the latest APEX, there is nice functionality that creates a wizard for you for a single table. I wanted to have a single wizard but pick a table then have the ability to map my fields for insert/update.
Using Apex 3.2 version , Need to Upload .CSV Files to the Table (T_UPLOAD),
View 11 Replies View Relatedin our application, we're uploading .xls files with several (and heavy) sheets.
In order to get better performance, is there any way to load just one of them?
I have to do upload into the table through a csv file . The table's primary key i have to load the rest through user's uploaded file. Is it possible to do the data loading to the table only to required columns and fill the other columns from backend. Or is there any other way to do this?
View 1 Replies View RelatedI am trying to figure out a way to call EDQ (enterprise Data Quality) web service from APEX ?
View 6 Replies View RelatedWe have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
How can in increase the allocated space for a schema in Apex Admin section?
I know you can set this when creating a schema alongsite a workspace and looks like the only way to do it is via raising a service request for more space and loggin in as ADMIN and approving it (in increments of 500MB).
I've just instaledl APEX on Oracle 11g, with APEX listener 1.1, working fine at localhost. But I can't reach it from others computers on LAN. I searched several threads about this and thought I should run
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
But when I execute that, I got the message 'ORA-30952: illegal configuration of HTTP/HTTPS in xdbconfig.xml'.
we would like to generate pdf out of apex. as long as we have text (IRR) WITHOUT special characters (öäü), everything is working fine.when we have this characters in a text-columng (IRR), then we get a .pdf with the following content:
javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: An invalid XML character (Unicode: 0x3) was found in the element content of the document.
- we defined in ADMIN in 'report printing' / 'instance-settings': oracle-apex-listener
- we are working with apex-listener 2.0 (integrated in weblogic-server)
- we work with APEX 4.2.1.00.08
i m using apex 4.1 and the database is oracle *11g* i want to know how to use the java (servlet,jsp,all technologies of java in apex ) and what i have to do to use the java in apex
View 3 Replies View RelatedI am currently hosting a number of APEX applications, using OHS as the webserver and I looking into using the APEX Listener instead. However I have a lot of rewwriterules in my OHS configuration. Is this something that can be configured in the APEX Listener?
<VirtualHost *:80>
ServerAdmin webmaster@dummy-host.example.com
DocumentRoot "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/htdocs"
ServerName application-a.example.com
RewriteEngine On
RewriteRule ^/$ URL....
</VirtualHost>--Andy
how to upgrade Oracle apex listener from 1.1.4 to 2.We are using Oracle apex listener with Glassfish 3.1.2.
View 0 Replies View RelatedI am new to Oracle DB. I have installed Oracle 10g in XP Service Pack2 and was able to login using SYS/SYSTEM users and also was able to create a new user XYZ...
Once I restarted my system, I am facing a strange problem while login. It is continuously throwing the error "tns: listener does not currently know of service requested in connect descriptor". I do not understand the reason. I have checked the services and all oracle related services are running.
However, when I tried to login with the same userid/password from command prompt using 'sqlplus' command, I am able to login ! There was no error this time.