Guest User

Untitled

a guest
Sep 21st, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.85 KB | None | 0 0
  1. Now I'm getting all sorts of errors:
  2. Connecting to Oracle Database using...
  3. localhost, 1521, null pdborcl, GISD, ********, shapes, tl_2013_us_state, null, 0
  4. Dropping old table...
  5. Table not previously created.
  6. Creating new table...
  7. java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype
  8.  
  9. java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  10.  
  11. Record #1 not converted.
  12. java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  13.  
  14. Record #2 not converted.
  15. java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  16.  
  17. ...
  18.  
  19. Record #56 not converted.
  20. 56 record(s) not converted.
  21. 0 record(s) converted.
  22. Done.
  23.  
  24. host: localhost
  25. port: 1521
  26. sid: GDSRV
  27. db_username: GISD
  28. db_password: ********
  29. db_tablename: shapes
  30. shapefile_name: tl_2013_us_state
  31. SRID: 0
  32. db_geometry_column: geom
  33. Connecting to Oracle Database using...
  34. localhost, 1521, GDSRV null, GISD, ********, shapes, tl_2013_us_state, null, 0
  35. java.sql.SQLException: ORA-01017: invalid username/password; logon denied
  36.  
  37. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  38. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)
  39. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)
  40. at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:938)
  41. at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:480)
  42. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
  43. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
  44. at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:416)
  45. at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:825)
  46. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:596)
  47. at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
  48. at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
  49. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
  50. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
  51. at java.sql.DriverManager.getConnection(Unknown Source)
  52. at java.sql.DriverManager.getConnection(Unknown Source)
  53. at oracle.spatial.util.SampleShapefileToJGeomFeature.main(SampleShapefileToJGeomFeature.java:341)
  54. Exception in thread "main" java.lang.NullPointerException
  55. at oracle.spatial.util.SampleShapefileToJGeomFeature.main(SampleShapefileToJGeomFeature.java:345)
  56.  
  57. host: localhost
  58. port: 1521
  59. sid: pdborcl
  60. db_username: GISD
  61. db_password: ********
  62. db_tablename: shapes
  63. shapefile_name: tl_2013_us_state
  64. SRID: 0
  65. db_geometry_column: geom
  66. Connecting to Oracle Database using...
  67. localhost, 1521, pdborcl null, GISD, ********, shapes, tl_2013_us_state, null, 0
  68. java.sql.SQLException: Listener refused the connection with the following error:
  69. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  70.  
  71. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
  72. at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
  73. at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
  74. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
  75. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
  76. at java.sql.DriverManager.getConnection(Unknown Source)
  77. at java.sql.DriverManager.getConnection(Unknown Source)
  78. at oracle.spatial.util.SampleShapefileToJGeomFeature.main(SampleShapefileToJGeomFeature.java:341)
  79. Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
  80. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  81.  
  82. at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:272)
  83. at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)
  84. at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
  85. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
  86.  
  87. C:temp>java -cp C:apporclproduct12.1.0dbhomeTestjdbclibojdbc7.jar;C:apporclproduct12.1.0dbhomeTestmdjlibsdoutl.jar;C:apporclproduct12.1.0dbhomeTestmdjlibsd
  88. 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
  89. host: localhost
  90. port: 1523
  91. service_name: pdborclt
  92. db_username: GISD
  93. db_password: ********
  94. db_tablename: shapes
  95. shapefile_name: tl_2013_us_state
  96. SRID: 0
  97. db_geometry_column: geom
  98. Connecting to Oracle Database using...
  99. localhost, 1523, null pdborclt, GISD, ********, shapes, tl_2013_us_state, null, 0
  100. Dropping old table...
  101. Table not previously created.
  102. Creating new table...
  103. Converting record #10 of 56
  104. Converting record #20 of 56
  105. Converting record #30 of 56
  106. Converting record #40 of 56
  107. Converting record #50 of 56
  108. 56 record(s) converted.
  109. Done.
Add Comment
Please, Sign In to add comment