[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-user
Subject:    Re: stored procedure
From:       "jill han" <jhan () bynum ! com>
Date:       2007-07-12 14:58:05
Message-ID: DC6FE147362C62489838F079C478E0C37F973C () blr02 ! bynum ! com
[Download RAW message or body]

Thanks Thomas.
But the error is the same.
Here is some message from the log file.
****************************************
......
Caused by: org.apache.torque.TorqueException: java.sql.SQLException:
ORA-00900: invalid SQL statement

	at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:200)
	at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1395)
	at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1343)
	at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1293)
	at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1256)
	at
com.nequalsone.modules.actions.LoginUser.getUser(LoginUser.java:234)
	at
com.nequalsone.modules.actions.LoginUser.doPerform(LoginUser.java:131)
	... 39 more
Caused by: java.sql.SQLException: ORA-00900: invalid SQL statement

	at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
	at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
	at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:
1839)
	at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1
764)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:2354)
	at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:627
)
	at
com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
	at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1384)
	... 44 more
....

***********************************************
Any other instructions?
Appreciate.

Jill

-----Original Message-----
From: Thomas Vandahl <..@apache.org>
Sent: Wed, 11 Jul 2007 20:33:38 GMT
To: Apache Torque Users List
Subject: Re: stored procedure

jill han wrote:
> String sql = "exec doLogin(" + clientName + ", " + username + ", " +
> password + ")";

My guess would be that clientName, username and password are strings
which need to be quoted in the SQL statement, like

String sql = "exec doLogin('" + clientName + "', '" + username + "', '"
+ password + "')";

Bye, Thomas.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]