Hi, I spot two things:
> 11:17:42,137 INFO ~ Table TEST needs to be removed This message is from the Play framework. I think you need to ask there, or at StackOverflow.com The second thing is the error code, [42102-166], this means you are using build 166 (the "-166" means you are using this build). This is quite old, I suggest to upgrade to a more recent version of H2, because many bugs have been fixed (unrelated to your problem). Regards, Thomas On Tue, Dec 3, 2013 at 6:38 AM, Ryan How <[email protected]> wrote: > No idea. Must be an issue in your config. Try opening another connection > to your DB from the H2 console and see what happens to the tables. > > > On 3/12/2013 1:32 PM, 董藝興 wrote: > > NO,i setting file application.conf is > connection<http://www.h2database.com/html/features.html#embedded_databases> > database > "db.url=jdbc:h2:tcp://10.1.1.222/~/test<http://www.google.com/url?q=http%3A%2F%2F10.1.1.222%2F%7E%2Ftest&sa=D&sntz=1&usg=AFQjCNFDzEbF338PEfjfJJ9EitJ9GD6lJQ> > ;" > > Kartweel於 2013年12月3日星期二UTC+8下午12時48分59秒寫道： >> >> Are you using an in memory database? They don't persist so will be >> blank each time you open it. >> >> >> On 3/12/2013 11:29 AM, 董藝興 wrote: >> >> Do not know why...... >> 11:17:41,719 INFO ~ Connected to jdbc:h2:tcp://10.1.1.222/~/ >> test;CACHE_SIZE=131 <http://10.1.1.222/%7E/test;CACHE_SIZE=131> >> 072;CACHE_TYPE=SOFT_LRU;WRITE_DELAY=2000 >> 11:17:41,747 INFO ~ GAE environment detected >> 11:17:41,749 INFO ~ Siena DB Type: sql:h2:mysql >> 11:17:42,131 INFO ~ Table FT_INDEXES needs to be removed >> 11:17:42,137 INFO ~ Table IGNORELIST needs to be removed >> 11:17:42,137 INFO ~ Table MAP needs to be removed >> 11:17:42,137 INFO ~ Table ROWS needs to be removed >> 11:17:42,137 INFO ~ Table TEST needs to be removed >> 11:17:42,138 INFO ~ Table WORDS needs to be removed >> 11:17:42,168 INFO ~ Executed 6 SQL command(s) with 0 error(s) >> 11:17:42,197 INFO ~ Application 'Yi' is now started ! >> >> msg: select * from test where id = '1' >> Exception: Table "TEST" not found; SQL statement: >> select * from test where id = '1' [42102-166] >> >> application.conf >> >> # Database configuration >> db.default.driver=org.h2.Driver >> # db.default.url="jdbc:h2:fs:play" >> db.default.url="jdbc:h2:mem:play" >> db.url=jdbc:h2:tcp://10.1.1.222/~/test <http://10.1.1.222/%7E/test>; >> >> db.driver=org.h2.Driver >> #db.driver=com.mysql.jdbc.Driver >> db.user=sa >> db.pass= >> >> >> >> >> >> #source code >> >> package controllers; >> >> import play.*; >> import play.mvc.*; >> >> import java.sql.Connection; >> //import java.sql.DriverManager; >> import java.sql.ResultSet; >> import java.sql.SQLException; >> import java.sql.Statement; >> import java.util.*; >> >> import play.db.DB; >> >> >> //@With(Secure.class) >> public class Application extends Controller { >> //@Check("User") >> public static void index() throws ClassNotFoundException { >> System.out.println("start"); >> String SQLString; >> Connection Con = DB.getConnection(); >> SQLString = "select *"; >> SQLString += " from test"; >> SQLString += " where id = '" + "1'" ; >> //SQLString = "SHOW TABLES;"; >> System.out.println("msg: " + SQLString); >> try{ >> >> Statement Stmt = Con.createStatement(); >> if(Stmt == null) { >> System.out.println("Stmt is null"); >> } >> ResultSet Result = Stmt.executeQuery(SQLString); >> if(Result == null) { >> System.out.println("Res is null"); >> } >> Result.next(); >> System.out.println(Result.getString("ID")); >> if(Con != null) { >> Con.close(); >> } else { >> System.out.println("Con is null"); >> } >> }catch(Exception e) { >> >> System.out.println("Exception: " + e.getMessage()); >> } >> >> render(); >> >> } >> >> public static void index1(String name,String hidden) { >> >> render(name,hidden); >> >> >> } >> >> } >> >> Who can help me????A connection will remove database?? >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
