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

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

barisyildirimmm

Sorry about other topic...

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

Thanks...

chrismxnr

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

Marco_Boeck

Hi,

indeed, we will do that.

Regards,
Marco