Oracle Patch Upgrade JS 1.2 to 2.0

Posted on July 12, 2007 at 9:53am
Hello everybody,

has somebody already converted the mySQL Patch to Oracle?

It was not included onto the JasperServer Version 2.0 Software.

Thanks a lot,

Jorge
JasperReports® Server
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago

13 Answers:

Posted on July 12, 2007 at 12:52pm
see attachment..

[file name=jasperserverCreate_2.txt size=16259]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/jas...
Post edited by: kidice, at: 2007/07/12 12:52
kidice's picture
kidice
145
Joined: May 14 2007 - 5:58pm
Last seen: 16 years 4 months ago
Posted on July 12, 2007 at 1:18pm
Hi kidice,

many thanks, but I have already an installed JS 1.2.1 and need only the upgrade to JS 2.0.0 for Oracle (similar to the one for MySQL, attached) to install the new WAR-File.

I'm not sure, if I can extract the parts which are to be changed from your SQL-File.

Again, many thanks,

Jorge
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago
Posted on July 12, 2007 at 1:20pm
Sorry, now would be a TXT-File attached.
[file name=upgradeMySql_JS_1.txt size=1346]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/upg...
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago
Posted on July 12, 2007 at 2:16pm
sorry...look at the next post...
Post edited by: kidice, at: 2007/07/12 14:19
kidice's picture
kidice
145
Joined: May 14 2007 - 5:58pm
Last seen: 16 years 4 months ago
Posted on July 12, 2007 at 2:20pm
see attachment [file name=jasperserver_update_2-83dd9e350c4fcf1105e235eadb146ceb.txt size=1145]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/jas...
kidice's picture
kidice
145
Joined: May 14 2007 - 5:58pm
Last seen: 16 years 4 months ago
Posted on July 13, 2007 at 12:16pm
Hi kidice,
thanks for your help. I could not use your file directly, but I have made some adaptations, to be near to the known sql-commands (used during the installation from JS 1.2.1), giving the attached sql-part as a result.
I suppose, there are still some problems, because the upgraded (to JS 2.0.0) installation does not start, giving the attached log-part out.
Please, take a look on that txt-file, to find possible errors on upgrading the oracle DB (Solaris'10 Oracle'10).
Thanks in advance and have a nice weekend,
Jorge
[file name=upgradeOracle_JS_1.txt size=81922]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/upg...
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago
Posted on July 13, 2007 at 12:21pm
have you created an hibernate sequence? if not use this query:

Code:
<br />
CREATE SEQUENCE hibernate_sequence INCREMENT BY 1 MINVALUE 10 NOMAXVALUE CACHE 20 NOCYCLE NOORDER;<br />
</td></tr></tbody></table><br />
<br />
<br />
//edit: do you have a table called "THIS_14_" and a column called "VISIBLE"?  have you set the dialect in hibernate.properties to oracle??<br>Post edited by: kidice, at: 2007/07/13 12:34
kidice's picture
kidice
145
Joined: May 14 2007 - 5:58pm
Last seen: 16 years 4 months ago
Posted on July 13, 2007 at 1:15pm
Hi kidice,
yes, I have created the hibernate sequence (see please everything attached); there is no table with this name (THIS_14_); and I have the hibernate.properties set to oracle (hibernate.properties).
Many thanks for your help!,
Jorge [file name=hibernate.txt size=371]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/hib...
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago
Posted on July 13, 2007 at 1:18pm
I try again to send the images ... [file name=Images_Compressed.zip size=37729]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Ima...
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago
Posted on July 13, 2007 at 1:44pm
i think your tables are complete... i think that you don't need the table "JIREPORTDATASOURCE" anymore, because it isnt listed in the "jasperserver-create.ddl"

//edit: have you configured your mysql-ds.xml or a similar file which contains the jdbc/jasperserver connection to your oracle database??
Post edited by: kidice, at: 2007/07/13 13:55
kidice's picture
kidice
145
Joined: May 14 2007 - 5:58pm
Last seen: 16 years 4 months ago
Posted on July 13, 2007 at 2:56pm
I suppose you talk about "META-INF/context.xml attached! [file name=context.txt size=2630]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/con...
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago
Posted on July 16, 2007 at 7:04am
do you use tomcat or jboss???
Post edited by: kidice, at: 2007/07/16 07:05
kidice's picture
kidice
145
Joined: May 14 2007 - 5:58pm
Last seen: 16 years 4 months ago
Posted on July 16, 2007 at 9:08am
morning,
I use tomcat 5.5.23 and the last JasperServer version (1.2.1) was running there.
I have prepared new reports, using parameter-lists (that is, X at the place of $P).
Only the new version (2.0.0) has this possibility implemented; that is the reason!
I need only to upgrade from 1.2.1 to 2.0.0 (The JS software is ready, the DB still not).
thanks a lot,
Jorge
JMoralesGER's picture
JMoralesGER
119
Joined: Jul 19 2006 - 7:01pm
Last seen: 17 years 2 months ago
Feedback
randomness