i've upload file again. this is new link: http://www.2shared.com/file/6esz35JD/dbh2.html i can download it.
On 11 Apr, 13:52, Thotheolh <[email protected]> wrote: > Hi. darkSoulLight, your database zip somehow couldn't be downloaded. > > On Apr 11, 6:41 pm, darkSoulLight <[email protected]> wrote: > > > > > > > > > Hi, > > this is the link to download > > db.http://www.2shared.com/file/BMrUZjPC/Databaseh2.html > > > this is a code class for test db. > > > [code] > > import junit.framework.TestCase; > > > public class TestDbH2Query extends TestCase { > > > private static java.sql.Connection connection = null; > > > public static java.sql.Connection getDbConnection() { > > try { > > if (connection == null || connection.isClosed()) { > > Class.forName("org.h2.Driver"); > > connection = > > java.sql.DriverManager.getConnection("jdbc:h2:C:\ > > \Agord\\AgordTab", "", ""); > > } > > } catch (Exception e) { > > e.printStackTrace(); > > connection = null; > > } > > return connection; > > } > > > public void testAlterOrNotColumn() throws Exception { > > try { > > String sql = "ALTER TABLE TbOvrig ALTER COLUMN OrNot > > Varchar(1000)"; > > java.sql.Statement stmt = > > getDbConnection().createStatement(); > > stmt.executeUpdate(sql); > > System.out.println("OK"); > > sql = "ALTER TABLE TbBase ALTER COLUMN BasPerc62 > > DOUBLE"; > > stmt.executeUpdate(sql); > > System.out.println("OK"); > > stmt.close(); > > getDbConnection().close(); > > } catch (Exception e) { > > e.printStackTrace(); > > } > > } > > > } > > > [/code] > > Thanks for your help. > > > On 9 Apr, 14:48, Thomas Mueller <[email protected]> wrote: > > > > Hi, > > > > > i'll send you a copy of database on monday. > > > > Thanks a lot! Unfortunately, I will be on vacation for two weeks, so > > > I'm not sure if I will have time to look at it until then. > > > > > Do you need java class, too? > > > > Yes, that would be nice. > > > > Regards, > > > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
