Creating data source to access WAS database in CE 7.1 ehp1

[former_member40425]

Hi all,

Before CE 7.1 we used to create data source using visual Admin but from CE 7.1 visual admin is not supported.

Can please someone tell the alternative to create data source. Is there any way to create data source using NWA.

Regards,

Rohit

[Former Member]

Hi Rohit,

Yes, there is, as they are trying to move everything there. Go to NWA->Configuration management->Infrastructure->Application resources. There is a drop down button 'Create New Resource', you will find there 'New JDBC Custom DataSource' option.

Best Regards,

Anton

[former_member40425]

Thanks for your reply.

I am had tried creating Data Source there but I am not able to use it in JAVA EE project. In my landscape I have to use this data source to create a connection between System Default database i.e. MAX DB in my case. Default System driver that is available is System_Driver and default data source is SAPCE2DB. I hope I can reuse these default datasource or default driver. Now my question is which JDBC version to use i.e. 1.X or 2.X. If 2.X can someone please tell me Object Factory and CPDS Class name for MAX DB.

Also please let me know how to use this data source in Conn.java class. Here is what I am doing InitialContext initialContext=new InitialContext();// Initialize the context DataSource dataSource=(DataSource)initialContext.lookup("jdbc/TESTXAPPDS");//

And error I am getting at 2nd line is:

Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial

at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)

at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)

at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)

at javax.naming.InitialContext.lookup(Unknown Source)

at connection.Conn.main

Regards,

Rohit

[Former Member]

>

> Thanks for your reply.
> I am had tried creating Data Source there but I am not able to use it in JAVA EE project. In my landscape I have to use this data source to create a connection between System Default database i.e. MAX DB in my case. Default System driver that is available is System_Driver and default data source is SAPCE2DB. I hope I can reuse these default datasource or default driver. Now my question is which JDBC version to use i.e. 1.X or 2.X. If 2.X can someone please tell me Object Factory and CPDS Class name for MAX DB.
> 
> Also please let me know how to use this data source in Conn.java class. Here is what I am doing InitialContext initialContext=new InitialContext();// Initialize the context DataSource dataSource=(DataSource)initialContext.lookup("jdbc/TESTXAPPDS");//
> 
> And error I am getting at 2nd line is:
> 
> Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
> 	at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
> 	at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
> 	at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)
> 	at javax.naming.InitialContext.lookup(Unknown Source)
> 	at connection.Conn.main
> 
> Regards,
> Rohit

Do you try to use the default one, is there a problem?

DataSource dataSource=(DataSource)initialContext.lookup("jdbc/SAPCE2DB");

Or an alias may be?

Regards,

Anton

[former_member40425]

Yes I have tried using default Data Source but still getting same error. I am trying to execute code in simple java project with void Main(). Is there any other configuration needs to be done. I hope I have identified default data source correctly. Is there any standard rule of identifying default data source?

Regards

Rohit