Java 与 SQL 开发人员一起超出索引的字符串

String out of index with SQL developer

提问by Juneyoung Oh

I got below message from sql developer when I try to access. I did just nothing special.

当我尝试访问时，我收到了来自 sql 开发人员的以下消息。我只是没有做任何特别的事情。

my connection info like below

我的连接信息如下

• Connection name : z*sch***
• Username : root
• Password : it just numbers and characters(en)
• Connect Type : basic
• Role : default
• Host name : IP4 type address
• Port : 3306(MySQL)
• SID : z*_*

• 连接名称：z*sch***
• 用户名：root
• 密码：它只是数字和字符(zh)
• 连接类型：基本
• 角色：默认
• 主机名：IP4 类型地址
• 端口 : 3306(MySQL)
• SID : z* _*

Sorry for '*', But I sure that I opened information that I can do. There is no long Strings, so I do not know why this program(SQLDeveloper) shows error message 'String out of range'. Give me the light! :D

对不起'*'，但我确定我打开了我可以做的信息。没有长字符串，所以我不知道为什么这个程序（SQLDeveloper）显示错误消息“字符串超出范围”。给我光！:D

java.lang.StringIndexOutOfBoundsException: String index out of range: 13113
  at java.lang.String.checkBounds(String.java:401)
  at java.lang.String.<init>(String.java:338)
  at oracle.net.ns.Packet.extractData(Packet.java:439)
  at oracle.net.ns.RefusePacket.<init>(RefusePacket.java:72)
  at oracle.net.ns.NSProtocol.connect(NSProtocol.java:356)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1126)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:337)
  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:552)
  at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:253)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:526)
  at oracle.jdeveloper.db.adapter.AbstractConnectionCreator.getConnection(AbstractConnectionCreator.java:153)
  at oracle.dbtools.raptor.standalone.connection.RaptorConnectionCreator.getConnection(RaptorConnectionCreator.java:195)
  at oracle.dbtools.raptor.dialogs.conn.ConnectionPrompt.promptForPassword(ConnectionPrompt.java:67)
  at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:321)
  at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:254)
  at oracle.jdevimpl.db.adapter.CADatabaseFactory.createConnectionImpl(CADatabaseFactory.java:60)
  at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:534)
  at oracle.javatools.db.DatabaseFactory.createDatabase(DatabaseFactory.java:208)
  at oracle.jdeveloper.db.DatabaseConnections.getDatabase(DatabaseConnections.java:607)
  at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.getDatabase(Connections.java:172)
  at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1064)
  at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1045)
  at oracle.dbtools.raptor.navigator.DatabaseConnection.openConnectionImpl(DatabaseConnection.java:115)
  at oracle.dbtools.raptor.navigator.AbstractConnectionNode.getConnection(AbstractConnectionNode.java:30)
  at oracle.dbtools.raptor.navigator.ConnectionFilter.getFactory(ConnectionFilter.java:94)
  at oracle.dbtools.raptor.navigator.ConnectionFilter.doWork(ConnectionFilter.java:119)
  at oracle.dbtools.raptor.navigator.ConnectionFilter.doWork(ConnectionFilter.java:104)
  at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
  at java.util.concurrent.FutureTask.run(FutureTask.java:138)
  at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:515)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
  at java.util.concurrent.FutureTask.run(FutureTask.java:138)
  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
  at java.lang.Thread.run(Thread.java:695)

java.lang.StringIndexOutOfBoundsException: String index out of range: 13113
  at java.lang.String.checkBounds(String.java:401)
  at java.lang.String.<init>(String.java:338)
  at oracle.net.ns.Packet.extractData(Packet.java:439)
  at oracle.net.ns.RefusePacket.<init>(RefusePacket.java:72)
  at oracle.net.ns.NSProtocol.connect(NSProtocol.java:356)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1126)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:337)
  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:552)
  at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:253)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:526)
  at oracle.jdeveloper.db.adapter.AbstractConnectionCreator.getConnection(AbstractConnectionCreator.java:153)
  at oracle.dbtools.raptor.standalone.connection.RaptorConnectionCreator.getConnection(RaptorConnectionCreator.java:195)
  at oracle.dbtools.raptor.dialogs.conn.ConnectionPrompt.promptForPassword(ConnectionPrompt.java:67)
  at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:321)
  at oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:254)
  at oracle.jdevimpl.db.adapter.CADatabaseFactory.createConnectionImpl(CADatabaseFactory.java:60)
  at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:534)
  at oracle.javatools.db.DatabaseFactory.createDatabase(DatabaseFactory.java:208)
  at oracle.jdeveloper.db.DatabaseConnections.getDatabase(DatabaseConnections.java:607)
  at oracle.dbtools.raptor.utils.Connections$ConnectionInfo.getDatabase(Connections.java:172)
  at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1064)
  at oracle.dbtools.raptor.utils.Connections.getConnection(Connections.java:1045)
  at oracle.dbtools.raptor.navigator.DatabaseConnection.openConnectionImpl(DatabaseConnection.java:115)
  at oracle.dbtools.raptor.navigator.AbstractConnectionNode.getConnection(AbstractConnectionNode.java:30)
  at oracle.dbtools.raptor.navigator.ConnectionFilter.getFactory(ConnectionFilter.java:94)
  at oracle.dbtools.raptor.navigator.ConnectionFilter.doWork(ConnectionFilter.java:119)
  at oracle.dbtools.raptor.navigator.ConnectionFilter.doWork(ConnectionFilter.java:104)
  at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
  at java.util.concurrent.FutureTask.run(FutureTask.java:138)
  at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:515)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
  at java.util.concurrent.FutureTask.run(FutureTask.java:138)
  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
  at java.lang.Thread.run(Thread.java:695)

采纳答案by VVV

I am sure you have solved this issue, but since I faced this issue and found the solution, I am posting it here so that it might help someone.

我相信您已经解决了这个问题，但是由于我遇到了这个问题并找到了解决方案，所以我将它发布在这里，以便它可以帮助某人。

I got this error while trying to connect to mysql db via sql developer using the oracledb connection tab. SOlution - Loaded the mysql-jdbc jar in sql developer(tools-preference-database-third party jdbc drivers) and when connecting to the sql developer database I selected the my sql tab (appears next to oracle tab in new connection wizard window). Version of sqldev - 4.0.2.15

我在尝试使用oracledb connection 选项卡通过 sql developer 连接到 mysql db 时遇到此错误。解决方案 - 在 sql developer（工具-首选项-数据库-第三方 jdbc 驱动程序）中加载 mysql-jdbc jar，当连接到 sql developer 数据库时，我选择了 my sql 选项卡（出现在新连接向导窗口中的 oracle 选项卡旁边）。sqldev 版本 - 4.0.2.15

回答by Jyoti Verma

I found one more solution for the subjected error. The database I was trying to connect was located on other server. When I did telnet via putty to that linux/AIX server issue was resolved.

我找到了另一个解决错误的解决方案。我尝试连接的数据库位于其他服务器上。当我通过 putty telnet 到那个 linux/AIX 服务器时，问题就解决了。