You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by bogdan_voloshincu <bo...@yahoo.com> on 2010/11/22 19:35:22 UTC
cdataport Access denied for user .......
Hello ! i have a little issue with <cdataport> ant task. it runs very good
until it has to connect to database. If all the parameters ( username and
password , min = 1 , max = 10) from the node .driver.xml are ok why it
can't connect.
thank's for you responses !
--------------------------------------------------------------------------------------
[mkdir] Created dir: C:\Users\abc\wCayenne\Data_Cayenne\dist
import_oracle:
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate startedLoading
[cdataport] INFO: started configuration loading.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataDomain
[cdataport] INFO: loaded domain: oracle
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate loadDataMap
[cdataport] INFO: loaded <map name='oracle' location='oracle.map.xml'>.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
[cdataport] INFO: loading <node name='oracle' datasource='oracle.driver.xml'
factory='org.apache.cayenne.conf.DriverDataSourceFactory'
schema-update-strategy='org.apache.cayenne.access.dbsync.SkipSchemaUpdateStrategy'>.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
[cdataport] INFO: using factory:
org.apache.cayenne.conf.DriverDataSourceFactory
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.DriverDataSourceFactory load
[cdataport] INFO: loading driver information from 'oracle.driver.xml'.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.DriverDataSourceFactory$DriverHandler init
[cdataport] INFO: loading driver oracle.jdbc.driver.OracleDriver
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.DriverDataSourceFactory$LoginHandler init
[cdataport] INFO: loading user name and password.
[cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
logPoolCreated
[cdataport] INFO: Created connection pool:
jdbc:oracle:thin:@localhost:1521:XE
[cdataport] Driver class: oracle.jdbc.driver.OracleDriver
[cdataport] Min. connections in the pool: 1
[cdataport] Max. connections in the pool: 10
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
[cdataport] INFO: loaded datasource.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate initAdapter
[cdataport] INFO: no adapter set, using automatic adapter.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLinkDataMap
[cdataport] INFO: loaded map-ref: oracle.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
[cdataport] INFO: loading <node name='mysql' datasource='mysql.driver.xml'
factory='org.apache.cayenne.conf.DriverDataSourceFactory'
schema-update-strategy='org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy'>.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
[cdataport] INFO: using factory:
org.apache.cayenne.conf.DriverDataSourceFactory
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.DriverDataSourceFactory load
[cdataport] INFO: loading driver information from 'mysql.driver.xml'.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.DriverDataSourceFactory$DriverHandler init
[cdataport] INFO: loading driver com.mysql.jdbc.Driver
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.DriverDataSourceFactory$LoginHandler init
[cdataport] INFO: loading user name and password.
[cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
logPoolCreated
[cdataport] INFO: Created connection pool: jdbc:mysql://localhost:3306/date
[cdataport] Driver class: com.mysql.jdbc.Driver
[cdataport] Min. connections in the pool: 1
[cdataport] Max. connections in the pool: 10
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate shouldLoadDataNode
[cdataport] INFO: loaded datasource.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate initAdapter
[cdataport] INFO: no adapter set, using automatic adapter.
[cdataport] Nov 22, 2010 8:26:18 PM
org.apache.cayenne.conf.RuntimeLoadDelegate finishedLoading
[cdataport] INFO: finished configuration loading in 219 ms.
[cdataport] Porting from 'oracle' to 'mysql'.
[cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
logQueryStart
[cdataport] INFO: --- will run 1 query.
[cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
logConnect
[cdataport] INFO: Opening connection: jdbc:mysql://localhost:3306/date
[cdataport] Login: null
[cdataport] Password: *******
[cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
logConnectFailure
[cdataport] INFO: *** Connecting: FAILURE.
[cdataport] java.sql.SQLException: Access denied for user ''@'localhost'
(using password: NO)
[cdataport] at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
[cdataport] at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[cdataport] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
[cdataport] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
[cdataport] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
[cdataport] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
[cdataport] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
[cdataport] at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
[cdataport] at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
[cdataport] at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
[cdataport] at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[cdataport] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
[cdataport] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
[cdataport] at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
[cdataport] at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[cdataport] at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
[cdataport] at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
[cdataport] at
org.apache.cayenne.conn.DriverDataSource.getConnection(DriverDataSource.java:156)
[cdataport] at
org.apache.cayenne.conn.DriverDataSource.getConnection(DriverDataSource.java:128)
[cdataport] at
org.apache.cayenne.conn.PooledConnectionImpl.reconnect(PooledConnectionImpl.java:83)
[cdataport] at
org.apache.cayenne.conn.PooledConnectionImpl.getConnection(PooledConnectionImpl.java:120)
[cdataport] at
org.apache.cayenne.conn.PoolManager.uncheckConnection(PoolManager.java:369)
[cdataport] at
org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:340)
[cdataport] at
org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:330)
[cdataport] at
org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:375)
[cdataport] at
org.apache.cayenne.conf.NodeDataSource.getConnection(NodeDataSource.java:46)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.loadAdapter(AutoAdapter.java:170)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.getAdapter(AutoAdapter.java:155)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.tableTypeForTable(AutoAdapter.java:308)
[cdataport] at
org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy.getNameTablesInDB(CreateIfNoSchemaStrategy.java:93)
[cdataport] at
org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy.processSchemaUpdate(CreateIfNoSchemaStrategy.java:47)
[cdataport] at
org.apache.cayenne.access.dbsync.BaseSchemaUpdateStrategy.updateSchema(BaseSchemaUpdateStrategy.java:48)
[cdataport] at
org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:355)
[cdataport] at
org.apache.cayenne.conf.NodeDataSource.getConnection(NodeDataSource.java:46)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.loadAdapter(AutoAdapter.java:170)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.getAdapter(AutoAdapter.java:155)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.getExtendedTypes(AutoAdapter.java:263)
[cdataport] at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:243)
[cdataport] at
org.apache.cayenne.access.DataPort.processDelete(DataPort.java:151)
[cdataport] at
org.apache.cayenne.access.DataPort.execute(DataPort.java:110)
[cdataport] at
org.apache.cayenne.tools.DataPortTask.execute(DataPortTask.java:104)
[cdataport] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[cdataport] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[cdataport] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[cdataport] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[cdataport] at java.lang.reflect.Method.invoke(Method.java:597)
[cdataport] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[cdataport] at org.apache.tools.ant.Task.perform(Task.java:348)
[cdataport] at org.apache.tools.ant.Target.execute(Target.java:357)
[cdataport] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[cdataport] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[cdataport] at
org.apache.tools.ant.Project.executeTarget(Project.java:1306)
[cdataport] at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[cdataport] at
org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
[cdataport] at
org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[cdataport] at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
[cdataport] at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
[cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
logConnect
[cdataport] INFO: Opening connection: jdbc:mysql://localhost:3306/date
[cdataport] Login: null
[cdataport] Password: *******
[cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
logConnectFailure
[cdataport] INFO: *** Connecting: FAILURE.
[cdataport] java.sql.SQLException: Access denied for user ''@'localhost'
(using password: NO)
[cdataport] at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
[cdataport] at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[cdataport] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
[cdataport] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
[cdataport] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
[cdataport] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
[cdataport] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
[cdataport] at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
[cdataport] at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
[cdataport] at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
[cdataport] at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[cdataport] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
[cdataport] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
[cdataport] at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
[cdataport] at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[cdataport] at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
[cdataport] at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
[cdataport] at
org.apache.cayenne.conn.DriverDataSource.getConnection(DriverDataSource.java:156)
[cdataport] at
org.apache.cayenne.conn.DriverDataSource.getConnection(DriverDataSource.java:128)
[cdataport] at
org.apache.cayenne.conn.PooledConnectionImpl.reconnect(PooledConnectionImpl.java:83)
[cdataport] at
org.apache.cayenne.conn.PooledConnectionImpl.getConnection(PooledConnectionImpl.java:120)
[cdataport] at
org.apache.cayenne.conn.PoolManager.uncheckConnection(PoolManager.java:369)
[cdataport] at
org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:353)
[cdataport] at
org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:330)
[cdataport] at
org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:375)
[cdataport] at
org.apache.cayenne.conf.NodeDataSource.getConnection(NodeDataSource.java:46)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.loadAdapter(AutoAdapter.java:170)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.getAdapter(AutoAdapter.java:155)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.tableTypeForTable(AutoAdapter.java:308)
[cdataport] at
org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy.getNameTablesInDB(CreateIfNoSchemaStrategy.java:93)
[cdataport] at
org.apache.cayenne.access.dbsync.CreateIfNoSchemaStrategy.processSchemaUpdate(CreateIfNoSchemaStrategy.java:47)
[cdataport] at
org.apache.cayenne.access.dbsync.BaseSchemaUpdateStrategy.updateSchema(BaseSchemaUpdateStrategy.java:48)
[cdataport] at
org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:355)
[cdataport] at
org.apache.cayenne.conf.NodeDataSource.getConnection(NodeDataSource.java:46)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.loadAdapter(AutoAdapter.java:170)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.getAdapter(AutoAdapter.java:155)
[cdataport] at
org.apache.cayenne.dba.AutoAdapter.getExtendedTypes(AutoAdapter.java:263)
[cdataport] at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:243)
[cdataport] at
org.apache.cayenne.access.DataPort.processDelete(DataPort.java:151)
[cdataport] at
org.apache.cayenne.access.DataPort.execute(DataPort.java:110)
[cdataport] at
org.apache.cayenne.tools.DataPortTask.execute(DataPortTask.java:104)
[cdataport] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[cdataport] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[cdataport] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[cdataport] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[cdataport] at java.lang.reflect.Method.invoke(Method.java:597)
[cdataport] at
org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[cdataport] at org.apache.tools.ant.Task.perform(Task.java:348)
[cdataport] at org.apache.tools.ant.Target.execute(Target.java:357)
[cdataport] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[cdataport] at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[cdataport] at
org.apache.tools.ant.Project.executeTarget(Project.java:1306)
[cdataport] at
org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[cdataport] at
org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
[cdataport] at
org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[cdataport] at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
[cdataport] at
org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
BUILD FAILED
C:\Users\abc\wCayenne\Data_Cayenne\build.xml:146: Error porting data: Access
denied for user ''@'localhost' (using password: NO)
--
View this message in context: http://cayenne.195.n3.nabble.com/cdataport-Access-denied-for-user-tp1947844p1947844.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: cdataport Access denied for user .......
Posted by bogdan_voloshincu <bo...@yahoo.com>.
I overwrite all the files from resources and it connect but i get other
error : Error porting data: null
I looked at DataPortTask but still i don't know what is wrong .
thank's for responses
--
View this message in context: http://cayenne.195.n3.nabble.com/cdataport-Access-denied-for-user-tp1947844p1953345.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: cdataport Access denied for user .......
Posted by bogdan_voloshincu <bo...@yahoo.com>.
from the same computer. Is my cayenne.xml correct ???
---------------------------------------------------------------
<domains project-version="3.0.0.1">
<domain name="oracle">
<map name="oracle" location="oracle.map.xml" />
<node name="oracle"
datasource="oracle.driver.xml"
factory="org.apache.cayenne.conf.DriverDataSourceFactory">
<map-ref name="oracle" />
</node>
<node name="mysql" datasource="mysql.driver.xml"
factory="org.apache.cayenne.conf.DriverDataSourceFactory" />
</domain>
</domains>
--------------------------------------------------------------------
--
View this message in context: http://cayenne.195.n3.nabble.com/cdataport-Access-denied-for-user-tp1947844p1952568.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: cdataport Access denied for user .......
Posted by Andrus Adamchik <an...@objectstyle.org>.
On Nov 23, 2010, at 11:33 AM, bogdan_voloshincu wrote:
>
> Yes and before cdataport i use cdbimport and cgen and those two work without
> any problems.
Both against MySQL, not Oracle? And from the same client computer?
Andrus
Re: cdataport Access denied for user .......
Posted by bogdan_voloshincu <bo...@yahoo.com>.
Yes and before cdataport i use cdbimport and cgen and those two work without
any problems.
--
View this message in context: http://cayenne.195.n3.nabble.com/cdataport-Access-denied-for-user-tp1947844p1952374.html
Sent from the Cayenne - User mailing list archive at Nabble.com.
Re: cdataport Access denied for user .......
Posted by Andrus Adamchik <an...@objectstyle.org>.
Login is "null", is this correct?
Andrus
On Nov 22, 2010, at 8:35 PM, bogdan_voloshincu wrote:
> [cdataport] INFO: Opening connection: jdbc:mysql://localhost:3306/date
> [cdataport] Login: null
> [cdataport] Password: *******
> [cdataport] Nov 22, 2010 8:26:18 PM org.apache.cayenne.access.QueryLogger
> logConnectFailure
> [cdataport] INFO: *** Connecting: FAILURE.