I will agree with everyone else and tell you to use MySQL instead. It has
been released under GPL as well so there should not even be the $200 per
windows server to hold you back (I do not know the full details of which
version has been released as GPL.) And you will get a much more capable db.
You are not going to find many Access gurus here. But it would be nice if
the person who submitted the Access db, would comment on these errors. As a
guess, I would suggest trying to remove the blob column from the query to
see if you can get it working or are there any other jdbc drivers that you
could tr?. Have you tried submitting the query through some other client?
----- Original Message -----
From: Gopal Ramasammy-Cook <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 5:14 AM
Subject: DB access exception(s)
> 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\He
lloWorld.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]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
