Skip to Content
0
Former Member
Apr 15, 2008 at 12:37 PM

The SQL statement "SELECT * FROM "SDBAH"" contains the semantics error[s]:

307 Views

Hello all together,

actually I try to implement an user interface for using BRTools from a J2EE Application.

I created a datasource-alias "BRTOOLS" using netweaver administrator.

inside the implementation i execute the following code:

DataSource ds = (DataSource) ctx.lookup("jdbc/BRTOOLS");

Connection con = ds.getConnection();

String query = "select * from SDBAH;";

Statement stmt = con.createStatement();

try {

ResultSet rs = stmt.executeQuery(query);

........

As the result I get the following message:

The SQL statement "SELECT * FROM "SDBAH"" contains the semantics error[s]: - 1:15 - the table or view >>SDBAH<< does not exist.

Using SQLplus or dbconsole I can see and use the table SDBAH. The table scheme is "SAPSR3DB"which is the standard scheme for J2EE.

If I try:

select * from SAPSR3DB.SDBAH;

I get the same result.

What is wrong in my constellation?

Thank you very much in advance.

Greetings Stephan