You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Raghdan Rabah <ra...@netways.com> on 2004/09/01 19:58:41 UTC
MySQL SQLException
Hello,
I have jetspeed on WIN2000.
I did install mysql-4.1.3b and MySQL ODBC 3.51.
Then I have built jetspeed database using:
- turbine-mysql.sql
- dbpsml-schema.sql
- populate-mysql.sql
Also, in Torque.properties, i added:
###############################
#R torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver
#R torque.dsfactory.default.connection.url = jdbc:hsqldb:${webappRoot}/WEB-
INF/db/jetspeed
#R torque.dsfactory.default.connection.user = sa
#R torque.dsfactory.default.connection.password =
torque.dsfactory.default.connection.driver = sun.jdbc.odbc.JdbcOdbcDriver
torque.dsfactory.default.connection.url = jdbc:odbc:jetspeed2
torque.dsfactory.default.connection.user = root
torque.dsfactory.default.connection.password =
###############################
Still, jetspeed gives the following LoginException and SQLException:
There has been an Error!
Reason:
org.apache.jetspeed.services.security.LoginException: Failed to get
anonymous user: : Failed to retrieve user 'anon': [MySQL][ODBC 3.51 Driver]
[mysqld-4.1.3b-beta-nt]Unknown column 'TURBINE_USER.PASSWORD_CHANGED'
in 'field list'
Get/Post Data:
password = jetspeed
template = ShowError.vm
action = JLoginUser
submit = Login
username = admin
Stacktrace:
java.sql.SQLException: [MySQL][ODBC 3.51 Driver][mysqld-4.1.3b-beta-
nt]Unknown column 'TURBINE_USER.PASSWORD_CHANGED' in 'field list'
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery
(JdbcOdbcStatement.java:253)
at com.workingdogs.village.QueryDataSet.(Unknown Source)
at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1539)
at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1391)
.
.
.
$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:163)
at
.
.
.
Any help in how to solve this?
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: MySQL SQLException
Posted by "Eric L. Wittle" <er...@wittle.net>.
Raghdan Rabah wrote:
>Hello,
>
>I have jetspeed on WIN2000.
>I did install mysql-4.1.3b and MySQL ODBC 3.51.
>Then I have built jetspeed database using:
>- turbine-mysql.sql
>- dbpsml-schema.sql
>- populate-mysql.sql
>
>Also, in Torque.properties, i added:
>###############################
>#R torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver
>#R torque.dsfactory.default.connection.url = jdbc:hsqldb:${webappRoot}/WEB-
>INF/db/jetspeed
>#R torque.dsfactory.default.connection.user = sa
>#R torque.dsfactory.default.connection.password =
>
>torque.dsfactory.default.connection.driver = sun.jdbc.odbc.JdbcOdbcDriver
>torque.dsfactory.default.connection.url = jdbc:odbc:jetspeed2
>torque.dsfactory.default.connection.user = root
>torque.dsfactory.default.connection.password =
>
>
The jdbc:odbc bridge is a bad idea. Try the MySQL JDBC driver instead.
It is downloadable from the MySQL website.
>###############################
>
>Still, jetspeed gives the following LoginException and SQLException:
>
>There has been an Error!
>Reason:
> org.apache.jetspeed.services.security.LoginException: Failed to get
>anonymous user: : Failed to retrieve user 'anon': [MySQL][ODBC 3.51 Driver]
>[mysqld-4.1.3b-beta-nt]Unknown column 'TURBINE_USER.PASSWORD_CHANGED'
>in 'field list'
>
>Get/Post Data:
>password = jetspeed
>
>template = ShowError.vm
>
>action = JLoginUser
>
>submit = Login
>
>username = admin
>
>Stacktrace:
>
> java.sql.SQLException: [MySQL][ODBC 3.51 Driver][mysqld-4.1.3b-beta-
>nt]Unknown column 'TURBINE_USER.PASSWORD_CHANGED' in 'field list'
> at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
> at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
> at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
> at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
> at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery
>(JdbcOdbcStatement.java:253)
> at com.workingdogs.village.QueryDataSet.(Unknown Source)
> at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1539)
> at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1391)
>.
>.
>.
>
>$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> at org.apache.catalina.valves.ErrorReportValve.invoke
>(ErrorReportValve.java:163)
> at
>
>.
>.
>.
>
>
>Any help in how to solve this?
>
>Regards
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org