java.lang.RuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • [java] Exception in thread "main" java.lang.RuntimeException: db-hibernate for PortalDb failed [java] at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:137) [java] at org.jasig.portal.shell.PortalShellBuildHelper$hibernateCreate.call(Unknown Source) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128) [java] at upshell_114218966.run(upshell_114218966.groovy:20) [java] at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:257) [java] at groovy.lang.GroovyShell.run(GroovyShell.java:220) [java] at org.jasig.portal.shell.PortalShell.main(PortalShell.java:86) [java] Caused by: java.lang.RuntimeException: Failed to execute: create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA longtext not null, MEMBER_ADDRESS_CLASS varchar(100) not null, CLUSTER_NAME varchar(100) not null, MEMBER_ADDRESS longtext, PHYSICAL_ADDRESS_CLASS varchar(100), PHYSICAL_ADDRESS_DATA longtext, PHYSICAL_ADDRESS longtext, primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:133) [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.create(DataSourceSchemaExport.java:102) [java] at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:132) [java] ... 8 more [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA longtext not null, MEMBER_ADDRESS_CLASS varchar(100) not null, CLUSTER_NAME varchar(100) not null, MEMBER_ADDRESS longtext, PHYSICAL_ADDRESS_CLASS varchar(100), PHYSICAL_ADDRESS_DATA longtext, PHYSICAL_ADDRESS longtext, primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME))]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428) [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:127) [java] ... 10 more [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] at sun.reflect.GeneratedConstructorAccessor143.newInstance(Unknown Source) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [java] at com.mysql.jdbc.Util.getInstance(Util.java:386) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768) [java] at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) [java] at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) [java] at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [java] at java.lang.reflect.Method.invoke(Method.java:606) [java] at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) [java] at com.sun.proxy.$Proxy130.execute(Unknown Source) [java] at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) [java] ... 12 more
    via by Drew Wills,
  • UP_JGROUPS_PING uses BLOB type on MySQL for byte[] which cannot be part of a key. {noformat} [java] ERROR [36:56,664] Failed to execute: create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB [java] StatementCallback; bad SQL grammar [create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] INFO [36:56,967] Closing JPA EntityManagerFactory for persistence unit 'PortalDb' [java] INFO [36:57,235] Closing JPA EntityManagerFactory for persistence unit 'AggrEventsDb' [java] INFO [36:57,280] Closing JPA EntityManagerFactory for persistence unit 'RawEventsDb' [java] Exception in thread "main" java.lang.RuntimeException: db-hibernate for PortalDb failed [java] at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:137) [java] at org.jasig.portal.shell.PortalShellBuildHelper$hibernateCreate.call(Unknown Source) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128) [java] at upshell_1583455373.run(upshell_1583455373.groovy:20) [java] at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:257) [java] at groovy.lang.GroovyShell.run(GroovyShell.java:220) [java] at org.jasig.portal.shell.PortalShell.main(PortalShell.java:86) [java] Caused by: java.lang.RuntimeException: Failed to execute: create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:133) [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.create(DataSourceSchemaExport.java:102) [java] at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:132) [java] ... 8 more [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428) [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:127) [java] ... 10 more [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] at sun.reflect.GeneratedConstructorAccessor149.newInstance(Unknown Source) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) [java] at com.mysql.jdbc.Util.getInstance(Util.java:381) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) [java] at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) [java] at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) [java] at $Proxy173.execute(Unknown Source) [java] at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) [java] ... 12 more {noformat}
    via by Eric Dalquist,
  • UP_JGROUPS_PING uses BLOB type on MySQL for byte[] which cannot be part of a key. {noformat} [java] ERROR [36:56,664] Failed to execute: create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB [java] StatementCallback; bad SQL grammar [create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] INFO [36:56,967] Closing JPA EntityManagerFactory for persistence unit 'PortalDb' [java] INFO [36:57,235] Closing JPA EntityManagerFactory for persistence unit 'AggrEventsDb' [java] INFO [36:57,280] Closing JPA EntityManagerFactory for persistence unit 'RawEventsDb' [java] Exception in thread "main" java.lang.RuntimeException: db-hibernate for PortalDb failed [java] at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:137) [java] at org.jasig.portal.shell.PortalShellBuildHelper$hibernateCreate.call(Unknown Source) [java] at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) [java] at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128) [java] at upshell_1583455373.run(upshell_1583455373.groovy:20) [java] at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:257) [java] at groovy.lang.GroovyShell.run(GroovyShell.java:220) [java] at org.jasig.portal.shell.PortalShell.main(PortalShell.java:86) [java] Caused by: java.lang.RuntimeException: Failed to execute: create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:133) [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.create(DataSourceSchemaExport.java:102) [java] at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:132) [java] ... 8 more [java] Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA blob not null, MEMBER_ADDRESS_CLASS varchar(200) not null, CLUSTER_NAME varchar(200) not null, MEMBER_ADDRESS varchar(500), PHYSICAL_ADDRESS_CLASS varchar(200), PHYSICAL_ADDRESS_DATA blob, PHYSICAL_ADDRESS varchar(500), primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) ENGINE=InnoDB]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [java] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428) [java] at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:127) [java] ... 10 more [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length [java] at sun.reflect.GeneratedConstructorAccessor149.newInstance(Unknown Source) [java] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [java] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) [java] at com.mysql.jdbc.Util.getInstance(Util.java:381) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) [java] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) [java] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) [java] at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) [java] at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [java] at java.lang.reflect.Method.invoke(Method.java:597) [java] at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) [java] at $Proxy173.execute(Unknown Source) [java] at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421) [java] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) [java] ... 12 more {noformat}
    via by Eric Dalquist,
  • GitHub comment 79#69136623
    via GitHub by pkvov
    ,
  • Duplicate Upgrade Query in 3.1
    via GitHub by jtesser
    ,
  • Re: views created before tables?
    via by Stephen Cameron,
  • Invalid SQL syntax
    via GitHub by cbadenes
    ,
    • java.lang.RuntimeException: db-hibernate for PortalDb failed at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:137) at org.jasig.portal.shell.PortalShellBuildHelper$hibernateCreate.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128) at upshell_114218966.run(upshell_114218966.groovy:20) at groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:257) at groovy.lang.GroovyShell.run(GroovyShell.java:220) at org.jasig.portal.shell.PortalShell.main(PortalShell.java:86) Caused by: java.lang.RuntimeException: Failed to execute: create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA longtext not null, MEMBER_ADDRESS_CLASS varchar(100) not null, CLUSTER_NAME varchar(100) not null, MEMBER_ADDRESS longtext, PHYSICAL_ADDRESS_CLASS varchar(100), PHYSICAL_ADDRESS_DATA longtext, PHYSICAL_ADDRESS longtext, primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME)) at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:133) at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.create(DataSourceSchemaExport.java:102) at org.jasig.portal.shell.PortalShellBuildHelperImpl.hibernateCreate(PortalShellBuildHelperImpl.java:132) ... 8 more Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [create table UP_JGROUPS_PING (MEMBER_ADDRESS_DATA longtext not null, MEMBER_ADDRESS_CLASS varchar(100) not null, CLUSTER_NAME varchar(100) not null, MEMBER_ADDRESS longtext, PHYSICAL_ADDRESS_CLASS varchar(100), PHYSICAL_ADDRESS_DATA longtext, PHYSICAL_ADDRESS longtext, primary key (MEMBER_ADDRESS_DATA, MEMBER_ADDRESS_CLASS, CLUSTER_NAME))]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428) at org.jasig.portal.tools.dbloader.DataSourceSchemaExport.perform(DataSourceSchemaExport.java:127) ... 10 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'MEMBER_ADDRESS_DATA' used in key specification without a key length at sun.reflect.GeneratedConstructorAccessor143.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732) at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) at com.sun.proxy.$Proxy130.execute(Unknown Source) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) ... 12 more

    Users with the same issue

    slashslash
    7 times, last one,
    CasperCasper
    88 times, last one,
    tvrmsmithtvrmsmith
    7 times, last one,
    HronomHronom
    3 times, last one,
    KialandeiKialandei
    13 times, last one,
    112 more bugmates