{"action":"closed","issue":{"url":"https://api.github.com/repos/geosolutions-it/shp2oracle/issues/1","labels_url":"https://api.github.com/repos/geosolutions-it/shp2oracle/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/geosolutions-it/shp2oracle/issues/1/comments","events_url":"https://api.github.com/repos/geosolutions-it/shp2oracle/issues/1/events","html_url":"https://github.com/geosolutions-it/shp2oracle/issues/1","id":68609994,"number":1,"title":"Not able to upload on the new Oracle 12c installation","user":{"login":"fabio2111","id":2938392,"avatar_url":"https://avatars.githubusercontent.com/u/2938392?v=3","gravatar_id":"","url":"https://api.github.com/users/fabio2111","html_url":"https://github.com/fabio2111","followers_url":"https://api.github.com/users/fabio2111/followers","following_url":"https://api.github.com/users/fabio2111/following{/other_user}","gists_url":"https://api.github.com/users/fabio2111/gists{/gist_id}","starred_url":"https://api.github.com/users/fabio2111/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fabio2111/subscriptions","organizations_url":"https://api.github.com/users/fabio2111/orgs","repos_url":"https://api.github.com/users/fabio2111/repos","events_url":"https://api.github.com/users/fabio2111/events{/privacy}","received_events_url":"https://api.github.com/users/fabio2111/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-04-15T08:13:38Z","updated_at":"2015-05-07T16:09:16Z","closed_at":"2015-05-07T16:09:16Z","body":"Dear @ Geosolutions,\r\n\r\nWe have recently migrated from Oracle 10 to Oracle 12c and I am experiencing the following issue when trying to upload a shapefile into the DB. Any help is appreciated. Fabio\r\n\r\nThese are the steps:\r\n\r\n1) credentials for entering the DB:\r\nThis is the JNDI config, you can see the details there:\r\n               <Resource name=\"jdbc/figisgis\" auth=\"Container\"\r\n             type=\"javax.sql.DataSource\" driverClassName=\"oracle.jdbc.OracleDriver\"\r\n             url=\"jdbc:oracle:thin:@hqldvoracle01:1531:fisd\"\r\n             username=\"figis_gis\" password=\"xxx\" maxActive=\"6\" maxIdle=\"3\"\r\n             maxWait=\"-1\"/>  \r\n\r\n2) this is the line I pass to shp2oracle:\r\nrun.bat -s E:\\GIS\\RFBMapServer\\RFB_Comp_clip.shp -d fisd -H hqldvoracle01 -S FIGIS_GIS -u figis_gis -p xxx -P 1531\r\n\r\n3) this is the error message I receive:\r\n\r\nShp2Orcl: importing shapefile E:\\GIS\\RFBMapServer\\RFB_Comp_clip.shp\r\njava.lang.RuntimeException: Unable to obtain connection: Cannot create PoolableC\r\nonnectionFactory (ORA-28040: No matching authentication protocol\r\n)\r\n        at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1\r\n666)\r\n        at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:83\r\n3)\r\n        at org.geotools.data.store.ContentDataStore.entry(ContentDataStore.java:\r\n562)\r\n        at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:664)\r\n        at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:140)\r\n        at it.geosolutions.utils.db.Shp2Orcl.importShp(Shp2Orcl.java:240)\r\n        at it.geosolutions.utils.db.Shp2Orcl.main(Shp2Orcl.java:185)\r\nCaused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon\r\nnectionFactory (ORA-28040: No matching authentication protocol\r\n)\r\n        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto\r\nry(BasicDataSource.java:1549)\r\n        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou\r\nrce.java:1388)\r\n        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource\r\n.java:1044)\r\n        at org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getCon\r\nnection(AbstractManageableDataSource.java:46)\r\n        at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1\r\n652)\r\n        ... 6 more\r\nCaused by: java.sql.SQLException: ORA-28040: No matching authentication protocol\r\n\r\n\r\n        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java\r\n:112)\r\n        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)\r\n        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)\r\n        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)\r\n        at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthent\r\nicate.java:294)\r\n        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)\r\n        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:\r\n439)\r\n        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)\r\n        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio\r\nn.java:35)\r\n        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)\r\n        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv\r\nerConnectionFactory.java:38)\r\n        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable\r\nConnectionFactory.java:582)\r\n        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas\r\nicDataSource.java:1556)\r\n        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto\r\nry(BasicDataSource.java:1545)\r\n        ... 10 more\r\nShp2Orcl: Error while creating schema 'RFB_Comp_clip': Unable to obtain connecti\r\non: Cannot create PoolableConnectionFactory (ORA-28040: No matching authenticati\r\non protocol\r\n)\r\nShp2Orcl: Will try to load featuretypes bypassing the error.\r\nException in thread \"main\" java.lang.RuntimeException: Unable to obtain connecti\r\non: Cannot create PoolableConnectionFactory (ORA-28040: No matching authenticati\r\non protocol\r\n)\r\n        at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1\r\n666)\r\n        at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:83\r\n3)\r\n        at org.geotools.data.store.ContentDataStore.entry(ContentDataStore.java:\r\n562)\r\n        at org.geotools.data.store.ContentDataStore.ensureEntry(ContentDataStore\r\n.java:593)\r\n        at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentData\r\nStore.java:385)\r\n        at org.geotools.data.store.ContentDataStore.getFeatureSource(ContentData\r\nStore.java:368)\r\n        at org.geotools.data.store.ContentDataStore.ensureFeatureStore(ContentDa\r\ntaStore.java:449)\r\n        at org.geotools.data.store.ContentDataStore.getFeatureWriter(ContentData\r\nStore.java:431)\r\n        at org.geotools.data.store.ContentDataStore.getFeatureWriter(ContentData\r\nStore.java:466)\r\n        at it.geosolutions.utils.db.Shp2Orcl.importShp(Shp2Orcl.java:252)\r\n        at it.geosolutions.utils.db.Shp2Orcl.main(Shp2Orcl.java:185)\r\nCaused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon\r\nnectionFactory (ORA-28040: No matching authentication protocol\r\n)\r\n        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto\r\nry(BasicDataSource.java:1549)\r\n        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou\r\nrce.java:1388)\r\n        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource\r\n.java:1044)\r\n        at org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getCon\r\nnection(AbstractManageableDataSource.java:46)\r\n        at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1\r\n652)\r\n        ... 10 more\r\nCaused by: java.sql.SQLException: ORA-28040: No matching authentication protocol\r\n\r\n\r\n        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java\r\n:112)\r\n        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)\r\n        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)\r\n        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)\r\n        at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthent\r\nicate.java:294)\r\n        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)\r\n        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:\r\n439)\r\n        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)\r\n        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio\r\nn.java:35)\r\n        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)\r\n        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv\r\nerConnectionFactory.java:38)\r\n        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable\r\nConnectionFactory.java:582)\r\n        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas\r\nicDataSource.java:1556)\r\n        at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFacto\r\nry(BasicDataSource.java:1545)\r\n        ... 14 more\r\n\r\nE:\\GIS\\shp2oracle\\shp2oracle\\bin>\r\n\r\n\r\n"}}