Hi,
Can you tell me what the password should when using CIPHER=AES and use the
CREATE LINKED TABLE .
It gives this error: Exception in thread "main"
org.h2.jdbc.JdbcSQLException: Wrong user name or password; SQL statement:
CREATE LINKED TABLE IF NOT EXISTS TEST_LINK ( 'org.h2.Driver',
'jdbc:h2:./Copy', 'sa', 'sa', 'TEST' ); [28000-190]
I use h2-1.4.190.jar on Windows 7.
package nl.test.main;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class H2Test
{
public static void main( String[] args ) throws Exception
{
createDatabase();
createLinkedTable();
}
private static void createDatabase() throws SQLException
{
Connection conn = DriverManager.getConnection(
"jdbc:h2:./Data;MV_STORE=FALSE;CIPHER=AES", "sa", "filepwd sa" );
Statement stat = conn.createStatement();
stat.execute( "create table if not exists test(id int primary key, name
varchar)" );
stat.close();
conn.close();
}
private static void createLinkedTable() throws SQLException
{
Connection conn = DriverManager.getConnection(
"jdbc:h2:./Copy;MV_STORE=FALSE;CIPHER=AES", "sa", "filepwd sa" );
Statement stat = conn.createStatement();
stat.execute( "CREATE LINKED TABLE IF NOT EXISTS TEST_LINK (
'org.h2.Driver', 'jdbc:h2:./Copy', 'sa', 'filepwd sa', 'TEST' );" );
stat.close();
conn.close();
}
}
Thanks.
--
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
