Hi all,
I want to use esql, but I've got problems with <esql:parameter>. It
seems the parameter haven't been replaced by its real value.
Here is my xsp, with a java function:
<xsp:logic>
private String createTable() throws SQLException, org.xml.sax.SAXException
{
String tableName = "tmp123456";
//Create table
<esql:connection>
<esql:driver transactions="no">oracle.jdbc.OracleDriver</esql:driver>
<esql:dburl>jdbc:oracle:thin:@localhost:1521:OEMREP</esql:dburl>
<esql:username>SCOTT</esql:username>
<esql:password>TIGER</esql:password>
<esql:execute-query>
<esql:query>create table
<esql:parameter><xsp:expr>tableName</xsp:expr></esql:parameter> (id int
not null primary key)</esql:query>
<!--esql:error-results>
<error><esql:get-message/></error>
</esql:error-results-->
</esql:execute-query>
</esql:connection>
return tableName;
}
</xsp:logic>
...
...
When I call the function from the xsp body I've got the following sql
exception:
Error executing statement: create table ? (cd_id int not null primary
key): java.sql.SQLException:
ORA-00903: invalid table name
I tried to use the direction="in" with the same result. Any Idea?
Regards,
Gabor
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
