[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Insert into Orace TimesTen In Memory DataBase

[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 

anonymous wrote : 
  | 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)
  | 
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3957624#3957624

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3957624