I have a problem when i use J2EE server connecting to SQL Server 7.0. I use the the Sequeline 5.1 (jdbc driver for sql server which i downloaded the evaluation product from www.mereant.com). I follow the instruction how to config default.properties but i still get error when i start J2EE server. Here is the error message
Binding DataSource, name = jdbc/Merant, url = jdbc/XAMerant
java.lang.NullPointerException at java.util.Hashtable.put(Hashtable.java:381)at com.sun.enterprise.ServerConfiguration.getProperties(ServerConfiguration.java:174)
at com.sun.enterprise.resource.PoolManagerImpl.installJdbcXADataSources(PoolManagerImpl.java:514)
at com.sun.enterprise.resource.PoolManagerImpl.installJdbcDataSources(Po
olManagerImpl.java:397)
at com.sun.enterprise.server.J2EEServer.run(J2EEServer.java:280)
at com.sun.enterprise.server.J2EEServer.main(J2EEServer.java:866)
Error instantiating class com.merant.sequelink.jdbcx.datasource.SequeLinkDatasou
rce. Please check J2EE_CLASSPATH.
Here is what i config in default.properties file
jdbc.drivers=COM.cloudscape.core.RmiJdbcDriver:com.merant.sequelink.jdbc.SequeLinkDriver # JDBC URL Examples:
# Oracle thin driver:
# jdbc:oracle:thin:@<host>:<port>:<sid>
# Cloudscape RMI driver:
# jdbc:cloudscape:rmi:<database>;create=true
# Merant driver:
# jdbc:sequelink://<host>:<port>/[SQLServer];Database=<database>
#
jdbc20.datasources=jdbc/Merant|jdbc/XAMerant
xadatasource.0.jndiname=jdbc/XAMerant
xadatasource.0.classname=com.merant.sequelink.jdbcx.datasource.SequeLinkDatasource
Expecting reply soon
Thank you
Discussions
EJB programming & troubleshooting: Problem when access SQL Server from J2EE Server(Urgent)
-
Problem when access SQL Server from J2EE Server(Urgent) (2 messages)
- Posted by: Rapeepan Thawornwanchai
- Posted on: June 05 2001 21:40 EDT
Threaded Messages (2)
- Problem when access SQL Server from J2EE Server(Urgent) by ARUNACHALAM KANAGARAJ on June 06 2001 11:45 EDT
- Problem when access SQL Server from J2EE Server(Urgent) by Stephen Wink on June 07 2001 10:34 EDT
-
Problem when access SQL Server from J2EE Server(Urgent)[ Go to top ]
- Posted by: ARUNACHALAM KANAGARAJ
- Posted on: June 06 2001 11:45 EDT
- in response to Rapeepan Thawornwanchai
hi,
i think u didn't append the driver jar in the J2EE_CLASSPATH..i think better u can go for sun jdbc odbc driver...it is simple to configure and use..
-
Problem when access SQL Server from J2EE Server(Urgent)[ Go to top ]
- Posted by: Stephen Wink
- Posted on: June 07 2001 10:34 EDT
- in response to ARUNACHALAM KANAGARAJ
Although the JDBC:ODBC driver is not as robust as straight JDBC drivers ( especially ones that are commercially available and supported), and sun themselves don't recommend it for anything other than evaulation/prototyping.