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~%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
> 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;
>
> 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.
> 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.
