Troubleshooting
Problem
How to connect named database instance using SQLServer and sprinta2000
Symptom
We currently have one SQL Server 2000 database server for two separate
environments. On this database server (CCMDDB), we have two instances - the
default instance (CCMDDB) and a named instance (CCMDDB\ProductTest). Our hope
was to have our Assembly Test environment point to the CCMDDB instance and our
Product Test environment point to the CCMDDB\ProductTest instance. I have not
yet been able to get our Yantra Product Test application up and running. The
error being returned to me from WebLogic is:
com.inet.tds.SQLException:
ccmdsrv02\producttest
java.net.UnknownHostException:
ccmdsrv02\producttest
at
java.net.InetAddress.getAllByName0(InetAddress.java:571)
at
java.net.InetAddress.getAllByName0(InetAddress.java:540)
at
java.net.InetAddress.getByName(InetAddress.java:449)
at
java.net.Socket.<init>(Socket.java:100)
at
com.inet.tds.TdsDriver.do(Unknown Source)
at
com.inet.tds.TdsDriver.connect(Unknown Source)
at
java.sql.DriverManager.getConnection(DriverManager.java:517)
at
java.sql.DriverManager.getConnection(DriverManager.java:146)
at
com.yantra.yfs.core.YFSContext.createConnection(Unknown Source)
at
com.yantra.yfs.core.YFSContext.<init>(Unknown Source)
at
com.yantra.yfs.core.YFSContext.<init>(Unknown Source)
at
com.yantra.yfc.util.YFCLocale.init(Unknown Source)
at
com.yantra.yfc.util.YFCLocale.<clinit>(Unknown Source)
at
com.yantra.util.YFCJspUtils.initI18N(Unknown Source)
at
com.yantra.util.YFCJspUtils.initAll(Unknown Source)
at
com.yantra.yfs.yfsconfig.YFSCfLogin.<init>(Unknown Source)
at
jsp_servlet._yfsconfig._bin._login._jspService(_login.java:101)
Does
Yantra support the ability to connect to a named database instance instead of
the default instance?
Cause
Resolving The Problem
In yfs.properties set following properties.
1. The database type to
SQLServer
yfs.dblogin.dbtype=sqlserver
2.
yfs.dblogin.jdbcurl=jdbc:inetdae7:<IP address of database
server>?database=--your database name--
3. Make sure that Username /
Password you want to use has 'public' and 'db_owner' roll assigned for --your
database
name--.
eg:
yfs.dblogin.dbtype=sqlserver
yfs.dblogin.jdbcurl=jd
bc:inetdae7:10.10.20.155?database=yantra
yfs.dblogin.userid=sa
yfs.dbl
ogin.password=sa
Here, instead of connecting to default databse of
system administrator (sa) which is master, we are connecting to
'yantra'
If you are not using sprinta2000 jdbc driver, then refer to
your jdbc drivers manual for correct syntax for the 'yfs.dblogin.jdbcurl'
property.
Historical Number
PRI48750
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21523049