db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jill han" <j...@bynum.com>
Subject Re: stored procedure
Date Thu, 12 Jul 2007 14:58:05 GMT
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


Mime
View raw message