On Fri, 7 Jul 2000, Rafal Krzewski wrote:
> Huh... I believe that I have pretty basic setup - I haven't twaked
> any funny engine properties and such. I'm really surprised that
> there are such differences.
Same here, my Sybase setup is pretty basic (ie: I didn't touch anything).
okidz@bdg:~$ isql -Uturbine -Sbdg
Password:
1> select * from visitor
2> go
Msg 208, Level 16, State 1:
Line 1:
visitor not found. Specify owner.objectname or use sp_help to check
whether the
object exists (sp_help may produce lots of output).
1>
If I use "Visitor", then there would be no problem.
I'm surprised. I've been using Sybase since version 10 (this one was on
Windows), and all I know is that the case is always sensitive.
> OK, this is easy... I can fix it, as soon as other developers agree
> to this changes.
It would be nice if it can be fixed; I guess that the first time Turbine
users would like to see what the screens look like on the first install,
and the first screen would be that login screen.
I don't know, if there's some kind of "Hello World" screen, that would be
nice. So that installation would be easier (no database setup).
> > The two other scripts could be run perfectly.
>
> > Well, because one of the scripts wouldn't run correctly, I
> > think the case
> > is sensitive.
>
> Excuse me, but I think you are contradicting yourself here...
> Colud you please tell me what error messages you get running
> the scripts?
No, I wasn't contradicting myself; I ran 3 scripts, 2 schemas, and one
for data input. I had problem with the data input, because of the mixed
case on the column names.
> I don't think there should be a parameter for changing this...
> Case sensitivity (or lack of it) is a property of their SQL flavour (TSQL).
> I did the following:
I have tried to find one; to no avail.
> All of the selects worked just fine. Then, I used simple JDBCTest
> program to test this under JDBC (yes, I use JConnect 5.2) and
> it worked too.
Not for me; currently, I can't add new Turbine users. I think the problem
is pretty clear, Turbine couldn't access the tables (the columns) due to
the case-sensitiveness.
> Anyway, I have no idea what could be causing your problems
> with the database.
I'd prefer to see it the other way; if the scripts (and the SQL
accesses in the program) were consistent, then there would be no problem.
> > Yes; so some of the Admin's screens couldn't be run; really
> > big problems
> > for Sybase users.
>
> I checked again, and they are working fine for me....
Mmm... I think you should believe me...
> You are messing something up here...
> Why don't you download my war and try it?
> http://193.192.167.243/turbine/download/turbine.war
> (sorry for the messy address, our DNS "is going to be OK really soon")
> it's 1Mb, because it has all needed jars inside
OK, I'll try it out.
> You have to change the following settings:
> WEB-INF/classes/WebMacro.properties:
> - templates path
> - logfile location
>
> WEB-INF/Turbine.properties
> - database settings
> - logfile location
OK, pretty clear.
Thanks a lot.
Oki
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
