This content has been marked as final. Show 3 replies
I fixed this - the problem was that adding the oracle driver to the project library through project properties doesn't do the 'right thing' in this case. The driver has to go in WEB-INF/lib rather than WEB-INF/flex/lib
However, that just got me to the next problem - cannot connect to any Oracle database - just get Channel errors or 'SQL ERROR' even though the SQL is good.
Out of interest, has *anyone* managed to connect to their Oracle Database using the SQLAssembler?
i think you should setup the channels in service-config.xml and make sure your data-management.xml have the default-channel.
Yes I am connecting to a 10g database using SQLAssembler and it is working. Try testing your SQL query within PL/SQL or similar. Also note that you cannot have special characters within the <sql> tags as it will invalidate the schema for data-management-config.xml and result in an SQL ERROR