Cannot find the table for my Data Store in my Oracle SQL database

jurajb1 over 7 years ago

#SQLOracleDatabase
Hello guys,

I have a problem with my Oracle SQL Database. I am using the Data Store to save the data to the SQL table, fetch them and I can also show them on the dashboard. However I cannot find the specific table for the Data Store in my SQL Database.
For a CDT I used the same target namespace and for the Data Store I used the same source as for my other Data Stores I can see in my SQL database.

Do you know what could be the problem ?

Thanks

Discussion posts and replies are publicly visible

0 PhilB
Certified Lead Developer
over 7 years ago

Are you looking in the correct database? You say "Oracle SQL Database but then also "in my SQL Database" - do you still mean Oracle or are you also using MySQL? Did you define a table name in the XSD? Have you downloaded the XSD to see what the table name is? The target namespace isn't relevant to the table name.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 7 years ago

yes, I am looking into the Oracle database I am using for DEV environment. Yes. I created the CDT like any other I am already using. I defined the table name in the XSD and also all the columns.
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Table (name="FC_requestStatus")
</xsd:appinfo>
</xsd:annotation>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 7 years ago

I am using only Oracle Database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
Certified Lead Developer
over 7 years ago

Are you accessing the database with the same user as Appian? Did you have Appian create the table or create it yourself? Have you compared the connection strings for the DS and your Oracle client?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 7 years ago

yes, I am accessing the database with the same user as Appian. Appian created the table.
The connection strings are the same.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 7 years ago

I can see info about the table in the folder "Sequences" in the SQL Database
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
Certified Lead Developer
over 7 years ago

Are the tables in the correct schema? Which client are you using?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 7 years ago

yes, they are in the same schema. What do you mean with client ? For accessing the DB I am using Oracle SQL Developer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
Certified Lead Developer
over 7 years ago

Can you run a select on the table and see rows returned?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Durgesh
A Score Level 2
over 7 years ago

For Oracle database, you can check for table naming convention (Upper case & lower case matters), underscore & make sure schema name is properly given.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel