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