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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/h2-database >> <http://groups.google.com/group/h2-database>. >> For more options, visit https://groups.google.com/groups/opt_out >> <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.
