Orbeon Forms community mailing list

Orbeon in Ubuntu - Cant connect to SQL Server

Classic

List

Threaded

6 messages Options

Neenu Jacob

Orbeon in Ubuntu - Cant connect to SQL Server

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

Erik Bruchez

Re: Orbeon in Ubuntu - Cant connect to SQL Server

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

Neenu Jacob

Re: Orbeon in Ubuntu - Cant connect to SQL Server

Yes, I placed JDBC driver, but the version was 41. when I placed JDBC 42 it works fine for me. Thanks

Alessandro Vernet

Re: Orbeon in Ubuntu - Cant connect to SQL Server

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

Neenu Jacob

Re: Orbeon in Ubuntu - Cant connect to SQL Server

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

Erik Bruchez

Re: Orbeon in Ubuntu - Cant connect to SQL Server

Administrator

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

-Erik