Orbeon in Ubuntu - Cant connect to SQL Server

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Orbeon in Ubuntu - Cant connect to SQL Server

Neenu Jacob
Hi,

I was working orbeon in windows os by establishing connection with SQL server. Now I changed the os to ubuntu, but couldn't establish the sql connection. Installed jTDs driver too.

<GlobalNamingResources>

   

    <Resource name="UserDatabase" auth="Container"

              type="org.apache.catalina.UserDatabase"

              description="User database that can be updated and saved"

              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"

              pathname="conf/tomcat-users.xml" />

                         

           <Resource name="jdbc/sqlserver" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" auth="Container" type="javax.sql.DataSource"

            initialSize="3" maxActive="10" maxIdle="10" maxWait="30000" poolPreparedStatements="true" validationQuery="select 1"

            testOnBorrow="true" username="sa" password="speridian1" url="jdbc:jtds:sqlserver://192.168.40.22:1433;databasename=orbeon;user=sa;password=speridian1"/>

 

  <Resource name="jdbc/sqlserversolismammotest" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" auth="Container" type="javax.sql.DataSource"

                initialSize="3" maxActive="10" maxIdle="10" maxWait="30000" poolPreparedStatements="true" validationQuery="select 1"

                testOnBorrow="true" username="sa" password="speridian1"

                url="jdbc:jtds:sqlserver://192.168.40.22:1433;databasename=solismammotest;user=sa;password=speridian1"/>

  </GlobalNamingResources>




Anybody plz tell how I can connect it to the sql server
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon in Ubuntu - Cant connect to SQL Server

Erik Bruchez
Administrator
Did you place the JDBC driver JAR file in your Tomcat installation on Ubuntu?

Do you see an error in the Tomcat or other logs?

-Erik
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon in Ubuntu - Cant connect to SQL Server

Neenu Jacob
Yes, I placed JDBC driver, but the version was 41. when I placed JDBC 42 it works fine for me. Thanks
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon in Ubuntu - Cant connect to SQL Server

Alessandro  Vernet
Administrator
Hi Neenu,

Interesting; out of curiosity, what version of Tomcat and what version of SQL Server are you using?

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon in Ubuntu - Cant connect to SQL Server

Neenu Jacob
Hi,

I am using Apache Tomcat/8.5.16 and SQL Server 2012. attached screenshot.

Regards,
Neenu Jacob

On Tue, Aug 1, 2017 at 11:09 AM, Alessandro Vernet [via Orbeon Forms community mailing list] <[hidden email]> wrote:
Hi Neenu,

Interesting; out of curiosity, what version of Tomcat and what version of SQL Server are you using?

Alex
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet



If you reply to this email, your message will be added to the discussion below:
http://discuss.orbeon.com/Orbeon-in-Ubuntu-Cant-connect-to-SQL-Server-tp4662653p4662657.html
To unsubscribe from Orbeon in Ubuntu - Cant connect to SQL Server, click here.
NAML


VirtualBox_Ubuntu_01_08_2017_11_58_46.png (43K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon in Ubuntu - Cant connect to SQL Server

Erik Bruchez
Administrator
Great. Glad to see that using a newer driver solved the issue.

-Erik