Foros
Nuevos mensajes
Buscar en foros
Acceder
Regístrate
Novedades
Buscar
Buscar
Buscar solo en títulos
De:
Menú
Acceder
Regístrate
Install the app
Instalar
Foros
Software de Gestión
Business Intelligence
Error Pentaho Error connecting to database: (using class org
JavaScript está desactivado. Para una mejor experiencia, por favor, activa JavaScript en el navegador antes de continuar.
Estás utilizando un navegador obsoleto. Este u otros sitios web pueden no ser mostrados correctamente.
Debes actualizarlo o utilizar un
navegador alternativo
.
Responder al tema
Mensaje
<blockquote data-quote="jigal" data-source="post: 21875" data-attributes="member: 21877"><p>Amig@s:</p><p></p><p>Soy nuevo en el uso de la herramienta Pentaho, ya lo instale el PDI o kettle y quiero conectarme a una BD Mysql que tengo y lo hago a través de Input Table pero al querer conectarlo y hago test pero me sale este error, ya revise documentación pero no logro correjirle, si alguién sabe mas detalles de como arreglarlo.</p><p>Saludos a todos Jigal</p><p></p><p>Este es el error que me da.</p><p></p><p>Error connecting to database [mysql] : org.pentaho.di.core.exception.KettleDatabaseException: </p><p>Error occured while trying to connect to the database</p><p></p><p>Error connecting to database: (using class org.gjt.mm.mysql.Driver)</p><p>Unknown character set: 'utf8mb4'</p><p></p><p></p><p>org.pentaho.di.core.exception.KettleDatabaseException: </p><p>Error occured while trying to connect to the database</p><p></p><p>Error connecting to database: (using class org.gjt.mm.mysql.Driver)</p><p>Unknown character set: 'utf8mb4'</p><p></p><p></p><p> at org.pentaho.di.core.database.Database.normalConnect(Database.java:427)</p><p> at org.pentaho.di.core.database.Database.connect(Database.java:361)</p><p> at org.pentaho.di.core.database.Database.connect(Database.java:314)</p><p> at org.pentaho.di.core.database.Database.connect(Database.java:302)</p><p> at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80)</p><p> at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2685)</p><p> at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:546)</p><p> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</p><p> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)</p><p> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</p><p> at java.lang.reflect.Method.invoke(Method.java:483)</p><p> at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)</p><p> at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)</p><p> at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)</p><p> at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43)</p><p> at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:138)</p><p> at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)</p><p> at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)</p><p> at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)</p><p> at org.eclipse.jface.window.Window.open(Window.java:796)</p><p> at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:389)</p><p> at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:318)</p><p> at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116)</p><p> at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:59)</p><p> at org.pentaho.di.ui.trans.step.BaseStepDialog$5.widgetSelected(BaseStepDialog.java:770)</p><p> at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)</p><p> at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)</p><p> at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.open(TableInputDialog.java:435)</p><p> at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124)</p><p> at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8720)</p><p> at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027)</p><p> at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744)</p><p> at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)</p><p> at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)</p><p> at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)</p><p> at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310)</p><p> at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7931)</p><p> at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9202)</p><p> at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648)</p><p> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</p><p> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)</p><p> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</p><p> at java.lang.reflect.Method.invoke(Method.java:483)</p><p> at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)</p><p>Caused by: org.pentaho.di.core.exception.KettleDatabaseException: </p><p>Error connecting to database: (using class org.gjt.mm.mysql.Driver)</p><p>Unknown character set: 'utf8mb4'</p><p></p><p> at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:572)</p><p> at org.pentaho.di.core.database.Database.normalConnect(Database.java:410)</p><p> ... 51 more</p><p>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown character set: 'utf8mb4'</p><p> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</p><p> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</p><p> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</p><p> at java.lang.reflect.Constructor.newInstance(Constructor.java:408)</p><p> at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)</p><p> at com.mysql.jdbc.Util.getInstance(Util.java:360)</p><p> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)</p><p> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)</p><p> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)</p><p> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)</p><p> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)</p><p> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)</p><p> at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1813)</p><p> at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3358)</p><p> at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2278)</p><p> at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2064)</p><p> at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)</p><p> at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)</p><p> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</p><p> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</p><p> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</p><p> at java.lang.reflect.Constructor.newInstance(Constructor.java:408)</p><p> at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)</p><p> at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395)</p><p> at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)</p><p> at java.sql.DriverManager.getConnection(DriverManager.java:664)</p><p> at java.sql.DriverManager.getConnection(DriverManager.java:247)</p><p> at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:554)</p><p> ... 52 more</p></blockquote><p></p>
[QUOTE="jigal, post: 21875, member: 21877"] Amig@s: Soy nuevo en el uso de la herramienta Pentaho, ya lo instale el PDI o kettle y quiero conectarme a una BD Mysql que tengo y lo hago a través de Input Table pero al querer conectarlo y hago test pero me sale este error, ya revise documentación pero no logro correjirle, si alguién sabe mas detalles de como arreglarlo. Saludos a todos Jigal Este es el error que me da. Error connecting to database [mysql] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) Unknown character set: 'utf8mb4' org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) Unknown character set: 'utf8mb4' at org.pentaho.di.core.database.Database.normalConnect(Database.java:427) at org.pentaho.di.core.database.Database.connect(Database.java:361) at org.pentaho.di.core.database.Database.connect(Database.java:314) at org.pentaho.di.core.database.Database.connect(Database.java:302) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2685) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:546) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141) at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43) at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:138) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:389) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:318) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:59) at org.pentaho.di.ui.trans.step.BaseStepDialog$5.widgetSelected(BaseStepDialog.java:770) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.open(TableInputDialog.java:435) at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:124) at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8720) at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3027) at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:744) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1310) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7931) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9202) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.gjt.mm.mysql.Driver) Unknown character set: 'utf8mb4' at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:572) at org.pentaho.di.core.database.Database.normalConnect(Database.java:410) ... 51 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown character set: 'utf8mb4' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) at com.mysql.jdbc.Util.getInstance(Util.java:360) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526) at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1813) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3358) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2278) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2064) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:554) ... 52 more [/QUOTE]
Nombre
Verificación
¿Cuanto es 4-3+2?
Responder
Foros
Software de Gestión
Business Intelligence
Error Pentaho Error connecting to database: (using class org
Arriba
