与SQL开发人员一起使用的索引不足 [英] String out of index with SQL developer
问题描述
当我尝试访问时,我收到了来自sql developer的以下消息. 我没什么特别的.
我的连接信息如下
- 连接名称:z * sch ***
- 用户名:root
- 密码:它只是数字和字符(英文)
- 连接类型:基本
- 角色:默认
- 主机名:IP4类型地址
- 端口:3306(MySQL)
- SID:z * _ *
对不起,'*',但是我确定我打开了我能做的信息.没有长字符串,所以我不知道为什么该程序(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$1.doWork(ConnectionFilter.java:119) at oracle.dbtools.raptor.navigator.ConnectionFilter$1.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)
我确定您已经解决了此问题,但是由于遇到此问题并找到了解决方案,因此我将其发布在这里,以便对某人有所帮助. /p>
我在尝试使用 oracle db connection选项卡通过sql developer连接到mysql db时遇到此错误. 解决方案-将mysql-jdbc jar加载到sql developer(工具-首选项-数据库-第三方jdbc驱动程序)中,并且在连接到sql developer数据库时,我选择了sql选项卡(出现在新连接向导窗口中的oracle选项卡旁边). sqldev版本-4.0.2.15
I got below message from sql developer when I try to access. I did just nothing special.
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*_*
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
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$1.doWork(ConnectionFilter.java:119) at oracle.dbtools.raptor.navigator.ConnectionFilter$1.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)
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 oracle db 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
这篇关于与SQL开发人员一起使用的索引不足的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!