Hi, all:
I want to use Hypersonic database with jetspeed, but I met some problem:
in TR.prop file, I set:
database.default.driver=org.hsql.jdbcDriver
database.default.url=jdbc:HypersonicSQL:${webappRoot}/WEB-INF/db/jetspeed
database.default.username=sa
database.default.password=
while in the code, I wrote:
// set up the database connection
Connection conn = DriverManager.getConnection
("jdbc:HypersonicSQL:jetspeed", "sa", "");
DriverManager.registerDriver (new org.hsql.jdbcDriver ());
Statement stmt = conn.createStatement ();
// get the current userID
String sql = "SELECT TURBINE_USER.USER_ID, TURBINE_USER.LOGIN_NAME,
TURBINE_USER.PASSWORD_VALUE, TURBINE_USER.FIRST_NAME,
TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL, TURBINE_USER.CONFIRM_VALUE,
TURBINE_USER.MODIFIED, TURBINE_USER.CREATED, TURBINE_USER.LAST_LOGIN,
TURBINE_USER.OBJECTDATA FROM TURBINE_USER WHERE
(TURBINE_USER.LOGIN_NAME='turbine')";
ResultSet rset = stmt.executeQuery (sql);
.....
but I got this error message:
java.sql.SQLException: Table not found: TURBINE_USER in statement [SELECT
TURBIN
E_USER.USER_ID, TURBINE_USER.LOGIN_NAME, TURBINE_USER.PASSWORD_VALUE,
TURBINE_US
ER.FIRST_NAME, TURBINE_USER.LAST_NAME, TURBINE_USER.EMAIL,
TURBINE_USER.CONFIRM_
VALUE, TURBINE_USER.MODIFIED, TURBINE_USER.CREATED,
TURBINE_USER.LAST_LOGIN, TUR
BINE_USER.OBJECTDATA FROM TURBINE_USER WHERE
(TURBINE_USER.LOGIN_NAME='turbine')
]
However, I am pretty sure that the TURBINE_USER table is there, because the
login is successful. Does anyone have a clue of this? Thanks in advance.
Zhen
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
