hello Thomas Mueller And play framework version Matter? my play framework version play-1.2.5.3
Thomas Mueller於 2013年12月3日星期二UTC+8下午1時49分24秒寫道： > > 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]<javascript:> > > 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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.
