Hello Rick.
I tried your program and worked as espected, here is de output:
Cierre de la base de datos 'memory:db'.
Correctly failed to connect without credentials: Se ha producido un fallo de
autenticación de conexión. Motivo: Autenticación no válida..
Successfully connected as user APP.
Afer that worked, I replaced "jdbc:derby:memory:db" with
"jdbc:derby://localhost:1527/demo4" and got the exception I'm pasting below
this. I don´t know what I'm configuring wrong.
Thanks in advance.
Exception in thread "main" java.sql.SQLSyntaxErrorException:
'SYSCS_UTIL.SYSCS_CREATE_USER' no se reconoce como una función o
procedimiento.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.Connection.prepareCall(Unknown Source)
at CreateNativeUser1.main(CreateNativeUser1.java:23)
Caused by: org.apache.derby.client.am.SqlException:
'SYSCS_UTIL.SYSCS_CREATE_USER' no se reconoce como una función o
procedimiento.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at
org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readPrepare(Unknown
Source)
at org.apache.derby.client.net.StatementReply.readPrepare(Unknown
Source)
at org.apache.derby.client.net.NetStatement.readPrepare_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepare(Unknown Source)
at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInput(Unknown
Source)
at
org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareCallX(Unknown Source)
... 2 more
--
Sent from:
http://apache-database.10148.n7.nabble.com/Apache-Derby-Developers-f4.html
