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

[grdzeli_kaci]

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#3957622

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