Options

9 character problem

barisyildirimmmbarisyildirimmm Member Posts: 3 Contributor I
edited November 2018 in Help
hi,

i want to add data to postgresql from excel...but i cant do that because one column adding as 'name' format...but i send it 'text' format...and for example my name is Barış YILDIRIM , it says that ;



Exception: com.rapidminer.operator.UserError
Message: Database error occurred: Attribute isim contains values with length >9 which is the maximum length for columns of SQL type name
Stack trace:

 com.rapidminer.operator.io.DatabaseExampleSetWriter.write(DatabaseExampleSetWriter.java:82)
 com.rapidminer.operator.io.DatabaseExampleSetWriter.write(DatabaseExampleSetWriter.java:60)
 com.rapidminer.operator.io.AbstractWriter.doWork(AbstractWriter.java:67)
 com.rapidminer.operator.Operator.execute(Operator.java:764)
 com.rapidminer.operator.execution.SimpleUnitExecutor.execute(SimpleUnitExecutor.java:51)
 com.rapidminer.operator.ExecutionUnit.execute(ExecutionUnit.java:709)
 com.rapidminer.operator.OperatorChain.doWork(OperatorChain.java:368)
 com.rapidminer.operator.Operator.execute(Operator.java:764)
 com.rapidminer.Process.run(Process.java:854)
 com.rapidminer.Process.run(Process.java:761)
 com.rapidminer.Process.run(Process.java:756)
 com.rapidminer.Process.run(Process.java:746)
 com.rapidminer.gui.ProcessThread.run(ProcessThread.java:65)

Cause
Exception: java.sql.SQLException
Message: Attribute isim contains values with length >9 which is the maximum length for columns of SQL type name
Stack trace:

 com.rapidminer.tools.jdbc.StatementCreator.makeColumnCreator(StatementCreator.java:253)
 com.rapidminer.tools.jdbc.StatementCreator.makeTableCreator(StatementCreator.java:183)
 com.rapidminer.tools.jdbc.DatabaseHandler.createTable(DatabaseHandler.java:476)
 com.rapidminer.operator.io.DatabaseExampleSetWriter.write(DatabaseExampleSetWriter.java:79)
 com.rapidminer.operator.io.DatabaseExampleSetWriter.write(DatabaseExampleSetWriter.java:60)
 com.rapidminer.operator.io.AbstractWriter.doWork(AbstractWriter.java:67)
 com.rapidminer.operator.Operator.execute(Operator.java:764)
 com.rapidminer.operator.execution.SimpleUnitExecutor.execute(SimpleUnitExecutor.java:51)
 com.rapidminer.operator.ExecutionUnit.execute(ExecutionUnit.java:709)
 com.rapidminer.operator.OperatorChain.doWork(OperatorChain.java:368)
 com.rapidminer.operator.Operator.execute(Operator.java:764)
 com.rapidminer.Process.run(Process.java:854)
 com.rapidminer.Process.run(Process.java:761)
 com.rapidminer.Process.run(Process.java:756)
 com.rapidminer.Process.run(Process.java:746)
 com.rapidminer.gui.ProcessThread.run(ProcessThread.java:65)

Answers

  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering
    Hi,

    please do not cross-post your problem around various boards, if anything it will delay answers.
    However I don't quite understand your problem, could you be more clear about it and post your process xml as well?

    Regards,
    Marco
  • Options
    barisyildirimmmbarisyildirimmm Member Posts: 3 Contributor I
    Sorry about other topic...

    i am using another program because of this problem...so the problem disappeared...

    Thanks...
  • Options
    chrismxnrchrismxnr Member Posts: 12 Contributor II
    Hi,
    I had exactly the same problem here today. It didn't want to add two of my nominal attributes in the ExampleSet to a table in PostgreSQL (the same exception).

    I got it fixed with integrating the newest version of the PostgreSQL JDBC driver into RapidMiner (9.1-901, JDBC4).

    My database version is PostgreSQL 8.4.8.

    So maybe it would be a good idea to update the integrated PostgreSQL JDBC-driver with the next update? For me it seems to be a bug in the old one.

    Best regards,
    Chris
  • Options
    Marco_BoeckMarco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,996 RM Engineering
    Hi,

    indeed, we will do that. :)

    Regards,
    Marco
Sign In or Register to comment.