Hi All
My sincere apologies for this long note (if this is bad mailing list etiquette - I
do apologise), but we have been trying to get Turbine working
for us for over a week now, without much success.
We are looking at using Turbine in the second phase of our project, and as usual
this needed to start yesterday. I have
been looking at the Turbine docs and it seems conceptually very strong.
I am thinking of using it in all our future web based database development.
We have already installed Turbine and Tomcat on Windows NT 4.0. We are using
the snapshot that we downloaded on the 8 Aug 2000.
However, we have still not managed to get the Login working, as well as
the HelloWorld example.
We are using JDK1.2.2 and our JAVA_HOME environment variable is set to
d:\jdk1.2.2
Login:
------
1. We are using the Access database provided with the downloaded files (
ie. Turbine-AccessY2K.mdb)
2. I have set up all the Turbine source files in a Java IDE and recompiled
them (so that I can better debug).
3. The Turbine classes are in directory c:\jakarta-tomcat\webapps\test\WEB-INF\classes
4. I have added /test as a <Context> xml tag in Tomcat's server.xml. with
its docBase = "webapps/test"
5. When I run Turbine in MS Internet Explorer, I get to the login screen.
However, when I type in user=turbine password=turbine, I get a message
"Sorry, your username or password is incorrect!", which is the login.error
property specified in the TurbineResources.properties file.
6. In terms of resolving this, I have put in some debug code in the Turbine
classes. It appears that the first access to the database (to the
VISITOR table) comes back with an exception. Unfortunately, the exception thrown
does not always appear to be the same one.
It is either (Note, I have printed out the actual SQL statement executed):
********************************************************************************************
BasePeer.querySql= SELECT Visitor.VISITORID, Visitor.LOGINID, Visitor.PASSWORD_V
ALUE, Visitor.FIRST_NAME, Visitor.MIDDLE_NAME, Visitor.LAST_NAME, Visitor.SUFFIX
_NAME, Visitor.ADDRESS1, Visitor.ADDRESS2, Visitor.CITY, Visitor.STATE, Visitor.
POSTALCODE, Visitor.COUNTRY, Visitor.CITIZENSHIP, Visitor.PHONE, Visitor.ALTPHON
E, Visitor.FAX, Visitor.CELL, Visitor.PAGER, Visitor.EMAIL, Visitor.MODIFIED, Vi
sitor.CREATED, Visitor.LASTLOGIN, Visitor.OBJECTDATA, Visitor.CONFIRM_VALUE FROM
Visitor WHERE Visitor.LOGINID='turbine'
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLColAttributesString(JdbcOdbc.java, Compiled
Code)
at sun.jdbc.odbc.JdbcOdbcResultSetMetaData.getColAttributeString(JdbcOdb
cResultSetMetaData.java, Compiled Code)
at sun.jdbc.odbc.JdbcOdbcResultSetMetaData.getColumnTypeName(JdbcOdbcRes
ultSetMetaData.java:562)
at com.workingdogs.village.Column.populate(Column.java, Compiled Code)
at com.workingdogs.village.Schema.populate(Schema.java, Compiled Code)
at com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:114)
at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:905)
at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:878)
at org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:818)
at org.apache.turbine.om.user.peer.TurbineUserPeer.doSelect(TurbineUserP
eer.java, Compiled Code)
at org.apache.turbine.om.user.TurbineUser.retrieveFromStorage(TurbineUse
r.java:347)
at org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:
117)
at org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:
89)
at org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java
:97)
**************************************************************************************************
or, sometimes, it is the following exception :
************************************************************************************************
BasePeer.querySql= SELECT Visitor.VISITORID, Visitor.LOGINID, Visitor.PASSWORD_V
ALUE, Visitor.FIRST_NAME, Visitor.MIDDLE_NAME, Visitor.LAST_NAME, Visitor.SUFFIX
_NAME, Visitor.ADDRESS1, Visitor.ADDRESS2, Visitor.CITY, Visitor.STATE, Visitor.
POSTALCODE, Visitor.COUNTRY, Visitor.CITIZENSHIP, Visitor.PHONE, Visitor.ALTPHON
E, Visitor.FAX, Visitor.CELL, Visitor.PAGER, Visitor.EMAIL, Visitor.MODIFIED, Vi
sitor.CREATED, Visitor.LASTLOGIN, Visitor.OBJECTDATA, Visitor.CONFIRM_VALUE FROM
Visitor WHERE Visitor.LOGINID='turbine'
java.lang.NegativeArraySizeException:
at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(JdbcOdbcResultSet.java:703)
at com.workingdogs.village.Value.<init>(Value.java, Compiled Code)
at com.workingdogs.village.Record.createValues(Record.java, Compiled Cod
e)
at com.workingdogs.village.Record.<init>(Record.java:102)
at com.workingdogs.village.DataSet.fetchRecords(DataSet.java, Compiled C
ode)
at com.workingdogs.village.DataSet.fetchRecords(DataSet.java:463)
at com.workingdogs.village.DataSet.fetchRecords(DataSet.java:448)
at org.apache.turbine.om.peer.BasePeer.getSelectResults(BasePeer.java, C
ompiled Code)
at org.apache.turbine.om.peer.BasePeer.getSelectResults(BasePeer.java:95
4)
at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:906)
at org.apache.turbine.om.peer.BasePeer.executeQuery(BasePeer.java:878)
at org.apache.turbine.om.peer.BasePeer.doSelect(BasePeer.java:818)
at org.apache.turbine.om.user.peer.TurbineUserPeer.doSelect(TurbineUserP
eer.java, Compiled Code)
at org.apache.turbine.om.user.TurbineUser.retrieveFromStorage(TurbineUse
r.java:347)
at org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:
117)
at org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:
89)
at org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java
:97)
*****************************************************************************************
HelloWorld:
-----------
1. I have created class com.testco.modules.screens.HelloWorld
2. The class file has been compiled to directory
c:\jakarta-tomcat\webapps\test\WEB-INF\classes
(thus, I have a
c:\jakarta-tomcat\webapps\test\WEB-INF\classes\com\testco\modules\screens\HelloWorld.class
3. I have added com.testco.modules to property "modules.packages" in
TurbineResources.properties
file.
4. When I type in URL localhost:8080/test/servlet/Turbine/screen/HelloWorld,
I get taken back to the Login screen, and when I try to Login, I end up with
the errors described above.
5. I have also tried to set property "screen.homepage" to an empty string so as to
avoid
the login, but when I type in the same URL, this time I get an error
"requested screen not found". (Note: the message I get tells me that
com.testco.modules
is part of my modules.packages)
6. Note, I have also tried setting "screen.homepage=HelloWorld", and when I type in
localhost:8080/test/servlet/Turbine, I do get to the HelloWorld screen in this case.
Does anyone have idea how to resolve any of these issues.
Thanks in advance
Chris
PS. Off Topic Question: Does anyone know where the setting for which JDK Tomcat
must use is??
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
