CREATE TABLE statement

[former_member27419]

i am accessing the local database through JDBC for an application. but i've been getting "not allowed" errors while trying to execute a CREATE TABLE statement in my servlet. It allows all other statements like insert, delete, select etc. i've been using a default table because of the same reason.

so if someone could please throw some light into it.

[Former Member · Accepted solution]

DDL statements are not allowed at runtime. You need to define the objects (TABLES) in DEV and transport through the hierarchy....

[guru_subramanianb]

Hi,

Statements like Create which is a Data definition one

will not be entertained by the program while executing.

The reason being the DB cannot allocate the required buffer for crating a table at the time of execution.

So the alterantive is create your DB table manually in ur Db and try other DML statements.

Hope it helps.

Regards,

Guru