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

i have created table in oracle timesten [ | CREATE TABLE "PAATA"."STUDENT" ( | "ID" INTEGER NOT NULL, | "NAME" VARCHAR(200), | "SURNAME" VARCHAR(200), | "AGE" INTEGER, | "GROUPID" INTEGER | ) ; | /code] | | then i tried to insert from java | | | | import java.sql.DriverManager; | | import java.sql.Connection; | | import java.sql.*; | | | | public class TestTimesTen { | | public static void main(String[] args) { | | try { | | Class.forName("com.timesten.jdbc.TimesTenDriver"); | | String URL = "jdbc:timesten:DSName"; | | Connection _Connection = DriverManager.getConnection(URL); | | Statement stmt = _Connection.createStatement(); | | int res1 = stmt.executeUpdate("insert into PAATA.STUDENT (ID,NAME,SURNAME,AGE,GROUPID) values (1,'asdasd','asdasdasd',22,2)"); | | | | System.out.println("asdasdasdasd"); | | } | | catch (SQLException ex) { | | ex.printStackTrace(); | | } | | catch (ClassNotFoundException ex) { | | ex.printStackTrace(); | | } | | } | | } | | | | | | | but i get an error :( i don't know why :( | | | | 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.executeQuery(JdbcOdbcStatement.java:328) | | at untitled3.Untitled1.main(Untitled1.java:16) | | | | | | can anybody help me ? | thanks.... | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3957622#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...