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.
