Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
1752 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
We are using oracle 11g as our database. When I try to use the query database sm
padmanabhanv
over 10 years ago
We are using oracle 11g as our database. When I try to use the query database smart service with the following SELECT query, Select name, address from employee , it does not save and gives a validation error -"Table or view does not exist". However if I change the query to Select "name","address" from "employee", it works fine without issues. I did not see anything in the documentation pertaining to this. Is this how we should be writing the queries?...
OriginalPostID-97107
OriginalPostID-97107
Discussion posts and replies are publicly visible
0
evan.rust
Appian Employee
over 10 years ago
As noted in
forum.appian.com/.../e-97055
, the SQL query statement used by the Query Database Smart Service will vary according to the database (Oracle 11g in your case).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Patty Isecke
Appian Employee
over 10 years ago
The DDL.sql script uses quotations when creating the tables. This Stackoverflow provides some background information on Oracle:
stackoverflow.com/.../ora-00904-invalid-identifier
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
padmanabhanv
over 10 years ago
I had a look at the appian generated SQL while publishing the datastore, it looks like create table "employee" (
"id" number(10,0) not null,
"name" varchar2(255 char) not null,
"address" varchar2(255 char) not null,
primary key ("id")
);
As a best practice should we download the ddl script, remove the auto generated quotes and then run the scripts in the db. Then the issue with quotes will vanish. Any known issues with that?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Patty Isecke
Appian Employee
over 10 years ago
I believe it would be easier if you allowed Appian to create your database structure and include the quotations when creating your queries. However, you do have the option to modify the DDL script.
"When the data structures in your database do not match, you are given the option to create tables manually with a link to download the SQL needed to generate the necessary structure."
forum.appian.com/.../Data_Stores
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 10 years ago
Search for 'teneo' on Forum. You'll find articles related to your query.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel