Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Now I'm getting all sorts of errors:
- Connecting to Oracle Database using...
- localhost, 1521, null pdborcl, GISD, ********, shapes, tl_2013_us_state, null, 0
- Dropping old table...
- Table not previously created.
- Creating new table...
- java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype
- java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
- Record #1 not converted.
- java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
- Record #2 not converted.
- java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
- ...
- Record #56 not converted.
- 56 record(s) not converted.
- 0 record(s) converted.
- Done.
- host: localhost
- port: 1521
- sid: GDSRV
- db_username: GISD
- db_password: ********
- db_tablename: shapes
- shapefile_name: tl_2013_us_state
- SRID: 0
- db_geometry_column: geom
- Connecting to Oracle Database using...
- localhost, 1521, GDSRV null, GISD, ********, shapes, tl_2013_us_state, null, 0
- java.sql.SQLException: ORA-01017: invalid username/password; logon denied
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
- at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
- at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:938)
- at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:480)
- at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
- at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
- at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:416)
- at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:825)
- at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:596)
- at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
- at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
- at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
- at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at oracle.spatial.util.SampleShapefileToJGeomFeature.main(SampleShapefileToJGeomFeature.java:341)
- Exception in thread "main" java.lang.NullPointerException
- at oracle.spatial.util.SampleShapefileToJGeomFeature.main(SampleShapefileToJGeomFeature.java:345)
- host: localhost
- port: 1521
- sid: pdborcl
- db_username: GISD
- db_password: ********
- db_tablename: shapes
- shapefile_name: tl_2013_us_state
- SRID: 0
- db_geometry_column: geom
- Connecting to Oracle Database using...
- localhost, 1521, pdborcl null, GISD, ********, shapes, tl_2013_us_state, null, 0
- java.sql.SQLException: Listener refused the connection with the following error:
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
- at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
- at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
- at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
- at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at oracle.spatial.util.SampleShapefileToJGeomFeature.main(SampleShapefileToJGeomFeature.java:341)
- Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:272)
- at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)
- at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
- at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
- C:temp>java -cp C:apporclproduct12.1.0dbhomeTestjdbclibojdbc7.jar;C:apporclproduct12.1.0dbhomeTestmdjlibsdoutl.jar;C:apporclproduct12.1.0dbhomeTestmdjlibsd
- oapi.jar oracle.spatial.util.SampleShapefileToJGeomFeature -h localhost -p 1523 -sn pdborclt -u GISD -d gisd -t shapes -f tl_2013_us_state -r 0 -g geom
- host: localhost
- port: 1523
- service_name: pdborclt
- db_username: GISD
- db_password: ********
- db_tablename: shapes
- shapefile_name: tl_2013_us_state
- SRID: 0
- db_geometry_column: geom
- Connecting to Oracle Database using...
- localhost, 1523, null pdborclt, GISD, ********, shapes, tl_2013_us_state, null, 0
- Dropping old table...
- Table not previously created.
- Creating new table...
- Converting record #10 of 56
- Converting record #20 of 56
- Converting record #30 of 56
- Converting record #40 of 56
- Converting record #50 of 56
- 56 record(s) converted.
- Done.
Add Comment
Please, Sign In to add comment