----- Mensaje original -----
De: <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviado: martes 6 de febrero de 2001 11:51
Asunto: RE: TDK peer newapp

: A list of how to get tdk working with oracle would be a great help.
:
: Jon North
:

OK, this is what I did to get the TDK 1.1a10 Peer example newapp running
with Oracle under Windows. Please note that this is just a way to
manually overcome the errors, and that some of the problems I ran into
are probably fixed in the new TDK release :-)

- Define turbine.app.type=peer in newapp.props, as explained in the
documentation, and run  newapp myapp.

- Update myapp.properties in \myapp\WEB_INF\build\project as explained
in \myapp\WEB_INF\build\GETTING_STARTED.txt:
database=oracle
targetPlatform = windows
targetPlatformExt = bat
databaseUrl = jdbc:oracle:thin:@srvlabbcn:1521:LABO
databaseDriver = oracle.jdbc.driver.OracleDriver
databaseUser = user
databasePassword = password

- In \myapp\WEB_INF\build\project\turbine-schema.xml, comment the
DOCTYPE xml tag to avoid the DTD access problem:
<!-- DOCTYPE .... -->

- In
\myapp\WEB_INF\build\bin\torque\templates\sql\security\default-roles-per
ms.vm, edit the INSERT INTO TURBINE_USER command to add the USER_ID
column and value:
INSERT INTO TURBINE_USER
(USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME)
 VALUES
(1, 'turbine', 'turbine', 'turbine', 'turbine');

- Run the build-project init script. It will try to drop Oracle elements
that are not there the first time you run it (because of some
incompatibility TDK-Oracle), and the script will abend with a "table or
view does not exist" error. When this happens, open an SQL Worksheet or
similar utility and create dummy elements that can be dropped: look for
"drop" SQL commands in the files \myapp\WEB_INF\src\sql\xxx.sql, and use
the following "create" commands to create the dummy elements. Then
re-run build-project init.

- Catalina.bat in \tdk\bin is not set to find the Oracle JDBC drivers at
runtime. They are probably stored in your Oracle directories structure,
and maybe in your default environment CLASSPATH. Edit catalina.bat,
below the comment "Set Up The Runtime Classpath", to add:
set CP = ....;%_CLASSPATH%
or
set CP = ....;C:/yourOracleJDBCpath/yourJDBCsupport.jar

OK, I think that's all.

Pere Torrodellas






------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to