Menu
▾
▴
dbprism-users — DBPrism users list (Peer-to-Peer Support)
You can subscribe to this list here.
| 2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(1) |
Sep
|
Oct
(7) |
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2011 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Sergey S. <ser...@gm...> - 2011-01-23 20:22:51
|
Dear Guru, Dear Brainiac!!! Please help me to solve problem with installing DBPrism 3.0.2.1.0 ( "lucene-odi-bin-3.0.2.1.0.zip", http://sourceforge.net/projects/dbprism/files/odi/3.0.2.1.0 ). OS: Windows XP SP3 x86 DBMS: Oracle 10g (10.2.0.1.0) Apache ANT 1.8.2 Microsoft Visual C++ 2010 Express ORACLE JAVA VERSION: 1.4.2_04 FILE "build.properties" is configured. and configured environment (JAVA_HOME, ORACLE_HOME, ANT_HOME etc.) After launching installation Lucene into Oracle the script had been worked about 4 minutes and terminated with failure. After 4 minutes of execution more than 12,000 lines of code Sevaral error messages appeared. They are ORA-xxxxx: - (ORA-29521: referenced name java/lang/StringBuilder could not be found - and ORA-29534: referenced object could not be resolved). But, in all loaded classes all was well (for example: [java] Classes Loaded: 42 [java] Resources Loaded: 1 [java] Sources Loaded: 0 [java] Published Interfaces: 0 [java] Classes generated: 0 [java] Classes skipped: 2 [java] Synonyms Created: 45 [java] *Errors: 0* ) , except: [java] resolving: class org/apache/lucene/index/AllTests [java] *errors *: class org/apache/lucene/index/AllTests [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/TestDBIndex [java] synonym : org/apache/lucene/index/AllTests [java] granting : execute on class org/apache/lucene/index/DBTestCase to public [java] *errors *: class org/apache/lucene/index/DBTestCase [java] ORA-29521: не удалось найти ссылочное имя org/apache/lucene/util/English [java] synonym : org/apache/lucene/index/DBTestCase [java] granting : execute on class org/apache/lucene/index/TestDBIndex to public [java] *errors *: class org/apache/lucene/index/TestDBIndex [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/DBTestCase [java] synonym : org/apache/lucene/index/TestDBIndex [java] granting : execute on class org/apache/lucene/index/TestDBIndexAddDoc to public [java] *errors *: class org/apache/lucene/index/TestDBIndexAddDoc [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/DBTestCase [java] synonym : org/apache/lucene/index/TestDBIndexAddDoc [java] granting : execute on class org/apache/lucene/index/TestDBIndexDelDoc to public [java] *errors *: class org/apache/lucene/index/TestDBIndexDelDoc [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/DBTestCase [java] synonym : org/apache/lucene/index/TestDBIndexDelDoc [java] granting : execute on class org/apache/lucene/index/TestDBIndexParallel$1 to public [java] *errors *: class org/apache/lucene/index/TestDBIndexParallel$1 [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/TestDBIndexParallel [java] synonym : org/apache/lucene/index/TestDBIndexParallel$1 [java] granting : execute on class org/apache/lucene/index/TestDBIndexParallel$2 to public [java] *errors *: class org/apache/lucene/index/TestDBIndexParallel$2 [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/TestDBIndexParallel [java] synonym : org/apache/lucene/index/TestDBIndexParallel$2 [java] granting : execute on class org/apache/lucene/index/TestDBIndexParallel$3 to public [java] *errors *: class org/apache/lucene/index/TestDBIndexParallel$3 [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/TestDBIndexParallel [java] synonym : org/apache/lucene/index/TestDBIndexParallel$3 [java] granting : execute on class org/apache/lucene/index/TestDBIndexParallel$4 to public [java] *errors *: class org/apache/lucene/index/TestDBIndexParallel$4 [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/TestDBIndexParallel [java] synonym : org/apache/lucene/index/TestDBIndexParallel$4 [java] granting : execute on class org/apache/lucene/index/TestDBIndexParallel$5 to public [java] *errors *: class org/apache/lucene/index/TestDBIndexParallel$5 [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/TestDBIndexParallel [java] synonym : org/apache/lucene/index/TestDBIndexParallel$5 [java] granting : execute on class org/apache/lucene/index/TestDBIndexParallel to public [java] *errors* : class org/apache/lucene/index/TestDBIndexParallel [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/DBTestCase [java] synonym : org/apache/lucene/index/TestDBIndexParallel [java] granting : execute on class org/apache/lucene/index/TestDBIndexSearchDoc to public [java] *errors* : class org/apache/lucene/index/TestDBIndexSearchDoc [java] ORA-29534: referenced object could not be resolved LUCENE.org/apache/lucene/index/DBTestCase AND after that IN ORACLE THERE WAS FOUNDED SEVERAL JAVA INVALID OBJECTS: INVALID OBJECTS in scheme LUCENE: - /86373e88_AllTests - /dcc56b9d_DBTestCase - /9741ab83_TestDBIndex - /27f2c777_TestDBIndexAddDoc - /14b7f85f_TestDBIndexDelDoc - /71f71292_TestDBIndexSearchDoc - /8e92669b_TestDBIndexParallel2 - /7ce6952a_TestDBIndexParallel3 - /3d2e3536_TestDBIndexParallel4 - /77f2ec61_TestDBIndexParallel5 - /d1f15c3d_TestDBIndexParallel - /90c9812c_TestDBIndexParallel1 INVALID OBJECTS in scheme SYS: - mx4j/log/CommonsLogger - mx4j/log/Log4JLogger LAST MESSAGE (LOG) IN ANT AFTER TERMINATED: [java] granting : execute on class org/tartarus/snowball/ext/Portuguese2Stemmer to public [java] skipping : class org/tartarus/snowball/ext/Portuguese2Stemmer [java] synonym : org/tartarus/snowball/ext/Portuguese2Stemmer [java] The following operations failed [java] class org/apache/lucene/index/AllTests: resolution [java] class org/apache/lucene/index/DBTestCase: resolution [java] class org/apache/lucene/index/TestDBIndex: resolution [java] class org/apache/lucene/index/TestDBIndexAddDoc: resolution [java] class org/apache/lucene/index/TestDBIndexDelDoc: resolution [java] class org/apache/lucene/index/TestDBIndexParallel$1: resolution [java] class org/apache/lucene/index/TestDBIndexParallel$2: resolution [java] class org/apache/lucene/index/TestDBIndexParallel$3: resolution [java] class org/apache/lucene/index/TestDBIndexParallel$4: resolution [java] class org/apache/lucene/index/TestDBIndexParallel$5: resolution [java] class org/apache/lucene/index/TestDBIndexParallel: resolution [java] class org/apache/lucene/index/TestDBIndexSearchDoc: resolution [java] exiting : Failures occurred during processing BUILD FAILED E:\dbprism-lucene\lucene-odi\build.xml:532: The following error occurred while executing this line: E:\dbprism-lucene\lucene-odi\loadjava.xml:45: Java returned: 1 Total time: 4 minutes 13 seconds What was the problem in? Thanks for your help. best regards, Sergey S. Semka |
|
From: Marcelo O. <mar...@gm...> - 2008-10-17 10:13:24
|
Hi Ricardo: Good. I'll prepare a new DBPrism release with this fix ASAP. Marcelo. On Fri, Oct 17, 2008 at 4:05 AM, Ricardo Borillo <Ric...@si...> wrote: > Hi Marcelo, > > It works perfect. Thanks for your quick help!!! > > --- > Salut, > ==================================== > Ricardo Borillo Domenech > http://xml-utils.com > > > > On Thu, Oct 16, 2008 at 14:50, Marcelo Ochoa <mar...@gm...> wrote: >> Hi Ricardo: >> Please check if attached Prism.jar works with you application. >> Marcelo. >> >> On Thu, Oct 16, 2008 at 9:11 AM, Marcelo Ochoa <mar...@gm...> wrote: >>> Ricardo: >>>> With the original especification: >>>> >>>> CREATE OR REPLACE PROCEDURE GRI_WWW.euji00222 >>>> (NAME_ARRAY IN euji_util.ident_arr2 >>>> ,VALUE_ARRAY IN euji_util.ident_arr2 >>>> ) >>>> IS >>>> BEGIN >>>> ... >>>> END; >>>> >>>> I have added this code in the body of the procedure >>>> >>>> htp.p('<!--' || name_array.count || '-->'); >>>> >>>> And the printed value obtained is: >>>> >>>> <!--0--> >>>> >>>> So, it seems to receive two arrays of size 0. >>> OK, I'll work on this direction. >>>> >>>> Thanks >>> Marcelo. >>> >>> >>> -- >>> Marcelo F. Ochoa >>> http://marceloochoa.blogspot.com/ >>> http://marcelo.ochoa.googlepages.com/home >>> ______________ >>> Want to integrate Lucene and Oracle? >>> http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html >>> Is Oracle 11g REST ready? >>> http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html >>> >> >> >> >> -- >> Marcelo F. Ochoa >> http://marceloochoa.blogspot.com/ >> http://marcelo.ochoa.googlepages.com/home >> ______________ >> Want to integrate Lucene and Oracle? >> http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html >> Is Oracle 11g REST ready? >> http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >> Build the coolest Linux based applications with Moblin SDK & win great prizes >> Grand prize is a trip for two to an Open Source event anywhere in the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> dbprism-users mailing list >> dbp...@li... >> https://lists.sourceforge.net/lists/listinfo/dbprism-users >> >> > -- Marcelo F. Ochoa http://marceloochoa.blogspot.com/ http://marcelo.ochoa.googlepages.com/home ______________ Want to integrate Lucene and Oracle? http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html Is Oracle 11g REST ready? http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html |
|
From: Ricardo B. <Ric...@si...> - 2008-10-17 07:06:03
|
Hi Marcelo, It works perfect. Thanks for your quick help!!! --- Salut, ==================================== Ricardo Borillo Domenech http://xml-utils.com On Thu, Oct 16, 2008 at 14:50, Marcelo Ochoa <mar...@gm...> wrote: > Hi Ricardo: > Please check if attached Prism.jar works with you application. > Marcelo. > > On Thu, Oct 16, 2008 at 9:11 AM, Marcelo Ochoa <mar...@gm...> wrote: >> Ricardo: >>> With the original especification: >>> >>> CREATE OR REPLACE PROCEDURE GRI_WWW.euji00222 >>> (NAME_ARRAY IN euji_util.ident_arr2 >>> ,VALUE_ARRAY IN euji_util.ident_arr2 >>> ) >>> IS >>> BEGIN >>> ... >>> END; >>> >>> I have added this code in the body of the procedure >>> >>> htp.p('<!--' || name_array.count || '-->'); >>> >>> And the printed value obtained is: >>> >>> <!--0--> >>> >>> So, it seems to receive two arrays of size 0. >> OK, I'll work on this direction. >>> >>> Thanks >> Marcelo. >> >> >> -- >> Marcelo F. Ochoa >> http://marceloochoa.blogspot.com/ >> http://marcelo.ochoa.googlepages.com/home >> ______________ >> Want to integrate Lucene and Oracle? >> http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html >> Is Oracle 11g REST ready? >> http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html >> > > > > -- > Marcelo F. Ochoa > http://marceloochoa.blogspot.com/ > http://marcelo.ochoa.googlepages.com/home > ______________ > Want to integrate Lucene and Oracle? > http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html > Is Oracle 11g REST ready? > http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > dbprism-users mailing list > dbp...@li... > https://lists.sourceforge.net/lists/listinfo/dbprism-users > > |
|
From: Marcelo O. <mar...@gm...> - 2008-10-16 12:50:40
|
Hi Ricardo:
Please check if attached Prism.jar works with you application.
Marcelo.
On Thu, Oct 16, 2008 at 9:11 AM, Marcelo Ochoa <mar...@gm...> wrote:
> Ricardo:
>> With the original especification:
>>
>> CREATE OR REPLACE PROCEDURE GRI_WWW.euji00222
>> (NAME_ARRAY IN euji_util.ident_arr2
>> ,VALUE_ARRAY IN euji_util.ident_arr2
>> )
>> IS
>> BEGIN
>> ...
>> END;
>>
>> I have added this code in the body of the procedure
>>
>> htp.p('<!--' || name_array.count || '-->');
>>
>> And the printed value obtained is:
>>
>> <!--0-->
>>
>> So, it seems to receive two arrays of size 0.
> OK, I'll work on this direction.
>>
>> Thanks
> Marcelo.
>
>
> --
> Marcelo F. Ochoa
> http://marceloochoa.blogspot.com/
> http://marcelo.ochoa.googlepages.com/home
> ______________
> Want to integrate Lucene and Oracle?
> http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html
> Is Oracle 11g REST ready?
> http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html
>
--
Marcelo F. Ochoa
http://marceloochoa.blogspot.com/
http://marcelo.ochoa.googlepages.com/home
______________
Want to integrate Lucene and Oracle?
http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html
Is Oracle 11g REST ready?
http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html
|
|
From: Marcelo O. <mar...@gm...> - 2008-10-15 12:24:23
|
Hi Ricardo: > I'm using this construction with mod_pslq without problems. I can call > procedures without parameters and flexible passing system. > But you are right, it works with a default value in the declaration. > My problem is that i have hundreds of web pl/sql procedures and i > don't know if it's possible to modify all of them with this default > values ... OK, I working on the patch ASAP. I'll send to you a new Prism.jar with the change to test if its working well. > > Finally, i like to tell you that this mod_plsql replacement is a very > good idea, and i will be very happy if in a future i can complettly > remove my OAS installation :) According to APEX 4.0 statement of direction, Oracle is going in the same way :) Marcelo. > > --- > Salut, > ==================================== > Ricardo Borillo Domenech > http://xml-utils.com > > > > On Wed, Oct 15, 2008 at 12:32, Marcelo Ochoa <mar...@gm...> wrote: >> Hi Ricardo: >> As you can see in the logs euij00222 is pased without any argument. >> >> 2008-10-14 16:43:49,350 [http-9180-2] DEBUG >> com.prism.oracle.DBConnPLSQL - .doIt - Servlet Name: >> 'gri_www.euji00222' >> 2008-10-14 16:43:49,351 [http-9180-2] INFO >> com.prism.oracle.DBConnPLSQL - .doIt command: >> DECLARE >> BEGIN >> gri_www.euji00222; END; >> 2008-10-14 16:43:49,362 [http-9180-2] DEBUG com.prism.DBConnection - >> servletpath = /!gri_www.euji00222 >> >> mod_plsql documentation didn't say anything about what happen if you >> use flexible request syntax without arguments :( >> http://download.oracle.com/docs/cd/B19306_01/server.102/b14337/concept.htm#sthref41 >> Is your code working with mod_plsql? >> If yes, I need to patch DBPrism to be full compatible with mod_plsql :( >> On the other hand, try to define a default value for both arguments, I mean: >> >> CREATE OR REPLACE PROCEDURE GRI_WWW.euji00222 >> (NAME_ARRAY IN euji_util.ident_arr2 DEFAULT euji_util.empty_arr2 >> ,VALUE_ARRAY IN euji_util.ident_arr2 DEFAULT euji_util.empty_arr2 >> ) >> IS >> BEGIN >> ... >> END; >> >> and declaring euji_util.empty_arr2 in euji_util package public spec >> as an empty array. >> For example: >> >> create or replace >> package euji_util is >> >> type empty_arr2 is table of varchar2(30) index by binary_integer; >> .... >> empty_arr2 euji_util.empty_arr2; >> end; >> >> Best regards, Marcelo. >> >> On Tue, Oct 14, 2008 at 12:47 PM, Ricardo Borillo >> <Ric...@si...> wrote: >>> Hi Marcelo, >>> >>> Here it's all the information: >>> >>> *. EUJI00222 spec: >>> >>> CREATE OR REPLACE PROCEDURE GRI_WWW.euji00222 >>> (NAME_ARRAY IN euji_util.ident_arr2 >>> ,VALUE_ARRAY IN euji_util.ident_arr2 >>> ) >>> IS >>> BEGIN >>> ... >>> END; >>> >>> And euji_util.ident_arr2 is a type declared as: >>> >>> type ident_arr2 is table of varchar2(4000) index by binary_integer; >>> >>> *. dpls.log with error information. I have redeployed the WAR file and >>> now i have all the trace information (file attached). >>> *. Version: I'm using WAR deployment in tomat 6.0.16, with the latest >>> DBPrism version. >>> >>> >>> Thank you for your time :) >>> >>> >>> --- >>> Salut, >>> ==================================== >>> Ricardo Borillo Domenech >>> http://xml-utils.com >>> >>> >>> >>> On Tue, Oct 14, 2008 at 17:02, Marcelo Ochoa <mar...@gm...> wrote: >>>> Ricardo: >>>> Which is your PLSQL spec for EUJI00222 procedure? >>>> But anyway, using standard "ant run" target on DBPrism distribution >>>> conf/log4j.properties is automatically modified and copied to Jetty >>>> run directory to enable logging to /tmp/dpls.log >>>> With logging enable you should have something like: >>>> .......... >>>> 2008-10-14 11:46:33,849 [P1-19] DEBUG com.prism.DBConnection - .doCall >>>> entered. >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - >>>> servletpath = /demo.startup >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - >>>> servletname = demo.startup >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - >>>> servletpath = /sample >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - >>>> servletname = demo.startup >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - >>>> servletpath = /demo.startup >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - >>>> servletname = demo.startup >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - >>>> servletpath = /sample >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.DBConnection - SP >>>> command: demo.startup >>>> 2008-10-14 11:46:33,850 [P1-19] DEBUG com.prism.oracle.DBConnPLSQL - >>>> Reset session >>>> 2008-10-14 11:46:34,271 [P1-19] DEBUG com.prism.oracle.DBConnPLSQL - >>>> .resetPackages - 'BEGIN dbms_session.reset_package; END;' >>>> 2008-10-14 11:46:34,272 [P1-19] DEBUG com.prism.oracle.DBConnPLSQL - >>>> hostaddr: 127.0.0.1 >>>> 2008-10-14 11:46:34,275 [P1-19] DEBUG com.prism.CgiVars - .CgiVars >>>> dump cgi array start. >>>> 2008-10-14 11:46:34,275 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REQUEST_METHOD' = 'GET' >>>> 2008-10-14 11:46:34,275 [P1-19] DEBUG com.prism.CgiVars - 'PATH_INFO' >>>> = '/demo.startup' >>>> 2008-10-14 11:46:34,275 [P1-19] DEBUG com.prism.CgiVars - >>>> 'PATH_TRANSLATED' = >>>> '/usr/local/jdevhome/mywork/prism/tmp/webapps/dpls/demo.startup' >>>> 2008-10-14 11:46:34,275 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REMOTE_USER' = 'scott' >>>> 2008-10-14 11:46:34,275 [P1-19] DEBUG com.prism.CgiVars - >>>> 'SCRIPT_NAME' = '/sample' >>>> 2008-10-14 11:46:34,275 [P1-19] DEBUG com.prism.CgiVars - >>>> 'SCRIPT_PREFIX' = '/' >>>> 2008-10-14 11:46:34,276 [P1-19] DEBUG com.prism.CgiVars - >>>> 'SERVER_SOFTWARE' = 'DBPrism' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'CONTENT_LENGTH' = '-1' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'SERVER_PROTOCOL' = 'HTTP/1.1' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REQUEST_PROTOCOL' = 'HTTP' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'SERVER_NAME' = 'localhost' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'SERVER_PORT' = '8888' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REMOTE_ADDR' = '127.0.0.1' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REMOTE_HOST' = '127.0.0.1' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REMOTE_PORT' = '1350' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'HTTP_USER_AGENT' = 'Mozilla/5.0 (X11; U; Linux i686; en-US; >>>> rv:1.9.1b1pre) Gecko/20081006 Minefield/3.1b1pre' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - 'HTTP_HOST' >>>> = 'localhost:8888' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'HTTP_ACCEPT' = >>>> 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'HTTP_ACCEPT_ENCODING' = 'gzip,deflate' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'HTTP_ACCEPT_LANGUAGE' = 'en-us,en;q=0.8,es-ar;q=0.5,es;q=0.3' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'HTTP_ACCEPT_CHARSET' = 'ISO-8859-1,utf-8;q=0.7,*;q=0.7' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - 'DAD_NAME' >>>> = 'sample' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'DOC_ACCESS_PATH' = 'docs' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REQUEST_CHARSET' = 'utf-8' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'DOCUMENT_TABLE' = 'wpg_document' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'PLSQL_GATEWAY' = 'DBPrism' >>>> 2008-10-14 11:46:34,277 [P1-19] DEBUG com.prism.CgiVars - >>>> 'GATEWAY_IVERSION' = '2.1.2.1-production' >>>> 2008-10-14 11:46:34,278 [P1-19] DEBUG com.prism.CgiVars - >>>> 'REQUEST_IANA_CHARSET' = 'iso-8859-1' >>>> 2008-10-14 11:46:34,278 [P1-19] DEBUG com.prism.CgiVars - .CgiVars >>>> dump cgi array end. >>>> 2008-10-14 11:46:34,597 [P1-19] DEBUG com.prism.oracle.DBConnPLSQL - >>>> .doIt entered. >>>> 2008-10-14 11:46:34,597 [P1-19] DEBUG com.prism.oracle.DBConnPLSQL - >>>> .doIt - Servlet Name: 'demo.startup' >>>> 2008-10-14 11:46:34,604 [P1-19] DEBUG com.prism.oracle.SPProcPLSQL - >>>> .create overload for: 'demo.startup' >>>> 2008-10-14 11:46:34,686 [Thread-3] DEBUG >>>> com.prism.oracle.JTADBPrismConnectionCacheImpl - run: Busy >>>> com.prism.oracle.DBConnPLSQL@17cec96 count=600 >>>> 2008-10-14 11:46:34,776 [P1-19] DEBUG com.prism.oracle.SPProcPLSQL - >>>> Resolving package.procedure call >>>> 2008-10-14 11:46:34,776 [P1-19] DEBUG com.prism.oracle.SPProcPLSQL - >>>> Excuting: SELECT argument_name, overload, data_type, type_owner, >>>> type_name, type_subname FROM all_arguments WHERE owner = ? AND >>>> package_name = ? AND object_name = ? ORDER BY overload,sequence >>>> 2008-10-14 11:46:34,776 [P1-19] DEBUG com.prism.oracle.SPProcPLSQL - >>>> With arg 1: SCOTT >>>> 2008-10-14 11:46:34,776 [P1-19] DEBUG com.prism.oracle.SPProcPLSQL - >>>> With arg 2: DEMO >>>> 2008-10-14 11:46:34,777 [P1-19] DEBUG com.prism.oracle.SPProcPLSQL - >>>> With arg 3: STARTUP >>>> 2008-10-14 11:46:35,571 [P1-19] DEBUG com.prism.oracle.SPProcPLSQL - >>>> overload: 1 no argument >>>> 2008-10-14 11:46:35,571 [P1-19] INFO com.prism.oracle.DBConnPLSQL - >>>> .doIt command: >>>> DECLARE >>>> BEGIN >>>> demo.startup; END; >>>> 2008-10-14 11:46:35,686 [Thread-3] DEBUG >>>> com.prism.oracle.JTADBPrismConnectionCacheImpl - run: Busy >>>> com.prism.oracle.DBConnPLSQL@17cec96 count=599 >>>> 2008-10-14 11:46:35,855 [P1-19] DEBUG com.prism.oracle.DBConnPLSQL - >>>> .doIt exited. >>>> 2008-10-14 11:46:35,855 [P1-19] DEBUG com.prism.DBConnection - .doCall >>>> exited. >>>> 2008-10-14 11:46:35,855 [P1-19] DEBUG com.prism.DBPrism - .makePage >>>> doCall success on com.prism.oracle.DBConnPLSQL@17cec96 >>>> 2008-10-14 11:46:35,855 [P1-19] DEBUG com.prism.DBPrism - .makePage >>>> exited. >>>> 2008-10-14 11:46:35,906 [P1-19] DEBUG com.prism.oracle.DBConnPLSQL - >>>> buff=Content-type: text/html; charset=iso-8859-1 >>>> X-DB-Content-length: 2136 >>>> ............... >>>> And a lot of more debugging information before and after the above section. >>>> Note that there is an special part: >>>> command: >>>> DECLARE >>>> BEGIN >>>> demo.startup; END; >>>> which tell you the PLSQL anonymous block executed by DBPrism to call >>>> your procedure. >>>> Which version of DBPrism are you using? >>>> Are using Jetty deployment, or a dpls.[war|ear] into another J2EE container? >>>> Best regards, Marcelo. >>>> >>>> On Tue, Oct 14, 2008 at 11:28 AM, Ricardo Borillo >>>> <Ric...@si...> wrote: >>>>> Hi Marcelo, >>>>> >>>>> I have modified log4.properties file, but no log information was >>>>> generated when the call fails. >>>>> When the request succeds i can see a lot of debug information in this file ... >>>>> >>>>> I only get the browser page error: >>>>> >>>>> Servlet Wrapper Error Page >>>>> >>>>> PLSQL Adapter - PLSQL Error >>>>> ORA-06550: línea 3, columna 1: >>>>> PLS-00306: wrong number or types of arguments in call to 'EUJI00222' >>>>> ORA-06550: línea 3, columna 1: >>>>> PL/SQL: Statement ignored >>>>> >>>>> >>>>> >>>>> While try to execute !gri_www.euji00222 >>>>> with args >>>>> >>>>> >>>>> --- >>>>> Salut, >>>>> ==================================== >>>>> Ricardo Borillo Domenech >>>>> http://xml-utils.com >>>>> >>>>> >>>>> >>>>> On Fri, Oct 10, 2008 at 13:32, Marcelo Ochoa <mar...@gm...> wrote: >>>>>> Hi Ricardo: >>>>>> Could you change log4j.properties to enable DBPrism debugging? >>>>>> Uncomment this at the end of the file: >>>>>> >>>>>> log4j.logger.com.prism=DEBUG,A2 >>>>>> log4j.additivity.com.prism=false >>>>>> >>>>>> Usually dbpls.log is created at /tmp/ directory. >>>>>> Then, could you paste last part of dpls.log to see if there are errors? >>>>>> Best regards, Marcelo. >>>>>> >>>>>> On Fri, Oct 10, 2008 at 7:40 AM, Ricardo Borillo >>>>>> <Ric...@si...> wrote: >>>>>>> Hi all, >>>>>>> >>>>>>> I'm trying to access an Oracle PL/SQL stored procedure through >>>>>>> DBPrism, and all is ok if parameters are present in the query string. >>>>>>> For example: >>>>>>> >>>>>>> http://localhost:8080/dpls/sample/!gri_www.euji00222?a=1 >>>>>>> >>>>>>> But, when i try to make a GET without parameters, an error is issued: >>>>>>> >>>>>>> http://localhost:8080/dpls/sample/!gri_www.euji00222 >>>>>>> >>>>>>> -------------------------- >>>>>>> >>>>>>> Servlet Wrapper Error Page >>>>>>> >>>>>>> PLSQL Adapter - PLSQL Error >>>>>>> ORA-06550: línea 3, columna 1: >>>>>>> PLS-00306: wrong number or types of arguments in call to 'EUJI00222' >>>>>>> ORA-06550: línea 3, columna 1: >>>>>>> PL/SQL: Statement ignored >>>>>>> >>>>>>> While try to execute !gri_www.euji00222 with args >>>>>>> >>>>>>> >>>>>>> It's possible to call with "!" to an URL without parameters? It's a >>>>>>> configuration error? >>>>>>> >>>>>>> Thanks a lot >>>>>>> >>>>>>> >>>>>>> --- >>>>>>> Salut, >>>>>>> ==================================== >>>>>>> Ricardo Borillo Domenech >>>>>>> http://xml-utils.com >>>>>>> >>>>>>> ------------------------------------------------------------------------- >>>>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >>>>>>> Build the coolest Linux based applications with Moblin SDK & win great prizes >>>>>>> Grand prize is a trip for two to an Open Source event anywhere in the world >>>>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>>>>> _______________________________________________ >>>>>>> dbprism-users mailing list >>>>>>> dbp...@li... >>>>>>> https://lists.sourceforge.net/lists/listinfo/dbprism-users >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Marcelo F. Ochoa >>>>>> http://marceloochoa.blogspot.com/ >>>>>> http://marcelo.ochoa.googlepages.com/home >>>>>> ______________ >>>>>> Want to integrate Lucene and Oracle? >>>>>> http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html >>>>>> Is Oracle 11g REST ready? >>>>>> http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html >>>>>> >>>>>> ------------------------------------------------------------------------- >>>>>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >>>>>> Build the coolest Linux based applications with Moblin SDK & win great prizes >>>>>> Grand prize is a trip for two to an Open Source event anywhere in the world >>>>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>>>>> _______________________________________________ >>>>>> dbprism-users mailing list >>>>>> dbp...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/dbprism-users >>>>>> >>>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> Marcelo F. Ochoa >>>> http://marceloochoa.blogspot.com/ >>>> http://marcelo.ochoa.googlepages.com/home >>>> ______________ >>>> Want to integrate Lucene and Oracle? >>>> http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html >>>> Is Oracle 11g REST ready? >>>> http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html >>>> >>>> >>> >> >> >> >> -- >> Marcelo F. Ochoa >> http://marceloochoa.blogspot.com/ >> http://marcelo.ochoa.googlepages.com/home >> ______________ >> Want to integrate Lucene and Oracle? >> http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html >> Is Oracle 11g REST ready? >> http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html >> >> > -- Marcelo F. Ochoa http://marceloochoa.blogspot.com/ http://marcelo.ochoa.googlepages.com/home ______________ Want to integrate Lucene and Oracle? http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html Is Oracle 11g REST ready? http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html |
|
From: Ricardo B. <Ric...@si...> - 2008-10-14 14:28:20
|
Hi Marcelo, I have modified log4.properties file, but no log information was generated when the call fails. When the request succeds i can see a lot of debug information in this file ... I only get the browser page error: Servlet Wrapper Error Page PLSQL Adapter - PLSQL Error ORA-06550: línea 3, columna 1: PLS-00306: wrong number or types of arguments in call to 'EUJI00222' ORA-06550: línea 3, columna 1: PL/SQL: Statement ignored While try to execute !gri_www.euji00222 with args --- Salut, ==================================== Ricardo Borillo Domenech http://xml-utils.com On Fri, Oct 10, 2008 at 13:32, Marcelo Ochoa <mar...@gm...> wrote: > Hi Ricardo: > Could you change log4j.properties to enable DBPrism debugging? > Uncomment this at the end of the file: > > log4j.logger.com.prism=DEBUG,A2 > log4j.additivity.com.prism=false > > Usually dbpls.log is created at /tmp/ directory. > Then, could you paste last part of dpls.log to see if there are errors? > Best regards, Marcelo. > > On Fri, Oct 10, 2008 at 7:40 AM, Ricardo Borillo > <Ric...@si...> wrote: >> Hi all, >> >> I'm trying to access an Oracle PL/SQL stored procedure through >> DBPrism, and all is ok if parameters are present in the query string. >> For example: >> >> http://localhost:8080/dpls/sample/!gri_www.euji00222?a=1 >> >> But, when i try to make a GET without parameters, an error is issued: >> >> http://localhost:8080/dpls/sample/!gri_www.euji00222 >> >> -------------------------- >> >> Servlet Wrapper Error Page >> >> PLSQL Adapter - PLSQL Error >> ORA-06550: línea 3, columna 1: >> PLS-00306: wrong number or types of arguments in call to 'EUJI00222' >> ORA-06550: línea 3, columna 1: >> PL/SQL: Statement ignored >> >> While try to execute !gri_www.euji00222 with args >> >> >> It's possible to call with "!" to an URL without parameters? It's a >> configuration error? >> >> Thanks a lot >> >> >> --- >> Salut, >> ==================================== >> Ricardo Borillo Domenech >> http://xml-utils.com >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >> Build the coolest Linux based applications with Moblin SDK & win great prizes >> Grand prize is a trip for two to an Open Source event anywhere in the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> dbprism-users mailing list >> dbp...@li... >> https://lists.sourceforge.net/lists/listinfo/dbprism-users >> > > > > -- > Marcelo F. Ochoa > http://marceloochoa.blogspot.com/ > http://marcelo.ochoa.googlepages.com/home > ______________ > Want to integrate Lucene and Oracle? > http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html > Is Oracle 11g REST ready? > http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > dbprism-users mailing list > dbp...@li... > https://lists.sourceforge.net/lists/listinfo/dbprism-users > > |
|
From: Marcelo O. <mar...@gm...> - 2008-10-10 12:05:22
|
Hi Ricardo: Could you change log4j.properties to enable DBPrism debugging? Uncomment this at the end of the file: log4j.logger.com.prism=DEBUG,A2 log4j.additivity.com.prism=false Usually dbpls.log is created at /tmp/ directory. Then, could you paste last part of dpls.log to see if there are errors? Best regards, Marcelo. On Fri, Oct 10, 2008 at 7:40 AM, Ricardo Borillo <Ric...@si...> wrote: > Hi all, > > I'm trying to access an Oracle PL/SQL stored procedure through > DBPrism, and all is ok if parameters are present in the query string. > For example: > > http://localhost:8080/dpls/sample/!gri_www.euji00222?a=1 > > But, when i try to make a GET without parameters, an error is issued: > > http://localhost:8080/dpls/sample/!gri_www.euji00222 > > -------------------------- > > Servlet Wrapper Error Page > > PLSQL Adapter - PLSQL Error > ORA-06550: línea 3, columna 1: > PLS-00306: wrong number or types of arguments in call to 'EUJI00222' > ORA-06550: línea 3, columna 1: > PL/SQL: Statement ignored > > While try to execute !gri_www.euji00222 with args > > > It's possible to call with "!" to an URL without parameters? It's a > configuration error? > > Thanks a lot > > > --- > Salut, > ==================================== > Ricardo Borillo Domenech > http://xml-utils.com > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > dbprism-users mailing list > dbp...@li... > https://lists.sourceforge.net/lists/listinfo/dbprism-users > -- Marcelo F. Ochoa http://marceloochoa.blogspot.com/ http://marcelo.ochoa.googlepages.com/home ______________ Want to integrate Lucene and Oracle? http://marceloochoa.blogspot.com/2007/09/running-lucene-inside-your-oracle-jvm.html Is Oracle 11g REST ready? http://marceloochoa.blogspot.com/2008/02/is-oracle-11g-rest-ready.html |
|
From: Ricardo B. <Ric...@si...> - 2008-10-10 11:13:35
|
Hi all, I'm trying to access an Oracle PL/SQL stored procedure through DBPrism, and all is ok if parameters are present in the query string. For example: http://localhost:8080/dpls/sample/!gri_www.euji00222?a=1 But, when i try to make a GET without parameters, an error is issued: http://localhost:8080/dpls/sample/!gri_www.euji00222 -------------------------- Servlet Wrapper Error Page PLSQL Adapter - PLSQL Error ORA-06550: línea 3, columna 1: PLS-00306: wrong number or types of arguments in call to 'EUJI00222' ORA-06550: línea 3, columna 1: PL/SQL: Statement ignored While try to execute !gri_www.euji00222 with args It's possible to call with "!" to an URL without parameters? It's a configuration error? Thanks a lot --- Salut, ==================================== Ricardo Borillo Domenech http://xml-utils.com |
|
From: Marcelo F. O. <mo...@ie...> - 2008-08-08 19:24:04
|
Hi seam: Please sign up at new DBPrism users lists: Yahoo groups has been moved to: https://lists.sourceforge.net/lists/listinfo/dbprism-users Best regards, Marcelo. PD: If you have an account signed in old yahoo groups, you can see the archive. On Sun, Aug 3, 2008 at 11:35 AM, Sean McLinden <mcl...@in...> wrote: > > Greetings: > > I recently moved my DBPrism instance to a new Oracle database and I'm missing the instructions on how to replace OAS with DBprism. In particular, what packages need to be run, synonyms need to be created, etc., to make the package run correctly. > > The information appears to be in Yahoo Groups but I can't find the group through a search and accessing it via a Google search tells me that I am not a member. > > Can you either send me the instructions dealing with the OWA_UTILS package, synonyms, etc. or enable my access of the Yahoo! group in order to view the archives. > > Thanks. > > Sean McLinden > -- Marcelo F. Ochoa http://marceloochoa.blogspot.com/ http://marcelo.ochoa.googlepages.com/home ______________ Do you Know DBPrism? Look @ DB Prism's Web Site http://www.dbprism.com.ar/index.html More info? Chapter 17 of the book "Programming the Oracle Database using Java & Web Services" http://www.amazon.com/gp/product/1555583296/ Chapter 21 of the book "Professional XML Databases" - Wrox Press http://www.amazon.com/gp/product/1861003587/ Chapter 8 of the book "Oracle & Open Source" - O'Reilly http://www.oreilly.com/catalog/oracleopen/ |
|
From: Marcelo O. <mar...@gm...> - 2008-07-08 22:15:28
|
