this is how my code looks
/**
* Grab Update SQL Connection
*
* @return
* @throws NamingException
* @throws SQLException
* @throws SQLException
*/
public Connection getConnection() throws NamingException, SQLException
{
Context env = (Context) new
InitialContext().lookup("java:comp/env");
DataSource obj_datasrc = (DataSource) env.lookup("jdbc/xxxx");
return obj_datasrc.getConnection();
}
and this is my context xml looks
<Context>
<Resource name="jdbc/xxxx"
auth="Container"
type="javax.sql.DataSource"
maxActive="5"
maxIdle="2"
maxWait="10000"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
username="xxxxxxx"
password="xxxxxxx"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://xxx.xxx.xxx.xxx:port;DatabaseName=db_name"/>
</Context>
hope this helps
cheers
dipu
On Mon, Feb 2, 2009 at 10:10 AM, Ashis <[email protected]> wrote:
>
> Hello all,
> i have problem regarding mssql connection
>
> /*****Code Snippet for MSSQL connection*******/
> public static Connection getSqlConnection() throws SQLException {
> try {
> Context c = new InitialContext();
> DataSource dataSource = (DataSource)
> c.lookup("java:/comp/env/jdbc/mssql");
> return dataSource.getConnection();
> } catch (NamingException err) {
> throw new SQLException();
> }
> }
>
> I got a SQLEXCEPTION in getSqlConnection() function:
> "*javax.naming.NameNotFoundException: cannot create resource instance"
>
>
> /*****Code Snippet of context path for MSSQL connection*******/
> <Resource
> name="jdbc/mssql"
> type="net.sourceforge.jtds.jdbcx.JtdsDataSource"
> removeAbandoned="true"
> removeAbandonedTimeout="60"
> maxActive="4"
> maxIdle="2"
> username="sa"
> password="root"
> maxWait="5000"
> driverClassName="net.sourceforge.jtds.jdbc.Driver"
> url="jdbc:jdts:sqlserver://localhost:1433/flight" />
>
>
> How can i remove this sql exception?
> Looking forward to your suggestion.
> Thank you
>
> --
> View this message in context:
> http://www.nabble.com/mssql-connection-problem-tp21787078p21787078.html
> Sent from the Wicket - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
