[ 
https://issues.apache.org/jira/browse/TOMEE-1537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393234#comment-14393234
 ] 

CHERANTHIAN MUTHUVINAYAGAM commented on TOMEE-1537:
---------------------------------------------------

Again thanks for your reply. Your second solution fits very well into my usage 
scenario. 

When I call,  
{quote}     
       
SystemInstance.get().getComponent(Assembler.class).createResource(serviceInfo);
{quote}     

will the resource will be registered as global resource(Is it equivalent to 
defining the resource in tomee.xml). If so how to register the resource as 
application specific resource (equivalent to defining in WEB-INF/resources.xml. 

When should the destroyresource method in a web application. Do I need write a 
any listener and call the destroyresource ?. 

Thanks
Cheran

> DataSourceFactory.create method removes the single backslash from MS SQL 
> Server jdbcUrl string that contains SQL Server instance name that causes 
> dataSoruce.getConnection() to throw SQLServerException.
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TOMEE-1537
>                 URL: https://issues.apache.org/jira/browse/TOMEE-1537
>             Project: TomEE
>          Issue Type: Bug
>    Affects Versions: 1.7.1
>         Environment: Windows, Sql Server 2012, MS Sql Server JDBC Driver 4
>            Reporter: John Pratt
>            Priority: Critical
>
> If you pass in a valid connection string to the DataSourceFactory.create 
> method that contains a single backslash i.e., 
> jdbcUrl=jdbc:sqlserver://IN08268\SQLEXPRESS. The DataSource factory 
> implementation parses the “definition” String as java.util.Properties. 
> Parsing the string as java.util.Properties removes the single backslash 
> character that cause JDBC driver to fail.
> There is a workaround you could do to replace the single backslash with 
> double backslash in the jdbcUrl property (but this is an invalid conection 
> url for sql server). 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to