On Thu, 6 Jul 2000, Rafal Krzewski wrote:
> The scripts in docs/schemas/Sybase_* work OK with Sybase
> Adaptive Server Enterprise 11.9.2 on Linux. Could you please
> tell what specific Sybase server are you using?
11.9.2 on Linux; using jConnect 5.2.
> Working scripts for your dbms would be also much appreciated!
I think the statements that needs to be added/changed in
default_roles_permissions.sql are the ones after "-- Finally...":
/*
-- Finally, add the user turbine to the turbine_root group
*/
insert into Visitor
(VISITORID,LOGINID,PASSWORD_VALUE,FIRST_NAME,LAST_NAME,LASTLOGIN)
values(1,"turbine","turbine","Root","Turbine","7/5/2000")
go
insert into VisitorRole ( VISITORID, ROLEID ) select Visitor.VISITORID,
UserRole.ROLEID from Visitor, UserRole where Visitor.LOGINID = 'turbine'
AND UserRole.ROLENAME = 'turbine_root'
I guess that "1" is the correct value for "turbine's" VISITORID.
The two other scripts could be run perfectly.
> As far as I can tell ASE 11.9.2 is NOT case sensitive, both on
> table and column names. Never the less, this can actualy cause
> problems - some schema files use uppercase for column names
> (Oracle and DB2) other use mixed case.
Well, because one of the scripts wouldn't run correctly, I think the case
is sensitive. I have tried to set Sybase to be case-insensitive (using
sp_configure), but I don't think I could find the parameter for doing it.
>TurbineMapBuilder
> contains mixed case names.
Yes; so some of the Admin's screens couldn't be run; really big problems
for Sybase users.
BTW, I'm having problems with TurbineResources.properties; where should I
put it? I have followed what's stated in
http://java.apache.org/turbine/war-webmacro.html, but it turned out that
Turbine still couldn't find the properties file. Even when I put
turbine-war-webmacro.war in $TOMCAT_HOME/webapps (and then restarted
Tomcat), the .war file got unjar'ed but the turbine-war-webmacro directory
has another turbine-war-webmacro in it (so Tomcat would really have big
problem finding the properties file).
>From the Servlet docs:
getRealPath
public java.lang.String getRealPath(java.lang.String path)
...
The real path returned will be in a form appropriate to the computer and
operating system on which the servlet container is running, including the
proper path separators. This method returns null if the servlet container
cannot translate the virtual path to a real path for any reason (such as
when the content is being made available from a .war archive).
And from Turbine.java:
String props = getInitParameter(INIT_PROPS_KEY);
...
if ( props != null )
{
String realPath = getServletContext().getRealPath(props);
if ( realPath != null )
props = realPath;
}
It seems that getInitParameter() always returns null. The parameter is
defined in web.xml (which is located in
$TOMCAT_HOME/webapps/turbine-war-webmacro/WEB-INF), but I'm not sure
whether this file is read by Tomcat during starting up.
Does it mean that Turbine shouldn't be put in a .war file?
Oki
ps: of course, if I edit the Turbine.java and hard-wire the location of
the properties file, there would be no problem.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
