This content has been marked as final.
Show 1 reply
-
1. Re: Insert into Orace TimesTen In Memory DataBase
grdzeli_kaci Jul 13, 2006 1:33 AM (in response to grdzeli_kaci)sorry when i was wrote
insert into PAATA.STUDENT (ID,NAME,SURNAME,AGE,GROUPID) values (1,'asdasd','asdasdasd',22,2)
i get an error
java.sql.SQLException: [TimesTen][TimesTen 6.0.2 ODBC Driver][TimesTen]TT2206: Table PAATA.STUDENT not found -- file "comp.c", lineno 2031, procedure "sbCompCacheTbl()"
at com.timesten.jdbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6327)
at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:6460)
at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:6425)
at com.timesten.jdbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3934)
at com.timesten.jdbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:420)
at com.timesten.jdbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:360)
at untitled3.Untitled1.main(Untitled1.java:26)
and if i remove shemaname PAATA from insert
insert into STUDENT (ID,NAME,SURNAME,AGE,GROUPID) values (1,'asdasd','asdasdasd',22,2)
i get an error like this :java.sql.SQLException: [TimesTen][TimesTen 6.0.2 ODBC Driver][TimesTen]TT2206: Table ADMINISTRATOR.STUDENT not found -- file "comp.c", lineno 2031, procedure "sbCompCacheTbl()" at com.timesten.jdbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6327) at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:6460) at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:6425) at com.timesten.jdbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3934) at com.timesten.jdbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:420) at com.timesten.jdbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:360) at untitled3.Untitled1.main(Untitled1.java:26)