DBPSML with Oracle and Jetspeed 1.4b1 : Finally got it to work !

[Aurelien Pernoud <ap...@sopragroup.com>]

Hi there,

I was trying to put psml in database. I'm using 1.4b1 and Oracle. I've
followed the "How-to" many times, from the beginning, and it doesn't work
well with... Oracle in fact. Due to the ORA-01465 sql error with BLOB !

Here's what I've tried, several times (with little changes I'll explain
later), without success :

- Modify build.properties and psml.properties to use oracle
- Build jetspeed -> ok
- replace the jar in tomcat with the new one
- run SQL scripts this order :
turbine-oracle (from ext) to use oracle for user as well
security-schema freshly created
dbpsml-schema freshly created
and finally populate

Didn't have any errors.

Then modified the torque.properties in jetspeed to start the import process.
When I come to the portal, I can see the login, then a "Unable to fetch
pane", and here's the log I had :

[Wed Oct 23 17:32:09 CEST 2002] -- INFO -- Running PSMLImporter...
[Wed Oct 23 17:32:09 CEST 2002] -- INFO -- PSML-Man: calculated
resource:user\admin\html\default.psml. Base:
C:\Serveurs\jakarta-tomcat-3.3.1\webapps\jetspeed\WEB-INF\psml
[Wed Oct 23 17:32:10 CEST 2002] -- ERROR -- Error saving
profile:BaseProfile[user/admin/html/default.psml]
[Wed Oct 23 17:32:10 CEST 2002] -- ERROR -- Error occurred in Database PSML
Manager:
	Exception:  org.apache.torque.TorqueException: ORA-01465: nombre
hexadécimal incorrect

	Stack Trace follows:
	java.sql.SQLException: ORA-01465: nombre hexadécimal incorrect
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
	...

[Wed Oct 23 17:32:11 CEST 2002] -- INFO -- PSMLImporter completed. Exported
0 profiles

I then saw a thread
<http://www.mail-archive.com/jetspeed-user@jakarta.apache.org/msg05108.html>
with the exact same trouble, so I just tried to change every scripts used
above to modify every BLOB found with a LONG RAW.

In fact the guy was right, all generated scripts (security-schema,
dbpsml-schema) have BLOB inside, and it doesn't work with Oracle.

I first saw that in sql/external there was a psml-db-oracle.sql, which is
fine, but there's no security-schema-oracle, so a default user will use the
one created with Torque (I tried so many combinations I don't remember)

Now it works, but woooooooooow, that was long. Don't know if the trouble is
still there with a nightly build and future 1.4b2, but nothing on the
website mention it right now.

Aurélien Pernoud


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: DBPSML with Oracle and Jetspeed 1.4b1 : Finally got it to work !

[David Sean Taylor <da...@bluesunrise.com>]

> -----Original Message-----
> From: Aurelien Pernoud [mailto:apernoud@sopragroup.com]
> Sent: Wednesday, October 23, 2002 8:53 AM
> To: 'Jetspeed Developers List'
> Subject: DBPSML with Oracle and Jetspeed 1.4b1 : Finally got it to work
> with the exact same trouble, so I just tried to change every scripts used
> above to modify every BLOB found with a LONG RAW.
>

fixed in the cvs head

> In fact the guy was right, all generated scripts (security-schema,
> dbpsml-schema) have BLOB inside, and it doesn't work with Oracle.
>
> I first saw that in sql/external there was a psml-db-oracle.sql, which is
> fine, but there's no security-schema-oracle, so a default user will use
the
> one created with Torque (I tried so many combinations I don't remember)
>
> Now it works, but woooooooooow, that was long. Don't know if the trouble
is
> still there with a nightly build and future 1.4b2, but nothing on the

yes its fixed in the cvs head (and nightly build)

Aurelien, could you please send a patch updating the source and
documentation with a better process?
Or at least explain to me, since I documented the process, where I went
wrong, and how you would improve the process?



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>