servicemix SQL component

[GridView]

Hi, I'm trying use sql component and my work stopped in this question.
 I have this code:  
<bean id="myDS" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
    <property name="url" value="jdbc:sqlserver://localhost:1433;databaseName=123" />
    <property name="username" value="tim" />
    <property name="password" value="*******" />
</bean>
Before start service "Servicemix" show me next error:
 
"SEVERE: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
ERROR - DeadLetterChannel            
 - Failed delivery for exchangeId: ID-10-036/20065-1256119312028/0-2. On delivery attempt: 0 caught: java.lang.Unsupported
OperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0."

I'm using this(sqljdbc4.jar) jar.... but I think servicemix doesn't use this jar.
How  I can connect to MssqlServer using Servicemix?
What must I do?:)

[Jean-Baptiste Onofre]

Hi,

which servicemix-sql component do you speak ?
I guess it's the bean database sample. It uses servicemix-bean. I'm
going to work on servicemix-jdbc and servicemix-hibernate component
(it's in the roadmap).

In your case, I think that you don't use the correct driver. I know that
there's several driver available for MSSQL (as for Oracle).

Could you please:
- try the latest driver which support JDK 1.6
- try with your current driver but using JDK 1.5 to start ServiceMix

Regards
JB

GridView wrote:

> Hi, I'm trying use sql component and my work stopped in this question.
>  I have this code:  
> <bean id="myDS"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource">
>     <property name="driverClassName"
> value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
>     <property name="url"
> value="jdbc:sqlserver://localhost:1433;databaseName=123" />
>     <property name="username" value="tim" />
>     <property name="password" value="*******" />
> </bean>
> Before start service "Servicemix" show me next error:
>  
> "SEVERE: Java Runtime Environment (JRE) version 1.6 is not supported by this
> driver. Use the sqljdbc4.jar class library, which provides support for JDBC
> 4.0.
> ERROR - DeadLetterChannel            
>  - Failed delivery for exchangeId: ID-10-036/20065-1256119312028/0-2. On
> delivery attempt: 0 caught: java.lang.Unsupported
> OperationException: Java Runtime Environment (JRE) version 1.6 is not
> supported by this driver. Use the sqljdbc4.jar class library, which provides
> support for JDBC 4.0."
>
> I'm using this(sqljdbc4.jar) jar.... but I think servicemix doesn't use this
> jar.
> How  I can connect to MssqlServer using Servicemix?
> What must I do?:)
>
>

[GridView]

My task is simple. I must connect to MSSqlSever2005 and execute the query.
I'm using servicemix 3.3.1 and jdk1.6.0_13. Servicemix-Jdbc doesn't connect to MSSqlSever2005. Or, am I wrong?
You can show me sample, with a correct use of this component?

[Jean-Baptiste Onofre]

Hi,

Which servicemix-jdbc do you talk about ?
Do you talk about the sample using servicemix-bean ?

Regards
JB
------Original Message------
From: GridView
To: dev@...
Subject: Re: servicemix SQL component
Sent: Oct 29, 2009 12:09


My task is simple. I must connect to MSSqlSever2005 and execute the query.
I'm using servicemix 3.3.1. Servicemix-Jdbc doesn't connect to
MSSqlSever2005. Or, am I wrong?
You can show me sample, with a correct use of this component?

--
View this message in context: http://www.nabble.com/servicemix-SQL-component-tp25995512p26111033.html
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.

[GridView]

well... I'm using servicemix-camel component and  using this http://camel.apache.org/jdbc.html or this http://camel.apache.org/sql-component.html camel-component.
Mt dependency:

  <dependency>
      <groupId>org.apache.servicemix</groupId>
      <artifactId>servicemix-camel</artifactId>
      <version>${servicemix-version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.servicemix</groupId>
      <artifactId>servicemix-core</artifactId>
      <version>${servicemix-version}</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>org.apache.camel</groupId>
        <artifactId>camel-core</artifactId>
        <version>${camel-version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.camel</groupId>
      <artifactId>camel-mina</artifactId>
      <version>${camel-version}</version>
    </dependency>


But if you know another decision, i see it.

[Jean-Baptiste Onofre]

Ahhh understood it's camel jdbc component.

Have you tried to use database-bean sample from SMX ?

Regards
JB
------Original Message------
From: GridView
To: dev@...
ReplyTo: dev@...
Subject: Re: servicemix SQL component
Sent: Oct 29, 2009 13:22


well... I'm using servicemix-camel component and  using this
http://camel.apache.org/jdbc.html or this
http://camel.apache.org/sql-component.html camel-component.
Mt dependency:

  <dependency>
      <groupId>org.apache.servicemix</groupId>
      <artifactId>servicemix-camel</artifactId>
      <version>${servicemix-version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.servicemix</groupId>
      <artifactId>servicemix-core</artifactId>
      <version>${servicemix-version}</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>org.apache.camel</groupId>
        <artifactId>camel-core</artifactId>
        <version>${camel-version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.camel</groupId>
      <artifactId>camel-mina</artifactId>
      <version>${camel-version}</version>
    </dependency>


But if you know another decision, i see it.
--
View this message in context: http://www.nabble.com/servicemix-SQL-component-tp25995512p26111993.html
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.

[GridView]

hmm.... i do't see  database-bean sample... you mean sample from folder "examples" or sample from this site?

[Jean-Baptiste Onofre]

It's on the smx3 svn trunk. Sorry I haven't any network connection to give the complete url.

Regards
JB
------Original Message------
From: GridView
To: dev@...
ReplyTo: dev@...
Subject: Re: servicemix SQL component
Sent: Oct 29, 2009 13:54


hmm.... i do't see  database-bean sample... you mean sample from folder
"examples" or sample from this site?
--
View this message in context: http://www.nabble.com/servicemix-SQL-component-tp25995512p26112515.html
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.

[GridView]

I'm sorry. But i do't found this example.  If it is not difficult give me
link.
--
View this message in context: http://old.nabble.com/servicemix-SQL-component-tp25995512p26160020.html
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.

[Jean-Baptiste Onofre]

Sorry for the late answer. The database bean sample is here:
http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/

Regards
JB

GridView wrote:
> I'm sorry. But i do't found this example.  If it is not difficult give me
> link.

[GridView]

GridView wrote:
>
> I'm sorry. But i do't found this example.  If it is not difficult give me
> link.
>
That's all right.... I thinck i found example.
--
View this message in context: http://old.nabble.com/servicemix-SQL-component-tp25995512p26160023.html
Sent from the ServiceMix - Dev mailing list archive at Nabble.com.