Conexión a base de datos SQL

[Patricia Burgueño]

Hola, estoy comenzando en el tema de diseño de Cubos y para empezar estoy teniendo dificultades en establecer la conexión con la base que tengo.

La base la tengo en SQL Server 2008.

Me guié con el turorial de Jorge Rivera pero me da error:


En prueba.xaction
Failed
--------------------------------------------------------------------------------
 
[es_161] Error: No connection info specified or could not establish a connection to the database. - !No connection info specified or could not establish a connection to the database.! (org.pentaho.plugin.mdx.MDXLookupRule)
[es_116] Debug: [es_21] Starting execute of ventas//prueba.xaction (org.pentaho.core.solution.SolutionEngine)
[es_116] Debug: [es_30] Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
[es_116] Debug: [es_33] Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
[es_116] Debug: SolutionRepository.DEBUG_FILE_PATH - [es_35] getFile path=C:\Pentaho\pentaho_V1.7\pentaho-demo\pentaho-solutions\ventas\prueba.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
[es_116] Debug: [es_34] audit: instanceId=4a029de1-7679-11df-b8b5-a552dbe61f64, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
[es_116] Debug: SolutionRepository.DEBUG_FILE_PATH - [es_35] getFile path=C:\Pentaho\pentaho_V1.7\pentaho-demo\pentaho-solutions (org.pentaho.repository.filebased.solution.SolutionRepository)
[es_14] Error: MDXBaseComponent.ERROR_0006 - [es_38] Could not execute prueba.xaction - java.lang.NullPointerException (org.pentaho.plugin.mdx.MDXLookupRule)
[es_161] Error: No connection info specified or could not establish a connection to the database. - !No connection info specified or could not establish a connection to the database.! (org.pentaho.plugin.mdx.MDXLookupRule)
[es_161] Error: RuntimeContext.ERROR_0012 - [es_33] ActionDefinition for MDXLookupRule did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
[es_161] Error: SolutionEngine.ERROR_0007 - [es_27] Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)



En jboss-web.xml agregué:

 <!-- insert additional jboss resource-refs -->

<resource-ref>
      <res-ref-name>jdbc/Connection</res-ref-name>   acá no me doy cuenta si está bien????
    <res-type>javax.sql.DataSource</res-type>
    <jndi-name>java:/Connection</jndi-name>
  </resource-ref>


En web.xml agregué:

<!-- insert additional resource-refs -->

 <resource-ref>
      <description>Connection</description>
      <res-ref-name>jdbc/Connection</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
    </resource-ref>


Cree sql-ds.xml

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>Connection</jndi-name>
<connection-url>jdbc:sqlserver://127.0.0.1:1174/BitDwh_Indutop</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>1234</password>
</local-tx-datasource>
</datasources>

 (el driver jqljdbc4.jar está en jboss/server/default/lib)


Si se les ocurre algo, agradezco datos.