"name to text 9 character problem"

barisyildirimmm

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)

Marco_Boeck

Please do not open multiple threads for your problem.

http://rapid-i.com/rapidforum/index.php/topic,3826.0.html