Hi Pierre,
I found that the psml-db-oracle.sql provided to create the psml tables in
oracle didn't create the correct tables when running with jetspeed 1.4.1b.
Using the ant build file given in the torque directory i managed to create
the new sql files, and run them.
As Aurelien said (thanks by the way), you don't need to run ant 'import', if
you just comment out those lines in the JetspeedResources.properties
configuration file, then when you run tomcat it runs the psml importer for
you.
However i am still having problems importing, as i now get the error:
[10:49:15,921 DEBUG] BasePeer.doUpdate:
whereClause=TABLE_NAME='JETSPEED_USER_PROFILE'
[10:49:15,984 DEBUG] updateRow: UPDATE ID_TABLE SET NEXT_ID = 130 WHERE
TABLE_NAME = 'JETSPEED_USER_PROFILE'
[10:49:16,218 ERROR] Error saving
profile:BaseProfile[user/admin/html/default.psml]
[10:49:16,218 ERROR] Error occurred in Database PSML Manager:
java.sql.SQLException: ORA-01465: invalid hex number
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1313
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1232)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:1
353)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1805)
at ...
any suggestions?
-----Original Message-----
From: Pierre Henry [mailto:phenry@;proconcept.ch]
Sent: Friday, November 08, 2002 10:31 AM
To: Jetspeed User List (E-mail)
Subject: build/deploy/war file and PSML database
Hi all !
I am quite new to the J2EE environment, and I have been trying Jetspeed for
about two weeks now. I am impressed with the functionalities, and until now
I could more or less easily make all the changes I wanted to do.
But now I want to import the PSML in my db (Oracle 9i). I already configured
Jetspeed to use Oracle for the user tables by modifying the
torque.properties file. I created the PSML-db tables using the sql script
provided with the distribution (psml-db-oracle.sql). Now the howto says I
have to run "ant import" from the /build dir. As I installed the war
release I haven't any build dir.
So I have downloaded the source release, but I cant figure out exactly how
the building process is supposed to work. The thing is I would like to keep
all the changes I already did to my installation (skins, connection to
Oracle, templates, etc...). The only thing I found was in the "install" file
of the src release, it says to build using "ant war" and then to copy the
war into the tomcat/webapps dir.
So I tried to first update all my modified .properties, .xreg and .jsp files
into the src release, then delete the old release from tomcat, build witn
"ant war" and copy the new war file into tomcat. It seems to work, with all
my changes kept.
My first question is, is this the right method ? Is there another way to do
it ? I guess I should now do all my changes to the src release, then build
and deploy the new war... I know this is more a general question about
bulding/deploying a web app, ant etc, but I would be grateful to any help or
pointers to doc about this.
My second question is, I cannot do the psml-db importation. The build.xml
file doesn't contain any import target. Which build file should I use ?
(same question than Karen Davies in the "ant import command" thread).
My setup is :
OS : win2k
Tomcat 4.0.4
Jetspeed 1.4 b1
Oracle 9.0.2
Thanks in advance for any help.
Good day !
Pierre Henry
--
To unsubscribe, e-mail: <mailto:jetspeed-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-user-help@;jakarta.apache.org>
