Cannot Create Datasource through Java Application

venkatesh_r · ‎09-16-2006

Hi All,

I tried to create a datasource through my Java application

JDBCDescriptor jdbcDescriptor = new JDBCDescriptor();

jdbcDescriptor.setDataSourceName("ds_venky");

jdbcDescriptor.setDriverClassName("org.gjt.mm.mysql.Driver");

jdbcDescriptor.setDriverName("mysql");

jdbcDescriptor.setInitConnections(2);

jdbcDescriptor.setMaxConnections(10);

jdbcDescriptor.setPassword("xxxx");

jdbcDescriptor.setURL("jdbc:mysql://172.22.76.8:3306/wise");

jdbcDescriptor.setUsername("xxxx");

Properties ctxProp = new Properties();

ctxProp.put(

Context.INITIAL_CONTEXT_FACTORY,

"com.sap.engine.services.jndi.InitialContextFactoryImpl");

ctxProp.put(Context.PROVIDER_URL, "myServerName:50004");

ctxProp.put(Context.SECURITY_PRINCIPAL, "xxxx");

ctxProp.put(Context.SECURITY_CREDENTIALS, "xxxx");

InitialContext context = new InitialContext(ctxProp);

DataSourceManager dsm =

(DataSourceManager) context.lookup("dbpool");

dsm.createDataSource("ds_venky", jdbcDescriptor);

But i get the following exception

1.5#000F20FEA14B0053000000000000107800041D9052026725#1158405595218#System.err#sap.com/DataSourceSAPEAR#System.err#Guest#2#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain###0#

#1.5#000F20FEA14B0053000000010000107800041D905202B73E#1158405595234#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain###1#

#1.5#000F20FEA14B0053000000020000107800041D905202D985#1158405595249#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain###2#

#1.5#000F20FEA14B0053000000040000107800041D905205BA71#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain###java.io.FileNotFoundException: .
temp
deploy
1158405595421 (The system cannot find the file specified)#

#1.5#000F20FEA14B0053000000050000107800041D905205BD49#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at java.io.FileInputStream.open(Native Method)#

#1.5#000F20FEA14B0053000000060000107800041D905205BDD6#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at java.io.FileInputStream.<init>(FileInputStream.java:106)#

#1.5#000F20FEA14B0053000000070000107800041D905205BE3C#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.application.DeployUtilTransaction.uploadSAPPropertiesFile(DeployUtilTransaction.java:493)#

#1.5#000F20FEA14B0053000000080000107800041D905205BEA4#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.application.DeployUtilTransaction.uploadSpecialEARFiles(DeployUtilTransaction.java:480)#

#1.5#000F20FEA14B0053000000090000107800041D905205BF0B#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.application.DeployUtilTransaction.commonBegin(DeployUtilTransaction.java:320)#

#1.5#000F20FEA14B00530000000A0000107800041D905205BF74#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.application.DeploymentTransaction.begin(DeploymentTransaction.java:296)#

#1.5#000F20FEA14B00530000000B0000107800041D905205BFD8#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:304)#

#1.5#000F20FEA14B00530000000C0000107800041D905205C03E#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhases(ApplicationTransaction.java:335)#

#1.5#000F20FEA14B00530000000D0000107800041D905205C0A5#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.DeployServiceImpl.makeGlobalTransaction(DeployServiceImpl.java:3008)#

#1.5#000F20FEA14B00530000000E0000107800041D905205C109#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.deploy.server.DeployServiceImpl.deploy(DeployServiceImpl.java:520)#

#1.5#000F20FEA14B00530000000F0000107800041D905205C16C#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.dbpool.deploy.DataSourceManagerImpl.deploy(DataSourceManagerImpl.java:253)#

#1.5#000F20FEA14B0053000000100000107800041D905205C1E2#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.dbpool.deploy.DataSourceManagerImpl.createDataSource(DataSourceManagerImpl.java:317)#

#1.5#000F20FEA14B0053000000110000107800041D905205C248#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.dbpool.deploy.DataSourceManager_Stub.createDataSource(DataSourceManager_Stub.java:504)#

#1.5#000F20FEA14B0053000000120000107800041D905205C2AC#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.CreateDataSource.<init>(CreateDataSource.java:50)#

#1.5#000F20FEA14B0053000000130000107800041D905205C30D#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at jsp_Create1158405589640._jspService(jsp_Create1158405589640.java:11)#

#1.5#000F20FEA14B0053000000140000107800041D905205C36F#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:467)#

#1.5#000F20FEA14B0053000000150000107800041D905205C3D3#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:181)#

#1.5#000F20FEA14B0053000000160000107800041D905205C436#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)#

#1.5#000F20FEA14B0053000000170000107800041D905205C498#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385)#

#1.5#000F20FEA14B0053000000180000107800041D905205C4F9#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263)#

#1.5#000F20FEA14B0053000000190000107800041D905205C55A#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:337)#

#1.5#000F20FEA14B00530000001A0000107800041D905205C5BB#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:315)#

#1.5#000F20FEA14B00530000001B0000107800041D905205C61E#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:815)#

#1.5#000F20FEA14B00530000001C0000107800041D905205C67F#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:238)#

#1.5#000F20FEA14B00530000001D0000107800041D905205C6E1#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)#

#1.5#000F20FEA14B00530000001E0000107800041D905205C751#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147)#

#1.5#000F20FEA14B00530000001F0000107800041D905205C7B8#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)#

#1.5#000F20FEA14B0053000000200000107800041D905205C81C#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)#

#1.5#000F20FEA14B0053000000210000107800041D905205C87F#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)#

#1.5#000F20FEA14B0053000000220000107800041D905205C8DE#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at java.security.AccessController.doPrivileged(Native Method)#

#1.5#000F20FEA14B0053000000230000107800041D905205C940#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)#

#1.5#000F20FEA14B0053000000240000107800041D905205C9A1#1158405595437#System.err#sap.com/DataSourceSAPEAR#System.err#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain### at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:151)#

#1.5#000F20FEA14B0053000000280000107800041D90520A54F1#1158405595734#com.sap.engine.services.dbpool.deploy.ContainerImpl#sap.com/DataSourceSAPEAR#com.sap.engine.services.dbpool.deploy.ContainerImpl#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error##Plain###ContainerImpl.startDataSources(): Cannot create DataSource: ds_venky. Reason: java.lang.ArrayIndexOutOfBoundsException: -1#

#1.5#000F20FEA14B00530000002A0000107800041D90520A9B54#1158405595749#com.sap.engine.services.deploy#sap.com/DataSourceSAPEAR#com.sap.engine.services.deploy#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error#1#/System/Server#Java#deploy_5029##Exception in operation startApp with application sap.com/ds_venky.#2#startApp#sap.com/ds_venky#

#1.5#000F20FEA14B00530000002B0000107800041D90520A9FA9#1158405595749#com.sap.engine.services.deploy#sap.com/DataSourceSAPEAR#com.sap.engine.services.deploy#Administrator#191#####SAPEngine_Application_Thread[impl:3]_8##0#0#Error#1#/System/Audit#Java###Exception #1#com.sap.engine.services.deploy.exceptions.ServerDeploymentException: Exception in operation startApp with application sap.com/ds_venky.

Any kind of help will be appreciated

venkatesh_r · ‎05-03-2007

Hi,

I have found the solution for this thread and have posted a blog on how to create data sources. Please find the link below

/people/venkatesh.ramachandran/blog/2006/10/19/how-to-create-and-remove-data-source-on-sap-was-j2ee-engine-dynamically-through-java

Regards,

Venkatesh

Cannot Create Datasource through Java Application

Accepted Solutions (0)

Answers (1)

Answers (1)

Re: How to get Binary Value from Partner Directory...

Re: How add Content or Section in Manage Product M...

Re: CIG transaction tracker handling

Re Generate Co files and data files

Re: SBPA - How to handle Intermediate Message Even...