Creating a CSV data source

[rpentahoj]

Hi,

I have installed Pentaho CE (4.1). This Pentaho is configured to use hibernate on MySQL. When I try create a data source CSV, then appear an error: Database type [null[not found!

If I try create a data source CSV (same file CSV) on other Pentaho (same version), but using hibernate on HSQLDB, the data source is created.

Can you help me, please?

Thank you, Regards.

[rpentahoj]

Solved.

The JNDI have to be called Hibernate

[roostam]

Hello, running Pentaho CE version 4.5.0 stable.
Trying to create a new data source from CSV from Data Source Wizard in the browser, large file (40Mb) with 450K rows.
Getting an error "the compressed file uploaded contained more than one file. any compressed files must contain only one file". Tried with a small file - it worked.
What could be the problem? I changed maximum size in pentaho.xml, changed request size in ngenix just in case.
Checked the los in catalina.out, these lines seem to me referring to this problem:

17:28:41,779 WARN [AxisService] Unable to generate EPR for the transport : http
Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor
17:28:42,143 WARN [AxisService] Unable to generate EPR for the transport : http
Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor
17:28:42,588 WARN [DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
17:28:42,638 WARN [DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
17:28:42,667 WARN [AxisService] Unable to generate EPR for the transport : http
Warning: Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor

Can anyone help?

Screen Shot 2012-05-22 at 16.54.02.jpg

[roostam]

Really, noone experienced this?

[nbaker]

CSV's are staged to a particular database. By default it's Hibernate, but you can change that in pentaho-solutions/system/data-access/settings.xml

<!-- settings for Agile Data Access -->
<data-access-staging-jndi>Hibernate</data-access-staging-jndi>

[nbaker]

Really, noone experienced this?

Those Axis errors aren't involved. We're not using Axis services for the data access wizard.

I found the code showing this error and it does look a little fragile. It could be that your zip utility is adding a newline at the end. I guess I would try compressing the CSV with a different tool

if( uploadedFile.indexOf("\n") != -1 ) {
// uploadedFile is newline-separated list of file names
// for now we only support a single file
showErroDialog(messages.getString("fileImportDialog.COMPRESSED_TOO_MANY_FILES"));
return;
}