SQL Exception: Connection refused : Invalid authentication.

Arne Anka Fri, 21 Oct 2005 08:05:10 -0700

hi,

i'm fairly new to derby and experience a problem absolutely not clear tome.programming an java-application (rcp-based, if it matters) i create adatabase programmatically with two tables, reading and writing works well.i restart my application, try to access the db with_exactly_the_same_code_ ... and get the error mentioned in the subject!

-------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0

[/home/arne/Eclipse/.plugins/eclipse/plugins/org.apache.derby.core_10.1.1/derby.jar]10.1.1.0 - (208786)[/home/arne/Eclipse/.plugins/eclipse/plugins/org.apache.derby.core_10.1.1/derbyclient.jar]10.1.1.0 - (208786)[/home/arne/Eclipse/.plugins/eclipse/plugins/org.apache.derby.core_10.1.1/derbytools.jar]10.1.1.0 - (208786)[/home/arne/Eclipse/.plugins/eclipse/plugins/org.apache.derby.core_10.1.1/derbynet.jar]10.1.1.0 - (208786)

------------------------------------------------------

it works well, if i create and access the db in a single session. if tryto access the db in another session later on,Connection conn = DriverManager.getConnection("jdbc:derby:/tmp/TestDB",prop); yields


SQL Exception: Connection refused : Invalid authentication.

at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(UnknownSource)at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(UnknownSource)at org.apache.derby.impl.jdbc.Util.generateCsSQLException(UnknownSource)atorg.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(UnknownSource)at org.apache.derby.impl.jdbc.EmbedConnection.<init>(UnknownSource)at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(UnknownSource)at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(UnknownSource)

        at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)

atde.itcputbus.marinasw.main.dblocal.LocalDBStuff.readEmbedded(LocalDBStuff.java:181)

...

code to create and access (if you find a typo -- the code i use issyntactically correct, i probabyl introduced it here)



 public static void initEmbedded() {
                try{
                   //prop is a java.utils.Properties instance
                   prop.setProperty("derby.user.username", "password");

prop.setProperty("derby.system.home",dbpath.removeLastSegments(1).toOSString());prop.setProperty("derby.connection.requireAuthentication","true");prop.setProperty("derby.database.fullAccessUsers","dba,username");prop.setProperty("derby.authentication.provider","BUILTIN");System.setProperty("derby.system.home",dbpath.removeLastSegments(1).toOSString());


                    Class.forName("org.apache.derby.jdbc.EmbeddedDriver");

                }catch(Exception e){
                    e.printStackTrace();
                }
        }
    }

    public static void createEmbedded(){
        try{

Connection conn =DriverManager.getConnection("jdbc:derby:/tmp/TestDB;create=true", prop);

            Statement s = conn.createStatement();

s.addBatch("CALLSYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.connection.requireAuthentication','true')");s.addBatch("CALLSYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.username','password')");s.addBatch("CALLSYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.fullAccessUsers','dba,username')");s.addBatch("CALLSYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.authentication.provider','BUILTIN')");


            s.executeBatch();

try{//derby does not know "drop table if exists" but yields anerror if the table to drop not exists -- so we need a workaround ...

                s.execute("drop table custs");
                s.execute("drop table orders");
            }catch(SQLException e) {}

s.addBatch("create table custs (id char(5) not null, namechar(40) not null, primary key(id))");s.addBatch("create table orders (id char(8) not null, custidchar(5) not null, total integer, primary key(id, custid))");


            s.executeBatch();

            s.addBatch("insert into custs values('1', 'John Milton')");
            s.addBatch("insert into custs values('2', 'Duns Scotus')");

            s.executeBatch();

            s.addBatch("insert into orders values('0001', '1', 12345)");
            s.addBatch("insert into orders values('0002', '2', 145)");

            s.executeBatch();

            conn.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public static void readEmbedded(){
        try{

Connection conn =DriverManager.getConnection("jdbc:derby:/tmp/TestDB", prop);ResultSet rs=conn.createStatement().executeQuery("select *from custs, orders");

            while(rs.next()) {

System.out.println("-: "+rs.getString(1)+" |"+rs.getString(2)+" | "+rs.getString(3)+" | "+rs.getString(4)+" |"+rs.getString(5));

            }
            conn.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }




--
Schon vor dem comeback von Modern Talking wusste ich:
Dieter Bohlen ist der Preis der Freiheit!
                                                         Heinz Rudolf Kunze

SQL Exception: Connection refused : Invalid authentication.

Reply via email to